Skip to content

Cancelled registrations · 184

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 = 'FORT WAYNE' 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 = 'FORT WAYNE'
  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 = 'FORT WAYNE'
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.

N9943PPilatus PC-12/47E · S/N 1558Cancelled Jun 20, 2024 · Exported to Canada · Built 2015 · Pc12a LLC N3391HEngineering & Research 415-CD · S/N 4016Cancelled Mar 30, 2024 · Registration pending, canceled · Built 1946 N2902NCessna 120 · S/N 13163Cancelled Apr 12, 2023 · Built 1947 · Day Michael J N4046JRobinson Helicopter R44 II · S/N 14282Cancelled Mar 12, 2022 · Second renewal notice · Built 2019 · Bc Dental Inc N6065GMcnamara Gerald E KITFOX II · S/N 359Cancelled Mar 6, 2021 · Registration expired, pending cancellation · Built 2000 · Allen Louis L N76HMBellanca 17-30A · S/N 76-30824Cancelled Apr 3, 2020 · Registration expired, pending cancellation · Built 1976 · Rasawehr Craig N212DXDiamond Aircraft Ind DA20-C1 · S/N C0275Cancelled Mar 27, 2020 · Built 2004 · Sweet Aviation LLC N362CACirrus Design SR22T · S/N 0930Cancelled Feb 14, 2020 · Exported to Canada · Built 2014 · Fort Wayne Aircraft LLC N533JWBeech J35 · S/N D-5696Cancelled Feb 10, 2020 · Built 1958 · Long Jeffrey F N4908ESnoke Special 1 · S/N 1Cancelled Nov 19, 2019 · Revoked, pending cancellation · Built 1958 · Snoke Harry R N734LCDJI PHANTOM 2 VISION + · S/N PH645385324 V2.0Cancelled Nov 4, 2019 · Registration expired, pending cancellation · Tippmann Construction LLC N642JPDJI PHANTOM 3 PROFESSION · S/N P76DCF16017173Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Nicholas J Photography LLC N91800Schweizer SGU-1-19 · S/N 8Cancelled Sep 6, 2019 · Revoked, canceled · Built 1946 · Fort Wayne Soaring Council Inc N87152Engineering & Research ERCOUPE 415-C · S/N 325Cancelled Aug 5, 2019 · Revoked, canceled · Built 1946 · Bailey George H Inc N263DMPiper PA-34-220T · S/N 348133101Cancelled Jul 16, 2019 · Registration expired, pending cancellation · Built 1981 · Zollinger Wayne D N90416Bell 47G-3B-1 · S/N 3482Cancelled Feb 27, 2019 · Revoked, canceled · Built 1965 · Allen County Civil Defense N27542Taylorcraft BF · S/N 2184Cancelled Jan 14, 2019 · Revoked, canceled · Built 1940 · Hobbs Andrew J N18298Joe Winkler HOT AIR DIRIGIBLE · S/N 131407Cancelled Jul 19, 2018 · Revoked, canceled · Built 1940 · Kolkman William A N8703WPiper PA-28-235 · S/N 28-10235Cancelled Apr 18, 2018 · Registration expired, pending cancellation · Built 1964 · Pfister David N N79278Cessna T-50 · S/N 1201Cancelled Apr 6, 2018 · Revoked, canceled · Leeward Albert J N130ALEurocopter EC 130 B4 · S/N 4054Cancelled Jan 11, 2018 · Registration expired, pending cancellation · Built 2006 · N120ec LLC N8310GCessna 150F · S/N 15062410Cancelled Nov 21, 2017 · Revoked, canceled · Built 1965 · Ehrman C Ralph N88MNBeech A36 · S/N E-741Cancelled Oct 20, 2017 · Registration expired, pending cancellation · Built 1975 · Microjet LLC N6237XLankenau Larry LANK-EB · S/N 002Cancelled Aug 8, 2017 · Built 2011 · Lankenau Larry P N7640HPiper PA-12 · S/N 12-515Cancelled Feb 4, 2017 · Revoked, canceled · Barton Owen W N7874ACessna 180A · S/N 32771Cancelled Feb 4, 2017 · Revoked, canceled · Built 1957 · Gilsdorf Walter R N19VTSchleicher ASW-19 · S/N 19033Cancelled Jan 11, 2017 · First renewal notice · Woenker Timothy E N13WLLittle Walter B PAZMANY PL-1 · S/N WL-02Cancelled May 11, 2015 · Sale reported, canceled · Built 1987 N4XRGould L John RV-4 · S/N 4244Cancelled Mar 9, 2015 · Registration expired · Built 2010 · Gould L John N3432BBeech D35 · S/N D-3670Cancelled Jan 23, 2015 · Sale reported · Built 1953 N3537Cessna 182M · S/N 18259451Cancelled Oct 2, 2014 · Registration expired, pending cancellation · Built 1968 · Callahan Thomas D III N69DHCessna 340A · S/N 340A0361Cancelled Feb 3, 2014 · Exported to Canada · Built 1977 · Timberland Services Inc N201AMMooney M20J · S/N 24-0387Cancelled Aug 7, 2013 · Registration expired, pending cancellation · Built 1977 · Bh&B Inc N1637VCessna 140 · S/N 13809Cancelled Jul 18, 2013 · Registration expired, pending cancellation · Built 1947 · Long Gordon W N90763Balloon Works FIREFLY 8B · S/N F8B-311Cancelled Jun 27, 2013 · Sale reported, canceled · Built 1990 N6198VCarnes Robert N FALCON II · S/N RH-003Cancelled Jun 7, 2013 · Registration expired, pending cancellation · Built 1999 · Carnes Robert N N84547Piper PA-32-301 · S/N 32-8206002Cancelled Jun 7, 2013 · Registration expired, pending cancellation · Built 1981 · North Wind Avn Corporation N5676WRaven Industries RX6 · S/N RX6-333Cancelled Apr 22, 2013 · Registration expired, pending cancellation · Air Venture Of Ft Wayne Inc N4879LPiper PA-28-180 · S/N 28-4245Cancelled Apr 18, 2013 · Registration expired, pending cancellation · Built 1967 · 65r Club Inc N8184ZCessna 210-5(205) · S/N 205-0184Cancelled Mar 21, 2013 · First renewal notice · Built 1962 · Indiana Vocational Technical College N402AARaven S55A · S/N S55A-225Cancelled Nov 15, 2012 · Registration expired, pending cancellation · Built 1975 · Lagrand William L DBA N3794YCessna 210D · S/N 21058294Cancelled Nov 13, 2012 · Registration expired, pending cancellation · Built 1963 · Nagel Neal R N40843Piper J3F-65 · S/N 7547Cancelled Nov 7, 2012 · Sale reported, canceled · Built 1941 N6189URotor Hawk RH-1 FALCON · S/N RH-001Cancelled Sep 25, 2012 · Registration expired, pending cancellation · Built 1995 · Carnes Neal N5198WPiper PA-28 · S/N 28-233Cancelled Sep 20, 2012 · Revoked, canceled · Built 1961 · Croghan Fred H N79267Cessna T-50 · S/N 2204Cancelled Sep 18, 2012 · Revoked, canceled · Snoke H R N79280Cessna T-50 · S/N 1156Cancelled Sep 10, 2012 · Revoked, canceled · Leeward Albert J N914PLTerry Roy P PELICAN PL · S/N 672Cancelled Dec 13, 2011 · Exported to Canada · Terry Roy P N5985HPiper PA-16 · S/N 16-613Cancelled Sep 28, 2011 · Triennial form not returned · Built 1949 · Anderson Robert S N922SCessna 414 · S/N 4140922Cancelled Aug 19, 2011 · Exported to Mexico · Built 1977 · Executive Aircraft Leasing Inc

Back to Fort Wayne, IN