Skip to content

Cancelled registrations · 29

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 = 'OK' AND d.registrant_city = 'MCALESTER' 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 = 'OK' AND d.registrant_city = 'MCALESTER'
  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 = 'OK' AND d.registrant_city = 'MCALESTER'
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.

N582USSkytrails Lsa PREDATOR · S/N P582E40008Cancelled Aug 2, 2020 · Registration expired, pending cancellation · Built 2009 · Outlaw Chutes LLC N25LCConner Leroy RV6A · S/N 21440Cancelled Feb 12, 2018 · Registration expired, pending cancellation · Built 1999 · Conner Leroy N35QJBeech H35 · S/N D-4986Cancelled Oct 27, 2017 · Registration expired, pending cancellation · Built 1957 · Flaps Ok LLC N22FDSiai-Marchetti SF260 · S/N 17-01Cancelled Dec 2, 2014 · Registration expired, pending cancellation · Built 1974 · Storrie R C N71TMMacmillan David T VENTURE · S/N V55TNCancelled May 23, 2013 · Registration expired, pending cancellation · Built 1994 · Macmillan David T N85958Aeronca 11AC · S/N 11AC-376Cancelled May 15, 2013 · Registration expired, pending cancellation · Built 1946 · Dees Leslie DBA N4823QCessna A188B · S/N 18802560TCancelled Dec 13, 2012 · Registration expired, pending cancellation · Built 1976 · Redman Clarence H N137AAutra ROTORCRAFT SCORPION · S/N 6382Cancelled Aug 10, 2012 · Registration expired, pending cancellation · Autra Robert T N4680QCessna 210L · S/N 21059580Cancelled Aug 1, 2012 · Revoked, canceled · Built 1972 · Mcida Leasing Inc N33183Piper J5A · S/N 5458Cancelled Dec 16, 2010 · Revoked, pending cancellation · Built 1940 · Helms J T N4974FCessna TU206B · S/N U206-0674Cancelled Jul 21, 2010 · Built 1966 · Advanced Aviation LLC N8428XCessna 172C · S/N 17248928Cancelled May 26, 1994 · Exported to Mexico · J Air Inc N8557KRobinson Helicopter R22 ALPHA · S/N 0461Cancelled Apr 18, 1991 · Triennial form not returned · Mills Brangus Ranch N50166Boeing A75N1 · S/N 751096Cancelled Jun 25, 1976 · Exported to Philippines · Griffith Harold L N55717Boeing A75N1 · S/N 754939Cancelled Jun 25, 1976 · Exported to Philippines · Henley James H N5409NBoeing B75N1 · S/N 75-7620Cancelled Jun 23, 1976 · Exported to Philippines · Henley J H N54831Cons Vultee/Basinger BT-13A · S/N 8486Cancelled Jan 4, 1971 · Henley J H N85811Aeronca 11AC · S/N 11AC230Cancelled Sep 25, 1970 · Revoked, pending cancellation · Built 1946 · Bohreer Roy Edwin N7180TCessna 172A · S/N 46780Cancelled Jun 25, 1970 · Webster Francis N80667Globe GC-1B · S/N 1072Cancelled Jun 24, 1970 · Davis & Horne Flying Service N6145XAero Commander 500-A · S/N 500A-921-24Cancelled Jun 9, 1970 · Meeco Marinas Inc N1787NCessna 120 · S/N 12031Cancelled Jun 22, 1966 · Stokes Harold H N9127DPiper PA-18-150 · S/N 18-6508Cancelled May 25, 1965 · Kenneth E Stokes N53725Fairchild PT-19A · S/N T42-3551Cancelled Oct 13, 1955 · Built 1942 · Galloway Charles R N50560Taylorcraft DCO-65 · S/N 4075Cancelled Oct 11, 1955 · Taylor Tommy L And P L Richardson N17427Aeronca C-3 · S/N A-735Cancelled Jun 29, 1950 · Horne J L Jr N77111Cessna 140 · S/N 11569Cancelled Apr 13, 1948 · Built 1946 · Whitlock Lowell L N10810Stinson SM-6000-B · S/N 5032Cancelled Oct 2, 1940 · Built 1931 · Eure Claud N5778American Eagle 101 · S/N 216Cancelled Jul 25, 1934 · Bernarde John

Back to Mcalester, OK