Amarillo, TX
Cancelled registrations · 230
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 = 'AMARILLO' 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 = 'AMARILLO' 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.
N7083BPiper PA-18A 150 · S/N 18-5165N5237WGalaxy Balloons GALAXY 7 · S/N GLX-1287N2691ACessna 414A · S/N 414A0409N356TWCessna 172S · S/N 172S9761N9447RSnow S2A · S/N 1078AN19998Cessna 172M · S/N 17260921N8064VBeech F33A · S/N CE-1672N226HCCarpenter Hal G BD-4 · S/N 226N718LGCessna 210 · S/N 57031N974DCPiper PA-31T · S/N 31T-8120027N4002MRobinson Helicopter R22 BETA · S/N 1444N40PCKirkland Freddy D KIRKLAND POLY COUPE · S/N 01AN17SSShaughnessy SWACO-STAGGERWING · S/N D3N2526LCessna 172H · S/N 17255726N888HGBeech B200 · S/N BB-891N3965KPiper PA-28-140 · S/N 28-23848N313VAero Commander 560 · S/N 193N7086SKennedy Mermon Joe MODIFIED PA-18 · S/N 1N42JJAlbert Norman R POLLIWAGEN · S/N 0378NN218JWCessna 310Q · S/N 310Q1023N7923QCessna 401B · S/N 401B0023N201YYMooney M20J · S/N 240532N24GDRaven S55A · S/N S55A877N36VPiper PA-31P · S/N 31P7530018N469RJCessna 421B · S/N 421B0444N42845Benningfield Johnnie L RUF-TAIL · S/N 1N4300ZPiper PA-28-181 · S/N 288390054N131RCPiper PA-42 · S/N 428001006N6231GCessna 421C · S/N 421C0262N5351MCessna 152 · S/N 15284554N3956UCessna 150E · S/N 15061356N5414VCessna 172RG · S/N 172RG0525N31379Bell UH-1B · S/N 62-2043N49845Cessna 152 · S/N 15281356N2316SCessna 337B · S/N 3370616N51957Reed TEENIE II · S/N 151660N8007HAero Commander 685 · S/N 12048N4153QCessna 310N · S/N 310N-0053N6476XCessna 180D · S/N 18050976N17602Beech A36 · S/N E-994N93363Cessna A185F · S/N 18503226N4027BBellanca 17-30A · S/N 75-30764N41818Bellanca 8KCAB · S/N 121-74N997YPiper PA-23-160 · S/N 31241N8293RBellanca 17-30A · S/N 30478N123BCCessna 320 · S/N 320-0022N7963RBeech V35A · S/N D-8965N6128NBeech B23 · S/N M-1213N2108HEngineering & Research 415-C · S/N 2731N87EStinson SR-9E · S/N 5452
Back to Amarillo, TX