Skip to content

Cancelled registrations · 39

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

N601NDPaul Darrell Ownby ZODIAC 601XL · S/N 6-6444Cancelled Oct 21, 2022 · Registration expired, pending cancellation · Built 2013 · Ownby Paul Darrell N8692EGyro-Copter XV-100 · S/N 431-41284Cancelled Sep 6, 2019 · Revoked, canceled · Built 1962 · Williams Mfg Co C A N39210Taylorcraft BC12-D · S/N 6464Cancelled May 30, 2018 · Sale reported, canceled · Built 1945 N31984Grumman S2F-1 · S/N 136573Cancelled Apr 19, 2018 · Registration expired, pending cancellation · Built 1954 · Stricker Wes N2234LGallaphis Christopher S PANTHER 2 PLUS · S/N 25760Cancelled Feb 12, 2018 · Registration expired, pending cancellation · Built 1990 · Hoffman David N477CStinson 108-2 · S/N 108-3477Cancelled May 6, 2015 · Registration expired, pending cancellation · Built 1947 · Sands William D N14KUBellanca 17-30A · S/N 30393Cancelled Dec 22, 2014 · Registration expired, pending cancellation · Built 1971 · San Jack Aircraft Sales Inc N8270ZCessna 210-5 · S/N 205-0270Cancelled Nov 19, 2014 · Registration expired, pending cancellation · Built 1963 · San Jack Aircraft Sales Inc N60171Beech C23 · S/N M-2148Cancelled Oct 29, 2014 · Registration expired, pending cancellation · Built 1979 · San Jack Aircraft Sales Inc N8287FCessna 150F · S/N 15064387Cancelled May 14, 2013 · Registration expired, pending cancellation · Built 1966 · Jack Schulkins Svcs Inc N8124ZCessna 210-5(205) · S/N 205-0124Cancelled Feb 27, 2013 · Sale reported, canceled · Built 1962 N1190YCessna 150B · S/N 15059590Cancelled Feb 21, 2013 · Revoked, canceled · Built 1962 · Zenor Hughes M N6569VBellanca 17-30 · S/N 30253Cancelled Feb 13, 2013 · Sale reported, canceled · Built 1969 N35363Piper J3C-65 · S/N 6330Cancelled Oct 4, 2012 · Registration expired, pending cancellation · Built 1941 · Stricker William E N1383FCessna 172G · S/N 17254878Cancelled Jul 30, 2012 · Registration expired, pending cancellation · Built 1966 · Lee Robert Leroy N6552ECessna 175 · S/N 56052Cancelled Mar 18, 2011 · Expired dealer · Built 1959 · San Jack Aircraft Sales Inc N6736YPiper PA-23-250 · S/N 27-4070Cancelled Mar 18, 2011 · Expired dealer · Built 1968 · San Jack Aircraft Sales Inc N6041DPiper PA-22-150 · S/N 22-4694Cancelled Mar 10, 2011 · Expired dealer · Built 1956 · San Jack Aircraft Sales Inc N3106VBeech 35 · S/N D-527Cancelled Mar 3, 2011 · Expired dealer · Built 1947 · San Jack Aircraft Sales Inc N12293Bell OH-13E · S/N 51-13958Cancelled Jul 7, 2006 · Triennial form not returned · Pritchett Travis N5310ACessna T210N · S/N 21063362Cancelled Aug 29, 2002 · Triennial form not returned · Built 1979 · Scott Charters Inc N8354NCessna 335 · S/N 335-0063Cancelled Apr 18, 2001 · Carnahan Hickle & Calvert LLC DBA N28UBell 206L-3 · S/N 51458Cancelled May 20, 1994 · Exported to Panama · Ozark Management Inc DBA N62352Dehavilland DHC-2 MK 1 · S/N 1349Cancelled May 27, 1983 · Exported to Canada · Dickman Aviation Services Inc N4331VCessna 195 · S/N 7237Cancelled May 11, 1981 · Built 1951 · Morgan Ray E N11105Cessna 177B · S/N 17702326Cancelled Nov 18, 1977 · Dickman Daniel B DBA Dickman Aviation Service N4819LPiper PA-28-180 · S/N PA28-4159Cancelled Jul 7, 1977 · Day Delbert E N4201VCessna 170 · S/N 18557Cancelled Sep 2, 1971 · Neri Lewis N8878JPiper PA-28-180 · S/N 28-2851Cancelled May 14, 1971 · Dickman Aviation Service N36855Aeronca 65-TAF · S/N F1771TACancelled Dec 23, 1970 · Rolla C A P Flying Club Corp N3635APiper PA-22 · S/N 221893Cancelled May 20, 1965 · Shoemaker F Russ N64269Cessna T-50 · S/N 3463Cancelled Feb 17, 1956 · Campbell Flying Service N3133KCulver V · S/N V-352Cancelled Feb 13, 1951 · Steele Davis Tillou N3015EAeronca 7AC · S/N 7AC-6601Cancelled Jul 29, 1949 · Campbell James S N47204Taylorcraft DCO-65 · S/N L-5504Cancelled Nov 29, 1948 · Aaron William W N48357Taylorcraft DCO-65 · S/N 5349Cancelled Nov 9, 1948 · Built 1943 · Campbell James S N76928Cessna 120 · S/N 11370Cancelled Aug 30, 1948 · Campbell Flying Service N6081Travel Air Mfg 2000 · S/N 585Cancelled Aug 5, 1941 · Dickman M J/Dickman C W/Hough L P N9910Travel Air Mfg 2000 · S/N 1120Cancelled Jun 23, 1933 · Campbell Harry S

Back to Rolla, MO