Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.
select RecordID from <tablename> where Recordtype = 10 would give you a list of flights.
If you know the first 10 record, then you could query as follows
select * from <tablename> where recordtype <> 10 and
recordid >firstflightrecordid
and recordid < (select min(recordid) from <tablename> where recordid > firstflightrecordid and recordtype = 10)