Skip to content

Cancelled registrations · 61

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 = 'MI' AND d.registrant_city = 'NILES' 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 = 'MI' AND d.registrant_city = 'NILES'
  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 = 'MI' AND d.registrant_city = 'NILES'
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.

N997VBeech C23 · S/N M-2234Cancelled Jan 20, 2026 · Built 1979 · Ringler James H N345ESDavid W Cooper EPIC SPORT · S/N 06172019Cancelled Dec 3, 2022 · Registration expired, pending cancellation · Sport Pilot Club Inc N2617PTeam MINI MAX · S/N 104Cancelled Jun 21, 2018 · Sale reported · Built 2007 N87943Piper J3C-65 · S/N 15561Cancelled Feb 21, 2018 · Registration expired, pending cancellation · Built 1946 · Dennis Karla J N55204Piper PA-28-140 · S/N 28-7325343Cancelled May 15, 2017 · Registration expired, pending cancellation · Built 1973 · Thompson Diane A N7108BPiper PA-22-150 · S/N 22-4324Cancelled Jul 23, 2013 · Registration expired, pending cancellation · Built 1956 · Hulce Ray L N276FMMilbourn FLYBABY FM-1 · S/N 6817Cancelled Apr 9, 2013 · Sale reported, canceled · Built 1970 N43902Taylorcraft BC12-D · S/N 7561Cancelled Nov 29, 2012 · Registration expired, pending cancellation · Built 1946 · Hoffecker Richard A Jr N4413KNavion NAVION A · S/N NAV-4-1413Cancelled Aug 10, 2012 · Sale reported, pending cancellation · Built 1948 N39779Baird/Ruppel GOLDWING · S/N 411Cancelled Jun 29, 2009 · Triennial form not returned · Built 1984 · Baird Robert P N143WWGrimes Jon C SNS-9 · S/N 3Cancelled May 23, 2007 · Triennial form not returned · Built 1986 · Wolverton William R N30TLWakevainen Mark D SEA HAWKER · S/N 170Cancelled Nov 2, 2005 · Triennial form not returned · Wakevainen Dale K N9715ZCessna 310C · S/N 35967Cancelled Sep 20, 2000 · Triennial form not returned · Szucs John G N441RRentz Randy C MODEL 01 · S/N 44Cancelled Jun 29, 1999 · Triennial form not returned · Rentz C Randy N2254LMoneysmith William H TEAM 1300 Z · S/N 101Cancelled Sep 23, 1996 · Moneysmith William H N43WWWolverton William R ROTEC R-3 · S/N 25532Cancelled Mar 25, 1991 · Triennial form not returned · Wolverton William R N32298Wolter Charles MITCHELL B 10 · S/N P688Cancelled Mar 21, 1991 · Triennial form not returned · Wolter Charles E N2588KPiper PA-38-112 · S/N 38-79A0681Cancelled Oct 28, 1982 · Built 1979 · Niles Airways Inc N5773FPiper PA-28-140 · S/N 28-25078Cancelled Sep 11, 1982 · Niles Airways Inc N32935Piper J4A · S/N 41316Cancelled Nov 15, 1972 · Built 1940 · Kennedy Richard L N542CStinson 108-3 · S/N 108-3542Cancelled Nov 15, 1972 · Kennedy Richard L N28746Luscombe 8C · S/N 1507Cancelled Apr 30, 1971 · Thwaits Clarence N95895Taylorcraft BC12-D · S/N 8195Cancelled Jan 6, 1971 · Built 1946 · Shuler Norman/Keebler Charles T/Coquillard Edward N6208WPiper PA-28-140 · S/N 28-20241Cancelled Dec 8, 1970 · Exported to Canada · Hack George J N2314QBeech 23 · S/N M-378Cancelled Jun 5, 1970 · Mould Graham & Assoc N7728HPiper PA-12 · S/N 12-624Cancelled Jun 5, 1967 · Exported to Canada · Niles Airways Inc N88002Piper J3C-65 · S/N 15620Cancelled Apr 18, 1967 · Exported to Canada · Built 1946 · Niles Airways Inc N81778Aeronca 7AC · S/N 7AC-401Cancelled May 24, 1965 · Clarence J Thwaits N4775APiper PA-22-150 · S/N 22-3924Cancelled Sep 2, 1960 · Niles Airways Inc N5733NCessna T-50 · S/N 4711Cancelled Nov 15, 1955 · Roskay Leland C N36964Aeronca 65-TAC · S/N C2651TACancelled Oct 19, 1955 · Davis Jack D N97058Stinson 108-1 · S/N 108-1-1058Cancelled Oct 17, 1955 · Built 1946 · Tyler Fixture Corp N22347Aeronca 65-C · S/N C-5009Cancelled Oct 6, 1955 · Reeves Richard N9848HFairchild PT-26 M62A3 · S/N FA1002Cancelled Oct 5, 1955 · Roskay Leland C N9835HDouglas DC2 · S/N 1298Cancelled Apr 8, 1955 · Duke Harrah Inc N3599EAeronca 7AC · S/N 7AC-6935Cancelled Sep 24, 1953 · Built 1947 · Hooten Lewis D N6128KRepublic RC-3 · S/N 314Cancelled Jul 23, 1951 · Laverty Ralph E N48165Fairchild M-62A · S/N 5493AECancelled Jun 29, 1951 · Mccarthy Charles M N17921Piper J-2 · S/N 1521Cancelled Jun 15, 1951 · Kuhl Albert G N79551Cessna T-50 · S/N 3062Cancelled Jun 7, 1951 · Roskay Leland C N88453Piper J3C-65 · S/N 16075Cancelled Apr 7, 1949 · Roskay Leland C N47419Aeronca 0-58B · S/N 058B-12063Cancelled Jun 14, 1948 · Hawkins Fred E & Edna B Hawkins N22373Aeronca 50-F · S/N F-3749Cancelled Jun 10, 1948 · Built 1939 · Dusoe Francis A N2869VBeech 35 · S/N D-274Cancelled Apr 14, 1948 · Roskay Leland C N3810MPiper PA-12 · S/N 12-2732Cancelled Apr 14, 1948 · Roskay Leland C N9652KStinson 108-2 · S/N 108-2652Cancelled Apr 14, 1948 · Roskay Leland C N98448Piper J3C-65 · S/N 18640Cancelled Apr 14, 1948 · Roskay Leland C N811Aeromarine 39-B · S/N 293Cancelled Apr 8, 1948 · Kysor Eaglerock Co N37048Luscombe 8C · S/N 1709Cancelled Oct 14, 1947 · Built 1941 · Kerr J A N92711Piper PA-12 · S/N 12-146Cancelled Oct 9, 1947 · Roskay Leland C

Back to Niles, MI