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.

N84341Aeronca 7AC · S/N 7AC-3035Cancelled Feb 23, 1956 · Obrien James FN70051Fairchild M-62C · S/N 39FECancelled Feb 20, 1956 · Barc Richard AN61661Cessna T-50 · S/N 3815Cancelled Oct 24, 1955 · Versatile Engineering & Manufacturing CoN1450NPiper J3C-65 · S/N 22978Cancelled Oct 18, 1955 · Pirtle James MN67908Douglas A-26B · S/N 28037Cancelled Oct 13, 1955 · The Ford Motor CoN21965Rearwin 9000 DELUXE · S/N 645DCancelled Mar 18, 1955 · Dearborn Flying ClubN63653Consolidated Vultee BT-13A · S/N 8225Cancelled Mar 4, 1955 · Nichols Thomas HN51116Cessna UC-78 · S/N 4878Cancelled Nov 16, 1953 · Dearborn Skyways IncN1926EAeronca 7AC · S/N 7AC-5493Cancelled Jul 23, 1951 · Chappell RonaldN6198KRepublic RC-3 · S/N 389Cancelled Jul 23, 1951 · Paterson Jack HN21988Porterfield CP-50 · S/N 571Cancelled Jun 15, 1951 · Naylor Robert MN7470KPiper PA-20 · S/N 20-383Cancelled Mar 7, 1951 · Townsend Robert FN3366NPiper J3C-65 · S/N 22567Cancelled Feb 16, 1950 · Built 1946 · Chappell RonaldN1271Gwinn Aircar I · S/N 501Cancelled Jul 12, 1948 · Built 1937 · Gwinn Joseph M JrN22301Welch OW5M · S/N 144Cancelled Jun 8, 1948 · Zaphiriou James George & Zaphiriou Diamond AlexN19335Aeronca K · S/N K-198Cancelled May 12, 1948 · Bailey Kenneth RN766KWaco BSO · S/N 160Cancelled Apr 29, 1948 · Albert Jarvis Willoughby GayN262YWaterman Arrowplane W-5A · S/N 2Cancelled Apr 6, 1948 · Consolidated Vultee Aircraft CorporationN946HWaco GXE · S/N 2066Cancelled Dec 29, 1947 · Lundgren JohnN23458Piper J3F-50 · S/N 3181Cancelled Nov 19, 1947 · Stabenau Robert W & Reuther Sherman JN3365NPiper J3C-65 · S/N 22565Cancelled Nov 4, 1947 · Built 1946 · Chappel RonaldN9922HDouglas C-47 · S/N 4662Cancelled Aug 18, 1947 · Exported to Nicaragua · Built 1942 · Ford Motor CoN4696Waco GXE · S/N 2054Cancelled Mar 1, 1941 · Wieczorak Victor J And Drab Harry RomanN999EFord Motor Co Airplane Div 15-P · S/N 1Cancelled Jan 1, 1937 · Built 1935 · Ford Motor Company Inc/Aircraft DivisionN10899Stout SKYCAR · S/N 101Cancelled Oct 15, 1935 · Built 1931 · Stout Engineering Laboratories IncN360American Glider Association A · S/N 2-ACancelled Jun 17, 1935 · American Glider AssociationN490MStout Engineering Laboratories SX-9 · S/N 1Cancelled Jan 11, 1933 · Built 1930 · Stout Engineering LaboratoriesN9654Ford 5-AT-D · S/N 113Cancelled Sep 21, 1932 · Ford Motor CoN8404Stout Metal FORD 11AT · S/N 1Cancelled Apr 1, 1932 · Built 1929 · Stout Metal AirplanecoN9652Ford Motor Co Airplane Div XB-906 · S/N 1Cancelled Oct 3, 1931 · Ford Motor CompanyN419HStout Metal FORD 5-AT · S/N 79Cancelled Dec 3, 1930 · Stout Metal Airplane CompanyN4542Ford 4-AT · S/N 15Cancelled Aug 21, 1930 · Ford Motor CoN404American Glider Association A · S/N 1-ACancelled Mar 28, 1930 · American Glider AssociationN267Fokker F-VII (TRI-MOTOR) · S/N 600Cancelled Mar 14, 1930 · Ford Motor CompanyN8412Ford 5-AT-C · S/N 50Cancelled Jan 10, 1930 · Exported to Czech Republic · Built 1929 · Stout Metal Airplain CompanyN1992Waco 10 · S/N 1587Cancelled Oct 4, 1929 · Built 1918 · Reed J WN1319Standard J-1 · S/N 3859Cancelled Sep 6, 1929 · Built 1927 · Hazelfeldt Harry HN5810Ford 4-AT · S/N 26Cancelled May 11, 1929 · Built 1928 · Stout Metal Airplane CompanyN1076Ford 4-AT · S/N 9Cancelled Feb 14, 1929 · Stout Air Services IncN880Ford 4-AT · S/N 8Cancelled Oct 30, 1928 · Built 1927 · Stout Air Servies IncN1492Ford 4-AT · S/N 1Cancelled May 1, 1928 · Built 1926 · Ford Motor CompanyN3444Stout Metal TRI-MOTOR TRANSPORT · S/N 4-AT-13Cancelled Dec 15, 1927 · Built 1927 · Stout Metal Airplane Co
Back to Dearborn, MI