Cancelled registrations · 38

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 = 'BENTON HARBOR' 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 = 'BENTON HARBOR'
  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 = 'BENTON HARBOR'
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.

N3171NOdosij Eugene FLIGHTSTAR II · S/N 100406Cancelled Feb 22, 2023 · Odosij Eugene N5137TQuad City Ultralight Acft CHALLENGER LW1 · S/N 0294W0465Cancelled Jan 6, 2020 · Registration expired, pending cancellation · Built 1994 · Crowder Larry A N180TADroidworx AD-8HL · S/N GE5YXSVJCancelled Nov 29, 2019 · Registration expired, pending cancellation · Alti Thomas G N163TADJI FLAMEWHEEL F450 · S/N YGYFHMQBCancelled Nov 1, 2019 · Registration expired, pending cancellation · Alti Thomas G N179TADJI FLAMEWHEEL F550 · S/N WA4YZUYYCancelled Sep 6, 2019 · Registration expired, pending cancellation · Alti Thomas G N7636JPiper PA-28R-180 · S/N 28R-31034Cancelled Nov 21, 2017 · Revoked, canceled · Kinnavy Roger J N6725ACessna 172 · S/N 28825Cancelled Sep 26, 2013 · Revoked, canceled · Built 1956 · Smith Ernest T N8826YPiper PA-30 · S/N 30-1984Cancelled Dec 3, 2009 · Exported to Australia · Built 1969 · Priebe Equipment LLC N65568Cessna 152 · S/N 15281623Cancelled Apr 18, 2008 · Exported to New Zealand · Built 1978 · Rhoads Warren N60MLRockwell International NA-265-60 · S/N 306-129Cancelled Sep 10, 2002 · Exported to Mexico · Engineered Plastic Components Inc N515AWFokker F.27MK 500 · S/N 10678Cancelled Jan 10, 1995 · Exported to India · Whirlpool Financial Corporation N1442JRockwell International 112A · S/N 442Cancelled Mar 13, 1979 · Exported to Switzerland · Edquid Aviation Inc N53803Bellanca 8KCAB · S/N 21475Cancelled Sep 7, 1976 · Yettaw Delbert N9162XCessna 182 · S/N 18253562Cancelled Jan 21, 1974 · Exported to Canada · Blue Star Aviation Inc N2596CCessna 170B · S/N 26240Cancelled Mar 22, 1972 · Exported to Canada · Fisher Ivan P N9924RBeech D50C · S/N DH-267Cancelled Apr 1, 1971 · Aircraft Components Inc N2761BAero Commander 560-A · S/N 442Cancelled Jun 29, 1970 · Beaudoin-Stueland Electric Co Inc N7847ZCessna 150C · S/N 15059947Cancelled Jun 29, 1970 · Cramer Aviation Center Inc N8476WPiper PA-28-180 · S/N 28-2718Cancelled Jun 16, 1970 · Built 1965 · Schumacher William M N5639LAmerican AA-1 · S/N AA1-0039Cancelled Jun 6, 1969 · Cramer Eugene S N24133Benson GYROCOPTER · S/N OWB-7Cancelled Nov 14, 1967 · Brown Orville W N1750NCessna 120 · S/N 11994Cancelled Sep 27, 1960 · Freier Irving R N24591Piper J3F-50 · S/N 3271Cancelled Sep 21, 1960 · Meiners Lester And/Or Louise Meiners N42729Piper J3C-65 · S/N 15029Cancelled Sep 21, 1960 · Built 1945 · Meiners Lester & Meiners Louise N81569Aeronca 7AC · S/N 7AC-188Cancelled Aug 23, 1960 · Meiners Lester And Meiners Louise N76266Cessna 120 · S/N 10674Cancelled Sep 2, 1958 · Exported to Canada · Boyer Ronald W N54742Fairchild M-62A · S/N T42-3318Cancelled Oct 21, 1955 · Gersh Nathan W N79546Cessna T-50 · S/N 2653Cancelled Oct 12, 1955 · Knipschild Arthur S N1781EAeronca 7AC · S/N 7AC-5348Cancelled Oct 4, 1955 · Twin Cities Flying Service N63720Consolidated Vultee BT-13A · S/N 9645Cancelled Mar 4, 1955 · Peterson Jr A J & Ronald A Nelthorpe N1826KLuscombe 8E · S/N 4553Cancelled Aug 9, 1951 · Morrison Charles N97026Stinson 108-1 · S/N 108-1-1026Cancelled Dec 6, 1950 · Built 1946 · Twin Cities Flying Service N36627Aeronca 65-TAL · S/N L1201TACancelled Aug 31, 1948 · Built 1941 · Keith Guy P N3213HErcoupe 415-C · S/N 3838Cancelled Aug 7, 1947 · Built 1946 · Twin Cities Flying Service N11398Long Guy G MEAD RHON RANGER · S/N 10Cancelled Jul 1, 1937 · Built 1931 · Navroth Edward John N15773Alti Stanley ALTIS SPECIAL · S/N 1Cancelled Jul 27, 1936 · Built 1936 · Alti Stanley N817VWaco NAZ · S/N 4018Cancelled Mar 13, 1933 · Twin City Glider Club N1576Alexander EAGLEROCK · S/N 202Cancelled Sep 21, 1928 · Built 1927 · Trimble E J

Back to Benton Harbor, MI