Cancelled registrations · 24

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 = 'MO' AND d.registrant_city = 'PARKVILLE' 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 = 'MO' AND d.registrant_city = 'PARKVILLE'
  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 = 'MO' AND d.registrant_city = 'PARKVILLE'
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.

N247RSStarks Richard KOLB TWINSTAR MK II · S/N 247Cancelled May 8, 2021 · Registration expired, pending cancellation · Built 1991 · Starks Richard D N57578Boeing A75N1(PT17) · S/N 75-2506Cancelled Dec 10, 2018 · Registration expired, pending cancellation · Built 1941 · Reed Randall C N18753Porterfield CP-40 · S/N 521Cancelled Mar 20, 2018 · Registration expired, pending cancellation · Built 1943 · Steinbrink James E N32568Piper PA-28R-200 · S/N 28R-7535069Cancelled Jan 3, 2018 · Registration expired, pending cancellation · Built 1974 · Oosting David N7429JPiper PA-28-140 · S/N 28-20390Cancelled Feb 4, 2017 · Revoked, canceled · Built 1964 · Colston William H N123DHStarks Sharon M DH-2 · S/N 001Cancelled Dec 31, 2013 · Second renewal notice · Built 2009 · Starks Sharon M N2417YCessna 172D · S/N 17249717Cancelled Oct 16, 2012 · Registration expired, pending cancellation · Built 1962 · Thompson Robert L N526ABellanca 14-19 · S/N 2079Cancelled Aug 14, 2012 · Revoked, canceled · Built 1951 · Hetsel Gene A N21173Cessna 172S · S/N 172S9621Cancelled Jun 30, 2006 · Exported to Venezuela · US Aviation & Marine LLC N1914SStarks Richard TAUBE · S/N 001Cancelled Jun 19, 2006 · Triennial form not returned · Built 2003 · Starks Richard D N266WRyan NAVION A · S/N NAV-4-1402Cancelled May 25, 2006 · Exported to Canada · Built 1948 · Keel Homer G N98DDBeech 65-A90 · S/N LJ-195Cancelled Sep 26, 2003 · Exported to Venezuela · Jet Sales International LLC N63152Cessna 150M · S/N 15077140Cancelled Oct 28, 2002 · Second triennial mailing, no response · Built 1975 · Stafford Joseph E N64500Cessna 172M · S/N 17265265Cancelled Apr 21, 1993 · K And M Aviation Inc N2378WBeech A23-19 · S/N MB-15Cancelled Jul 7, 1977 · Scheuler Kenneth F And Scheuler Ruth L N6504SCessna 150H · S/N 15067304Cancelled Mar 24, 1972 · Exported to Canada · Cloud 9 Flying Club Inc N57923Taylorcraft BCS-65 · S/N L-5583Cancelled Jan 4, 1971 · Warren Peery N71244Luscombe 8A · S/N 2671Cancelled Dec 31, 1970 · Built 1946 · Peery Warren R N75784Luscombe 8A · S/N 4435Cancelled Oct 26, 1970 · Fred C Long N44188Taylorcraft BC12-D · S/N 9988Cancelled Jul 6, 1970 · John D O Connor N9101VMooney M20C · S/N 690012Cancelled Jun 24, 1970 · Cloud 9 Flying Club Inc N43675Taylorcraft BC12-D · S/N 7334Cancelled Nov 1, 1965 · Built 1946 · Carter Lonnie W N76623Cessna 140 · S/N 11063Cancelled May 22, 1965 · Pew George Hubert N21380Aeronca 65-C · S/N C-1898Cancelled May 18, 1964 · Williams L J Et Al

Back to Parkville, MO