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.

N3498YCessna 180H · S/N 51998Cancelled Feb 3, 1982 · Built 1968 · National Headquarters Civil Air PatrolN207PSBell TH-13T · S/N 658074Cancelled Dec 31, 1980 · Department Of Public SafetyN209PSBell TH-13T · S/N 65-8056Cancelled Dec 31, 1980 · Department Of Public SafetyN2979PPiper PA-18-150 · S/N 18-4517Cancelled Mar 27, 1978 · State Of AlabamaN499YGrumman G-164 · S/N 143Cancelled Aug 10, 1977 · Exported to Nicaragua · Smith Aero Service IncN1579Dehavilland BEAVER U-6A · S/N 52-6143Cancelled Jul 11, 1977 · Exported to Canada · Built 1952N206PSBell TH-13T · S/N 3622Cancelled Oct 26, 1976 · Separtment Of Public Safety State Of AlabamaN41479Piper PA-28R-200 · S/N 28R-7435190Cancelled Jun 23, 1976 · Built 1974 · Maxwell-Gunter Air Force Base Aero ClubN8296DBeech J35 · S/N D-5386Cancelled Apr 6, 1976 · Arrow IncN7929CPiper PA-28-151 · S/N 28-7615067Cancelled Feb 10, 1976 · Exported to Canada · Montgomery Piper Sales IncN8635QBeech S35 · S/N D-7657Cancelled Nov 8, 1975 · Built 1964 · Reagan C HN203PSBell TH-13T · S/N 66-8104Cancelled May 6, 1975 · United States GovtN5834ZPiper PA-22-108 · S/N 22-9686Cancelled Aug 7, 1974 · Montgomery Aviation CorpN4102XAero Commander 100 · S/N 159Cancelled Jul 25, 1974 · Built 1967 · Civil Air PatrolN5904GCessna 150K · S/N 15071404Cancelled Dec 11, 1973 · Capital City Aviation IncN3798VCessna 140A · S/N 15219Cancelled Oct 1, 1973 · Green R WN46605Aeronca 65-TC · S/N C3852TACancelled Oct 7, 1970 · Arsenault Ronald LN27637Taylorcraft BL-65 · S/N 2279Cancelled Jul 30, 1970 · Gwin B AN3376PPiper PA-23-160 · S/N 23-1336Cancelled Jul 6, 1970 · Built 1958 · Montgomery Aviation CorporationN2953ACessna 180 · S/N 30153Cancelled Jun 22, 1970 · Cox Charles LN32612Piper J3C-65 · S/N 5484Cancelled Apr 24, 1970 · Jones James SN2115DBeech D35 · S/N D-3460Cancelled May 19, 1965 · Montogomery Aviation CorpN6878MStinson 108-3 · S/N 108-48778Cancelled Sep 4, 1959 · Peek James BN3174PPiper PA-23 · S/N 23-1109Cancelled Feb 1, 1959 · Built 1957 · State Of Alabama State Highway DepartmentN39100Taylorcraft BC12-65 · S/N 3312Cancelled Jun 7, 1957 · Barney E Godwin JrN46835Taylorcraft DCO-65 · S/N L-6278Cancelled Jul 24, 1956 · Edmonson Joseph FN54506Boeing A75N1 · S/N 75-1087Cancelled Nov 30, 1955 · United Dusting Corp IncN55561Consolidated Vultee BT-13A · S/N 11347Cancelled Oct 26, 1955 · Miller T CalvinN22203Taylorcraft BC · S/N 1141Cancelled Oct 19, 1955 · Edmonson Joseph FrankN5950CBeech C35 · S/N D-3311Cancelled Feb 7, 1955 · Alabama Discount CorpN9228ACessna 170A · S/N 18989Cancelled Jun 18, 1953 · Exported to Colombia · Peterson A JohnN1916MBoeing E75N1 · S/N 75-8641Cancelled Jun 15, 1953 · Civil Air Patrol Alabama Wing Montgomery Group 1N1999BLuscombe T-8F · S/N 6426Cancelled Mar 25, 1952 · Built 1948 · Montgomery Aviation CorpN71518Luscombe 8A · S/N 2945Cancelled Nov 19, 1951 · Pentecost W GeraldN102EHarlow PJC-2 · S/N 4Cancelled Nov 8, 1951 · Built 1940 · Brazil R HN55380Fairchild PT-19A · S/N T42-1646Cancelled Apr 30, 1951 · Built 1942 · Alabama Air ServiceN90153Arbc Inc DBA Lindstrand 120A · S/N 9218Cancelled Apr 27, 1951 · Alabama Air ServiceN5694HPiper PA-16 · S/N 16-305Cancelled Mar 9, 1951 · Norman Bridge Aviation Corp IncN6391KRepublic RC-3 · S/N 629Cancelled Jun 8, 1950 · State Of Alabama Conservation DeptN46985Ryan Aeronautical ST3KR · S/N 1674Cancelled Mar 7, 1950 · T Calvin MillerN3528NPiper J3C-65 · S/N 22759Cancelled Jul 15, 1949 · Alabama Air ServiceN53581Fairchild M-62A · S/N T42-3414Cancelled Jun 6, 1949 · Montgomery Aviation CorpN81835Aeronca 7AC · S/N 7AC-458Cancelled May 31, 1949 · Montgomery Aviation CorpN92161Piper J3C-65 · S/N 16600Cancelled Apr 29, 1949 · Alabama Air ServiceN55384Fairchild M-62A · S/N T42-3978Cancelled Mar 9, 1949 · Built 1943 · Alabama Air ServiceN75242Fairchild UC-61A · S/N 43-14891Cancelled Feb 17, 1949 · Montgomery Aviation CoN84878Aeronca 7AC · S/N 7AC-3597Cancelled Jul 9, 1948 · Montgomery Aviation CorporationN12846Great Lakes 2T-1A · S/N 256Cancelled Aug 15, 1938 · Capenis JamN921Waco GXE · S/N 977Cancelled Jul 11, 1934 · Hobbie R M JrN895YLenoir Henry Clifton HEATH PARASOL · S/N 1-HCLCancelled Jul 26, 1933 · Henry Clifton Lenoir
Back to Montgomery, AL