Skip to content

Cancelled registrations · 99

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 = 'KS' AND d.registrant_city = 'OTTAWA' 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 = 'KS' AND d.registrant_city = 'OTTAWA'
  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 = 'KS' AND d.registrant_city = 'OTTAWA'
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.

N478BBBeech A36 · S/N E2344Cancelled May 8, 2021 · Registration expired, pending cancellation · Dodson Aviation Inc N94262Cessna 210L · S/N 21060568Cancelled Apr 5, 2021 · Registration expired, pending cancellation · Built 1974 · Scott John D N6816MStinson 108-3 · S/N 108-4816Cancelled Jun 5, 2020 · Revoked, canceled · Built 1948 · Sexton Earl F N6014DPiper PA-22-150 · S/N 22-4666Cancelled Apr 3, 2020 · Revoked, canceled · Built 1956 · Snouffer Thomas F N1965JCessna T188C · S/N T18803308TCancelled May 30, 2018 · Sale reported, canceled · Built 1978 N8081BCessna 172 · S/N 29881Cancelled Feb 26, 2018 · Registration expired, pending cancellation · Built 1957 · Reeder James T N6881SBeech B90 · S/N LJ-450Cancelled Jan 23, 2018 · Registration expired, pending cancellation · Dodson International Parts Inc N117FRCessna 172P · S/N 17276602Cancelled Jan 10, 2018 · Registration expired, pending cancellation · Built 1986 · Dodson Aviation Inc N552TRPiper AEROSTAR 600 · S/N 6008478161243Cancelled Jan 5, 2018 · Registration expired, pending cancellation · Built 1981 · Dodson Aviation Inc N225BACessna 340A · S/N 340A1029Cancelled Jul 20, 2017 · Registration expired, pending cancellation · Built 1980 · Dodson International Parts Inc N51394Beech 35 · S/N D-576Cancelled Apr 4, 2017 · Registration expired, pending cancellation · Reeder James T N120ESCessna 501 · S/N 501-0041Cancelled Apr 24, 2015 · Registration expired, pending cancellation · Built 1977 · Dodson International Parts Inc N17201Cessna 177B · S/N 17702517Cancelled Jul 29, 2014 · First renewal notice · Built 1976 · Scott John D N411BWMitsubishi Acft International MU-300-10 · S/N A1008 S.A.Cancelled Nov 4, 2013 · Registration expired, pending cancellation · Built 1985 · Dodson Aviation Inc N400PAPiper PA-23-250 · S/N 27-7405340Cancelled Sep 30, 2013 · Sale reported, canceled · Built 1974 N2062JCessna T188C · S/N T18803352TCancelled Aug 19, 2013 · Sale reported, canceled · Built 1978 N448GGLearjet 23 · S/N 23-057Cancelled Aug 15, 2013 · Registration expired, pending cancellation · Dodson International Parts Inc N838MDouglas C-47 · S/N 43-15982Cancelled Aug 8, 2013 · Sale reported, canceled · Built 1943 N10BQPiper PA-31T · S/N 31T-7400005Cancelled Aug 6, 2013 · Sale reported, canceled · Built 1974 N616PBCessna 402C · S/N 402C0622Cancelled Jul 2, 2013 · Registration expired, pending cancellation · Built 1981 · Dodson International Parts Inc N913Maxwell-Howard FLY BABY 1A · S/N 6672Cancelled May 22, 2013 · Registration expired, pending cancellation · Built 1972 · Maxwell Gary D N600WRPiper PA-31T · S/N 31T-7620038Cancelled Apr 25, 2013 · Registration expired, pending cancellation · Built 1976 · Dodson Investment Inc N26077Grumman American Avn. AA-5A · S/N AA5A0416Cancelled Apr 9, 2013 · Sale reported, canceled · Built 1977 N37331Balloon Works FIREFLY 7-B · S/N F7B-091Cancelled Mar 11, 2013 · Sale reported, canceled · Built 1983 N7740QCessna 310Q · S/N 310Q0240Cancelled Feb 26, 2013 · Sale reported, canceled · Built 1970 N7796QCessna 310Q · S/N 310Q0406Cancelled Feb 26, 2013 · Sale reported, canceled · Built 1971 N7411Vickers VISCOUNT 797 · S/N 109Cancelled Feb 21, 2013 · Sale reported, canceled · Built 1955 N6928LCessna 310K · S/N 310K0028Cancelled Feb 13, 2013 · Sale reported, canceled · Built 1965 N5976Aero Commander 560-A · S/N 55-4641Cancelled Feb 8, 2013 · Sale reported, canceled · Built 1955 N5371TPiper PA-34-200 · S/N 34-7250253Cancelled Jan 30, 2013 · Sale reported, canceled · Built 1972 N9061EPiper PA-31-310 · S/N 31-522Cancelled Jan 16, 2013 · Expired dealer · Built 1969 · Dodson Aviation Inc N17FNLearjet 24B · S/N 220Cancelled Dec 11, 2012 · Sale reported, canceled · Built 1970 N47076Aero Commander 560-A · S/N 240Cancelled Nov 27, 2012 · Sale reported, canceled · Built 1955 N5478VReims CESSNA F172G · S/N 0222Cancelled Nov 20, 2012 · Sale reported, pending cancellation · Built 1966 N444KBeech 35 · S/N D-81Cancelled Nov 9, 2012 · Sale reported, canceled · Built 1947 N407CSCessna 310D · S/N 39209Cancelled Nov 7, 2012 · Sale reported, canceled · Built 1960 N421JDCessna 421A · S/N 421A0005Cancelled Nov 7, 2012 · Sale reported, canceled · Built 1968 N2528WBeech B24R · S/N MC-201Cancelled Aug 21, 2012 · Sale reported, canceled · Built 1973 N101KHBeech 58 · S/N TH-289Cancelled Jun 2, 2011 · Sale reported, canceled · Built 1973 N8684YPiper PA-30 · S/N 30-1829Cancelled Mar 29, 2011 · Expired dealer · Built 1969 · Dodson Aviation Inc N9756QSmith AEROSTAR 601P · S/N 61P-0374-121Cancelled Jan 7, 2011 · Expired dealer · Dodson Aviation Inc N5459NPiper PA-28-180 · S/N 28-4145Cancelled Jan 6, 2011 · Expired dealer · Dodson Aviation Inc N13963Piper PA-23-250 · S/N 27-4578Cancelled Jan 3, 2011 · Expired dealer · Built 1970 · Dodson Aviation Inc N30MWPiper PA-31-310 · S/N 31-44Cancelled Jan 3, 2011 · Expired dealer · Built 1967 · Dodson Aviation Inc N460PCPiper PA-23-250 · S/N 27-4675Cancelled Jan 3, 2011 · Expired dealer · Built 1971 · Dodson Aviation Inc N5384GHelio H-295 · S/N 1254Cancelled Nov 29, 2010 · Exported to Canada · Built 1967 · Pollock John N24959Piper J3F-50 · S/N 3566Cancelled Jul 15, 2009 · Registration revoked · Davis Joe C N800TGHawker Siddeley BH.125-400A · S/N NA780Cancelled Nov 18, 2008 · Exported to Republic of the Congo · Built 1972 · Dodson Services Inc N90FFBritish Aerospace HS 125-700A · S/N NA0279Cancelled Feb 9, 2006 · Exported to South Africa · Built 1980 · Dodson Aviation Inc N62TJHawker Siddeley DH-125 · S/N 25023Cancelled Nov 4, 2004 · Exported to South Africa · Built 1965 · Dodson Services Inc

Back to Ottawa, KS