Cancelled registrations · 30

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 = 'OH' AND d.registrant_city = 'FREMONT' 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 = 'OH' AND d.registrant_city = 'FREMONT'
  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 = 'OH' AND d.registrant_city = 'FREMONT'
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.

N23UTStarduster II SA-300 · S/N 182Cancelled Nov 5, 2022 · Registration expired, pending cancellation · Built 1971 · Damschroder Rex A N2986HEngineering & Research 415-C · S/N 3611Cancelled Sep 26, 2020 · Revoked, canceled · Built 1946 · Conner Arley N2352KLuscombe 8E · S/N 5079Cancelled Sep 23, 2020 · Sale reported, canceled · Built 1946 N11266Cessna 150L · S/N 15075285Cancelled Apr 23, 2019 · Built 1973 · Pierstorff Roger D N22793Leonard Bruce F QUICKSILVER MX II · S/N 3699Cancelled Jan 2, 2018 · Registration expired, pending cancellation · Built 1991 · Leonard Bruce F N63944Piper PA-23-250 · S/N 27-7854077Cancelled Aug 16, 2017 · First renewal notice · Built 1978 · Randall John Kelly N5855GCessna A188B · S/N 18801156Cancelled May 19, 2015 · Registration expired, pending cancellation · Built 1973 · Gibbs Aero Spray Inc N3590HAerostar International S-60A · S/N S60A-3093Cancelled Apr 24, 2015 · Registration expired, pending cancellation · Built 1988 · Pasch David W N29122Cessna U206C · S/N U206-1092Cancelled Nov 4, 2008 · Triennial form not returned · Built 1968 · Damschroder Eugene E Trustee N8215SCessna 150F · S/N 15061815Cancelled Aug 5, 2004 · Sale reported · Built 1965 N4345YPiper PA-25-260 · S/N 25-4841Cancelled Feb 25, 2003 · Exported to Mexico · Built 1968 · Gibbs Luther A N61533Cessna 172M · S/N 17264620Cancelled Apr 15, 1976 · Exported to Canada · Gene Damschroder N2313APiper PA-22 · S/N 22-702Cancelled May 8, 1975 · Exported to Canada · Built 1952 · Wright Paul L N1122VCessna U206F · S/N U20602476Cancelled Oct 1, 1974 · Exported to Liberia · Damschroder Sales Co N1582UCessna 207 · S/N 20700182Cancelled Jun 5, 1973 · Damschroder Gene N2002HErcoupe 415-C · S/N 2625Cancelled Sep 21, 1972 · Built 1946 · Proietty Francesco A N3194JCessna 150G · S/N 15065894Cancelled Aug 18, 1971 · Exported to Canada · Damschroder Sales Co DBA/ Etal N97528Stinson 108 · S/N 108-528Cancelled Mar 3, 1971 · Plihall James L N2888KLuscombe 8A · S/N 5615Cancelled Jun 20, 1967 · Foos John A N9146KUniversal Stinson 108-1 · S/N 108-2146Cancelled May 21, 1965 · Kiser Jack R N39512Aeronca 65-TAF · S/N F5152TACancelled Mar 7, 1956 · Built 1942 · Slager J W N9995HFairchild M-62A-3 · S/N FV248Cancelled Feb 14, 1956 · Slager Joseph W N5665NConsolidated Vultee BT-13A · S/N 7284Cancelled Nov 15, 1955 · Joseph Binder Jr N47497Fairchild M-62A · S/N T43-5156Cancelled Jun 26, 1952 · Nobil Jerry C N5662NCessna T-50 · S/N 4669Cancelled Nov 23, 1951 · Slager J W N51275Consolidated Vultee BT-13A · S/N 9850Cancelled Mar 8, 1950 · Shulenberger Earl N9618HCessna T-50 · S/N 4543Cancelled Feb 20, 1950 · Central Airparts Inc N923KCurtiss Wright ROBIN · S/N 509Cancelled Apr 29, 1948 · George H Demmel N9619HCessna T-50 · S/N 4193Cancelled Mar 15, 1948 · Central Airparts Inc N1366National Airways System AIR KING · S/N M3764Cancelled Jul 2, 1928 · Homer W Johnston

Back to Fremont, OH