Skip to content

Cancelled registrations · 28

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 = 'MO' AND d.registrant_city = 'RAYTOWN' 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 = 'MO' AND d.registrant_city = 'RAYTOWN'
  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 = 'MO' AND d.registrant_city = 'RAYTOWN'
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.

N79TLLoftin Thomas J LOFTIN KR-2 · S/N 001Cancelled Oct 29, 2021 · Thomas J Loftin LLC N7830FDJI PHANTOM 2 VISION + · S/N PH645302295 V2.0Cancelled Dec 2, 2019 · Registration expired, pending cancellation · Fearless Eye Inc N7832FDJI PHANTOM 2 VISION + · S/N PH645494603 V3.0Cancelled Dec 2, 2019 · Registration expired, pending cancellation · Fearless Eye Inc N784CFDJI INSPIRE 1 · S/N W13DCD16031905Cancelled Dec 2, 2019 · Registration expired, pending cancellation · Fearless Eye Inc N20409Taylorcraft BC · S/N 1097Cancelled Sep 26, 2019 · Revoked, pending cancellation · Built 1938 · Kneeland David N2622CGrumman American Avn. AA-5A · S/N AA5A0499Cancelled Jan 12, 2018 · Registration expired, pending cancellation · Built 1977 · Cavanaugh James M N8298CPiper PA-22-135 · S/N 22-2363Cancelled Nov 21, 2017 · Revoked, canceled · Built 1954 · Wagner Robert A N9345DPiper PA-22-160 · S/N 22-6373Cancelled Nov 21, 2017 · Revoked, canceled · Built 1958 · Westwind Flg Club Inc N1034ZBensen B-8MC · S/N MM001Cancelled Sep 12, 2016 · Revoked, canceled · Built 1963 · Rinehart John A Co Ow N910TJLoftin Thomas J LOFTIN 601XL · S/N 6-4600Cancelled Sep 24, 2015 · Loftin Thomas J N7691CCessna 150G · S/N 15066979Cancelled Apr 27, 2015 · Registration expired, pending cancellation · Built 1967 · Gene Miller Advertising Inc N8753XPowell Richard V STAR-LITE · S/N 145Cancelled Dec 22, 2014 · Registration expired, pending cancellation · Powell Richard V N8156BCessna 172 · S/N 29956Cancelled Sep 10, 2013 · Registration expired, pending cancellation · Built 1957 · Ball Charles L N6657VBellanca 17-30 · S/N 30016Cancelled Apr 30, 2013 · Registration expired, pending cancellation · Built 1967 · Gouldsmith David N N5948LAmerican AA-1 · S/N AA1-0248Cancelled Apr 24, 2013 · Registration expired, pending cancellation · Built 1969 · Cavanagh James M N6048VBeech D18S · S/N A-64Cancelled Sep 20, 2012 · Revoked, canceled · Built 1946 · Borofsky Jacquelyn N777JHBeech D18S · S/N A-219Cancelled Sep 6, 2012 · Revoked, canceled · Built 1967 · Borofsky Jacquelyn N5009CBeech B35 · S/N D-2374Cancelled Aug 10, 2012 · Revoked, canceled · Built 1950 · Trotter Daniel W DBA N13WCClark BOWERS FLYBABY 1-A · S/N 70-32Cancelled Jun 12, 2012 · Sale reported, canceled · Built 1976 N2293HBalloon Works FIREFLY 7 · S/N 7756Cancelled May 23, 2011 · Revoked, canceled · Built 1978 · Harris John R N9056NClemons R Linn ZENITH CH 200 · S/N 2-423Cancelled Mar 24, 2009 · Triennial form not returned · Built 1999 · Clemons R Linn N6127SAir & Space America 18A · S/N 1836Cancelled Apr 1, 1997 · Triennial form not returned · Throneberry Antonette N18KGGettings A H GLASAIR · S/N G2Cancelled Jun 25, 1992 · Second triennial mailing, no response · Gettings Albert H N65MCessna P210N · S/N P21000687Cancelled Oct 3, 1991 · Triennial form not returned · Cavu Inc N9056NRobinson Duane L ZENITH CH-200 · S/N 2423Cancelled Jul 24, 1991 · Triennial form not returned · Clemons R Linn N7424ACessna 172 · S/N 29524Cancelled Nov 8, 1983 · Gene Miller Advertising Inc N2968YCessna 182E · S/N 18253968Cancelled Feb 14, 1975 · Exported to Canada · Built 1962 · Mizer Don A & Rosemary N500YLiberty Aircraft Sales & Mfg P-2 · S/N 1Cancelled Oct 23, 1935 · Built 1930 · Cadwell James

Back to Raytown, MO