Skip to content

Cancelled registrations · 30

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 = 'TN' AND d.registrant_city = 'MARYVILLE' 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 = 'TN' AND d.registrant_city = 'MARYVILLE'
  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 = 'TN' AND d.registrant_city = 'MARYVILLE'
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.

N92449Piper J3C-65 · S/N 16917Cancelled Feb 4, 2023 · Registration expired, pending cancellation · Built 1946 · Lowery Glen N676LBLindstrand Balloons 90A · S/N 5066Cancelled Dec 8, 2020 · Registration expired, pending cancellation · Built 1998 · Davis Steven M N9676WPiper PA-28-140 · S/N 28-23142Cancelled Aug 2, 2020 · Registration expired, pending cancellation · Built 1967 · Childress Ronald D N46689Taylorcraft DC-65 · S/N 5093Cancelled Feb 28, 2020 · Revoked, canceled · Built 1943 · Cutshaw James E N101TNDJI INSPIRE 1 · S/N W13DCD25030296Cancelled Nov 29, 2019 · Registration expired, pending cancellation · Atmos Productions LLC N3517LCessna 150F · S/N 15062317Cancelled Feb 15, 2018 · Sale reported, canceled · Built 1965 N43046Kolb MK II · S/N M2-121Cancelled Jan 19, 2018 · Registration expired, pending cancellation · Built 1989 · Roth Jerry D N56796Piper PA-28-140 · S/N 28-7425037Cancelled Jan 10, 2018 · Registration expired, pending cancellation · Built 1973 · Hunt James W N7169YPiper PA-30 · S/N 30-190Cancelled Sep 26, 2017 · Registration expired, pending cancellation · Built 1963 · Mckevitz Peter M N8890GCessna 150F · S/N 15062990Cancelled Jul 19, 2017 · Registration expired, pending cancellation · Built 1966 · Harris Dan C N9823WBrian Delamater VANS RV-7 · S/N 73435Cancelled Apr 26, 2017 · Exported to United Kingdom · Delamater Brian N8693BCessna 172 · S/N 36393Cancelled Dec 22, 2014 · Registration expired, pending cancellation · Built 1957 · Cash Jimmy W N5001EWillocks Russell Clay HI MAX · S/N 0094Cancelled Jul 15, 2013 · Registration expired, pending cancellation · Willocks Russell Clay N1439BLuscombe 8A · S/N 6066Cancelled Jul 9, 2013 · Registration expired, pending cancellation · Built 1948 · Shope Z Conley Jr N8486TCessna 182C · S/N 52386Cancelled May 14, 2013 · Registration expired, pending cancellation · Built 1959 · Conner Willard R N6775Owens SCORPION TOO · S/N WH0-77Cancelled May 2, 2013 · Registration expired, pending cancellation · Ferguson Jerry E N6312KCessna 150M · S/N 15077639Cancelled Apr 29, 2013 · Registration expired, pending cancellation · Built 1975 · East Tennessee Pilots Club Inc N5482SCessna 337B · S/N 337-0582Cancelled Jan 30, 2013 · Sale reported, canceled · Built 1966 N51941Aeronca 7AC · S/N 7AC-690Cancelled May 28, 2010 · Triennial form not returned · Delozier Roger E N736SFCessna R172K · S/N R1722747Cancelled Aug 21, 2007 · Exported to Bolivia · Built 1977 · Stone David L II N122GWSharman SCHREDER RS15 · S/N 30Cancelled Dec 28, 2005 · Exported to Canada · Built 1974 · Wackerhagen Garry L N704QNCessna 150M · S/N 15078791Cancelled Sep 21, 1992 · Triennial form not returned · East Tennessee Pilots Club Inc N416EWWood 1 · S/N 1Cancelled Jun 11, 1992 · East Tennessee Pilots Club Inc N9348UCessna 150M · S/N 15078297Cancelled Mar 14, 1991 · Triennial form not returned · East Tennessee Pilots Club Inc N2317YCessna 177 · S/N 17700117Cancelled Jul 13, 1984 · Administratively canceled · Harder Ralph N N6111FCessna 210H · S/N 21059011Cancelled Jan 4, 1977 · Self Glenn F N98991Piper PA-12 · S/N 12-349Cancelled May 24, 1973 · East Tenn. Pilots Association Inc N9122BCessna 172 · S/N 36722Cancelled Jan 21, 1969 · Smith Ronald M N20807Piper J-3 · S/N 2107Cancelled May 18, 1948 · Bowler Thomas A & Ruth Evans Bowler N11471Waco QDC · S/N 3515Cancelled Apr 7, 1948 · Caylor Melvin M Et Al

Back to Maryville, TN