OpenAirDocs.org
Elizabethton, TN

Cancelled registrations · 31

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 = 'TN' AND d.registrant_city = 'ELIZABETHTON'
  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.

N6104SAir & Space America 18A · S/N 18-10Cancelled May 29, 2020 · Registration expired, pending cancellation · Built 1965 · Hayduk International LLCN22326Cessna 150H · S/N 15068217Cancelled Oct 5, 2019 · Registration expired, pending cancellation · Built 1968 · Hayduk AviationN31952Piper PA-30 · S/N 30-193Cancelled Oct 4, 2019 · Registration expired, pending cancellation · Railroad Equipment Restoration AssociationN115ESHughes 269A-1 · S/N 26-0470Cancelled Jul 1, 2013 · Registration expired, pending cancellation · Built 1964 · Netstar Air Rescue IncN120MSCessna U206G · S/N U20603668Cancelled Mar 13, 2013 · First renewal notice · Built 1977 · Focus AviationN70059Cessna A185E · S/N 18501932Cancelled Feb 27, 2013 · Sale reported, canceled · Built 1971N13600Cessna 172M · S/N 17262872Cancelled Feb 28, 2011 · Sale reported, pending cancellation · Built 1973N1638UCessna 210N · S/N 21064712Cancelled Oct 29, 2003 · Exported to Australia · Built 1982 · Project Air IncN991DJJackson Darrell W JACKSON P-51 · S/N 001Cancelled Oct 10, 2001 · Sale reported · Built 1991N734FXCessna 172N · S/N 17268829Cancelled Jan 24, 2001 · Exported to Brazil · Moody Bible Institute Of ChicagoN75981Cessna 172N · S/N 17268082Cancelled Nov 2, 2000 · Exported to Australia · Moody Bible Institute Of ChicagoN734UCCessna 172N · S/N 17269116Cancelled Aug 22, 2000 · Exported to Venezuela · Moody Bible Institute Of ChicagoN732FDCessna U206G · S/N U20604668Cancelled Aug 24, 1998 · Triennial form not returned · Project Air IncN2045SCessna T210L · S/N 21061012Cancelled Oct 27, 1993 · Triennial form not returned · Moody Bible Institute Of Chicago IncN32NCGolden Circle Air T-BIRD II · S/N 9201001Cancelled Aug 17, 1993 · Carter NickN4583JPiper PA-28R-180 · S/N 28R-30453Cancelled Nov 22, 1982 · Built 1968 · C And G AeroN9590XCessna 210B · S/N 21057890Cancelled Dec 17, 1981 · Moody Bible Institute Of ChicagoN644ZCessna 180H · S/N 18051613Cancelled Aug 1, 1980 · Modern Furniture Co Of Elizabethon IncN1850RCessna A185F · S/N 18502565Cancelled Jul 1, 1980 · Built 1974 · Modern Furniture Co Of Elizabethton IncN9025MCessna 180H · S/N 180-52125Cancelled Mar 1, 1976 · Exported to Canada · Modern Furniture Co Of Elizabethon IncN91292Cessna 180H · S/N 18052032Cancelled Feb 27, 1976 · Exported to Canada · Modern Furniture Co Of Elizabethton IncN4626UCessna 180G · S/N 18051326Cancelled Sep 8, 1975 · Exported to Canada · Modern Furniture Co Of Elizabethton IncN7995VCessna 180H · S/N 18051895Cancelled May 30, 1975 · Exported to Canada · Modern Furniture Co Of Elizabethton IncN4810BCessna 180 · S/N 18051883Cancelled Apr 12, 1975 · Nick Carter'S Modern Furniture Co IncN8742ABeech A35 · S/N D-2164Cancelled Jan 4, 1971 · Baughman William JN86227Aeronca 11AC · S/N 11AC-31Cancelled Oct 7, 1965 · Besty Flying ClubN94156Engineering & Research 415-C · S/N 1479Cancelled May 22, 1965 · Elizabethton Flying ClubN99966Erco 415-C · S/N 2589Cancelled May 20, 1965 · Modern Furniture Co Of Elizabethton IncN3312DCessna 180 · S/N 32110Cancelled May 19, 1965 · Modern Furniture Co IncN4602ACessna 180 · S/N 32200Cancelled May 13, 1964 · Modern Furniture Co Of Elizabeth IncN16990Piper J-2 · S/N 856Cancelled Jan 4, 1938 · Hyder O Carson And Hutchins Harry Wagner
Back to Elizabethton, TN