Tempe, AZ
Cancelled registrations · 146
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 = 'TEMPE' 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 = 'TEMPE' 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.
N8094ZRaven S55A · S/N S55A499N4278RSpargo Lyle R DRAGONFLY · S/N 1N4089URaven S-60A · S/N S60A267N6679VBellanca 17-30 · S/N 30052N922ETTeague Edwin L PHANTOM · S/N 487N5312RCessna 172M · S/N 17263514N13896Cessna 172M · S/N 17263033N85ASStrojnik Alex S-4 · S/N 001N38823Hasforth Chester MITCHELL U2 · S/N 159N4198PRaven S55A · S/N S55A944N89WSStarr Robert H BUMBLE BEE II · S/N 1N83WSStarr Robert H STARR · S/N 1N6653XCessna 210A · S/N 21057653N5262UCessna 172RG · S/N 172RG0309N2309EFritts-David CASSUTT-3M · S/N 12345N49774Cessna 152 · S/N 15283512N3586Nickerson-Pietenpol AIR CAMPER NFL · S/N 1N37824Newell SCORPION 133 · S/N RW04N69395Stinson VULTEE V-77 · S/N 77-477N5886Rotorway SCORPION TOD BJ201 · S/N 001N31222Schramm SCORPION TOO · S/N RW02N8010PPiper PA-24-250 · S/N 24-3253N25186Parker ICARUS · S/N JP02N1819GChampion 7ECA · S/N 576N34087Schweizer SGS 1-35 · S/N 10N44756Naval Aircraft Factory N3N-3 · S/N 2773N4423SCessna 337D · S/N 337-1035N662APiper PA-22 · S/N 22-65N7530Schweizer SGS 2-33A · S/N 170N6019QMooney M20E · S/N 869N72453Cessna U206D · S/N U206-1413N44977Naval Aircraft Factory N3N-3 · S/N 2823N45110Naval Aircraft Factory N3N-3 · S/N 4364N38191Piper J4E · S/N 4-1557N45007Naval Aircraft Factory N3N-3 · S/N 2779N19001Taylorcraft A · S/N 107N47710Aeronca 0-58B · S/N 058B4982N83351Aeronca 7AC · S/N 7AC-2018N85007Aeronca 11AC · S/N 11AC-3732N4973VStinson L-5 · S/N 02793N43317Taylorcraft BC12-D · S/N 6976N85272Aeronca 7AC · S/N 7AC-4007N45173Naval Aircraft Factory N3N-3 · S/N 2638N2260KLuscombe 8A · S/N 4987N847CStinson 108-3 · S/N 108-3847N37281Interstate S-1A · S/N 124
Back to Tempe, AZ