Skip to content

Cancelled registrations · 138

Query with SQL

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

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.

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

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N4325NCessna 195 · S/N 7084Cancelled Aug 16, 1991 · Triennial form not returned · Peters Ray L N7158WPiper PA-28-180 · S/N 28-966Cancelled Jan 7, 1986 · Robert C Locke N50552Cessna 150J · S/N 15069393Cancelled Oct 22, 1984 · Allen Terry F N51MBeech E18S · S/N BA-239Cancelled Dec 1, 1982 · Green Aero Inc N2269YCessna 177 · S/N 17700069Cancelled Jan 21, 1981 · Exported to New Zealand · Built 1968 · Anglin Mary E N91755Converse EASYRISER · S/N WJC513Cancelled Oct 29, 1980 · Converse Wesley J N3473VVoto SMYTH SIDEWINDER · S/N 212268Cancelled Apr 10, 1979 · Built 1978 · Voto Robert C N6590WPiper PA-28-140 · S/N 28-20676Cancelled Dec 13, 1977 · Garrett Glen W N5564Thorp T-18 · S/N 532Cancelled May 25, 1976 · Warren Howard B N76554Cessna 120 · S/N 10990Cancelled Sep 26, 1975 · Creager M M Jr N9989Bell TH-13T · S/N 64-17893Cancelled Jun 20, 1975 · Genesee County Civil Defense N4306BCessna 170B · S/N 26650Cancelled May 30, 1975 · Exported to Canada · Schock James C Et Al N4589KRyan NAVION · S/N NAV-4-1589Cancelled Jul 19, 1974 · Exported to Canada · Built 1948 · Ballentine Evelyn N3230XCessna 150G · S/N 64630Cancelled May 4, 1974 · Built 1974 · Kitson Dale N212CKBeech J35 · S/N D-5706Cancelled Apr 23, 1974 · Exported to Canada · Harrell Ernest J N3065Knight KNIGHTS TEAL · S/N 1Cancelled Apr 22, 1974 · Knight Donald H N4888LPiper PA-28-180 · S/N 28-4254Cancelled Mar 29, 1974 · Built 1967 · Parker Norman N5254LPiper PA-28-180 · S/N 284551Cancelled Mar 23, 1974 · Eagle Aviation Inc N2689NCessna 140 · S/N 12947Cancelled Dec 17, 1973 · Exported to Canada · Elston Stewart W N2447MPiper PA-12 · S/N 12-1539Cancelled Aug 10, 1973 · Exported to Canada · Randall Clarence O And Wilson Jack L N1426APiper PA-22 · S/N 22-342Cancelled Jun 5, 1973 · Jucius George W Robert P Kucher N6790FCessna 150F · S/N 15063390Cancelled May 21, 1973 · Exported to Canada · Flight School Regal Inc N2070TPiper PA-28R-200 · S/N 28R7135014Cancelled Sep 21, 1972 · Built 1970 · Flint Air Inc N65AHWoods EVANS VP-1 · S/N 622Cancelled Mar 10, 1972 · Built 1971 · Woods William E N4317GMcculloch J-2 · S/N 027Cancelled Dec 16, 1971 · Gyroplanes Of Michigan Inc N29555Cessna 177 · S/N 17700961Cancelled Nov 24, 1971 · Flint Air Inc N2342NCessna 140 · S/N 12588Cancelled Sep 28, 1971 · Bedford Milton P N3450Mckeighan John J BENSON B-8M · S/N 1Cancelled Sep 23, 1971 · Mckeighan John J N2510MPiper PA-12 · S/N 12-1008Cancelled Sep 15, 1971 · Built 1946 · Lakies Willard W N24555Piper J4A · S/N 4-643Cancelled Aug 31, 1971 · Joesph Booker N2253APiper PA-22 · S/N 22-655Cancelled Feb 25, 1971 · Bradford Paul Edward N2657GCessna 182B · S/N 51957Cancelled Dec 8, 1970 · Flintair Inc N25258Luscombe 8A · S/N 1165Cancelled Sep 21, 1970 · Ira J Sewell N3804NBeech 35 · S/N D-1032Cancelled Jun 8, 1970 · Comber William N9187CCessna 180 · S/N 31286Cancelled Feb 3, 1966 · Habermahl Clarence E N54551Cessna UC-78 · S/N 4828Cancelled May 20, 1965 · Flint Aeronauticalcorp N7806ECessna 150 · S/N 17606Cancelled Jul 29, 1964 · Robert Dryer N6412DNorth American SNJ-4 · S/N 88-13256Cancelled Dec 19, 1963 · Built 1958 · Lussier Arthur H N3518APiper PA-22-135 · S/N 22-1790Cancelled Nov 7, 1963 · Dixon James P N5362DCessna 180A · S/N 50260Cancelled Aug 13, 1963 · Exported to Canada · Built 1958 · Fisher & Wright Inc N2326CCessna 180 · S/N 30626Cancelled May 3, 1963 · Chamberlin Clayton B N2542VCessna 170 · S/N 18046Cancelled Oct 23, 1959 · Flint Aeronautical Corp N79581Stinson V77 · S/N 77-217Cancelled Sep 29, 1959 · Exported to Canada · Laurin Carl N407CStinson 108-2 · S/N 108-3407Cancelled Dec 31, 1958 · Bielby Clarence S N7784KPiper PA-20 · S/N 20-608Cancelled Nov 26, 1958 · Jordan Joseph E N9649BCessna 180A · S/N 32946Cancelled Sep 11, 1958 · Fisher And Wright Inc N9673EAeronca 11AC · S/N 11AC-1316Cancelled Nov 12, 1957 · Exported to Canada · Davision Flying Club N3376VBeech 35 · S/N D-844Cancelled Sep 12, 1957 · Rhame Paul W N5371CCessna 140A · S/N 15504Cancelled Aug 9, 1956 · Koerts Albert J N3539CCessna 170B · S/N 26582Cancelled Jul 24, 1956 · Flint Aeronautical Corp

Back to Flint, MI