Skip to content

Cancelled registrations · 30

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 = 'NE' AND d.registrant_city = 'PAPILLION' 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 = 'NE' AND d.registrant_city = 'PAPILLION'
  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 = 'NE' AND d.registrant_city = 'PAPILLION'
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.

N80ZAEaa Chapter 80 STOL CH750 · S/N 75-8591Cancelled Oct 5, 2024 · Sale reported, canceled · Built 2023 N6XMMooney M20C · S/N 2805Cancelled Jan 6, 2020 · Registration expired, pending cancellation · Built 1964 · Ahmanson Jason A N457EMDJI PHANTOM 3 PROFESSION · S/N P76DCE18016662Cancelled Jan 16, 2019 · Registration expired, pending cancellation · Sibbernsen Michael K D N5204BMooney M20 · S/N 1067Cancelled May 18, 2018 · Revoked, canceled · Built 1956 · Whited Flying Service N882RHHarriman Richard S-16 · S/N 1298008Cancelled Apr 4, 2018 · Registration expired, pending cancellation · Built 1999 · Harriman Richard H Trustee N2294SWiley Dennis 80% SPAD 13 · S/N 001Cancelled Feb 12, 2018 · Registration expired, pending cancellation · Built 1995 · Ratte Jim N93866Forney 415-C · S/N 1189Cancelled Nov 21, 2017 · Revoked, canceled · Built 1946 · Cozad Russell F N2438QCessna 182K · S/N 18257638Cancelled Oct 25, 2017 · Registration expired, pending cancellation · Built 1966 · Lawson Christopher N20509Berdeaux Gary C RAVEN X · S/N SN2232/0180Cancelled Jul 6, 2016 · First renewal notice · Built 1986 · Howard Keith J N30337Barche Martin J DESTINY XLT · S/N 3C0481Cancelled May 6, 2015 · Registration expired, pending cancellation · Built 2002 · Barche Martin J N7669CNorth American TB-25N · S/N 44-29839Cancelled Nov 18, 2014 · Registration expired, pending cancellation · United Aerial Applicators Inc N46242Cessna 172I · S/N 17257131Cancelled Oct 9, 2014 · Registration expired, pending cancellation · Built 1968 · Midlands Aircraft Sales Inc N228DWWondrasek David J RANS S-10 SAKOTA · S/N 10290088Cancelled Aug 29, 2014 · Registration expired, pending cancellation · Wondrasek David J N4352UCessna 150D · S/N 15060352Cancelled Aug 19, 2013 · Sale reported, canceled · Built 1964 N914AXNihon YS-11A-500 · S/N 2056Cancelled Aug 13, 2013 · Sale reported, canceled · Built 1968 N912AXNihon YS-11A-500 · S/N 2052Cancelled Aug 8, 2013 · Sale reported, canceled · Built 1968 N7028DPiper PA-22-150 · S/N 22-4922Cancelled Jul 30, 2013 · Sale reported, canceled N915AXNihon YS-11A-500 · S/N 2062Cancelled Mar 26, 2013 · Sale reported, canceled · Built 1968 N922AXNihon YS-11A-500 · S/N 2120Cancelled Mar 26, 2013 · Sale reported, canceled · Built 1969 N301SBeech T42 · S/N 66-04302Cancelled Dec 7, 2012 · Sale reported, canceled · Built 1966 N4767PPiper PA-23-250 · S/N 27-309Cancelled Nov 27, 2012 · Sale reported, canceled · Built 1960 N38207Piper J3C-65 · S/N 6917Cancelled Aug 8, 2011 · Revoked, canceled · Built 1941 · Brown Copters Inc N2654UCessna 172D · S/N 17250254Cancelled Jul 15, 2009 · Registration revoked · Built 1963 · Bradley Robert W N4839RCessna A188B · S/N 18802358TCancelled Nov 25, 2003 · Exported to Brazil · Built 1975 N5351FHochstettler Richard Dean TERATORN-TIERRA · S/N 3443178Cancelled Apr 9, 1992 N3832JCessna 150G · S/N 15065132Cancelled Mar 5, 1992 · Triennial form not returned · Harriman Richard H N41806Bellanca 8KCAB · S/N 118-73Cancelled Jun 9, 1975 · Built 1973 · Dixon Robert T N1054BMooney M20A · S/N 1281Cancelled May 6, 1975 · Craig Willie B N85910Aeronca/Miller/Delaney 11AC · S/N 11AC-322Cancelled Nov 29, 1957 · Whited Richard N29071Piper J3F-65 · S/N 6043Cancelled Oct 9, 1951 · Built 1940 · Apollo Aviation Corp

Back to Papillion, NE