Tulsa, OK
Cancelled registrations · 1,070
Query with SQL
duckdb -csv -c "SELECT d.n_number, d.cancel_date, d.status, d.export_country, d.serial_number, d.year_manufactured, m.manufacturer, m.model, d.registrant_name, d.registrant_city, d.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_deregistration.parquet' d LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = d.aircraft_model_code WHERE d.registrant_state = 'OK' AND d.registrant_city = 'TULSA' ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id"
Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT d.n_number, d.cancel_date, d.status, d.export_country, d.serial_number, d.year_manufactured, m.manufacturer, m.model, d.registrant_name, d.registrant_city, d.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_deregistration.parquet' d LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = d.aircraft_model_code WHERE d.registrant_state = 'OK' AND d.registrant_city = 'TULSA' ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N278LLTextron 208B · S/N 208B5562N99JJTextron 208B · S/N 208B5718N3805JCessna 150G · S/N 15065105N277LLTextron 208B · S/N 208B5559N718LRRobinson Lyle ZODIAC 601XL · S/N 5984N229LHTextron 208B · S/N 208B5623N429LHTextron 208B · S/N 208B5596N384RZDJI AGRAS T30 · S/N 3U4DKHN0011T66N98915Piper PA-12 · S/N 12-259N246JRCessna 750 · S/N 750-0124N8247XCessna 172C · S/N 17248747N45AXLearjet 45 · S/N 377N509NKAirbus A319-132 · S/N 2603N508NKAirbus A319-132 · S/N 2567N510NKAirbus A319-132 · S/N 2622N521NKAirbus A319-132 · S/N 2797N507NKAirbus A319-132 · S/N 2560N42252Oliver E L JR DA-5A · S/N 15N2117YCessna 172S · S/N 172S9622N9127USharp James Edward J 3 · S/N 1N95549Taylorcraft BF · S/N 7849N515PMMuhle Paul M DR-107 · S/N 94-0257N16LXCirrus Design SR22T · S/N 1036N4466KRyan NAVION · S/N NAV-4-1466N6VLVan Dalsem Robert R VARIEZE · S/N 703N591PUCirrus Design SR20 · S/N 2052N46873Cessna 152 · S/N 15283128N6199QCessna 152 · S/N 15285191N89102Cessna 152 · S/N 15282633N94719Cessna 152 · S/N 15285772N617PRDJI PHANTOM 3 PROFESSION · S/N P76DCH26A20689N1047DCessna 195A · S/N 7659N209RPCessna 525 · S/N 525-0173N9572UGrumman American Avn. AA-5A · S/N AA5A-0072N6143WPiper PA-28-140 · S/N 28-20222N6545NCessna 210N · S/N 21063101N2891LCessna 172H · S/N 17256091N68946Cessna 152 · S/N 15282412N75BCIsrael Aircraft Industries 1124 · S/N 426N221GECirrus Design SR22 · S/N 5042N28858Grumman American Avn. AA-5B · S/N AA5B0865N782LBoeing A75N1(PT17) · S/N 75-1949N590PUCirrus Design SR20 · S/N 2051N503KTMercier Paul KOLB TWINSTAR · S/N 001N5918AYakovlev YAK-18A · S/N 1161706N7946QCessna 401B · S/N 401B0046N2265SCessna T210L · S/N 21061209N588PUCirrus Design SR20 · S/N 2049N86MNRaytheon Corporate Jets HAWKER 800XP · S/N 258330N4620QCessna 152 · S/N 152-85042
Back to Tulsa, OK