Skip to content

Cancelled registrations · 104

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 = 'AK' AND d.registrant_city = 'NOME' 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 = 'AK' AND d.registrant_city = 'NOME'
  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 = 'AK' AND d.registrant_city = 'NOME'
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.

N4138MRobinson Helicopter R44 II · S/N 12159Cancelled Feb 4, 2023 · Registration expired, pending cancellation · Built 2008 · Bering Air Inc N5626ZPiper PA-22-108 · S/N 22-9438Cancelled Jul 31, 2021 · Registration expired, pending cancellation · Built 1962 · Northwestern Alaska Career & Technical Center N9269ZBopp Kevin F AIRBORNE EDGE X · S/N 582-606Cancelled Apr 5, 2021 · Registration expired, pending cancellation · Built 2000 · Bopp Kevin N1598FCessna 185E · S/N 185-0980Cancelled May 4, 2019 · Revoked, canceled · Built 1965 · Lagneaux Irving J N1512LBell OH-58A · S/N 72-21194Cancelled Feb 15, 2019 · Registration expired, pending cancellation · Built 1972 · Beaty Donald Glenn N772HRKreger Kenneth S KITFOX SER 5 TAILDRG · S/N S9407-0036Cancelled Feb 5, 2019 · Registration expired, pending cancellation · Built 1997 · Mcclintock Robert S N38152Piper J4E · S/N 4-1570Cancelled Dec 15, 2018 · Revoked, canceled · Built 1941 · Willoya Milton N91059Cessna 207 · S/N 20700046Cancelled Oct 1, 2018 · Revoked, canceled · Built 1969 · Gandia Ramon F DBA N9545SChampion 7ECA · S/N 7ECA-311Cancelled Jun 8, 2018 · Registration expired, pending cancellation · Built 1965 · Johnson Lynn O N8177ACessna 170B · S/N 25029Cancelled Mar 30, 2018 · Registration expired, pending cancellation · West James D Jr N5006MHughes TH-55A · S/N 65-18259Cancelled Mar 26, 2018 · Registration expired, pending cancellation · Smith Timothy E N1046APiper PA-18 · S/N 18-615Cancelled Mar 19, 2018 · Registration expired, pending cancellation · Built 1950 · Parsons Anthony C N7440KPiper PA-20 · S/N 20-351Cancelled Mar 16, 2018 · Registration expired, pending cancellation · Built 1950 · Parsons Debra J N6922DPiper PA-22-150 · S/N 22-4850Cancelled Feb 16, 2018 · Registration expired, pending cancellation · Built 1957 · Parsons Anthony C N4237WRobinson Helicopter R44 II · S/N 12707Cancelled Nov 30, 2017 · Exported to Canada · Built 2009 · Bering Air Inc N6299HCessna 207A · S/N 20700474Cancelled Jun 21, 2017 · Registration expired, pending cancellation · Built 1978 · Olson Air Service Inc N7598QCessna 310Q · S/N 310Q0098Cancelled Jun 21, 2017 · Registration expired, pending cancellation · Built 1970 · Hoogendorn Peggy A N3120GBeech C-45H · S/N AF-825Cancelled Feb 22, 2017 · Registration expired, pending cancellation · Built 1961 · Foster Neal W N87578Hiller UH-12D · S/N 1011Cancelled Feb 4, 2017 · Revoked, canceled · Built 1958 · Northern Aviation Inc N205BACessna 208B · S/N 208B0890Cancelled Mar 28, 2016 · Exported to South Africa · Built 2001 · Bering Air Inc N907BACessna 208B · S/N 208B1022Cancelled Mar 2, 2016 · Exported to South Africa · Built 2003 · Bering Air Inc N582MHHahn Michael W KOLB TWN STR MK III · S/N MT99-3-00009Cancelled May 20, 2015 · Registration expired, pending cancellation · Hahn Michael W N3201MPiper PA-12 · S/N 12-1863Cancelled Apr 30, 2015 · Registration expired, pending cancellation · Built 1947 · Mawson Simon J N9701LBeech C23 · S/N M-1321Cancelled Nov 26, 2014 · Registration expired, pending cancellation · Built 1971 · Schreier Robert M N8772CPiper PA-18-135 · S/N 18-2862Cancelled Nov 20, 2014 · Registration expired, pending cancellation · Built 1953 · Green Louis Jr N7615SBellanca 7ECA · S/N 1162-76Cancelled Nov 18, 2014 · Registration expired, pending cancellation · Built 1976 · Umholtz Adam C N23210Cessna 150H · S/N 15068794Cancelled Oct 2, 2014 · Registration expired, pending cancellation · Built 1968 · Hoogendorn Jack H N1697DCessna 170B · S/N 20339Cancelled Sep 10, 2014 · Registration expired, pending cancellation · Built 1952 · Martinson Douglas N1172APiper PA-18-125 · S/N 18-773Cancelled Aug 28, 2014 · Registration expired, pending cancellation · Built 1951 · Graham Harold L N70008Cessna A185E · S/N 18501888Cancelled Nov 7, 2013 · Registration expired, pending cancellation · Built 1971 · Foster Aviation Inc N5324ACessna T210N · S/N 21063370Cancelled Sep 20, 2013 · Registration expired, pending cancellation · Built 1979 · Magnell Michael K N2893SCessna 150G · S/N 15066793Cancelled Jul 30, 2013 · Sale reported, canceled · Built 1967 N95245Taylorcraft BC12-D · S/N 9645Cancelled Jul 16, 2013 · Sale reported, canceled · Built 1946 N1708LMacchi LASA 60 · S/N 136158Cancelled Jul 8, 2013 · Registration expired, pending cancellation · Galleher Dick N740CStinson 108-3 · S/N 108-3740Cancelled Jul 8, 2013 · Registration expired, pending cancellation · Built 1947 · Ivanoff Wilfred G N9551HStinson VULTEE V-77 · S/N 77-440Cancelled May 23, 2013 · Registration expired, pending cancellation · Built 1944 · Mays Howard DBA N9044BChampion AERONCA 7EC · S/N 7EC-684Cancelled May 17, 2013 · Registration expired, pending cancellation · Built 1958 · Breeden Dan K N87579Hiller UH-12D · S/N 951Cancelled May 15, 2013 · Registration expired, pending cancellation · Built 1959 · Rogers Samuel I N6954MStinson 108-3 · S/N 108-4954Cancelled May 3, 2013 · Registration expired, pending cancellation · Built 1949 · Martinson Daniel L N71548Piper PA-16 · S/N 16707Cancelled May 3, 2013 · Registration expired, pending cancellation · Built 1949 · Fox Stephen A N68181Piper J3C-65 · S/N 13720Cancelled May 2, 2013 · Registration expired, pending cancellation · Built 1945 · Bahnke Robert S N6267GCessna 150K · S/N 15071767Cancelled Apr 29, 2013 · Registration expired, pending cancellation · Built 1970 · Bailey Dennis J N5233HPiper PA-16 · S/N 16-38Cancelled Apr 2, 2013 · Registration expired, pending cancellation · Built 1949 · Wheeler E C N9886ZCessna 182B · S/N 51776Cancelled Mar 21, 2013 · Sale reported, canceled · Built 1960 N80136Cessna A185F · S/N 18503097Cancelled Feb 27, 2013 · Sale reported, canceled · Built 1976 N95015Taylorcraft BC12-D · S/N 9415Cancelled Feb 20, 2013 · Sale reported, canceled · Built 1980 N39196Taylorcraft BC12-D · S/N 6448Cancelled Feb 11, 2013 · Sale reported, canceled · Built 1945 N4895CCessna A185F · S/N 18502646Cancelled Dec 7, 2012 · Sale reported, canceled · Built 1975 N23JMMorgan STEEN SKYBOLT MI-2 · S/N M100Cancelled Oct 16, 2012 · Registration expired, pending cancellation · Built 1976 · Mcculloch Chris P N3280JCessna 150G · S/N 15065980Cancelled Sep 10, 2012 · Sale reported, canceled · Built 1966

Back to Nome, AK