Cancelled registrations · 17

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

N797TBCostruzioni Aeronautiche Tecna P2004 BRAVO · S/N 090Cancelled Sep 30, 2026 · Exported to El Salvador · Built 2007 · Kluesner Melanie N76927Cessna 140 · S/N 11369Cancelled Apr 2, 2022 · Registration expired, pending cancellation · Built 1946 · Wood Steven N63KRSchleicher ASW 28-18E · S/N 28721Cancelled Dec 16, 2019 · Sale reported, canceled · Built 2004 N419TPPewtress Richard BUSHCADDY R-120 · S/N CA-002-127Cancelled Sep 7, 2017 · Registration expired, pending cancellation · Built 2010 · Pewtress Richard D N2494GCessna 182B · S/N 51794Cancelled Mar 10, 2017 · Registration expired, pending cancellation · Built 1959 · Amidan Don R N9073GCessna 182N · S/N 18260613Cancelled Aug 22, 2013 · Sale reported, canceled · Built 1971 N8720EOlsen Edward D E D OLSEN CRUISER · S/N ES0001Cancelled Jul 3, 2013 · Registration expired, pending cancellation · Olsen Edward Deturrest N3314TCessna 177 · S/N 17700614Cancelled Jun 7, 2013 · Sale reported, canceled · Built 1967 N36422Taylorcraft BC12-65 · S/N 3238Cancelled Jan 28, 2013 · Exported to Australia · Built 1941 · Garfield Joe N5113WPiper PA-28-160 · S/N 28-138Cancelled Dec 11, 2012 · Sale reported, canceled · Built 1961 N123BUGunn Brian D BUCCANEER · S/N 01540Cancelled Sep 11, 2012 · Triennial form not returned · Built 2002 · Gunn Brian D N99DDRadford DYKE DELTA JD II · S/N DR-1Cancelled Sep 18, 2009 · Registration revoked · Built 1978 · Radford David L N5731SSchweizer SGS 2-33 · S/N 74Cancelled Aug 27, 2009 · Triennial form not returned · Built 1968 · J Bird Enterprises LLC N310GMLet BLANIK L-13 · S/N 025730Cancelled Sep 19, 2003 · Triennial form not returned · Built 1974 · Wilkinson Wayne DBA N93016Hill SAILWING · S/N 001Cancelled May 18, 1979 · Hill Klaus K N37908Sinfield HONEYBEE · S/N 1Cancelled Nov 24, 1978 · Built 1977 · Sinfield Roland H N29616Taylorcraft BC-65 · S/N 2458Cancelled May 19, 1965 · Phillips Donald C

Back to Morgan, UT