Cancelled registrations · 21

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

N118LGBell Helicopter Textron Canada 505 · S/N 65107Cancelled Dec 5, 2025 · Bell 505 LLC N58935Cessna 182P · S/N 18262406Cancelled Sep 3, 2022 · Registration expired, pending cancellation · Shurtliff Kent T N526CPCessna 525 · S/N 525-0099Cancelled May 15, 2020 · Built 1995 · Vancon Holdings LLC N5506KBuckeye DREAM MACHINE · S/N 5094Cancelled May 30, 2018 · Sale reported, canceled · Built 2000 N16558Piper PA-34-200 · S/N 34-7350159Cancelled Mar 9, 2018 · Registration expired, pending cancellation · Built 1973 · Jmrm Aircraft Leasing LLC N6249KCessna 172P · S/N 17274177Cancelled Feb 27, 2018 · Registration pending, canceled · Built 1980 N7190SCessna 150H · S/N 15067890Cancelled Jan 23, 2018 · Registration expired, pending cancellation · Built 1967 · Parkin Ernest W N4459RCessna 172M · S/N 17263201Cancelled Dec 10, 2015 · First renewal notice · Built 1974 · Imsar Aviation LLC N2593Cessna 172D · S/N 172-49893Cancelled Sep 30, 2014 · Registration pending, pending cancellation N28WFCessna 177 · S/N 17700876Cancelled May 21, 2014 · First renewal notice · Built 1968 · Ame High LLC N1033VHorning John HUMMER · S/N 14Cancelled Jul 16, 2013 · Registration expired, pending cancellation · Built 1981 · Horning M John N2054DBeech C35 · S/N D-3397Cancelled Apr 16, 2013 · Registration expired, pending cancellation · Built 1953 · Parkin Ernest W N7277VSadler William G SADLER VAMPIRE · S/N 001Cancelled Mar 26, 2013 · Sale reported, canceled N35JVVance James C RENEGADE SPIRIT · S/N 001Cancelled Feb 11, 2013 · Sale reported, canceled · Built 2000 N5042FFairchild Hiller FH-1100 · S/N 212Cancelled Feb 27, 2008 · Second triennial mailing, no response · Built 1969 · Palfreyman Clark D N6798BCessna T210M · S/N 21062833Cancelled Jun 4, 2003 · Triennial form not returned · Built 1978 · Water Buffalo Ventures LLC N8026QFulwider Rodger L HUMMER · S/N 12Cancelled Nov 13, 1991 · Triennial form not returned · Fulwider Rodger L N9418XCessna 210A · S/N 21057718Cancelled Jun 28, 1973 · Jensen Const & Drilling Co N90445Douglas C-54B · S/N 10405Cancelled Jul 27, 1971 · Built 1946 · W W Clyde & Co N4785VBoeing PT-13D · S/N 75-5784Cancelled Feb 13, 1951 · Wilson R L N2474VCessna 120 · S/N 14746Cancelled Dec 13, 1949 · Atkinson Carl E

Back to Springville, UT