Skip to content

Cancelled registrations · 89

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

N5971GDJI PHANTOM 3 ADVANCED · S/N P76DCG14010437Cancelled Mar 5, 2022 · Registration expired, pending cancellation · Lochmueller Group Inc N261ZDJI PHANTOM 2 VISION + · S/N PH645501905Cancelled Feb 5, 2022 · Registration expired, pending cancellation · Lochmueller Group Inc N9529YBeech 35-B33 · S/N CD-555Cancelled Jan 8, 2022 · Registration expired, pending cancellation · Built 1962 · Weythman Grant O N601FLPiper PA-28-140 · S/N 28-7125475Cancelled Oct 30, 2021 · Registration expired, pending cancellation · Built 1971 · N601fl LLC N822VCDJI INSPIRE 1 · S/N W13DEA19060807Cancelled Oct 3, 2020 · Registration expired, pending cancellation · Vanderburgh County Sheriffs Office N1438GBeech P35 · S/N D-6915Cancelled Feb 28, 2020 · Registration expired, pending cancellation · Sizemore Bennie E N6700MStinson 108 · S/N 1084700Cancelled Aug 5, 2019 · Revoked, canceled · Built 1948 · Johann Albert And Sons Co Inc N615SGSensefly EBEE · S/N EB-02-746Cancelled Mar 11, 2019 · Registration expired, pending cancellation · Frontier Geospatial LLC N9723RBeech M35 · S/N D-6195Cancelled Nov 17, 2018 · Revoked, canceled · Built 1959 · Kirkman Drilling Co N8527JCessna 150G · S/N 15066427Cancelled May 21, 2018 · Revoked, canceled · Built 1967 · Jarvis Harold L N6616BCessna 310B · S/N 35716Cancelled Apr 6, 2018 · Revoked, canceled · Built 1958 · Slape Don Operating Co N572ASmith Miniplane DSA-1 · S/N S511Cancelled Mar 28, 2018 · Registration expired, pending cancellation · Built 1964 · Hensley Victor E N4379NSlivinski John F Q2 · S/N 2624Cancelled Jan 19, 2018 · Registration expired, pending cancellation · Moehlenkamp Robert E N5538FPiper PA-28-140 · S/N 28-24937Cancelled Jan 5, 2018 · Registration expired, pending cancellation · Built 1968 · J F Aircraft LLC N66DWWhitesel SONERAI II · S/N 177Cancelled Jan 5, 2018 · Registration expired, pending cancellation · Built 1978 · Wiggin Peter D N750RWBushmaster 2000 · S/N 2Cancelled Jun 15, 2017 · Registration expired, pending cancellation · Built 1985 · Fuchs Rr DBA N6764PPiper PA-24 · S/N 24-1894Cancelled Jun 7, 2017 · Registration expired, pending cancellation · Built 1960 · Hogan Bernard J Jr N36947Balloon Works FIREFLY 7-B · S/N F7B-112Cancelled May 31, 2017 · Registration expired, pending cancellation · Built 1984 · Weber Jeffrey R N11007Klett-Bailey STARDUSTER SA-300 · S/N 1007Cancelled Mar 5, 2016 · Exported to Canada · Built 1974 · Mcmichael Gregory E N7508FSchweizer 269C · S/N S1273Cancelled Jun 9, 2015 · Exported to Guatemala · Vertical Flight Leasing LLC N5061LBellanca 8KCAB · S/N 561-79Cancelled Apr 29, 2015 · Exported to Canada · Built 1979 · Bizal John N6257GCessna 150K · S/N 15071757Cancelled Nov 12, 2014 · Registration expired, pending cancellation · Built 1970 · Hixlin Industries Inc DBA N107VVWarren Jay L SONERAI II L · S/N 1014Cancelled Nov 12, 2013 · First renewal notice · Built 1993 · Warren Jay L N2556SKolb FIRESTAR · S/N 001Cancelled Aug 27, 2013 · Sale reported, canceled · Built 1991 N8135YFritchey Van F MXL II · S/N 1449Cancelled Jul 10, 2013 · Sale reported, canceled · Built 1989 N8713GCessna 172H · S/N 17256200Cancelled May 15, 2013 · Registration expired, pending cancellation · Built 1967 · Skylane Flying Club LLC N7241FPiper PA-28-140 · S/N 28-25154Cancelled May 6, 2013 · Registration expired, pending cancellation · Built 1968 · Prow Ben S N9305PAsbell William E PITTS S-1S · S/N 001Cancelled Nov 8, 2012 · Second renewal notice · Built 1999 · Jochim Mark A N4868WRockwell International 114 · S/N 14198Cancelled Aug 1, 2012 · Second renewal notice · Pure Air Inc N74025Grumman American Avn. AA-5B · S/N AA5B-0102Cancelled Jun 8, 2011 · Triennial form not returned · Built 1975 · Mcmichael Gregory E DBA N515BBEurocopter AS 350 BA · S/N 2726Cancelled Jan 6, 2011 · Exported to Australia · Built 1993 · Black Beauty Coal Co N65AHHartman Alfonse A EAA BI PLANE · S/N 0065Cancelled Mar 2, 2009 · Registration pending · Built 2003 N91686North American NAVION · S/N NAV-4-174Cancelled Jul 17, 2008 · Triennial form not returned · Built 1946 · Titzer Ronald C N7690EChampion 7FC · S/N 7FC-285Cancelled Mar 23, 2005 · Triennial form not returned · Built 1958 · Easley Ralph A Jr N13DTTaylor Donald E TINKER TOY II · S/N 001Cancelled Feb 25, 2003 · Built 2002 · Taylor Donald E N5178DLowe David N3 2 · S/N 001Cancelled Apr 8, 2002 · Jennings Ronald V N4752NCessna 182Q · S/N 18267339Cancelled Feb 5, 2002 · Built 1979 · Speer Aircraft II LLC N904DSCessna 177B · S/N 17702490Cancelled Mar 22, 2000 · Kaskel Richard W N782DBeech C35 · S/N D-3051Cancelled Nov 3, 1999 · Triennial form not returned · Keown Charles A III N41280Piper PA-28-151 · S/N 287415156Cancelled Jul 15, 1996 · Triennial form not returned · Wingert Jack L N5675LAmerican AA-1 · S/N AA10075Cancelled May 21, 1992 · Fireside Gallery Inc N8696TCessna 182C · S/N 52596Cancelled Feb 21, 1992 · Triennial form not returned · Pike Billy J N3504JCessna 150E · S/N 15061204Cancelled Sep 10, 1991 · Legate Benton L N5002NWilcox Douglas MXL II H P · S/N 1147Cancelled Dec 21, 1990 · Wilcox Douglas N6128GCessna 150K · S/N 15071628Cancelled Nov 19, 1984 · Whitney James E N6604QLong SKYBOLT NO. 1 · S/N 1Cancelled Nov 16, 1984 · Long Karen L N7265XCessna 150B · S/N 15059365Cancelled Oct 13, 1983 · Bufkin Walter R N2511YCessna 172D · S/N 17249811Cancelled Aug 31, 1982 · Willis Aviation Inc N35CHHooper PITTS SPECIAL S-1S · S/N 121976Cancelled Aug 24, 1982 · Built 1977 · Scott Mark D N75923Cessna 172N · S/N 17268046Cancelled Oct 15, 1981 · Tri State Aero Inc

Back to Evansville, IN