Skip to content

Cancelled registrations · 154

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 = 'SOUTH BEND' 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 = 'SOUTH BEND'
  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 = 'SOUTH BEND'
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.

N395GXPilatus PC-12/47G · S/N 3095Cancelled Aug 21, 2026 · Exported to Mexico N56SLLittle James S HELICYCLE · S/N 1-31-31Cancelled Dec 18, 2025 · Built 2007 · Little James S N6384YPiper PA-23-250 · S/N 27-3669Cancelled Sep 16, 2024 · Built 1967 · Ground Imaging Inc N183FSCessna T310Q · S/N 310Q0707Cancelled Aug 14, 2024 · Built 1973 · Ground Imaging Inc N5455XCessna T310Q · S/N 310Q0072Cancelled Aug 14, 2024 · Built 1970 · Aerial Imaging Inc N7772QCessna 310Q · S/N 310Q0272Cancelled Aug 14, 2024 · Built 1971 · Ground Imaging Inc N6346LAgusta AB139 · S/N 31006Cancelled Mar 15, 2021 · Built 2005 · Sfg Commercial Aircraft Leasing Inc N111YPRockwell International 112 · S/N 259Cancelled Mar 6, 2021 · Registration expired, pending cancellation · Built 1975 · Leach Sarah E N9138BCessna 172 · S/N 36738Cancelled May 6, 2019 · Revoked, pending cancellation · Built 1958 · Stockert Flying Service Inc N332SECessna 500 · S/N 500-0332Cancelled Jan 31, 2019 · Registration expired, pending cancellation · Yatish Air LLC N302NDNicolaides IRISH FLYER IV · S/N 1Cancelled Dec 17, 2018 · Revoked, canceled · Nicolaides John D N8994VCessna 172M · S/N 17264349Cancelled Oct 29, 2018 · Built 1974 · Wings Inc N7422SButler AEROSTAR 600 · S/N 60-0051-115Cancelled May 17, 2018 · Sale reported, canceled · Built 1970 N9620TCessna 210 · S/N 57420Cancelled May 17, 2018 · Sale reported, canceled · Built 1960 N7714QCessna T310Q · S/N 310Q0214Cancelled May 15, 2018 · Registration expired, pending cancellation · Built 1971 · Aerial Imaging Inc N1815PPiper PA-22 · S/N 22-2594Cancelled Apr 2, 2018 · Revoked, canceled · Built 1955 · Finneran Robert P N1519Cooper David W CHALLENGER II · S/N C08292011Cancelled Feb 28, 2018 · Registration expired, pending cancellation · Built 2012 · Hubbard Benjamin T N22851Piper J3C-65 · S/N 2773Cancelled Oct 28, 2017 · Revoked, canceled · Built 1939 · Heighn Floyd E N929MACessna T206H · S/N T20608107Cancelled May 23, 2017 · Exported to Netherlands · Built 1999 · Afoc LLC N901TXDassault-Breguet MYSTERE FALCON 900 · S/N 170Cancelled Apr 20, 2016 · Exported to Mexico · Built 1998 N4370DTeam MINI-MAX 1600 · S/N 049APCancelled Oct 2, 2014 · Registration expired, pending cancellation · Built 2008 · Patus Nandor F N2022GCameron Balloons US V-77 · S/N 5367Cancelled Sep 13, 2013 · Registration expired, pending cancellation · Built 1987 · Decoker Inc N2094UAndre David J CHALLENGER II · S/N 1131Cancelled Aug 22, 2013 · Sale reported, canceled · Built 1995 N6117YPiper PA-23-250 · S/N 27-3326Cancelled Aug 19, 2013 · Sale reported · Built 1966 N4186ERaven S55A · S/N S55A-882Cancelled Jul 30, 2013 · Registration expired, pending cancellation · Built 1982 · Steele Larry O N2496HEngineering & Research 415-C · S/N 3121Cancelled Jul 18, 2013 · Registration expired, pending cancellation · Built 1946 · Hawthorn Edward W N33953Taylorcraft BC12-65 · S/N 2805Cancelled Jun 11, 2013 · Registration expired, pending cancellation · Built 1941 · Haselton William B N49JPPatus Nandor F WIND WAGON · S/N P-100Cancelled Apr 25, 2013 · Registration expired, pending cancellation · Built 1983 · Patus Nandor F N58AARaven S55A · S/N S55A-137Cancelled Apr 23, 2013 · Registration expired, pending cancellation · Built 1973 · Thompson Gerry P N9881JCessna A150M · S/N A1500690Cancelled Mar 21, 2013 · Sale reported, canceled · Built 1976 N9612TCessna 210 · S/N 57412Cancelled Mar 20, 2013 · Sale reported, canceled · Built 1960 N78CLBeech 95-C55 · S/N TE-163Cancelled Feb 26, 2013 · Sale reported, canceled · Built 1966 N7152CCessna 150F · S/N 15062036Cancelled Feb 20, 2013 · Registration pending · Built 1965 N154PAPiaggio Aero Industries P180 · S/N 1227Cancelled Nov 2, 2012 · Exported to Brazil · Built 2012 · Sfg Aircraft Inc N280RSEnstrom 280 · S/N 1005Cancelled Oct 18, 2012 · Registration expired, pending cancellation · Built 1975 · Weaver Wj N31JCBeech 95-C55 · S/N TE-283Cancelled Sep 6, 2012 · Sale reported, canceled · Built 1966 N52GBeech D18S · S/N A-236Cancelled Aug 14, 2012 · Revoked, canceled · Built 1946 · Murat Rene N499CBeech E18S · S/N BA-33Cancelled Aug 9, 2012 · Revoked, canceled · Built 1954 · Stockert Flying Service Inc N299WFAgusta A109E · S/N 11764Cancelled Jul 6, 2011 · Exported to Brazil · Built 2009 N721NCLancair LC-40-550FG · S/N 40057Cancelled Jun 25, 2010 · Exported to Canada · Built 2002 · Gurley Van K N37249Cessna 310R · S/N 310R0975Cancelled May 27, 2010 · Triennial form not returned · Built 1977 · Yatish Air LLC N3204PHawker Beechcraft 390 · S/N RB-224Cancelled Aug 15, 2008 · Exported to Brazil · Built 2007 N52NWGulfstream American G-1159 · S/N 052Cancelled Oct 28, 2005 · Sfg Equipment Leasing Corp I N780TJBoeing 737-217 · S/N 20197Cancelled Nov 18, 2004 · Exported to South Africa · Sfg Commercial Aircraft Leasing Inc N98DHHackbarth Dennis MONNETT MONI · S/N 24Cancelled Nov 8, 2004 · Second triennial mailing, no response · Built 1990 · Hackbarth Dennis K N51004Temple John E CHALLENGER II · S/N CH 0292 CW 0793Cancelled Jan 30, 2002 · Patus Nandor F N16702Embraer EMB-120ER · S/N 120.078Cancelled Jun 30, 1999 · Exported to Canada N10SEEnstrom F-28A · S/N 230Cancelled Mar 12, 1999 · Triennial form not returned · Weaver W J N1224REnstrom F-28A · S/N 228Cancelled Mar 12, 1999 · Triennial form not returned · Weaver William J N254QEnstrom F-28A · S/N 288Cancelled Mar 12, 1999 · Triennial form not returned · Weaver William J

Back to South Bend, IN