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 = 'CO' AND d.registrant_city = 'STERLING' 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 = 'CO' AND d.registrant_city = 'STERLING'
  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 = 'CO' AND d.registrant_city = 'STERLING'
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.

N235LAAir Tractor AT-402B · S/N 402B-1315Cancelled Dec 31, 2020 · Exported to Costa Rica · Built 2014 · Mertens Darrel N45287Naval Aircraft Factory N3N-3 · S/N 2999Cancelled Jun 26, 2020 · Revoked, canceled · Built 1941 · Baird And Abe Air Ag Svc Inc N5347RCessna 172F · S/N 17252876Cancelled Dec 31, 2015 · Exported to Canada · Built 1965 · Mckinney Owen N76DGGamble Don BD-4 · S/N 1Cancelled Jun 5, 2013 · Sale reported, canceled · Built 1979 N60243Cessna U206F · S/N U20602015Cancelled Nov 29, 2012 · Revoked, pending cancellation · Built 1973 · Star Leasing Inc N3929PPiper PA-22-150 · S/N 22-3602Cancelled Nov 14, 2012 · Registration expired, pending cancellation · Built 1956 · Nix William C N6062RRose Wayne RV-6 · S/N 22699Cancelled Oct 19, 2010 · Exported to Canada · Built 2001 · Rose Wayne N602AAAir Tractor AT-602 · S/N 602-1135Cancelled Jul 1, 2008 · Built 2005 · Aero Applicators Inc N5975PPiper PA-24-250 · S/N 24-1068Cancelled Aug 21, 2007 · Triennial form not returned · Built 1959 · Wolfley Todd L N1295WWeatherly 201C · S/N 1003Cancelled Apr 10, 1996 · Triennial form not returned · Benson Aviation Inc DBA N2254LCessna 210L · S/N 21061062Cancelled Feb 28, 1990 · Exported to South Africa · Built 1975 · Neiman Dee E N6484ZPiper PA-25-235 · S/N 25-2003Cancelled Apr 16, 1985 · Benson Aviation Inc N1004KLuscombe 8A · S/N 3731Cancelled Jun 14, 1976 · Weseman Fred W N7520FChampion 7GCBC · S/N 203-70Cancelled Apr 10, 1972 · Burkholder Bernard G N2296HEngineering & Research 415-C · S/N 2921Cancelled Jun 15, 1971 · Meisman Lawrence B N8460KStinson 108-1 · S/N 108-1460Cancelled Sep 3, 1970 · Rose Wayne E & Rose Mildred J N6648TCessna 150A · S/N 15059048Cancelled May 26, 1965 · Western Aviation Inc N99136Erco 415-C · S/N 1759Cancelled May 20, 1965 · Bozarth Electric N98836Piper J3C-65 · S/N 19084Cancelled Jul 30, 1962 · Exported to Canada · Baird & Abe Air-Ag Service Inc N2872MPiper PA-12 · S/N 12-1303Cancelled Jul 21, 1959 · Exported to Canada · Built 1947 · Western Aviation Inc N44820Naval Aircraft Factory N3N-3 · S/N 2805Cancelled Aug 13, 1958 · Baird & Abe Air Ag Service Inc N44915Naval Aircraft Factory N3N-3 · S/N 2799Cancelled Nov 3, 1954 · Baird & Abe Air Ag Service Inc N73413Fairchild M-62A-3 · S/N T43-4537Cancelled Feb 1, 1952 · Western Aviation Inc N2859EAeronca 7AC · S/N 7AC-6442Cancelled Nov 2, 1951 · Western Aviation Inc N73748Consolidated Vultee BT-15 · S/N 11484Cancelled May 31, 1950 · Jack E Cottrill N35026Piper J5A · S/N 5-537Cancelled Jun 17, 1949 · Built 1941 · Western Aviation Inc N96990Taylorcraft BC12-D · S/N 9290Cancelled May 12, 1949 · Built 1946 · Radford Harry & Frank N73433Consolidated Vultee BT-15 · S/N 9203Cancelled Feb 24, 1949 · Hungerford James Carlos N18527Porterfield CP-40 · S/N 507Cancelled Aug 10, 1944 · Built 1937 · Norton Samuel N15853Fulkerson Norris Neal A · S/N A-1Cancelled Jul 1, 1939 · Built 1936 · Fulkerson Norris Neal

Back to Sterling, CO