OpenAirDocs.org
Dearborn, MI

Cancelled registrations · 92

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 = 'DEARBORN'
  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.

N97744Stinson 108-1 · S/N 108-744Cancelled Oct 7, 2023 · Revoked, canceled · Built 1946 · Arens Adolf MN411ARScott C Williams AR-1 · S/N 0004Cancelled Sep 3, 2022 · Registration expired, pending cancellation · Built 2016 · Kitsune Aviation IncN11JMMills MX-2 · S/N 1200Cancelled Mar 6, 2021 · Registration expired, pending cancellation · Built 1972 · Mills James AN5679NCessna T-50 · S/N 2809Cancelled Apr 27, 2020 · Revoked, canceled · Built 1943 · Chepius EgonN15136Stinson SR-6 · S/N 9640Cancelled Mar 9, 2019 · Revoked, pending cancellation · Onken John BN1736KLuscombe 8A · S/N 4463Cancelled Oct 28, 2017 · Revoked, canceled · Built 1946 · Wicker Elzie LN2791LCessna 172H · S/N 17255991Cancelled Oct 28, 2017 · Revoked, pending cancellation · Built 1967 · Cook John SN8153K&R Rotorcraft B-8M · S/N 24920Cancelled Feb 4, 2017 · Revoked, canceled · Built 1970 · Zickefoose Ralph HN70160Scheibe BERGFALKE II · S/N 606Cancelled May 11, 2015 · Registration expired, pending cancellation · Built 1954 · Michigan Bergfalken IncN124ETTillman Edwin CHRISTEN II · S/N T001Cancelled Sep 20, 2013 · Registration expired, pending cancellation · Built 1988 · Tillman EdwinN1903MWright Experience WRIGHT KITTY HWK FLR · S/N WE 1Cancelled Aug 27, 2013 · Sale reported, canceled · Built 2003N1874DBeech C35 · S/N D-3113Cancelled Aug 20, 2013 · Sale reported, canceled · Built 1952N72HAAlbert Harry J JR 447 COMMANDER · S/N ALBERT 447-2Cancelled May 10, 2013 · Sale reported, canceled · Built 1986N5544DBeech H35 · S/N D-5147Cancelled Apr 22, 2013 · Registration expired, pending cancellation · Built 1957 · Browne Brian LeonardN52540Boeing A75N1(PT17) · S/N 75-1796Cancelled Apr 2, 2013 · Registration expired, pending cancellation · Built 1941 · Bressmer Thomas EN98005Piper J3C-85 · S/N 18136Cancelled Mar 21, 2013 · Sale reported, canceled · Built 1946N227PSSchroeder Paul C WICHAWK · S/N 119Cancelled Jan 14, 2013 · Third renewal notice · Built 1988 · Schroeder Paul CN97213Cessna T-50 · S/N 4662Cancelled Sep 12, 2012 · Revoked, canceled · Chappell RonaldN52099Howard DGA-15P · S/N 1716Cancelled Aug 14, 2012 · Revoked, canceled · Built 1943 · Hartleib John JN2047JSemco Balloon TC-4A · S/N SEM178Cancelled Aug 8, 2012 · Sale reported, canceledN2001VCessna 120 · S/N 14212Cancelled Jul 10, 2009 · Registration revoked · Built 1947 · Ostrowski David AndrewN41784Smith SPECIAL · S/N 1Cancelled May 18, 2009 · Registration revoked · Built 1950 · Pope LeonN965YLockheed VEGA 2D · S/N 40Cancelled Jun 1, 2006 · Triennial form not returned · Edison InstituteN693DHHagenian SA-300 · S/N 001Cancelled Sep 21, 1992 · Triennial form not returned · Hagenian Mikel JrN333LRLuscombe 8E · S/N 5366Cancelled Oct 3, 1991 · Triennial form not returned · Feichtinger Louis MN30575Piper PA-32RT-300 · S/N 32R7885280Cancelled Mar 20, 1991 · Triennial form not returned · Steffes Ronald LN56459Piper PA-28-140 · S/N 28-7325633Cancelled Nov 3, 1983 · Masterofrancesco AnthonyN3234CBeech E35 · S/N D3899Cancelled Jul 20, 1982 · Built 1954 · Browne Brian LN8395UCessna 172F · S/N 17252295Cancelled Oct 13, 1981 · Klassa James JN304KGrumman G-159 · S/N 75Cancelled Jan 4, 1978 · Exported to Brazil · Ford Motor CoN111ELBeech E18S · S/N BA157Cancelled Feb 10, 1977 · Exported to Colombia · Built 1956 · Air Transport CorpN329KBoeing 727-81 · S/N 19557Cancelled Jul 2, 1974 · Exported to Iran · Ford Motor CompanyN1164ABeech 95-B55 · S/N TC-1265Cancelled Apr 17, 1974 · Wayne Sales CorpN6719Bensen B-8M · S/N M-1942Cancelled Aug 25, 1972 · Motriuk OttoN5502MAero Commander 200D · S/N 373Cancelled Sep 1, 1971 · Bill Wink Leasing IncN87749Piper J3C-65 · S/N 15407Cancelled Jan 5, 1971 · Robert M NaylorN855BMooney M20 · S/N 1011Cancelled Dec 31, 1970 · Fisher Eugene FN9801DPiper PA-22-150 · S/N 22-6687Cancelled Jun 2, 1969 · Exported to Canada · Champion Flying ClubN302KGrumman G-159 · S/N 48Cancelled Jan 27, 1969 · Exported to United Kingdom · Ford Motor CoN301KDouglas DC-3A-S1C3G · S/N 3264Cancelled Apr 25, 1967 · Exported to Canada · Built 1940 · Ford Motor CoN4175VCessna 170 · S/N 18508Cancelled Apr 16, 1964 · Van Ameyde John C And Gruchacz George LN304KBeech E18S · S/N BA-72Cancelled Sep 21, 1961 · Exported to Canada · Ford Motor CompanyN91831Schweizer SGU 2-22 · S/N 3Cancelled Jan 29, 1960 · Vultures IncN43848Taylorcraft BC12-D1 · S/N 7507Cancelled Sep 2, 1958 · Exported to Canada · Friebel MaxN40058Stinson L-5E-1 · S/N 76-3649Cancelled Mar 31, 1958 · Vultures IncorporatedN1091APiper PA-18S · S/N 18-679Cancelled Mar 27, 1958 · Exported to Canada · Elliot Clayton Dr AN2759NCessna 120 · S/N 13017Cancelled Jan 21, 1958 · Blackmon David BenjaminN70392Piper J3C-65 · S/N 17383Cancelled May 11, 1956 · Lankenau Jerry JN36595Aeronca 65-TAL · S/N L 1041 TACancelled Mar 2, 1956 · Brown Edward FN42275Piper J3C-65 · S/N 14525Cancelled Feb 28, 1956 · Edward Henscel
Back to Dearborn, MI