Skip to content

Cancelled registrations · 35

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 = 'IN' AND d.registrant_city = 'SEYMOUR' 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 = 'IN' AND d.registrant_city = 'SEYMOUR'
  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 = 'IN' AND d.registrant_city = 'SEYMOUR'
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.

N328YSDJI AGRAS T50 · S/N 1581F6BUB236S00100GFCancelled Sep 17, 2026 · Registration pending, canceled N2132SCessna R182 · S/N R18201306Cancelled Jul 14, 2021 · Exported to Brazil · Rust James P N3160EAeronca 11AC · S/N 11AC-1502Cancelled Apr 25, 2017 · Registration expired, pending cancellation · Built 1946 · Imlay Stephen D N89396Cessna 140 · S/N 8428Cancelled Dec 27, 2016 · Revoked, pending cancellation · Built 1946 · Seymour Flying Club N6430SCessna 182T · S/N 18281409Cancelled Aug 8, 2014 · Exported to Brazil · Built 2004 · Hendrix Aviation LLC N7351DPiper PA-22-150 · S/N 22-5146Cancelled Aug 20, 2013 · Sale reported, canceled · Built 1957 N5359CCessna 140A · S/N 15490Cancelled Oct 18, 2012 · Exported to Brazil · Built 1950 · Rust Paul Andrew N145RMMulloy Richard C JR CHRISTEN EAGLE-II · S/N MULLOY-0001Cancelled Aug 13, 2012 · Sale reported, canceled N4773YPiper PA-25-235 · S/N 25-4537Cancelled Aug 6, 2012 · Revoked, canceled · Built 1968 · Agricultural Aviation Inc N9010USmith Stephen R PRECEPTOR (ULTRA PUP · S/N 1949Cancelled May 1, 2009 · Built 2004 · Smith Stephen R N3352WPiper PA-32-260 · S/N 32-194Cancelled Nov 23, 2004 · Triennial form not returned · Built 1965 · Grant Berl J N761KJCessna T210M · S/N 21062314Cancelled Mar 9, 2004 · Exported to Mexico · Built 1977 · Boys N M N6140TCessna 150E · S/N 15060840Cancelled Feb 14, 2001 · Stewart Le DBA N304RLSeibert Cletus A JUNGSTER I · S/N JI-7220Cancelled May 19, 2000 · Triennial form not returned · Seibert Cletus A N374ASDouglas C-47 · S/N 34154Cancelled Apr 1, 1996 · Jack Rhodes Aircraft Sales N6105YBeech A36 · S/N E1938Cancelled Mar 22, 1993 · Rose Acre Farms N500LBeech D18S · S/N A415Cancelled Sep 13, 1985 · Administratively canceled · Rhoades Aircraft Sales Inc N6119VBeech 95-B55 · S/N TC-872Cancelled Oct 29, 1982 · Exported to Canada · Bishop Air Service Inc N8920ZCessna 310G · S/N 310G0020Cancelled Aug 8, 1979 · Exported to Canada · Rhoades Jack L Aircraft Sales N7743ZPiper PA-25-235 · S/N 25-3923Cancelled Oct 1, 1976 · Agricultural Aviation Inc N3204WPiper PA-32-260 · S/N 32-4Cancelled Oct 8, 1974 · Built 1965 · Hembree Ray N7831GCessna 172L · S/N 17259531Cancelled Feb 25, 1974 · Exported to Canada · Jack L Rhoades Aircraft Sales N1171XBeech C18S · S/N 8124Cancelled Jul 31, 1973 · Built 1945 · Seymour Airmotive Inc N5573YPiper PA-23-250 · S/N 27-2677Cancelled Apr 12, 1973 · Exported to Canada · Jack L Rhoades Aircraft Sales Inc N1765NCessna 120 · S/N 12009Cancelled Mar 14, 1973 · Exported to Canada · Thornberry W L N29597Cessna 177 · S/N 17700982Cancelled Aug 25, 1972 · Exported to Canada · Built 1968 · Jack L Rhoades Aircraft Sales Inc N4508EAeronca 7DC · S/N 7DC122Cancelled May 25, 1951 · Exported to Canada · Trans Air Inc N96736Taylorcraft BC12-D · S/N 9036Cancelled Jul 16, 1948 · Ashcraft Charles Gregory N20060Piper J-2 · S/N 1860Cancelled May 13, 1948 · Williams Russell Et Al N84700Aeronca 7AC · S/N 7AC-3417Cancelled Apr 28, 1947 · Edwin K Beck N2159FCessna U206 · S/N U2060359Cancelled May 12, 1937 · Exported to Canada · Built 1963 · Metal Air Service N805YCrothersville Lumber CROTHERSVILLE GLIDER · S/N PT-3Cancelled Feb 25, 1936 · Built 1930 · Crothersville Lumber Co In N806YCrothersville Lumber CROTHERSVILLE GLIDER · S/N PT-4Cancelled Feb 25, 1936 · Built 1930 · Crothersville Lumber Co Inc N645WAeronca C-2 · S/N 25Cancelled Feb 15, 1936 · Crothersville Lumber Yard Co Inc N12810Brazil BRAZIL 300 · S/N 100-BCancellation date not recorded · Built 1932 · Midwestern Aviation Corp

Back to Seymour, IN