OpenAirDocs.org
Flint, MI

Cancelled registrations · 138

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

N61579Cessna UC-78 · S/N 4577Cancelled Apr 30, 1956 · Dinsmore Robert CN2192BLuscombe 8F · S/N 6619Cancelled Mar 29, 1956 · Ray Hull Aviation CoN9853HFairchild M-62A-3 · S/N FV672Cancelled Feb 14, 1956 · Massey Stewart WN48120Fairchild PT-19 · S/N T43-5654Cancelled Oct 25, 1955 · Built 1941 · Rogers Donald CN61726Fairchild M-62A · S/N T40-249Cancelled Oct 25, 1955 · Galbreath George MN65592Cessna T-50 · S/N 4729Cancelled Oct 13, 1955 · Ray Hull Aviation CoN51638Fairchild M-62A · S/N T43-5974Cancelled Oct 11, 1955 · Genesee AviationN3443MPiper PA-12 · S/N 12-2285Cancelled Sep 13, 1954 · Built 1947 · Chiles Paul LN3483VCessna 190 · S/N 7183Cancelled Feb 24, 1953 · Flint Flying Services IncN4110VCessna 170 · S/N 18442Cancelled Mar 7, 1952 · Fraser James CN1783EAeronca 7AC · S/N 7AC-5350Cancelled Feb 26, 1952 · Built 1946 · Cosand Frank C DBA Cosand Flying ServiceN3882HErcoupe 415-CD · S/N 4583Cancelled Jul 23, 1951 · Genesee AviationN54626Cessna T-50 · S/N 5604Cancelled Jul 13, 1951 · Moen Clarence HN51403Consolidated Vultee BT-13A · S/N 6560Cancelled Feb 9, 1949 · Panos Peter SN36829Aeronca 65-TAC · S/N C1631TACancelled Jan 5, 1949 · Genesee AviationN47369Ryan Aeronautical ST3KR · S/N 1668Cancelled Oct 26, 1948 · Westervelt Robert LN13552Aeronca C-3 · S/N 286Cancelled Jul 20, 1948 · Hughes Albert NN29251Culver LCA · S/N 119Cancelled Jul 16, 1948 · Built 1940 · Mark JosephN3769MPiper PA-12 · S/N 12-2701Cancelled Jun 30, 1948 · Flint Flying ServiceN19816Taylorcraft A · S/N 320Cancelled Jun 2, 1948 · Built 1937 · Charchan Andy And Kaszubowski StanleyN1680Northwestern Balloon EXHIBITION(48X75) · S/N 1480 (SUB)Cancelled Mar 9, 1948 · Murphy HarryN6349KRepublic RC-3 · S/N 578Cancelled Feb 10, 1948 · Bishop Flying ServiceN14105Macdonald Vance F SPORTFLIGHT-A · S/N 1Cancelled Oct 6, 1947 · Chazick John MN20928Culver LCA · S/N 108Cancelled Dec 15, 1940 · Built 1940 · Wolfe Sherman Et AlN2509Waco 9 · S/N 259Cancelled Feb 1, 1940 · Built 1926 · Owens Eugene JN6796Lincoln LINCOLN PAGE 3 · S/N 233Cancelled Oct 1, 1938 · Built 1928 · Straley Herb WN5354Merrill Balloon NORTHWESTERN HOT AIR · S/N 6Cancelled Jan 13, 1936 · Merrill Balloon CoN76Merrill Balloon NORTHWESTERN HOT AIR · S/N 4 SUBCancelled Jan 13, 1936 · Merrill Balloon CompanyN1298Curtiss JN4D · S/N 578Cancelled Feb 15, 1935 · Roy Sidney CliffordN317KCurtiss Wright ROBIN · S/N 455Cancelled Aug 16, 1934 · Miller LeoneN815YMccarroll H G MAC-1 · S/N MAC-1Cancelled Jun 22, 1932 · Built 1930 · St John DeeN115WLockheed SIRIUS 8A · S/N 166Cancelled Nov 1, 1931 · Salay WilliamN3500Advance WACO 6 · S/N 4Cancelled Jul 11, 1930 · Built 1918 · Perry Richard LN179Park J A PARKS HOT AIR BALLOO · S/N 1Cancelled Mar 20, 1930 · Built 1926 · Cody Ira LN6693Lincoln LINCOLN PAGE 3 · S/N 227Cancelled Sep 20, 1929 · Built 1916 · Love Joy School Of Aviation IncN1681Northwestern Balloon EXHIBITION (52X80) · S/N I-566Cancelled Aug 1, 1929 · Murphy HarryN3915Buhl CA-5 · S/N 11Cancelled Mar 3, 1928 · Built 1927 · Pedlar John AuggyN2915Buhl CA-3 AIRSEDAN · S/N 10Cancellation date not recorded · Malloska William F
Back to Flint, MI