Skip to content

Earlier aircraft under this name · 35

Cancelled registrations that named this owner when they ended, newest first.

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_name = 'WINGS OF HOPE' OR list_contains(d.other_registrant_names, 'WINGS OF HOPE') 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_name = 'WINGS OF HOPE' OR list_contains(d.other_registrant_names, 'WINGS OF HOPE')
  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_name = 'WINGS OF HOPE' OR list_contains(d.other_registrant_names, 'WINGS OF HOPE')
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.

N1697QCessna 150L · S/N 15072997Cancelled Sep 12, 2022 · Exported to Argentina · Built 1971 · Chesterfield, MO N3073WPiper PA-32-300 · S/N 32-7940081Cancelled Oct 27, 2021 · Exported to Belize · Built 1979 · Chesterfield, MO N74BJRockwell International NA-265-65 · S/N 465-44Cancelled Mar 29, 2019 · Second renewal notice · Built 1980 · St Louis, MO N7950LBeech A23-19 · S/N MB-150Cancelled Dec 15, 2018 · Built 1966 · St Louis, MO N1262FBalloon Works FIREFLY 6 · S/N 614Cancelled Feb 28, 2018 · Registration expired, pending cancellation · Built 1974 · Chesterfield, MO N3412JCessna 150G · S/N 15066112Cancelled Nov 1, 2017 · Built 1967 · Saint Louis, MO N711VKnight Twister KTP · S/N 1234Cancelled Jul 20, 2017 · Registration expired, pending cancellation · Built 1952 · Chesterfield, MO N2355JBeech 23 · S/N M-313Cancelled Jun 2, 2017 · First renewal notice · Built 1963 · St Louis, MO N6621UMooney M20D · S/N 116Cancelled May 30, 2017 · Built 1963 · Saint Louis, MO N8060JOliver Joseph ZODIAC CH 601XL · S/N 64848Cancelled May 30, 2017 · First renewal notice · Built 2004 · Chesterfield, MO N308MCessna 206 · S/N 2060092Cancelled May 15, 2017 · First renewal notice · Built 1964 · Chesterfield, MO N52BFS.O.C.A.T.A. MS894A · S/N 12008Cancelled May 15, 2017 · First renewal notice · Built 1972 · Chesterfield, MO N72170Cessna 140 · S/N 9339Cancelled May 12, 2017 · Third renewal notice · Built 1946 · Chesterfield, MO N4987ZPiper PA-22-108 · S/N 22-8595Cancelled May 1, 2017 · Built 1961 · Saint Louis, MO N6000NAero Commander 560-E · S/N 531Cancelled Feb 16, 2017 · Registration expired, pending cancellation · Built 1957 · St Louis, MO N6555LDassault-Breguet FALCON 20 · S/N 085Cancelled Apr 30, 2015 · St Louis, MO N65SRRockwell International NA-265-65 · S/N 465-54Cancelled Mar 23, 2015 · Chesterfield, MO N843BHawker Siddeley DH.125-400A · S/N NA742Cancelled Mar 23, 2015 · Built 1970 · St Louis, MO N86CPNorth American NA-265-60 · S/N 306-76Cancelled Mar 23, 2015 · Built 1974 · St Louis, MO N8627NPiper PA-32-300 · S/N 32-7140020Cancelled Aug 13, 2014 · Built 1970 · Saint Louis, MO N23DVCessna 182Q · S/N 18266980Cancelled Aug 7, 2014 · Exported to Ecuador · Built 1979 · St Louis, MO N6606ECessna 175 · S/N 56106Cancelled Dec 22, 2011 · Exported to Paraguay · Built 1959 · Chesterfield, MO N3343UCessna 182F · S/N 18254743Cancelled Apr 26, 2011 · Exported to Ecuador · Built 1963 · Chesterfield, MO N818UColeman Chuck PITTS S1 · S/N 001ACancelled Jun 28, 2010 · St Louis, MO N7267HCessna 182S · S/N 18280591Cancelled Jan 25, 2010 · Exported to Zambia · Built 1999 · St Louis, MO N338WSPiper PA-23-160 · S/N 23-1341Cancelled Apr 2, 2009 · Built 1958 · St Louis, MO N24013Cessna 206H · S/N 20608087Cancelled May 23, 2007 · Exported to Zambia · Built 2000 · Chesterfield, MO N789PMCessna 414 · S/N 4140489Cancelled Jun 1, 2006 · Exported to Canada · Built 1974 · Chesterfield, MO N20768Digman Donald W ROTORWAY 162F · S/N 6294Cancelled May 4, 2006 · Built 2000 · Chesterfield, MO N696TKCessna U206F · S/N U20601965Cancelled Mar 28, 2006 · Exported to Ecuador · Built 1965 · Chesterfield, MO N3009YCessna 182E · S/N 18254009Cancelled Mar 31, 2004 · Exported to Ecuador · Built 1962 · Chesterfield, MO N70ESNorth American NA-265-40 · S/N 282-124Cancelled Dec 1, 2003 · Exported to Mexico · Built 1973 · Chesterfield, MO N5454CCessna 182E · S/N 18253822Cancelled Aug 6, 2002 · Exported to Ecuador · Built 1962 · Chesterfield, MO N942PSAsselyn Philip Peter CH-701 · S/N 7-1568Cancelled Apr 18, 2002 · Exported to Canada · Chesterfield, MO N8241ZCessna 210-5(205) · S/N 205-0241Cancelled Apr 22, 1969 · Exported to Peru · Built 1963 · St Louis, MO

Back to Wings Of Hope