Midland, TX
Cancelled registrations · 265
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 = 'TX' AND d.registrant_city = 'MIDLAND' 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 = 'TX' AND d.registrant_city = 'MIDLAND' 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.
N732QKCessna TU206G · S/N U20604707N59394Bensen B-8M · S/N 325N5583QElam Daryl B SONERAI-II · S/N 564N5676DRaven Industries RX6 · S/N RX6-329N5236KRyan NAVION B · S/N NAV-4-2136BN91163North American NAVION · S/N NAV-4-217N7859YPiper PA-30 · S/N 30-787N6703BPiper PA-22-150 · S/N 22-4035N2370Charles D Parrott B-8M · S/N 250524330N324FAConsolidated Vultee 28-5ACF · S/N 64092N2854QCessna TU206F · S/N U20603004N2171GCessna 182A · S/N 51471N54702Raven S55A · S/N S55A-192N112DADavis Leeon D DA-11-2 · S/N 1N7013CNorth American SNJ-4 · S/N 8813892N4254LPorterfield LP-65 · S/N 818N12102North American F82B · S/N 44-65162N9040YDavis Leeon D DA-11 · S/N 1N1026WBeech 95-B55 (T42A) · S/N TC-1532N2CVCessna T337G · S/N P3370046N154JDCessna 180 · S/N 30942N4574YNorth American BT14 · S/N 64-2214N476TMCessna TR182 · S/N R18201054N428SEPiper PA 46-350P · S/N 4636428N5662DMaule MX-7-180 · S/N 11014CN601LMBeech A100 · S/N B-116N61100Stinson L-5 · S/N 76-361N261AFairchild M-62A · S/N T434383N6371CLockheed 18-56 · S/N 18-2598N2048North American HARVARD 4 · S/N CCF-4-20232N215CASandberg S&S SPECIAL MODEL C · S/N 51CAFN26GAFairchild M-62A-3 · S/N T43-4433N40HRCourtney DA-5A · S/N 20N7318CAir Tractor AT-401 · S/N 401-0680N72615C A S A 2.111 · S/N T8-B-124N5586AMartin-Confederate Air Force AM-1 MAULER · S/N 13920N5234AGrumman S-2B · S/N 136404N4089TAmerican Arpwr Hrtg Flyng Muse STEEN SKYBOLT · S/N 1N9562ZBeech C-45H · S/N AF-12N60110Air Tractor AT-401 · S/N 401-0954N109MEMesserschmitt ME 109 · S/N 67N30055Piper PA-32R-301T · S/N 3257348N7955GCessna 172L · S/N 17259655N5279ACessna T210N · S/N 21063344N198Cessna T337G · S/N P3370223N8314LCessna 172I · S/N 17256514N4353WBeech B19 · S/N MB-728N50204Cessna 150H · S/N 15069134N51497Raven S-50A · S/N S50A-218N66791Convair BT-13A · S/N 3336
Back to Midland, TX