Fountain Hills, AZ
Cancelled registrations · 20
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 = 'FOUNTAIN HILLS' 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 = 'FOUNTAIN HILLS' 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.
N450TNDehavilland Acft Canada DHC-2 · S/N 1575N28RGCessna 340A · S/N 340A0347N655THHeidtke Trent PRESCOTT PUSHER · S/N 030N416KBPdps Pzl-Bielsko SZD-48-3 · S/N B-2123N93TFDJI PHANTOM 3 ADVANCED · S/N P76DDA25B2635N601AZBriggerman Brian L ZODIAC 601XL · S/N 6-5854N2690SScheibe SF-25A · S/N 4538N94XXReeves Dagley M TORNADO · S/N D94503CAZK0083N4393KRaven S-60A · S/N S60A-301N75JLLewis James E KR-2 · S/N 6640N91KWWells Dale K KITFOX IV · S/N 1592N439CNew Piper PA-34-220T · S/N 3449323N703CDCirrus Design SR22 · S/N 0004N282SLLopez Ricardo RAF 2000GXT SE · S/N RSL 01N9222HCessna 185 · S/N 18503423N5337XCessna 182T · S/N 18281203N6DKKetcher D / Ferguson L RV-6 · S/N 20405N912TTReeves Dagley M REEVES TORNADO · S/N D94912C0HK110N4788CCessna T210N · S/N 21063625N611BCCessna T210N · S/N 21063459
Back to Fountain Hills, AZ