Skip to content

Cancelled registrations · 163

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

N484WWBeech 58 · S/N TH-909Cancelled Nov 30, 2024 · Built 1978 · Slegers John E N1513UPiccard AX-4 · S/N 10Cancelled Jan 29, 2024 · Revoked, canceled · Built 1966 · Meddock Robert D N2850KLuscombe 8A · S/N 5577Cancelled Apr 2, 2022 · Registration expired, pending cancellation · Built 1947 · Bakrevski Lupcho N4921ZPiper PA-22-108 · S/N 22-8510Cancelled Mar 10, 2022 · Registration expired · Built 1961 · Ingram Russell D N5714ZPiper PA-22-108 · S/N 22-9553Cancelled Feb 24, 2022 · First renewal notice · Built 1963 · Ingram Russell D N77200Cessna 120 · S/N 11662Cancelled Jul 12, 2021 · Sale reported, canceled · Built 1946 N311DMDavis David R TRI-Q2 · S/N 2274Cancelled Jan 9, 2021 · Registration expired, pending cancellation · Built 2004 · Stamper Peter G N5999TCessna 150 · S/N 15060699Cancelled Aug 5, 2019 · Sale reported, canceled · Built 1964 N38303Piper J3C-65 · S/N 6913Cancelled Feb 19, 2019 · Revoked, canceled · Built 1941 · Rusk Crop Spraying Co N4366CAeronca 7EC · S/N 7EC-389Cancelled Dec 17, 2018 · Revoked, canceled · Built 1956 · Valparaiso Aero Service Inc N1702AMcguire Robert T RAF-200 · S/N H2-03-14-577Cancelled Sep 13, 2018 · Registration expired, pending cancellation · Built 2004 · Mcguire Robert T N767MSDJI PHANTOM 3 PROFESSION · S/N C1261843556174Cancelled Jul 12, 2018 · Sale reported, canceled N18RZZarones Richard Lou LANCAIR 320 · S/N 531Cancelled Mar 12, 2018 · Registration expired, pending cancellation · Built 1993 · Moberley Bruce W N76SAPiper PA-28R-200 · S/N 28R-7635110Cancelled Mar 12, 2018 · Built 1975 · Slegers Lenore J N5538BGrumman American Avn. AA-1B · S/N AA1B-0339Cancelled Mar 6, 2018 · Registration expired, pending cancellation · Built 1974 · Brockus C George N9132SBeech 58 · S/N TH-724Cancelled Feb 5, 2018 · Built 1976 · Slegers John E N7528QBuckeye Industries DREAM MACHINE · S/N 4153 COLOR REDCancelled Jan 26, 2018 · Registration expired, pending cancellation · Built 1998 · Shivalec David W N33477Piper PA-28-140 · S/N 28-7525196Cancelled Jan 18, 2018 · Registration expired, pending cancellation · Built 1975 · Hendrickson Dale L N2595PPiper PA-18A 150 · S/N 18-4341Cancelled Nov 22, 2017 · Revoked, canceled · Built 1955 · Rusk Crop Spraying Co N43198Taylorcraft BF · S/N 6857Cancelled Nov 22, 2017 · Revoked, canceled · Built 1946 · Valparaiso Aero Club Inc N47327Taylorcraft DC-65 · S/N 5171Cancelled Nov 18, 2017 · Revoked, canceled · Built 1943 · Wagner Charles N947CEBritish Aerospace HS 125-700A · S/N NA0291Cancelled Jul 31, 2017 · Built 1981 · Sage-Popovich Inc N421KBCessna 421B · S/N 421B0432Cancelled Jul 7, 2017 · Registration expired, pending cancellation · Built 2000 · Great Lakes Aviation Inc N12LKBeech 58 · S/N TH-84Cancelled Jun 14, 2017 · Registration expired, pending cancellation · Built 1970 · N12lk N9522ZBeech C-45H · S/N 52-10608Cancelled Feb 13, 2017 · Revoked, canceled · Built 1960 · Graubart Avn Inc N7309UCessna 207A · S/N 20700394Cancelled Feb 4, 2017 · Revoked, canceled · Built 1977 · Sawyer Air Service Inc N737JDCessna 172N · S/N 17269445Cancelled Feb 4, 2017 · Revoked, canceled · Built 1977 · Sawyer Air Service Inc N8178CPiper PA-18A-135 · S/N 18-3634Cancelled Feb 4, 2017 · Revoked, canceled · Rusk Crop Spraying Co N9006BAeronca 7EC · S/N 7EC631Cancelled Feb 4, 2017 · Revoked, canceled · Built 1957 · Valparaiso Aero Svc Inc N6271QCessna 310Q · S/N 310Q0480Cancelled Nov 12, 2014 · Registration expired, pending cancellation · Built 1972 · Livemercial Inc N2581LPiper PA-38-112 · S/N 38-79A0771Cancelled Sep 22, 2014 · Registration expired, pending cancellation · Built 1979 · Northwest Aviation Inc N601NPCanadair CL-600-2A12 · S/N 3026Cancelled Aug 15, 2014 · Built 1984 · Sage-Popovich Flight Operations LLC N250ADFairchild Hiller FH-1100 · S/N 162Cancelled Oct 29, 2013 · Registration expired, pending cancellation · Built 1969 · Floating Czech Inc N7880ASefcik Timothy W PIENTENPOL AIRCAMPER · S/N TI214ZCancelled Sep 30, 2013 · Registration expired, pending cancellation · Sefcik Timothy W N2829SCessna 150G · S/N 15066729Cancelled Jul 15, 2013 · Exported to Canada · Built 1967 · Wings Aviation Inc N9686RBeech B95 · S/N TD-346Cancelled May 23, 2013 · Registration expired, pending cancellation · Built 1960 · Blaney Kenneth N276RWDolph Raymond A JR RAGWING · S/N 1Cancelled Apr 15, 2013 · Registration expired, pending cancellation · Dolph Raymond A Jr N738MMiller John E GLASAIR SH-2 · S/N 141Cancelled Apr 9, 2013 · Sale reported, canceled N456RCChilian Dirk KITFOX · S/N 1472Cancelled Mar 18, 2013 · Sale reported, canceled · Built 1997 N3113CRyan NAVION B · S/N NAV 4-2299BCancelled Nov 7, 2012 · Sale reported, canceled N4393NCessna 195A · S/N 7012Cancelled Oct 3, 2012 · Revoked, canceled · Built 1947 · Valparaiso Aero Svc Inc N5234TPiper PA-28R-200 · S/N 28R-7235201Cancelled Aug 14, 2012 · Revoked, canceled · Built 1972 · Bellafiore Samuel E N312HDDavis Earl L HEATH MODEL V · S/N 2HD1931Cancelled Sep 22, 2011 · Triennial form not returned · Built 1982 · Markley Glenn L N1ULSocata TBM 700 · S/N 564Cancelled Aug 29, 2011 · Urschel Air Leasing LLC N251QEnstrom F-28A · S/N 285Cancelled Jul 27, 2011 · Expired dealer · Built 1975 · Sawyer Transport Inc N67564Cessna 152 · S/N 15281914Cancelled Jul 20, 2011 · Expired dealer · Built 1978 · Aviation Activities Inc N4876QCessna A185F · S/N 18503569Cancelled Jul 15, 2011 · Expired dealer · Built 1978 · Aviation Activities Inc N1885FPiper PA-28R-200 · S/N 28R-7535079Cancelled Jul 14, 2011 · Expired dealer · Built 1974 · Sawyer Transport Inc N9860BChampion 7FC · S/N 7FC-186Cancelled Mar 18, 2011 · Expired dealer · Built 1958 · Graubart Aviation Inc N4810PPiper PA-23-250 · S/N 27-376Cancelled Sep 28, 2009 · Exported to Ecuador · Built 1961 · Baron Aviation Inc

Back to Valparaiso, IN