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.
N85FHBeech 58 · S/N TH-483N9216CCessna R182 · S/N R18200446N6324BCessna 182A · S/N 34224N6363NChampion 7ECA · S/N 284N6602UMooney M20C · S/N 2389N711PGCessna 172M · S/N 17264422N711RXBeech 58 · S/N TH-611N72CWBeech 35-C33A · S/N CE-69N73TWCirrus Design SR22 · S/N 0472N74632Robinson Helicopter R22 BETA · S/N 3963N776WMBeech A36 · S/N E-2088N7770QCessna 310Q · S/N 310Q0270N78994Mooney M20C · S/N 2028N801GJesse Saint/Troy Townsend/Etha CH-801 · S/N 8-7059N813JECirrus Design SR22 · S/N 3107N8162SPiper PA-28RT-201 · S/N 28R-8018042N143LHBeech 36 · S/N E-143N180XVCessna 180D · S/N 18050998N1952ECessna 340A · S/N 340A0679N2030MCessna 182M · S/N 18259657N21048Cessna 182P · S/N 18261381N228MGGonzalez Manuel A RV-7A · S/N 71045N2320UCessna 172D · S/N 17249920N27GXRemos REMOS GX · S/N 264N2951LMooney M20C · S/N 670085N3152UCessna 182F · S/N 18254552N3236FMooney M20E · S/N 670029N34899Grumman American Avn. AA-1B · S/N AA1B-0284N3839QCessna 172L · S/N 17259939N3877HMooney M20J · S/N 24-0972N4038QCessna 401 · S/N 401-0138N4433DBeech G35 · S/N D-4578N4596VCessna 172RG · S/N 172RG0333N505PCSocata TAMPICO TB 9C · S/N 1464N53MTBeech 58P · S/N TJ246N546CPiper PA 46-350P · S/N 4636626N5TGBellanca 17-30A · S/N 74-30620N6956UMooney M20C · S/N 2707N3022FLindstrand Balloons 60A · S/N 5096N565ACRobinson Helicopter R44 II · S/N 11785N200PPBeech 95-B55 (T42A) · S/N TC-1415N73285Bell 47G-3B-1 · S/N 2909N3529UCessna 182F · S/N 18254929N4258FCessna 172 · S/N 46158N7787PPiper PA-24-250 · S/N 24-3004N63253Stinson L-5 · S/N 76-225N7477ZSlingsby SWALLOW TYPE T.45 · S/N 1661N5173CBeech 35 · S/N D-2458N6209ZStinson L-5G · S/N 4615N2206KLuscombe 8A · S/N 4933
Back to Phoenix, AZ