Cancelled registrations · 25

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

N260YBarbara Bergstrom TITAN T-51 · S/N M07SV6SOHK0128Cancelled Sep 6, 2024 · Built 2013 · Sutton Kenneth P N263ACBeech 58 · S/N TH-382Cancelled Feb 16, 2023 · Registration expired, pending cancellation · Built 1973 · Lumair LLC N238CMDJI PHANTOM 3 PROFESSION · S/N P76DCE28016532Cancelled Mar 16, 2019 · Registration expired, pending cancellation · Meyer Christopher L N4101GBell 47G-5 · S/N 7912Cancelled Apr 13, 2017 · Registration expired, pending cancellation · Built 1968 · Arch Associates Ltd N6315PPiper PA-24 · S/N 24-1425Cancelled Apr 27, 2015 · Registration expired, pending cancellation · Built 1959 · Beggs Larry A Sr N6886GCessna 150L · S/N 15072386Cancelled Oct 24, 2013 · Registration expired, pending cancellation · Built 1970 · Daurelio Joseph L N2126CCessna 195B · S/N 16111Cancelled Mar 24, 2010 · Exported to Australia · Built 1953 · Maxfield John O N736FZCessna R172K · S/N R1722504Cancelled Jun 2, 2008 · Exported to Canada · Built 1977 · Ramsthel Steven N8421QAerofab LAKE LA-250 · S/N 87Cancelled Oct 7, 2003 · Exported to Canada · Air Cloverdale Inc N301FMFouga CM 170R MAGISTER · S/N 240Cancelled Oct 9, 2001 · Triennial form not returned · Built 1959 · Simpson Roger S N208KCCessna 208B · S/N 208B0764Cancelled Jul 9, 2001 · Exported to Canada · Kc Aviation LLC N21GVCessna P206B · S/N P2060343Cancelled Jul 31, 1995 · Triennial form not returned · Palicki Raymond F N41936Piper PA-28-151 · S/N 28-7415363Cancelled Sep 11, 1982 · Built 1974 · West Kenneth R N4WHHerzog VARI-EZE · S/N 430Cancelled Apr 10, 1979 · Built 1978 · Herzog W N17612Preiss Heinrich K SCHREDER HP-11 · S/N 2BCancelled Jun 27, 1974 · Built 1963 · Matz Thomas C Etal N7813XCessna 172B · S/N 17248313Cancelled Aug 30, 1972 · Exported to Canada · Canamer Associates Inc N7039WPiper PA-28-180 · S/N 28-722Cancelled Feb 16, 1972 · John Lemon N8554KStinson 108-1 · S/N 108-1554Cancelled Dec 14, 1971 · Stroh Arthur J N4183Stinson SM-1 · S/N 223Cancelled Aug 18, 1931 · Stinson Aircraft Corporation N7472Stinson SM1-B · S/N M-270Cancelled Aug 22, 1930 · International Air Transport N9698Stinson SM-1F · S/N 503Cancelled Oct 17, 1929 · Exported to China · Stinson Aircraft Corp N7469Stinson SM1-B · S/N M-268Cancelled Jun 28, 1929 · Exported to Mexico · Built 1928 · Stinson Aircraft Corp N7470Stinson SM1-B · S/N M-269Cancelled Jun 28, 1929 · Exported to Mexico · Built 1928 · Stinson Aircraft Corp N7473Stinson SM1-B · S/N M-271Cancelled Jun 28, 1929 · Exported to Mexico · Built 1928 · Stinson Aircraft Corp N5639Stinson SM1-B · S/N M-240Cancelled Oct 12, 1928 · Stinson Aircraft Corp

Back to Northville, MI