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.
N522FBMcdonnell Douglas Helicopter 500N · S/N LN002N526FBMcdonnell Douglas Helicopter 500N · S/N LN006N8XSBruss Adam M EUROPA CLASSIC · S/N UK185N8997Jenkins Joseph A JR 1A · S/N 4368-J1N7320QCessna 182P · S/N 18260960N999KSCessna T182T · S/N T18208016N5155NCessna 182Q · S/N 18267548N5360BCessna 182 · S/N 33360N451CPiper PA-32R-301T · S/N 3257379N4057SBalloon Works FIREFLY 7 · S/N 10069N854SGEmbraer EMB-135BJ · S/N 14500854N757DUCessna 152 · S/N 15279664N661XSchempp-Hirth VENTUS-B · S/N 79N119GPiper PA-23 · S/N 23-231N124GGriswold-Ivan RUTAN VARIEZE · S/N 124N57LPParent Leo G JR PHANTOM I · S/N 598N4046MRaven Industries RALLY RX7 · S/N RX7-310N5730KRaven S55A · S/N S55A-800N32AZBell 206L-3 · S/N 51008N754CAGates Lear Jet 25B · S/N 090N398ZAAero Vodochody L-39ZA · S/N 332638N2NEEastman N L THORP T-18C · S/N 1052N317AJMaule MXT-7-180 · S/N 14067CN4367YSpillman Lyle E KITFOX IV · S/N 1532N2097LHaglund Joel W RV-4 · S/N 3416N404ZAAero Vodochody L-39ZA · S/N 132036N28ATCessna 337 · S/N 337-0181N114RPSchempp-Hirth VENTUS-B · S/N 68N126RSSchaff Robert J KITFOX CLASSIC IV · S/N C9903-0242N22CRBeech 35-B33 · S/N CD-435N3607BAerostar International RAVEN S-55A · S/N S55A-3046N6184DBell 206L-3 · S/N 51253N642JBBridges John E LONG-EZ · S/N LE-6996N200KBBowers Kenneth R JR HIGH FLIGHT1 · S/N 001N850CBeech 200 · S/N BB-710N36FKKirkland Fred HATBOX SPECIAL · S/N 462-96-8303N2005Archuleta Harry Manuel RANS S-10 · S/N 1289073N165TBVought TA-7C · S/N 156738N107JBBlumer James Allen MXL II SPORT · S/N 1308N90892Balloon Works FIREFLY 8 · S/N F8-365N75076Cameron Balloons US N-105 · S/N 5809N75WLBeech 200 · S/N BB-574N25021Miller Charles MILLERS FLY-BY · S/N 001N4764XCessna TU206G · S/N U20605533N2350HBalloon Works FIREFLY 7 · S/N 7730N205RCCosgrove Robert CHALLENGER II · S/N CHII0886W0205N9537UCameron Balloons US V-77 · S/N 5582N3SAPiasecki HUP-2 · S/N 128561N5132ZCessna TU206G · S/N U20606069N3388ECessna 172N · S/N 17271527
Back to Phoenix, AZ