Huntsville, AL

Cancelled registrations · 227

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 = 'HUNTSVILLE'
  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.

N5703RCessna 172F · S/N 17253355Cancelled Apr 23, 1974 · Greenhaw William ON5749LAmerican AA-1 · S/N AA1-0149Cancelled Apr 23, 1974 · Lavender Homer C JrN712FLPiper PA-28-140 · S/N 28-7225331Cancelled Feb 7, 1974 · Huntsville Aviation CorpN7720RBeech 95-B55 (T42A) · S/N TC-1014Cancelled Feb 5, 1974 · Blue John IIIN4580JPiper PA-28R-180 · S/N 28-30449Cancelled Dec 19, 1973 · Victor W RuweN8329MCessna A150K · S/N 1500029Cancelled Dec 14, 1973 · Hutchison John P JrN22011Cessna 150H · S/N 15068008Cancelled Dec 12, 1973 · Bill R LakeN60318Cessna 150J · S/N 15070222Cancelled Dec 12, 1973 · Lake Bill RN3231BPiper PA-22-135 · S/N 222060Cancelled Aug 14, 1972 · Built 1954 · Richardson Robert FN4381FTaylor George G SA300 · S/N 38Cancelled Dec 16, 1971 · Misfeldt Richard LN3381VBeech 35 · S/N D-849Cancelled Mar 23, 1971 · Built 1947 · Dilsaver Keith DN18328Taylorcraft A · S/N 61Cancelled Jan 4, 1971 · Built 1937 · Hoots Lloyd PN459CMeyers Industries 200 · S/N 251Cancelled Dec 29, 1970 · Built 1959 · Associated Aircraft IncN8501JCessna 150G · S/N 15066401Cancelled Jun 24, 1970 · King Thomas Aa JrN10559Piper PA-18 · S/N 18-920Cancelled Jun 19, 1970 · United States ArmyN10563Navion NAVION A · S/N NAV-4-961Cancelled Jun 19, 1970 · United States ArmyN8985ABeech C35 · S/N D-2737Cancelled Jan 30, 1968 · Jewell Virgil HN7797FCessna 150F · S/N 150-63897Cancelled Nov 30, 1967 · 150 Flying ClubN5314BCessna 182 · S/N 33314Cancelled May 25, 1966 · Webb James WN77409Cessna 140 · S/N 11850Cancelled Nov 17, 1965 · Gooney Birds IncN2276DCessna 170B · S/N 20428Cancelled Aug 9, 1965 · Elaine & Herman FentressN1207HAeronca 15AC · S/N 15AC-219Cancelled May 18, 1965 · Carroll Ronald GN9573DPiper PA-18A 150 · S/N 18-6755Cancelled Jul 28, 1961 · Built 1959 · Carter Milton/Bailey AaronN7018Cessna LC-126C · S/N 517018Cancelled Jul 18, 1961 · US ArmyN39595Aeronca 65-TAC · S/N C5563TACancelled Oct 21, 1955 · Elliott Walton SN55538Consolidated Vultee SNV-2 · S/N 79-915Cancelled Dec 9, 1954 · Holmes Jr Samuel ON7460Alexander COMBINATION EAGLEROC · S/N 114Cancelled Mar 14, 1930 · Built 1926 · Lanier Freddie J
Back to Huntsville, AL