Skip to content

Cancelled registrations · 41

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 = 'UT' AND d.registrant_city = 'VERNAL' 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 = 'UT' AND d.registrant_city = 'VERNAL'
  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 = 'UT' AND d.registrant_city = 'VERNAL'
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.

N579LZLawrence M Zubel LOEHLE 5151 MUSTANG · S/N LMZ-001Cancelled Apr 28, 2025 · Built 2020 · Zubel Lawrence M N805RKDestiney PPC XLT · S/N 1C0279Cancelled Jan 14, 2023 · Registration pending, canceled N45QPPurkiser Raymon H FALCO F8L · S/N 039Cancelled Dec 3, 2022 · Registration expired, pending cancellation · Pitchford James J N7033LCessna 310K · S/N 310K0133Cancelled Aug 2, 2020 · Registration expired, pending cancellation · Built 1966 · Campbell Plumbing Inc N30321Cessna 162 · S/N 16200102Cancelled Mar 19, 2020 · First renewal notice · Built 2011 · H & H Versatile Services Inc N6447KCessna 150M · S/N 15077708Cancelled Mar 27, 2018 · Registration expired, pending cancellation · Built 1975 · Justice Jim N3559FCessna 182J · S/N 18257559Cancelled Mar 16, 2018 · Revoked, canceled · Built 1966 · Collier Daniel C N816BRDestiny DESTINY 2000 · S/N 1B0060Cancelled Jan 29, 2018 · Registration expired, pending cancellation · Reynolds Brett K N60906Cessna 150J · S/N 15070659Cancelled Jan 5, 2018 · Registration expired, pending cancellation · Built 1969 · Justice Jimmy W N3765UHarris J Warren HARRIS #4 · S/N HW 124Cancelled Jan 4, 2018 · Registration expired, pending cancellation · Built 1980 · Harris Elna R N8301QCessna TU206F · S/N U20603162Cancelled Nov 19, 2014 · Registration expired, pending cancellation · Built 1976 · Dinaland Aviation Inc N440KCGolden Circle TIERRA 1 · S/N 001Cancelled Sep 19, 2013 · Registration expired, pending cancellation · Crofts Kerry S N732JNCessna T210L · S/N 21061550Cancelled Aug 28, 2013 · Registration expired, pending cancellation · Dinaland Aviation Inc N58DKKarren David R PIETENPOL SCOUT · S/N L454339Cancelled Jul 8, 2013 · Registration expired, pending cancellation · Built 1987 · Karren David Robert N1176Infinity CLASSIC · S/N IPP4-215Cancelled May 30, 2013 · Registration expired, pending cancellation · Built 2004 · Cook Duane A N8164QCessna T310Q · S/N 310Q0632Cancelled May 13, 2013 · Registration expired, pending cancellation · Built 1972 · Dinaland Aviation Inc.N6417BCessna 172 · S/N 29617Cancelled Apr 29, 2013 · Registration expired, pending cancellation · Built 1956 · Mead Bill G N4607PCessna 152 · S/N 15284779Cancelled Jun 8, 2012 · Registration pending, canceled · Built 1980 N4259KMaule M-7-235C · S/N 25051CCancelled Mar 17, 2011 · Exported to Russia · Built 2000 · Blue Sky Enterprises Inc N35190Piper J5A · S/N 5577Cancelled Dec 22, 2010 · Revoked, pending cancellation · Built 1941 · Cruiser Club N165YWDestiny Powered Parachute XLT · S/N 1CO247Cancelled Aug 6, 2010 · Triennial form not returned · Built 2001 · Houghton T R N7151BDestiny XLT · S/N 3C0484Cancelled Jun 16, 2010 · Exported to Russia · Hoyt Nicholas L N1059VCessna TU206F · S/N U20602429Cancelled Jan 30, 2008 · Triennial form not returned · Built 1974 · Dinaland Aviation Inc.N738CWCessna 172N · S/N 17269881Cancelled Jan 30, 2008 · Triennial form not returned · Built 1977 · Gardiner John Arthur N500FUHughes Helicopters 369E · S/N 199ECancelled Jun 4, 2007 · Built 1986 · Pete Martin Drilling Inc N8427NPiper PA-28-161 · S/N 288116301Cancelled Oct 6, 1997 · Triennial form not returned · Owen Don R DBA N5018UCessna U206 · S/N 2060018Cancelled Apr 5, 1993 · Harris Elna R N2466XCessna 182H · S/N 18256366Cancelled Aug 19, 1992 · Triennial form not returned · Harris J Warren N6557Schempp-Hirth CIRRUS · S/N 77Cancelled May 10, 1982 · Exported to Canada · Weinhold Steve N53961Bellanca 8KCAB · S/N 23776Cancelled Feb 6, 1978 · Poag Arthur L N4735WRockwell International 114 · S/N 14065Cancelled May 25, 1977 · Dinaland Aviation Inc N3264SCessna 182G · S/N 18255764Cancelled Nov 4, 1975 · Collier Daniel C N1431VCessna 172M · S/N 17263573Cancelled Sep 16, 1975 · Built 1974 · Basin Flying Service Inc N66184Cessna 150M · S/N 15075902Cancelled May 14, 1975 · Basin Flying Service Inc N4028YCessna 185 · S/N 1850228Cancelled Nov 13, 1974 · Exported to Canada · Built 1961 · Basin Flying Service Inc N5849GCessna 150K · S/N 15071349Cancelled Aug 15, 1974 · Exported to Canada · Basin Flying Service Inc N5541RCessna 172 · S/N 17253125Cancelled Jul 23, 1974 · Exported to Canada · Basin Flying Service Inc N73776Consolidated Vultee BT-13A · S/N 11391Cancelled Oct 12, 1955 · Rodney D Ross N42256Piper J3C-65 · S/N 14506Cancelled Oct 10, 1955 · Basin Flying Service N53698Fairchild PT-19A · S/N T41-1096Cancelled Jan 22, 1952 · Built 1941 · Howtz Ross N13005Aeronca C-3 · S/N A-220Cancelled Nov 24, 1935 · Pope J R

Back to Vernal, UT