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.
N12GXLee G R/Robertson R A 7/8 NIEUPORT-12 · S/N 001N23702Air Tractor AT-301 · S/N 301-0419N1022PPiper PA-28-180 · S/N 28-5060N7773CPrue Irving O PRUE SUPER STANDARD · S/N 1N600AXDehavilland DHC-2 MK 1 · S/N 815N7529FChampion 7KCAB · S/N 268-70N8086WInfinity INFINITY 582 · S/N IPP3-183N432HBeech 65-A80 · S/N LD-206N243WCessna A185F · S/N 18503820N1753NCessna 120 · S/N 11997N322FSDiamond Aircraft Ind DA20-C1 · S/N C0279N65WNKitfox/Barnes Dwaine XL · S/N DB01ATN30NPBeech 65-B80 · S/N LD-407N99EKLet BLANIK L-13 · S/N 026117N20NPBeech 65-B80 · S/N LD-433N5376MBeech 65-B80 · S/N LD-301N8071RBeech 65-B80 · S/N LD-420N24196Rans S-4 COYOTE I · S/N 037N275DBeech 95-B55 (T42A) · S/N TC-589N8265YBell OH-58C · S/N 68-16859N182ESCessna 182P · S/N 18261041N78954Mooney M20C · S/N 1988N761DJCessna T210M · S/N 21062171N16HECrocker TAILWIND W-8 · S/N 289N66373Consolidated Vultee L-13 · S/N 47376N5679GCessna 150K · S/N 15071179N3649SAir Tractor AT-301 · S/N 301-0235N9922VCessna 172M · S/N 17264557N5855Beech UC-45J · S/N 29558N59649Boeing PT-17 · S/N 75-4223N46337Interstate S-1B1 · S/N 163N5148ZReno Gordon E P-5151 · S/N 140H7198N4249ALockheed 12A · S/N 1292N72825Destiny Powered Parachute DESTINY 2000 · S/N 1B0117N45159Naval Aircraft Factory N3N-3 · S/N 2994N65404Cessna 152 · S/N 15281530N29318Piper PA-28RT-201T · S/N 28R-7931196N2SQBellanca 17-31ATC · S/N 31038N5038DCessna 182A · S/N 51138N7022TLutker-Dittmer-Sturm DAVIS DA-5A · S/N 3N135LAPiper PA-23-250 · S/N 27-7305084N29271Culver LCA · S/N 140N6060XMooney M20A · S/N 1686N56014Buckeye DREAM MACHINE · S/N 16375N449RBellanca 17-31ATC · S/N 74-31076N481MCIsrael Aircraft Industries 1123 · S/N 184N566CABeech 58 · S/N TH-1632N917MBCessna 310K · S/N 310K0201N8785VBellanca 17-30A · S/N 30333N7864TCessna 172A · S/N 47464
Back to Midland, TX