Montgomery, AL
Cancelled registrations · 201
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 = 'AL' AND d.registrant_city = 'MONTGOMERY' 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 = 'AL' AND d.registrant_city = 'MONTGOMERY' 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.
N3498YCessna 180H · S/N 51998N207PSBell TH-13T · S/N 658074N209PSBell TH-13T · S/N 65-8056N2979PPiper PA-18-150 · S/N 18-4517N499YGrumman G-164 · S/N 143N1579Dehavilland BEAVER U-6A · S/N 52-6143N206PSBell TH-13T · S/N 3622N41479Piper PA-28R-200 · S/N 28R-7435190N8296DBeech J35 · S/N D-5386N7929CPiper PA-28-151 · S/N 28-7615067N8635QBeech S35 · S/N D-7657N203PSBell TH-13T · S/N 66-8104N5834ZPiper PA-22-108 · S/N 22-9686N4102XAero Commander 100 · S/N 159N5904GCessna 150K · S/N 15071404N3798VCessna 140A · S/N 15219N46605Aeronca 65-TC · S/N C3852TAN27637Taylorcraft BL-65 · S/N 2279N3376PPiper PA-23-160 · S/N 23-1336N2953ACessna 180 · S/N 30153N32612Piper J3C-65 · S/N 5484N2115DBeech D35 · S/N D-3460N6878MStinson 108-3 · S/N 108-48778N3174PPiper PA-23 · S/N 23-1109N39100Taylorcraft BC12-65 · S/N 3312N46835Taylorcraft DCO-65 · S/N L-6278N54506Boeing A75N1 · S/N 75-1087N55561Consolidated Vultee BT-13A · S/N 11347N22203Taylorcraft BC · S/N 1141N5950CBeech C35 · S/N D-3311N9228ACessna 170A · S/N 18989N1916MBoeing E75N1 · S/N 75-8641N1999BLuscombe T-8F · S/N 6426N71518Luscombe 8A · S/N 2945N102EHarlow PJC-2 · S/N 4N55380Fairchild PT-19A · S/N T42-1646N90153Arbc Inc DBA Lindstrand 120A · S/N 9218N5694HPiper PA-16 · S/N 16-305N6391KRepublic RC-3 · S/N 629N46985Ryan Aeronautical ST3KR · S/N 1674N3528NPiper J3C-65 · S/N 22759N53581Fairchild M-62A · S/N T42-3414N81835Aeronca 7AC · S/N 7AC-458N92161Piper J3C-65 · S/N 16600N55384Fairchild M-62A · S/N T42-3978N75242Fairchild UC-61A · S/N 43-14891N84878Aeronca 7AC · S/N 7AC-3597N12846Great Lakes 2T-1A · S/N 256N921Waco GXE · S/N 977N895YLenoir Henry Clifton HEATH PARASOL · S/N 1-HCL
Back to Montgomery, AL