Skip to content

Cancelled registrations · 138

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

N813TTThomason Ricky Dale AVID FLYER · S/N 960Cancelled Oct 3, 2026 · Sale reported, canceled N712CStinson 108-3 · S/N 108-3712Cancelled Aug 5, 2019 · Revoked, canceled · Built 1947 · Salminen Carl W Co Ow N5232BMooney M20 · S/N 1095Cancelled Sep 7, 2018 · Revoked, canceled · Built 1957 · G & G Auto Parts N2892NCessna 120 · S/N 13153Cancelled Aug 9, 2018 · Revoked, canceled · Aero Sales And Svc Inc N82869Piper PA-28-161 · S/N 28-8316006Cancelled May 3, 2018 · Registration expired, pending cancellation · Aerotrain Corp N5375PPiper PA-24 · S/N 24-425Cancelled Apr 5, 2018 · Revoked, canceled · Built 1958 · Harrell Ernie Co Ow N95700Taylorcraft BC12-D · S/N 8000Cancelled Jan 24, 2018 · Registration expired, pending cancellation · Built 1946 · Dove Harry J N4046TBalloon Works FIREFLY 7 · S/N 7900Cancelled Jan 18, 2018 · Registration expired, pending cancellation · Dove Balloon Flights Inc N96115Taylorcraft BC12-D · S/N 8415Cancelled Nov 21, 2017 · Revoked, canceled · Built 1946 · Rumfelt Bobby D N38BJRobinson Helicopter R22 BETA · S/N 3909Cancelled Oct 6, 2017 · Exported to Australia · Built 2005 · Andrews Ltd LLC N54EDRobinson Helicopter R22 BETA · S/N 3436Cancelled Oct 6, 2017 · Exported to Australia · Built 2003 · Andrews Limited LLC N9800HBeech C-45H · S/N 432Cancelled Feb 13, 2017 · Revoked, canceled · Built 1959 · American Aviation Corporation N2888AAerostar International RAVEN S-55A · S/N S55A-3003Cancelled May 19, 2015 · Registration expired, pending cancellation · Built 1986 · Tom Ryan Distributing Co Inc N704YDCessna 150M · S/N 15078971Cancelled Nov 13, 2014 · Registration expired, pending cancellation · Built 1976 · Bigelow Robert Edwin N7182JFlood Michael A AVID FLYER · S/N 622Cancelled Oct 28, 2013 · Registration expired, pending cancellation · Flood Michael A N4264YRaven S-60A · S/N S60A-322Cancelled Sep 16, 2013 · Registration expired, pending cancellation · Built 1984 · Tom Ryan Distributing Inc N5382ZPiper PA-22-108 · S/N 22-9148Cancelled Sep 16, 2013 · Registration expired, pending cancellation · Built 1961 · Sullivan Fred R N90074Cessna 210L · S/N 21060237Cancelled Sep 13, 2013 · Registration expired, pending cancellation · Johnson Boyt W N1033NFlesher Floyd O SPEZIO SPORT DAL-1 · S/N 360Cancelled Aug 15, 2013 · Sale reported, canceled · Built 1979 N66TTRaven S55A · S/N S55A-169Cancelled Aug 14, 2013 · Revoked, canceled · Built 1974 · Air Flambuoyant Division Of N6379TDean Herbert Franklin JR DELT-AIR 250 · S/N 001Cancelled Aug 6, 2013 · Revoked, canceled · Built 1961 · Dean Herbert Franklin Jr N276VMBeech 65-90 · S/N LJ-81Cancelled Jul 29, 2013 · Sale reported, canceled · Built 1965 N8963FHughes 269C · S/N 430200Cancelled May 17, 2013 · Registration expired, pending cancellation · Built 1973 · Helicopters Ltd N8826WPiper PA-28-235 · S/N 28-10373Cancelled May 15, 2013 · Registration expired, pending cancellation · Built 1964 · Childress Mark T N8535QCessna U206F · S/N U20603391Cancelled May 14, 2013 · Registration expired, pending cancellation · Built 1976 · C A Adkins Construction Co Inc N8152BCessna 172 · S/N 29952Cancelled May 13, 2013 · Registration expired, pending cancellation · Built 1957 · Mcnamara Thomas L N739PPCessna 172N · S/N 17270699Cancelled May 7, 2013 · Registration expired, pending cancellation · Built 1978 · Mccomb Kenneth J N6668KRepublic RC-3 · S/N 945Cancelled Apr 30, 2013 · Registration expired, pending cancellation · Knight Donald H N4393DRaven S55A · S/N S55A-1048Cancelled Apr 18, 2013 · Registration expired, pending cancellation · Built 1984 · Balloon Corp Of America N6320Woods MINI-HAWK I · S/N 6302Cancelled Apr 18, 2013 · Revoked, pending cancellation · Woods William E N5373VCessna 210L · S/N 21060922Cancelled Apr 9, 2013 · Registration expired, pending cancellation · Built 1975 · Sun & Country Leasing Inc N4384GMcculloch J-2 · S/N 094Cancelled Mar 11, 2013 · Registration expired, pending cancellation · Built 1972 · Shields Robert J N65098Bell TH-13T · S/N 3474Cancelled Feb 21, 2013 · Sale reported, canceled · Built 1965 N65097Bell TH-13T · S/N 3514Cancelled Feb 13, 2013 · Sale reported, canceled · Built 1966 N91473Cessna 180H · S/N 18052096Cancelled Sep 10, 2012 · Revoked, canceled · Built 1969 · Schock James C N4261NCessna 120 · S/N 13732Cancelled Jun 14, 2012 · Revoked, canceled · Built 1947 · Doyle Blake E N812AADassault/Sud FAN JET FALCON · S/N 57Cancelled Apr 24, 2009 · Sale reported · Built 1966 N617JCWsk-Swidnik MI-2 · S/N 6002Cancelled Apr 7, 2009 · Aerotrain Corp N8666HNorth American NAVION · S/N NAV-4-666Cancelled May 17, 2006 · Triennial form not returned · Built 1947 · Lager Ernest J N625EEPiper PA-28-140 · S/N 28-23294Cancelled Feb 13, 2003 · Triennial form not returned · Built 1967 · Hunt Charles N5889GCessna 150K · S/N 15071389Cancelled Aug 27, 2001 · Triennial form not returned · Daly Darle A N88CPBeech 200 · S/N BB-145Cancelled Nov 9, 2000 · Exported to Australia · Deveson Matthew N6454RPiper PA-28-140 · S/N 28-21639Cancelled Jun 23, 1999 · Father John 77 Flying Club Inc N8811ZCessna 172H · S/N 17255461Cancelled May 15, 1999 · Triennial form not returned · Snyder Martin D N7245DPiper PA-22-150 · S/N 225071Cancelled Jan 13, 1997 · Triennial form not returned · Father John 77 Flying Club Inc N118SWStrom Richard W AVID FLYER · S/N 18Cancelled Aug 3, 1994 · Triennial form not returned · Strom Richard W N20NEAerotek PITTS S-2B · S/N 5024Cancelled Aug 2, 1993 · Exported to Germany · Gregory James A N7581XCessna U206G · S/N U20605977Cancelled Sep 21, 1992 · Exported to Tanzania · Adkins Larry C N8396HPiper PA-28RT-201T · S/N 28R8131143Cancelled Aug 4, 1992 · Exported to France · Jennings Judy B N5277ACessna P210R · S/N P21000843Cancelled Dec 26, 1991 · Exported to Germany · Industrial Mechanical Contractors In

Back to Flint, MI