Cancelled registrations · 132

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 = 'WA' AND d.registrant_city = 'KENT' 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 = 'WA' AND d.registrant_city = 'KENT'
  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 = 'WA' AND d.registrant_city = 'KENT'
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.

N8122YPiper PA-28RT-201T · S/N 28R-8031021Cancelled Mar 9, 1982 · Brower Michael C N8863RCessna 150H · S/N 15067388Cancelled Dec 17, 1981 · Gatter Charles H N2262FCessna 310L · S/N 310L0062Cancelled Jul 18, 1980 · Exported to Canada · Built 1966 · Terhune Robert C Et Al N1468FCessna A185F · S/N 02846Cancelled Jul 10, 1980 · Built 1975 · Fournier Charles T N185Cessna T337G · S/N P3370201Cancelled May 14, 1980 · Built 1975 · Terhune Robert C Jr N1327ECessna 172N · S/N 17270957Cancelled Feb 26, 1979 · Gerhards Bernard M N43TSHeiner KR-2 · S/N 1002Cancelled Oct 31, 1977 · Eklund Jack E Et Al N5188LPiper PA-28-180 · S/N 284477Cancelled Jul 7, 1977 · Gerhards Bernard M & Dorothy M N3094SCessna 150G · S/N 15066994Cancelled Jun 2, 1976 · Built 1967 · Matney D H And Matney E M N7814TCessna 172A · S/N 47414Cancelled Sep 26, 1975 · Exported to Canada · Larsen Herbert N3795GUniversal Copter A · S/N 1Cancelled Jun 2, 1975 · Built 1962 · Howard Charles R N6199DPiper PA-22-150 · S/N 22-4796Cancelled Nov 8, 1974 · Atkins Deanna Elaine N6104MStinson 108-3 · S/N 1084104Cancelled Nov 6, 1973 · Exported to Canada · Armstrong Ronald L N7241QCessna 172L · S/N 17260541Cancelled Oct 5, 1973 · Gerhards Bernard M N82239Aeronca 7AC · S/N 7AC-867Cancelled Apr 23, 1973 · Exported to Canada · Built 1946 · Howell Harley L N4222UCessna 150D · S/N 15060222Cancelled Apr 14, 1972 · Exported to Canada · Clarke James G N80655Globe GC-1B · S/N 1060Cancelled Jul 16, 1971 · Wendell S Plue N8034PPiper PA-24-180 · S/N 24-3281Cancelled Jun 22, 1971 · Skycrest Aviation Inc N71747Luscombe 8A · S/N 3174Cancelled Feb 5, 1971 · Alfred E Knechtel N5284NSikorsky R-6A · S/N 4345451Cancelled Jan 22, 1971 · Knechtel Alfred E N44400Taylorcraft BC12-D1 · S/N 10200Cancelled Mar 6, 1968 · Exported to Canada · Built 1946 · Holtz George W N2819FCessna 182J · S/N 18256919Cancelled Nov 9, 1967 · Bledsoe Cecil V N6903ECessna 175A · S/N 56403Cancelled Jul 25, 1966 · Samuel H Dupuis N46472Douglas A-24B · S/N 17651Cancelled Dec 15, 1965 · Jack Heflin DBA Flight Aero N3868KTemco GC-1B · S/N 3568Cancelled Jun 12, 1965 · Knechtel Alfred E N76749Cessna 140 · S/N 11181Cancelled Sep 25, 1959 · Corcoran Mildred W N4036NCessna 140 · S/N 13494Cancelled May 22, 1950 · Smith Aviation Co N49101Taylorcraft DCO-65 · S/N L-5222Cancelled Jan 4, 1949 · Smith Flying Service N9043Travel Air 2000 · S/N 844Cancelled Oct 3, 1947 · Built 1929 · Axley Terry M N28715Luscombe 8A · S/N 1476Cancelled Oct 10, 1946 · Smith Flying Service N503KDavis V-3 · S/N 111Cancelled Jan 18, 1937 · Built 1929 · Swanson Martin / Nesland Stanley N3867Advance WACO 9 · S/N 308Cancelled Apr 1, 1936 · Wright Frank & Smith R M

Back to Kent, WA