OpenAirDocs.org
Wayne, MI

Cancelled registrations · 128

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

N86009Aeronca 11AC · S/N 11AC428Cancelled Jan 14, 2019 · Revoked, canceled · Built 1946 · Aber Raymond EN46191Fairchild M-62A · S/N T437315Cancelled Apr 10, 2018 · Revoked, canceled · Built 1944 · Yates Henry JN2400LCessna 172H · S/N 17255600Cancelled Mar 23, 2018 · Revoked, canceled · Built 1966 · Timoszyk Avn CorpN503TBBurkhart Thomas R EIPPER MX SUPER · S/N 1408Cancelled Sep 25, 2013 · Registration expired, pending cancellation · Burkhart Thomas RN63869Fairchild M-62A · S/N 183HOCancelled Aug 6, 2013 · Revoked, canceled · Built 1943 · Mikedis GeorgeN251DJBell H-13D · S/N 251Cancelled Mar 18, 2013 · Sale reported, canceledN8656BCessna 172 · S/N 36356Cancelled Feb 6, 1969 · Down River Flying Club IncN7088ECessna 175A · S/N 56588Cancelled Sep 17, 1966 · Robert G HebronN72873Cessna 140 · S/N 10064Cancelled Sep 14, 1965 · Fewlass Jere BN42539Piper J3C-65 · S/N 14816Cancelled May 17, 1961 · Exported to Canada · Jones Lewis CharlesN4335EAeronca 11CC · S/N 11CC-189Cancelled Apr 24, 1961 · Exported to Canada · Mathison Robert AN3360MPiper PA-12 · S/N 12-2052Cancelled Oct 9, 1957 · Daniel KennyN39372Aeronca 65-TAF · S/N F4412TACancelled Feb 28, 1956 · John E AndrewsN8551KStinson 108-1 · S/N 108-1551Cancelled Feb 17, 1956 · Consolidated Vultee Aircraft CorpN8557KStinson 108-1 · S/N 108-1557Cancelled Feb 17, 1956 · Consolidated Vultee Aircraft CorpN9017KStinson 108-1 · S/N 108-2017Cancelled Feb 14, 1956 · Consolidated Vultee Aircraft CorpN9027KStinson 108-1 · S/N 1082027Cancelled Feb 14, 1956 · Consolidated Vultee Aircraft CorpN9207KStinson 108-1 · S/N 108-2207Cancelled Feb 14, 1956 · Consolidated Vultee Aircraft CorpN9284KStinson 108-1 · S/N 108-2284Cancelled Feb 14, 1956 · Consolidated Vultee Aircraft CorpN24590Piper J3F-65 · S/N 3287Cancelled Nov 22, 1955 · Olson Vernon WN70047Consolidated Vultee BT-13 · S/N 9046Cancelled Oct 28, 1955 · Hebron Robert GN39539Aeronca 65-TAL · S/N L5122TACancelled Oct 20, 1955 · Built 1942 · Hamlin Thomas GN153CStinson 108-2 · S/N 108-3153Cancelled Oct 17, 1955 · Consolidated Vultee Aircraft CorpN203CStinson 108-2 · S/N 108-3203Cancelled Oct 17, 1955 · Consolidated Vultee Aircraft CorpN8141KStinson 108-1 · S/N 108-1-1141Cancelled Oct 17, 1955 · Built 1943 · Consolidated Vultee Aircraft CorpN8147KStinson 108-1 · S/N 108-1-1147Cancelled Oct 17, 1955 · Built 1946 · Consolidated Vultee Aircraft CorpN8346KStinson 108-1 · S/N 108-1346Cancelled Oct 17, 1955 · Built 1946 · Consolidated Vultee Aircraft CorpN8711KStinson 108-1 · S/N 108-1711Cancelled Oct 17, 1955 · Consolidated Vultee Aircraft CorpN8757KStinson 108-1 · S/N 108-1757Cancelled Oct 17, 1955 · Consolidated Vultee Aircraft CorpN4086CStinson 108-3 · S/N 108-5086Cancelled Oct 14, 1955 · Consolidated Vultee Aircraft CorpN4258CStinson 108-3 · S/N 108-5258Cancelled Oct 14, 1955 · Consolidated Vultee Aircraft CorpN591CStinson 108-3 · S/N 108-3591Cancelled Oct 14, 1955 · Consolidated Vultee Aircraft CorpN3043EAeronca 7AC · S/N 7AC-6629Cancelled Oct 4, 1955 · John E AndrewsN8541KStinson 108-1 · S/N 108-1541Cancelled Aug 23, 1955 · Built 1947 · Consolidated Vultee Aircraft CorporationN209EFairchild M-62A · S/N T41-999Cancelled Sep 14, 1954 · Built 1941 · Hebron Robert GN69493Cessna T-50 · S/N 1203Cancelled Sep 7, 1954 · Hebron Robert GN8241KStinson 108-1 · S/N 108-1-1241Cancelled Aug 10, 1954 · Consolidated Vultee Aircraft CorpN37059Luscombe 8B · S/N 1720Cancelled Dec 15, 1953 · Exported to Canada · Built 1941 · Bevard LawrenceN1491NPiper J3C-65 · S/N 23018Cancelled Jul 27, 1951 · Built 1947 · Thornton Truman DN3070EAeronca 7AC · S/N 7AC-6659Cancelled Jul 23, 1951 · Sutterfield DouglasN821CStinson 108-3 · S/N 108-3821Cancelled Sep 22, 1949 · Exported to China · Consolidated Vultee Aircraft CorpN1410North American AT-6A · S/N 78-6998Cancelled Aug 23, 1949 · Exported to Pakistan · Hebron Robert GeorgeN97487Stinson 108 · S/N 108-487Cancelled Aug 22, 1949 · Consolidated Vultee Aircraft CorpN97508Stinson 108 · S/N 108-508Cancelled Jun 14, 1949 · Consolidated Vultee Aircraft CorpN97087Stinson 108-1 · S/N 108-1-1087Cancelled May 5, 1949 · Built 1946 · Consolidated Vultee Aircraft CorporationN97101Stinson 108-1 · S/N 108-1-1101Cancelled May 5, 1949 · Built 1946 · Consolidated Vultee Aircaft CorporationN97107Stinson 108-1 · S/N 108-1-1107Cancelled May 5, 1949 · Built 1946 · Consolidated Vultee Aircraft CorporationN97111Stinson 108-1 · S/N 108-1-1111Cancelled May 5, 1949 · Built 1946 · Consolidated Vultee Aircraft CorporationN97117Stinson 108-1 · S/N 108-1-1117Cancelled May 5, 1949 · Built 1946 · Consolidated Vultee Aircraft CorporationN97121Stinson 108-1 · S/N 108-1-1121Cancelled May 2, 1949 · Built 1946 · Consolidated Vultee Aircraft Corporation
Back to Wayne, MI