OpenAirDocs.org
Royal Oak, MI

Cancelled registrations · 44

Query with SQL
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 = 'ROYAL OAK'
  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.

N687NSDJI INSPIRE 1 · S/N W13DBL24020481Cancelled Nov 5, 2022 · Registration expired, pending cancellation · Seventy 7 ProductionsN360NSmith Martin P LANCAIR 320 · S/N 330Cancelled Sep 6, 2019 · Sale reported, canceled · Built 1999N263ANBeauchesne/Wells GLASAIR TD · S/N 544Cancelled Mar 16, 2019 · Registration expired, pending cancellation · Built 1985 · Rusinowski Steven PN80221Cessna 172M · S/N 17266455Cancelled Aug 29, 2018 · Exported to Philippines · Built 1975 · Dmb Associates Consulting LLCN26181Grumman American Avn. AA-5A · S/N AA5A0469Cancelled Jan 2, 2018 · Registration expired, pending cancellation · Built 1977 · Snoopy Aviation LLCN1GKGrohs Donald SCORPION TOO · S/N 10689Cancelled Jun 19, 2017 · Registration expired, pending cancellation · Built 1980 · Kreiner Robert LN9405FHughes 269B · S/N 0131Cancelled Feb 13, 2017 · Revoked, canceled · Built 1964 · Nelson Hel Sales LarryN41466Piper PA-28-151 · S/N 28-7415227Cancelled May 15, 2015 · Registration expired, pending cancellation · Built 1974 · Hammond Robert EN714PRCessna 150M · S/N 15079332Cancelled Dec 2, 2014 · Revoked, canceled · Built 1977 · Polasky RobertN3669BBeech B50 · S/N CH-62Cancelled Oct 2, 2014 · Registration expired, pending cancellation · Built 1954 · Mattson Bruce AN6873MCessna 182P · S/N 18263872Cancelled Nov 6, 2013 · Registration expired, pending cancellation · Built 1975 · Kurvi Paavo EN3518ZPiper PA-22-150 · S/N 22-7416Cancelled Aug 13, 2013 · Registration expired, pending cancellation · Built 1960 · Lankford Blaine LN116KUUhley Kent L ONE-1 · S/N 375206180Cancelled Mar 21, 2013 · Registration expired, pending cancellation · Built 1991 · Uhley Kent LN48275Taylorcraft DC-65 · S/N 5392Cancelled Nov 13, 2012 · Revoked, canceled · Built 1943 · Badrak AlexN90RBBaker Roy G BCA-2 · S/N 1001Cancelled Sep 25, 2012 · Registration expired, pending cancellation · Built 1985 · Baker Roy GN1667CCessna 180 · S/N 30367Cancelled Jul 19, 2012 · Sale reported, canceled · Built 1953N5064WDestiny 2000 · S/N 2C0364Cancelled Apr 29, 2010 · Exported to Canada · Built 2001 · Knight Roger JN7196KRobinson Helicopter R44 · S/N 0985Cancelled Feb 7, 2007 · Exported to Canada · Built 2001 · Continental Helicopters LLCN4101UDzendel George T KITFOX MOD II · S/N 374Cancelled May 17, 2004 · Triennial form not returned · Dzendzel George TN8300TPiper PA-34-200T · S/N 34-8170044Cancelled Feb 13, 2004 · Triennial form not returned · Built 1980 · Abc Leasing IncN4283CBaker Corvair Amphibian BCA-1 · S/N 1002Cancelled Jul 17, 1984 · Built 1964 · Baker Gilbert RN64ACShort Bros. & Harland SC7 SERIES 3 · S/N SH1849Cancelled Mar 7, 1978 · De Gain William JN411EFCessna 411 · S/N 411-0081Cancelled Mar 4, 1977 · Built 1965 · J & L Aircraft SaleN212ADPiper PA-31 · S/N 31-160Cancelled May 30, 1973 · Equitable Engineering Co IncN96883Taylorcraft BC12-D · S/N 9183Cancelled Jul 26, 1971 · Sellheim WalbertN23363Piper J4A · S/N 4-594Cancelled Jul 17, 1971 · Higgs RobertN1234DCessna 170A · S/N 20117Cancelled Jun 15, 1971 · Spencer Alva LN1203DCessna 170A · S/N 19976Cancelled Sep 2, 1970 · Brown Robert M Eugene BrownN1075Kapeg 1 K-1 · S/N K-1Cancelled Aug 15, 1968 · Joseph C DoveyN13886Aeronca C-3 · S/N A-308Cancelled Jun 8, 1965 · Exported to Canada · Trainor Tom EN7401KPiper PA-20 · S/N 20-309Cancelled May 31, 1961 · Exported to Canada · Flying Ten Aero Club IncN1157HAeronca 15AC · S/N 15AC-170Cancelled Mar 7, 1957 · Exported to Canada · Built 1948 · Morean William EN43840Taylorcraft BC12-D · S/N 7499Cancelled Jan 9, 1957 · George V BodenbachN91473North American NAVION · S/N NAV-4-280Cancelled Dec 14, 1956 · Brown C RobertN14752Fairchild 24 C8C · S/N 2658Cancelled Feb 17, 1956 · Built 1934 · Seliga Gerald JN61982Boeing A75 · S/N 75-050Cancelled Feb 15, 1956 · Roper Harold AN9940HConsolidated Vultee BT-13A · S/N 7321Cancelled Feb 14, 1956 · Butler W J & H N CarterN47122Taylorcraft/Bacher Scott N DC0-65/L2M · S/N L-4746Cancelled Oct 10, 1955 · Muncey James L & Betty MunceyN97144Consolidated Vultee BT-13A · S/N 3049Cancelled Jul 25, 1951 · Built 1946 · Grattan Donald WN47361Aeronca 0-58B · S/N 13404Cancelled Jun 29, 1951 · Pierson Glenn WN21368Aeronca 65-LA · S/N C-1748Cancelled Jun 2, 1948 · Shriber W EN20468Welch OW5M · S/N 163Cancelled May 21, 1948 · Rydahl HarryN698Curtiss JN-4 (CANADIAN) · S/N 359Cancelled May 2, 1930 · Jeavons J HN795KRoyal ROYAL AIR TRAINER · S/N 6Cancelled Mar 22, 1930 · Built 1929 · Royal Aircraft Corporation
Back to Royal Oak, MI