OpenAirDocs.org
Ozark, AL

Cancelled registrations · 114

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

N4141Mooney M20C · S/N 680127Cancelled Feb 6, 2021 · Sale reported, canceled · Built 1968N925AVAndersen Alan Lewis KITFOX SER V VIXEN · S/N V9710-0065Cancelled Feb 2, 2021 · Exported to Canada · Built 1999 · Smith Gerald GN321RFForsythe Ronald D US LIGT ACFT HORNET · S/N 64Cancelled Mar 26, 2020 · Third renewal notice · Built 2001 · Varbel Charles FN26049Piper J3L · S/N 4001Cancelled Feb 7, 2019 · Sale reported, canceled · Built 1939N485TFBell AH-1F · S/N 20626Cancelled Mar 5, 2018 · Registration expired, pending cancellation · Friends Of Army Aviation OzarkN992LCBuckner Lloyd E RAND KR2 · S/N LEB102649Cancelled Feb 13, 2018 · Registration expired, pending cancellation · Built 1992 · Kiracofe George RN465JRBell TH-1L · S/N 157828Cancelled Jan 23, 2018 · Registration expired, pending cancellation · Williams Helicopter CorpN204APBell TH-1L · S/N 157840Cancelled Jan 16, 2018 · Registration expired, pending cancellation · Built 1970 · Southern Aero CorporationN296FABell UH-1H · S/N 66-16126Cancelled Dec 19, 2017 · Sale reported · Bell Helicopter Textron IncN4869ZBell UH-1H · S/N 66-17123Cancelled Dec 19, 2017 · Built 1966 · Bell Helicopter Textron IncN486PABell UH-1H · S/N 66-16321Cancelled Dec 19, 2017 · Built 1966 · Bell Helicopter Textron IncN806YBBell UH-1H · S/N 66-17099Cancelled Dec 19, 2017 · Sale reported · Built 1966 · Bell Helicopter Textron IncN810ASBell UH-1H · S/N 6413898Cancelled Dec 19, 2017 · Built 1964 · Bell Helicopter Textron IncN55266Cessna 172P · S/N 17275148Cancelled May 23, 2017 · Registration expired, pending cancellation · Built 1981 · Wallace Community CollegeN4491ZBell UH-1H · S/N 67-17155Cancelled Dec 28, 2016 · Built 1967 · Bell Helicopter Textron IncN464QABell UH-1H · S/N 69-15332Cancelled Dec 28, 2016 · Built 1969 · Bell Helicopter Textron IncN464XABell UH-1H · S/N 67-17772Cancelled Dec 28, 2016 · Built 1967 · Bell Helicopter Textron IncN4705BBell UH-1H · S/N 69-15910Cancelled Dec 28, 2016 · Built 1969 · Bell Helicopter Textron IncN476YBBell UH-1H · S/N 69-15579Cancelled Dec 28, 2016 · Built 1969 · Bell Helicopter Textron IncN482SDBell UH-1H · S/N 66-16572Cancelled Dec 28, 2016 · Bell Helicopter Textron IncN451FBBell UH-1H · S/N 70-16286Cancelled Mar 31, 2016 · Exported to Lebanon · Built 1970 · Bell Helicopter Textron IncN464NABell UH-1H · S/N 68-16271Cancelled Mar 31, 2016 · Exported to Lebanon · Built 1968 · Bell Helicopter Textron IncN5790GCessna 150K · S/N 15071290Cancelled Oct 29, 2014 · Registration expired, pending cancellation · Built 1969 · Enterprise Ozark Community CollegeN5641GCessna 150K · S/N 15071141Cancelled Oct 28, 2014 · Registration expired, pending cancellation · Built 1969 · Wallace Community CollegeN152DACessna 152 · S/N 15282012Cancelled Oct 18, 2013 · Registration expired, pending cancellation · Built 1978 · Enterprise-Ozark Community CollegeN32038Piper PA-32-300 · S/N 32-7540010Cancelled Oct 18, 2013 · Registration expired, pending cancellation · Built 1974 · Mccaslin JamesN7160JBell UH-1L · S/N 155346Cancelled Sep 26, 2013 · Registration expired, pending cancellation · Unc Helicopter IncN9424ABell UH-1H · S/N 68-15254Cancelled Sep 24, 2013 · Registration expired, pending cancellation · Built 1968 · Southern Aero CorporationN71SBMooney M20E · S/N 565Cancelled Sep 16, 2013 · Registration expired, pending cancellation · Built 1965 · Hollis James EN83985Bell UH-1B · S/N 62-1944Cancelled Sep 10, 2013 · Registration expired, pending cancellation · Unc Helicopter IncN101PHPiper PA-28 · S/N 28-101Cancelled Aug 21, 2013 · Sale reported, canceled · Built 1961N3809EAeronca 11AC · S/N 11AC-S-28Cancelled Aug 7, 2013 · Sale reported, canceled · Built 1947N1382XBell 47G-3B-1 · S/N 6579Cancelled Aug 6, 2013 · Registration expired, pending cancellation · Built 1966 · Helicopter Serv Air IncN4391TBell 212 · S/N 30813Cancelled Jul 16, 2013 · Sale reported, canceledN48707Cessna 152 · S/N 15280933Cancelled Jul 9, 2013 · Registration expired, pending cancellation · Built 1977 · Enterprise-Ozark Community CollegeN98024Bell UH-1B · S/N 63-8556Cancelled Jun 5, 2013 · Registration expired, pending cancellation · Built 1984 · Southern Aero CorporationN8452GCessna 150F · S/N 15062552Cancelled May 14, 2013 · Registration expired, pending cancellation · Built 1965 · Garrett Elizabeth LN80477Bell UH-1B · S/N 61-12555Cancelled May 13, 2013 · Registration expired, pending cancellation · Southern Aero CorporationN118HSBell UH-1L · S/N 155341Cancelled Apr 2, 2013 · Sale reported, canceled · Built 1968N119HSBell UH-1L · S/N 151887Cancelled Apr 2, 2013 · Sale reported, canceledN32284Bell UH-1F · S/N 64-15477Cancelled Apr 1, 2013 · Sale reported, canceledN94474Hiller OH-23G · S/N 64-15233Cancelled Mar 20, 2013 · Sale reported, canceled · Built 1964N74897Bell H-13D · S/N 51-2526Cancelled Feb 21, 2013 · Sale reported, canceled · Built 1951N65739Hiller H-23D · S/N 61-3092Cancelled Feb 13, 2013 · Sale reported, canceled · Built 1961N67163Bell-Cirello 204-B · S/N 7324Cancelled Feb 13, 2013 · Sale reported, canceled · Built 1975N68351Sikorsky R-4B · S/N 136Cancelled Feb 13, 2013 · Sale reported, canceled · Built 1944N4692PCessna 152 · S/N 15284800Cancelled Dec 11, 2012 · Registration expired, pending cancellation · Built 1980 · Wallace Community CollegeN49131Cessna 152 · S/N 15283428Cancelled Dec 10, 2012 · Sale reported, canceled · Built 1979N200HTAero Commander 200D · S/N 347Cancelled Dec 7, 2012 · Sale reported, canceled · Built 1966N30131Raven S-60 · S/N S60-102Cancelled Sep 25, 2012 · Registration expired, pending cancellation · Built 1966 · United States Army Aviation Museum
Back to Ozark, AL