OpenAirDocs.org
Ozark, MO

Cancelled registrations · 23

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

N55569Boeing A75N1(PT17) · S/N 75-1875Cancelled Jun 6, 2025 · Exported to South Africa · Saint Aviation Ministry LLCN6807VAerostar Acft Corp Of Texas M20E · S/N 21-0003Cancelled Oct 4, 2019 · First renewal notice · Built 1971 · Barnett Russell LN583FDDJI INSPIRE 1 · S/N 3DCC23030393Cancelled May 6, 2019 · Registration expired, pending cancellation · 417 Drone Imaging LLCN583HDDJI PHANTOM 3 PROFESSION · S/N 03Z0038609Cancelled Jan 15, 2019 · Registration expired, pending cancellation · 417 Drone Imaging LLCN311ABPiper PA-31P · S/N 31P-7300169Cancelled Dec 17, 2018 · Registration expired, pending cancellation · Built 1973 · Jakl LLCN5138PPiper PA-24 · S/N 24-152Cancelled Apr 23, 2018 · First renewal notice · Built 1958 · Nuckolls Mark AndrewN456NFPiper J3C-65 · S/N 15232Cancelled Jan 5, 2018 · Registration expired, pending cancellation · Flynn Joseph KN6102GBell Gene F EXEC 90 · S/N 52836Cancelled Sep 29, 2017 · Built 1998 · Bell Gene FN5350FPiper PA-34-200T · S/N 34-7770009Cancelled Aug 11, 2016 · First renewal notice · Built 1976 · Denney JamesN35SPSkypower GBN-41-1000 · S/N 111Cancelled Oct 2, 2014 · Registration expired, pending cancellation · Built 1979 · Herschend James RN88XSStern Lessing S ROTORWAY EXEC 162F · S/N 6049Cancelled Aug 8, 2013 · Sale reported, canceled · Built 1998N31460Anderson Doug QUICKSILVER MX II · S/N 3869Cancelled Jul 2, 2013 · Registration expired, pending cancellation · Built 1982 · Stratos Flight IncN801RCBellanca 17-30A · S/N 74-30631Cancelled May 22, 2013 · Registration expired, pending cancellation · Built 1973 · Teeter Brian HN13729Cessna 172M · S/N 17262975Cancelled Jan 23, 2008 · Exported to Canada · Built 1974 · Airregency LLCN145JBBumgarner Johnny G CA65 SKY FLY · S/N 001Cancelled Apr 21, 2003 · Triennial form not returned · Built 1995 · Bumgarner Johnny GN9187VMooney M20C · S/N 690038Cancelled Jul 18, 2002 · Built 1969 · Barnett RussellN7222URoberts Jim L RANS COYOTE S-4 · S/N 096242Cancelled Mar 26, 2001 · Brow Kelley JN35925Aerostar International RAVEN S57-A · S/N S57A-3057Cancelled May 25, 2000 · Second triennial mailing, no response · Ozark Balloon Port IncN22283Taylorcraft BL · S/N 1233Cancelled Dec 5, 1980 · Hickman David MN7130GCessna 172K · S/N 17258830Cancelled Oct 8, 1977 · Air Springfield IncN56200Cessna 172F · S/N 17251913Cancelled Jul 9, 1976 · Exported to Canada · Air Springfield IncN8028XCessna 172B · S/N 17248528Cancelled Mar 25, 1976 · Exported to Canada · Air Springfield IncN6830SAero Commander 680 · S/N 680-337-30Cancelled Oct 6, 1975 · Air Springfield Inc
Back to Ozark, MO