Phoenix, AZ
Cancelled registrations · 1,583
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 = 'PHOENIX' 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 = 'PHOENIX' 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.
N76GNBeech 65 · S/N LC-188N1668XCessna T210L · S/N 21060703N739BDCessna 172N · S/N 17270405N84AXBalloon Works FIREFLY AX-7 · S/N F7-075N7026FCessna 150F · S/N 15063626N7046XCessna 150A · S/N 15059146N7052BPiper PA-22-150 · S/N 22-4306N6920ZPiper PA-25-235 · S/N 25-2663N2866PRaven Industries RALLY RX7 · S/N RX7-449N67700Cessna 152 · S/N 15281968N6507WPiper PA-28-140 · S/N 28-20584N6279HCessna T207A · S/N 20700462N2856EAerostar International RX-7 · S/N RX7-3007N3712ZBalloon Works FIREFLY 8B · S/N F8B-017N6073ZPiper PA-25 · S/N 25-85N6623ECessna 175 · S/N 56123N5681NRaven S55A · S/N S55A-468N5714RRaven S55A · S/N S55A-679N58151Bell 206B · S/N 1067N567CBRaven S55A · S/N S55A-265N5706YRaven S55A · S/N S55A-647N4947YPiper PA-25-235 · S/N 25-4713N50894Kjonaas VARIEZE · S/N 1160N34ELockheed 18-56 · S/N 2082N125LQLevick Larry N QUICKIE · S/N 125N330LLGrumman HU-16B · S/N 1275N5388ACessna 310B · S/N 35588N5279BMooney M20 · S/N 1142N8530UCessna 172F · S/N 17252430N110DFFlanagan David DRAGONFLY · S/N 10N241EZKaltenbach Earl G RUTAN LONG-EZ · S/N 1250N5176ACessna 172 · S/N 28176N51976First Fighter GRP Flying Club FOCKE WULF FW 190 · S/N PFW 190-01-AN747CDCirrus Design SR22 · S/N 0047N414SBeech 95-C55 · S/N TE-377N60490Laister-Kauffman LK-10A · S/N 134N9006NBaiamonte Phil DRAGONFLY · S/N 117N307GWWhitesell Gregg W KR-2 · S/N B3078N5149DCessna 182A · S/N 51249N9727QBeech A24R · S/N MC-79N560EAero Commander 560-E · S/N 839N8105ACessna 170B · S/N 20957N580AGrieger Cassutt Racer CASSUTT SPECIAL · S/N GC-1N872WRCessna 172K · S/N 17257730N8785TCessna 182C · S/N 52685N36639Aeronca 65-CA · S/N CA-17161N711HDSmith Edwin James SMYTH SIDEWINDER · S/N 550202001N8629ZCessna P206C · S/N P206-0429N3431SCessna 182G · S/N 18255831N8401YPiper PA-30 · S/N 30-1550
Back to Phoenix, AZ