Skip to content

Cancelled registrations · 120

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 = 'MI' AND d.registrant_city = 'LANSING' 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 = 'MI' AND d.registrant_city = 'LANSING'
  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 = 'MI' AND d.registrant_city = 'LANSING'
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.

N8991WPiper PA-28-235 · S/N 28-10571Cancelled Aug 12, 2022 · Third renewal notice · Built 1964 · Cleared For Takeoff LLC N6109UBuckeye DREAM MACHINE · S/N 4732Cancelled Jun 5, 2021 · Registration expired, pending cancellation · Built 1998 · Eakin Brian D N149SQAlan Johnston PIETENPOL AIR CAMPER · S/N RFC 101Cancelled Mar 6, 2021 · Registration expired, pending cancellation · Built 2012 · Miller Warren E N503PEElliott Patrick K ELLIOTT RIDGE RUNNER · S/N 001Cancelled Aug 7, 2020 · Sale reported, canceled · Built 2008 N24330Taylorcraft BF · S/N 1665Cancelled Nov 25, 2019 · Revoked, canceled · Built 1940 · Nation Wide Airlines Inc N1490NPiper J3C-65 · S/N 23017Cancelled Sep 6, 2019 · Revoked, canceled · Built 1947 · East Lansing Pilots Assoc Inc N699TCDJI PHANTOM 3 ADVANCED · S/N P76DCG15011003Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Auto-Owners Insurance Co N75318Buckeye DREAM MACHINE · S/N 4211 05/98Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Built 2007 · Rogers Douglas D N84664Aeronca 7AC · S/N 7AC3375Cancelled Apr 6, 2018 · Revoked, canceled · Built 1946 · Hebert Aviation Co N22543Cessna 150H · S/N 15068350Cancelled Feb 12, 2018 · Registration expired, pending cancellation · Built 1968 · Lansing Community College N79WMBaudhuin Michael P DRAGONFLY · S/N 035Cancelled Jan 25, 2018 · Registration expired, pending cancellation · Built 1984 · Forringer Edward R N7955DBeech H35 · S/N D-5213Cancelled Jan 24, 2018 · Registration expired, pending cancellation · Built 1957 · Ott Norman D N96396Taylorcraft BC12-D · S/N 8696Cancelled Nov 21, 2017 · Revoked, canceled · Built 1946 · Maynard Earl C N5269FCessna 172F · S/N 17253392Cancelled Jun 30, 2017 · Registration expired, pending cancellation · Built 1965 · Lansing Community College N34TUCessna 310 · S/N 35351Cancelled May 15, 2015 · Registration expired, pending cancellation · Built 1956 · Lansing Community College N58189Laister-Kauffman LK-10A · S/N 92Cancelled May 6, 2015 · Registration expired, pending cancellation · Built 1943 · Michigan Aviation Heritage N7406LBalloon Works FIREFLY 8B · S/N F8B-070Cancelled Apr 30, 2015 · Registration expired, pending cancellation · Built 1986 · General Motors N3131WBeech E18S-9700 · S/N BA-436Cancelled Dec 17, 2014 · Registration expired, pending cancellation · Built 1959 · Lansing Community College N48DSStiles Charles R BARRACUDA · S/N 216Cancelled Nov 26, 2014 · Registration expired, pending cancellation · Stiles Charles R N2951TAero Commander 100 · S/N 076Cancelled Sep 29, 2014 · Registration expired, pending cancellation · Built 1967 · Phillips Walter L N99038Piper L-21B · S/N 54-2623Cancelled Jul 21, 2014 · Lansing Community College N74239Balloon Works FIREFLY 8B · S/N F8B-025Cancelled Jun 12, 2013 · Registration expired, pending cancellation · General Motors N39323Ultra Sport Flying QUICKSILVER MX II · S/N 1287Cancelled Jun 11, 2013 · Registration expired, pending cancellation · Built 1983 · Ultralight Sport Flying Inc N218HWWarren Howard T-18 · S/N A-532Cancelled Jun 4, 2013 · Registration expired, pending cancellation · Built 1980 · Boldt Norman W N40DSShumard Douglas J STAR-LITE · S/N 162Cancelled May 31, 2013 · Sale reported, canceled · Built 1988 N9942LGrumman American Avn. AA-1B · S/N AA1B-0242Cancelled May 31, 2013 · Registration expired, pending cancellation · Built 1973 · Fink Rodney R N94686Ercoupe 415-CD · S/N 4797Cancelled May 23, 2013 · Registration expired, pending cancellation · Built 1947 · Cronk Kenneth N912NSNardi FN-333 · S/N 0105Cancelled May 22, 2013 · Registration expired, pending cancellation · Built 1965 · Aviation Associates Inc N341MDDixon Bartley M VOLKSPLANE VP-1 · S/N A606D1X-2006Cancelled May 15, 2013 · Registration expired, pending cancellation · Built 2008 · Dixon Bartley M N232DAAlleva Dennis M MONERAI-S · S/N 232Cancelled May 9, 2013 · Registration expired, pending cancellation · Built 1981 · Alleva Dennis M N7531GCessna 150L · S/N 15074689Cancelled May 8, 2013 · Registration expired, pending cancellation · Built 1973 · Swanson Daniel J N7624YPiper PA-30 · S/N 30-698Cancelled May 8, 2013 · Registration expired, pending cancellation · Built 1964 · Hulce Verne D N40186Lockheed T-33B · S/N 143040Cancelled May 3, 2013 · Registration expired, pending cancellation · Built 1976 · Lansing Community College N5198FCessna 172F · S/N 17253175Cancelled Apr 1, 2013 · Registration expired, pending cancellation · Built 1965 · Lansing Community College N81375Fairchild 24R-46 · S/N R46275Cancelled Feb 27, 2013 · Sale reported, canceled · Built 1946 N455ASAvions Mudry ET Cie CAP 10B · S/N 150Cancelled Dec 18, 2012 · Registration expired, pending cancellation · Aerial Adventures LLC N83JPPalmer James SONERAI II · S/N JP-1Cancelled Sep 24, 2012 · Registration expired, pending cancellation · Palmer James O N5243FCessna 172F · S/N 17253328Cancelled Jun 13, 2012 · Registration pending, canceled · Built 1965 N1EYEY PITTS S-1C · S/N 1EYCancelled Jun 25, 2009 · Registration revoked · Built 1973 · Upp Richard A N795RPiper PA-23-250 · S/N 27-7305000Cancelled Jun 18, 2008 · Built 1973 · Earthcom Inc N732FLPiper PA-28-140 · S/N 28-7225510Cancelled Dec 16, 2003 · Built 1972 · Boyd Robert A N95RKBeech A65 · S/N LC-283Cancelled Feb 14, 2003 · Exported to Colombia · Built 1968 · Aero Realty Corp II N962WMMartin Wayne G EXEC 162F · S/N 6291Cancelled Oct 25, 2000 · Martin Wayne G N411WCWaco Classic YMF-F5C · S/N F5C080Cancelled Mar 4, 1998 · Exported to Australia · Waco Classic Aircraft Corp N40113Classic WACO YMF · S/N F5C072Cancelled Dec 2, 1996 · Exported to Australia · Classic Aircraft Corp N425YStinson SM-8A · S/N M4260Cancelled Dec 18, 1995 · Triennial form not returned · Steen Betty B N7410MBalloon Works FIREFLY 8B · S/N F8B071Cancelled Apr 1, 1991 · Triennial form not returned · Oldsmobile Division N3253GBeech C-45H · S/N AF-261Cancelled Dec 23, 1986 · Francis Aviation N76752Cessna 140 · S/N 11184Cancelled May 22, 1985 · Francis Gerald C N12136Cessna 172M · S/N 17261833Cancelled Sep 14, 1983 · Administratively canceled · Olds Forge Flyers Inc

Back to Lansing, MI