Skip to content

Cancelled registrations · 41

Query with SQL

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 = 'AR' AND d.registrant_city = 'LONOKE' ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id

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 = 'AR' AND d.registrant_city = 'LONOKE'
  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.

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 = 'AR' AND d.registrant_city = 'LONOKE'
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N43494Taylorcraft BC12-D · S/N 7153Cancelled Mar 23, 2026 · Sale reported, canceled · Built 1990 N7337DPiper PA-22-150 · S/N 22-5126Cancelled Nov 4, 2023 · Sale reported, canceled N7220XCessna 150A · S/N 15059320Cancelled Apr 1, 2023 · Registration expired, pending cancellation · Built 1961 · Adamson Matthew C N5286YPiper PA-23-250 · S/N 27-2351Cancelled Feb 5, 2022 · Registration expired, pending cancellation · Built 1963 · 92nd West Aviation Inc N8456FPiper PA-32R-300 · S/N 32R-7780100Cancelled Feb 5, 2022 · Registration expired, pending cancellation · Built 1976 · 92nd West Aviation Inc N9879TPiper PA-38-112 · S/N 38-78A0230Cancelled Nov 20, 2021 · Expired dealer · Built 1978 · Apd Systems LLC N8784HNorth American NAVION · S/N NAV-4-784Cancelled Jun 5, 2021 · Registration expired, pending cancellation · Built 1947 · Finley Wade W N820DAPiper PA-23 · S/N 23-820Cancelled May 8, 2021 · Registration expired, pending cancellation · Built 1956 · 92nd West Aviation Inc N33732Piper PA-28R-200 · S/N 28R-7535183Cancelled Sep 18, 2020 · Sale reported, canceled · Built 1975 N868DAPiper PA-23 · S/N 23-868Cancelled Sep 4, 2020 · Registration expired, pending cancellation · Built 1957 · 92nd West Aviation Inc N42LCChampion 7ECA · S/N 493Cancelled Apr 3, 2020 · Registration expired, pending cancellation · Built 1966 · 92nd West Aviation Inc N53805Bellanca 7KCAB · S/N 545-75Cancelled Apr 3, 2020 · Registration expired, pending cancellation · Built 1975 · 92nd West Aviation Inc N8417SCessna 182H · S/N 18256517Cancelled Apr 3, 2020 · Registration expired, pending cancellation · Built 1965 · 92nd West Aviation Inc N2201SBeech SNB-5 · S/N 12362Cancelled Jan 18, 2019 · Built 1963 · Ferguson Mark R N916HCGS HAWK ARROW II SLSA · S/N HAII-316-700E-TRICancelled Jun 26, 2018 · Registration pending, canceled · Built 2013 N114CPiper PA-23 · S/N 23-317Cancelled Jan 2, 2018 · Registration expired, pending cancellation · Built 1955 · 92nd West Aviation Inc N8SXPiper PA-32-300 · S/N 32-7540015Cancelled Dec 8, 2017 · Built 1974 · 92nd West Aviation Inc N24EBBaldwin Earl BALDWIN SKYBOLT · S/N 2Cancelled Sep 7, 2017 · Registration expired, pending cancellation · Built 1988 · Jackson Russell W DBA N89247Cessna 140 · S/N 8267Cancelled Nov 20, 2014 · Registration expired, pending cancellation · Built 1946 · Fulmer Ralph W N6750FCessna 150F · S/N 15063350Cancelled Sep 3, 2014 · Sale reported, canceled · Built 1966 N3672SCessna 172E · S/N 17250872Cancelled Aug 19, 2013 · Sale reported, canceled · Built 1963 N3962WPiper PA-32-260 · S/N 32-940Cancelled Aug 13, 2013 · Sale reported, canceled · Built 1967 N73471Cessna 172M · S/N 17267487Cancelled May 31, 2013 · Sale reported, canceled · Built 1976 N9898BChampion 7FC · S/N 7FC-218Cancelled Nov 14, 2012 · Registration expired, pending cancellation · 92nd West Aviation Inc N4ENNutter STITTS PLAYBOY S-607 · S/N S-607Cancelled Sep 18, 2012 · Built 1975 · Adamson Don R N3470APiper PA-22-135 · S/N 22-1738Cancelled Apr 14, 2012 · Triennial form not returned · Built 1953 · Babic Rick A N101KPiper PA-23-250 · S/N 27-3510Cancelled Aug 8, 2011 · First renewal notice · Built 1966 · 92nd West Aviation Inc N7810TCessna 172A · S/N 47410Cancelled Jan 19, 2011 · First renewal notice · Built 1960 · Adamson Don R N11030Champion 7ECA · S/N 54Cancelled Nov 30, 2010 · Exported to Belize · Built 1964 · Barnett Charles R N6532WPiper PA-28-140 · S/N 28-20611Cancelled Mar 31, 2010 · Triennial form not returned · Built 1965 · 32 Whiskey Inc N15WAPiper PA-23-250 · S/N 27-2701Cancelled Oct 5, 2005 · Triennial form not returned · Built 1964 · Adamson Donald R N485RVAdamson Donald R II RV-3 · S/N 485Cancelled Oct 5, 2005 · Triennial form not returned · Adamson Donald R II N92WACessna 150L · S/N 15073770Cancelled Apr 14, 2005 · Built 1972 · Adamson Donald R N7044QCessna 182P · S/N 18262020Cancelled Mar 15, 1985 · Aerie Inc N501RNNelson BD-5B · S/N 5047Cancelled Aug 5, 1980 · Nelson Gilter R Jr N20538Cessna 172M · S/N 17261375Cancelled Sep 28, 1979 · Exported to Paraguay · Nichols Gilbert A N57713Piper PA-36-285 · S/N 36-7660036Cancelled Dec 16, 1977 · Tidwell Flying Service Inc N88148Bellanca 8GCBC · S/N 80-74Cancelled Jul 21, 1977 · Built 1974 · Finley Co Farms N9699HCessna T-50 · S/N 2659Cancelled Aug 19, 1970 · Built 1943 · Lilly Joe H N6251ZPiper PA-25 · S/N 25-310Cancelled Nov 16, 1967 · Hanneman Delmar R N4597APiper PA-18A 150 · S/N 18-4910Cancelled Dec 12, 1960 · Aukes Donald E Etal

Back to Lonoke, AR