Skip to content

Cancelled registrations · 115

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 = 'OK' AND d.registrant_city = 'YUKON' 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 = 'OK' AND d.registrant_city = 'YUKON'
  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 = 'OK' AND d.registrant_city = 'YUKON'
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.

N5NKPiper PA-23-160 · S/N 23-1939Cancelled Mar 4, 2023 · Registration expired, pending cancellation · Built 1960 · Barnes Stephen W N418MGBeech 400 · S/N RJ-54Cancelled Feb 22, 2021 · Sale reported · Built 1988 N3008British Aerospace BAE 125 SERIES 800A · S/N 258092Cancelled Nov 1, 2019 · Registration expired, pending cancellation · Meritt Aviation Inc N4MHIsrael Aircraft Industries 1124 · S/N 232Cancelled Aug 15, 2019 · Registration expired · Built 1978 · Sundance Airport Fbo LLC N47908Fairchild M-62A · S/N T421990Cancelled Jan 29, 2019 · Revoked, canceled · Built 1942 · Kimbell Joseph T N929DSPierce Henry BUSHBY MUSTANG II · S/N 1242Cancelled Jan 25, 2019 · Registration expired, pending cancellation · Built 1987 · Bussett Casey J N125CKHawker Siddeley HS125 SERIES 400A · S/N 25266Cancelled Mar 13, 2018 · Registration expired, pending cancellation · Built 1971 · Meritt Aviation Inc N83SAMitsubishi MU-300 · S/N A030 S.A.Cancelled Mar 7, 2018 · Registration expired, pending cancellation · Meritt Aviation Inc N779DCMitsubishi MU-300 · S/N A072SACancelled Mar 6, 2018 · Registration expired, pending cancellation · Built 1984 · Meritt Aviation Inc N3957VChambers James O FISHER 303 · S/N 0013Cancelled Mar 2, 2018 · Registration expired, pending cancellation · Chambers James O N851CMitsubishi MU-300 · S/N A077 S.A.Cancelled Feb 20, 2018 · Registration expired, pending cancellation · Built 1984 · Meritt Aviation Inc N344BPBritish Aerospace HS 125-700A · S/N NA0344Cancelled Feb 13, 2018 · Registration expired, pending cancellation · Merritt Aviation Inc N393WBMitsubishi MU-300 · S/N A045 S.A.Cancelled Feb 13, 2018 · Registration expired, pending cancellation · Built 1983 · Meritt Aviation Inc N40SCessna T337G · S/N P3370151Cancelled Jan 19, 2018 · Registration expired, pending cancellation · Built 1973 · Escott Fred R N130SUBeech B19 · S/N MB-485Cancelled Jan 11, 2018 · Registration expired, pending cancellation · Built 1970 · Bishop Patrick G N886EPRaytheon 400A · S/N RK-117Cancelled Jul 17, 2017 · Built 1996 · Meritt Aviation Inc N984SAMitsubishi MU-300 · S/N A063 S.A.Cancelled Jun 19, 2017 · Registration expired, pending cancellation · Built 1983 · Meritt Aviation Inc N203WBeech D18S · S/N A-119Cancelled May 23, 2017 · Registration expired, pending cancellation · Built 1946 · Escott Fred R N705BBRaytheon BAE 125-800A · S/N 258015Cancelled Mar 29, 2017 · Sale reported · Built 1984 N203PStarduster SA-100 · S/N 101Cancelled Dec 17, 2014 · Registration expired, pending cancellation · Built 1968 · Patterson Henry Milton N38192Piper J3C-65 · S/N 7768Cancelled Dec 2, 2014 · Registration expired, pending cancellation · Built 1941 · Blackburn D S N9020NDouglas C54-D · S/N 10821Cancelled Nov 20, 2014 · Registration expired, pending cancellation · Commercial Aircraft Inc N6878QBeech 65-A80 · S/N LD-174Cancelled Nov 13, 2014 · Registration expired, pending cancellation · Built 1964 · F & B Aircraft N489SABritish Aerospace BAE 125 SERIES 800A · S/N 258053Cancelled Oct 22, 2014 · Sale reported, pending cancellation N3593BAerospatiale SA341G GAZELLE · S/N 1059Cancelled Oct 2, 2014 · Registration expired, pending cancellation · Built 1973 · Oklhoma Acft Corp N32DRDouglas C-54B · S/N 18356Cancelled Sep 29, 2014 · Registration expired, pending cancellation · Commerical Aircraft Inc N2800NNorth American-Rivera T-28C · S/N 140480Cancelled Sep 25, 2014 · Registration expired, pending cancellation · Escott Fred R N444HRockwell International 690B · S/N 11402Cancelled Apr 30, 2014 · Built 1977 · Legacy Aviation Services Inc N8LFBeech A65 · S/N LC-317Cancelled Jul 15, 2013 · Sale reported, canceled · Built 1968 N246WMCammack Kevin J VARIANT · S/N 1Cancelled Jul 2, 2013 · Registration expired, pending cancellation · Cammack Kevin J N28FMMitsubishi MU-300 · S/N A026 S.A.Cancelled Jun 11, 2013 · Sale reported, pending cancellation · Built 1982 N93656Bellanca 17-30A · S/N 73-30572Cancelled May 22, 2013 · Registration expired, pending cancellation · Built 1973 · Long Beverly A N7PWMitsubishi MU-300 · S/N A027 S.A.Cancelled May 13, 2013 · Sale reported, pending cancellation N600WBDouglas A-26B · S/N 44-35617Cancelled Apr 25, 2013 · Registration expired, pending cancellation · Built 1944 · Oklahoma Aircraft Corporation N90713Fairchild F-27 · S/N 04402-82Cancelled Mar 18, 2013 · Registration expired, pending cancellation · Built 1960 · Coronado Aircraft Corporation N365DErcoupe 415-C · S/N 2455Cancelled Mar 7, 2013 · Registration expired, pending cancellation · Built 1946 · Joesting Aircraft Services N59102Cessna 210L · S/N 21060090Cancelled Feb 26, 2013 · Revoked, canceled · Oklahoma Aircraft Corp N4545QCessna 402A · S/N 402A0045Cancelled Dec 7, 2012 · Registration expired, pending cancellation · Built 1969 · Oklahoma Aircraft Corp N3501TCessna 402 · S/N 402-0250Cancelled Nov 8, 2012 · Registration expired, pending cancellation · Built 1968 · Dick Sawyer International Inc N3210ZPiper PA-22-160 · S/N 22-7150Cancelled Nov 6, 2012 · Registration expired, pending cancellation · Built 1959 · Crawford Robert L N87DYMitsubishi MU-300 · S/N A085 S.A.Cancelled May 21, 2012 · Sale reported · Built 1984 N2300FCessna 210D · S/N 21058500Cancelled Aug 8, 2011 · Sale reported, pending cancellation · Built 1964 N411RSBeech 65-90 · S/N LJ-106Cancelled Jul 29, 2011 · Expired dealer · Built 1966 · Sundance Aviation Inc N9060Lockheed PV-1 · S/N 5269Cancelled Jul 22, 2011 · Expired dealer · Built 1955 · Oklahoma Aircraft Corp N644Aero Commander 680FL · S/N 1669-132Cancelled Jul 20, 2011 · Expired dealer · Built 1967 · Oklahoma Aircraft Corp N1850MCurtiss Wright C-46F · S/N 22537Cancelled Jul 19, 2011 · Expired dealer · Built 1944 · Oklahoma Aircraft Corp N2302PAero Commander 680FL · S/N 1547-106Cancelled Jul 18, 2011 · Expired dealer · Built 1965 · Oklahoma Aircraft Corp N500STCessna 421 · S/N 421-0149Cancelled Jul 18, 2011 · Expired dealer · Built 1968 · Oklahoma Aircraft Corp N5311YPiper PA-23-250 · S/N 27-2384Cancelled Jul 18, 2011 · Expired dealer · Built 1963 · Oklahoma Aircraft Corp N5PHBell 47G · S/N PH72Cancelled Jul 18, 2011 · Expired dealer · Built 1972 · Oklahoma Aircraft Corp

Back to Yukon, OK