Marana, AZ
Cancelled registrations · 43
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 = 'AZ' AND d.registrant_city = 'MARANA' 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 = 'AZ' AND d.registrant_city = 'MARANA' 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.
N279ADBoeing 737-4Q8 · S/N 26279N412QKBell 412 · S/N 33119N321WCChapin Wallace Hadley SENIOR AERO SPORT · S/N 001N5715GCessna 150K · S/N 15071215N74PDBittle Glenn MINI-500 · S/N 0173N553PMAir Creation CLIPPER 582S · S/N T098/066N4VPHeisey Adriel R KOLB TWINSTAR · S/N TS-270N276CSMcdonnell Douglas DC-9-82(MD-82) · S/N 49951N480KJQuicksilver SPORT II · S/N 000506N48HPHaralson Emmett A PRECEPTOR N3SP · S/N N32HPN6354MManning Waddell M JR RANS S-12 · S/N 0291063N406JFHughes 269C · S/N 490774N268RARemos REMOS G-3/600 · S/N 231N9QKButler HOMEBUILT HP-16 · S/N 2N181RLAeropro CZ EUROFOX · S/N 19006N14810Mcdonnell Douglas DC-9-82(MD-82) · S/N 49264N5292TPiper PA-34-200 · S/N 34-7250242N4906FCessna TU206A · S/N U206-0606N88CWWilpizeski Chester R FISHER 404 · S/N 4158N2821JAbendroth Harry J B8ME · S/N 1N52665Cessna 177RG · S/N 177RG1238N8316JCessna 150G · S/N 15066216N61249Boeing B75N1 · S/N 75-7734N2857ECessna 172N · S/N 17271348N256CTBoeing 737-500 · S/N 24652N86774Bellanca 14-13-2 · S/N 1135N1992APiper PA-18A-135 · S/N 18-1817N3275GNorth American SNJ-5 · S/N 90640N425FHFairchild Hiller FH-1100 · S/N 25N350KBRans S-12 XL AIRAILE · S/N 05970801N20294Cessna 172S · S/N 172S9940N9339Douglas DC-9-31 · S/N 47382N756DVCessna U206G · S/N U20604016N6656YPiper PA-23-250 · S/N 273968N559CTCessna 182Q · S/N 18266039N7085ZPiper PA-25-235 · S/N 25-2869N4597YPiper PA-25-235 · S/N 25-4287N8606Douglas DC-8-21 · S/N 45427N2038FBalloon Works FIREFLY 7 · S/N 707N351FHFairchild Heli-Porter PILATUS PC6/C-H2 · S/N 2012N6183ZPiper PA-25 · S/N 25-216N2522DCessna 170B · S/N 20674N90262Beech SNB-5 · S/N 67274
Back to Marana, AZ