Skip to content

Cancelled registrations · 324

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 = 'OKLA CITY' 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 = 'OKLA CITY'
  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 = 'OKLA CITY'
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.

N9750EAeronca 11AC · S/N 11AC1383Cancelled Dec 13, 2018 · Revoked, canceled · Built 1946 · Carlson D D N9556ACessna 170A · S/N 19421Cancelled Jan 24, 2018 · Registration expired, pending cancellation · Built 1956 · Banning Bruce L N6275PPiper PA-24-250 · S/N 24-1384Cancelled Nov 21, 2017 · Revoked, canceled · Built 1959 · Edwards Ronald E N7145VLockheed 1329 · S/N 5001Cancelled Jul 20, 2017 · Registration expired, pending cancellation · United States Marshals Service N84689Cessna 172K · S/N 17258579Cancelled May 12, 2015 · Sale reported, canceled · Built 1969 N736XPCessna R172K · S/N R1722872Cancelled Dec 22, 2014 · Registration expired, pending cancellation · Built 1978 · Harris Max E N691ABMooney M20A · S/N 1376Cancelled Nov 13, 2014 · Registration expired, pending cancellation · Built 1959 · Wyatt Russell A N655FLPiper PA-28-140 · S/N 28-7125570Cancelled Nov 12, 2014 · Registration expired, pending cancellation · Built 1971 · Crosby Darrell D N3643RPiper AEROSTAR 600 · S/N 6008378161240Cancelled Oct 6, 2014 · Registration expired, pending cancellation · Built 1980 · Oklahoma Jet Inc N3527BBeech E35 · S/N D-3744Cancelled Oct 2, 2014 · Registration expired, pending cancellation · Built 1954 · Supreme Construction Leasing Co N3721XAero Commander 100-180 · S/N 5026Cancelled Oct 2, 2014 · Registration expired, pending cancellation · Built 1968 · Nutty Jean W N28CDCurtiss MR 1 · S/N 1Cancelled Aug 21, 2013 · Sale reported, canceled · Built 1964 N8246KStinson 108-1 · S/N 108-1246Cancelled Aug 21, 2013 · Sale reported, canceled · Built 1946 N6261BAero Commander 500 · S/N 688-34Cancelled Aug 20, 2013 · Sale reported, canceled · Built 1958 N6684JPiper PA-28-140 · S/N 28-24824Cancelled Aug 20, 2013 · Sale reported, canceled · Built 1968 N2559CPiper PA-38-112 · S/N 38-79A0230Cancelled Aug 19, 2013 · Sale reported, canceled · Built 1978 N26110Cessna 402C · S/N 402C0075Cancelled Aug 19, 2013 · Sale reported, canceled · Built 1979 N4140EAeronca 11CC · S/N 11CC-48Cancelled Aug 19, 2013 · Sale reported, canceled · Built 1947 N9171RBruno Keith E ASAP CHINOOK PLUS 2 · S/N 02173XCancelled Aug 16, 2013 · Sale reported, canceled · Built 2001 N35599Cessna 172I · S/N 17256857Cancelled Aug 13, 2013 · Sale reported, canceled · Built 1968 N8919QAero Commander S2R · S/N 1589RCancelled Aug 13, 2013 · Sale reported, canceled · Built 1971 N52BMByrdell Mathews BD-5 · S/N 2088Cancelled Aug 7, 2013 · Sale reported, canceled N627SAPiper PA-31-310 · S/N 31-7400982Cancelled Aug 7, 2013 · Sale reported, canceled · Built 1973 N6374CPiper PA-32-300 · S/N 32-7840082Cancelled Aug 6, 2013 · Revoked, canceled · Built 1978 · Sooner Aviation N827BJHandel P A/Handel R B SR GENISIS · S/N 0001Cancelled Aug 6, 2013 · Sale reported, canceled · Built 2001 N8239ACessna 170B · S/N 25091Cancelled Aug 5, 2013 · Sale reported, canceled · Built 1952 N9743CHiller UH-12E · S/N 2141Cancelled Jul 29, 2013 · Sale reported, canceled · Built 1961 N6214BSponsel Donald E KR2 MODEL 1 · S/N 53052Cancelled Jul 16, 2013 · Sale reported, canceled N5749HPiper PA-16 · S/N 16-360Cancelled Jul 15, 2013 · Sale reported, canceled · Built 1949 N90503Balloon Works FIREFLY 8B · S/N F8B-326Cancelled Jul 11, 2013 · Sale reported, canceled · Built 1990 N8114JGrosvenor Richard SOLITAIRE · S/N 17SCancelled Jul 10, 2013 · Sale reported, canceled N7451PPiper PA-24-250 · S/N 24-2640Cancelled Jul 1, 2013 · Registration expired, pending cancellation · Built 1961 · Oltermann Henry H N80015Beech D18S · S/N A-75Cancelled Jun 14, 2013 · Sale reported, canceled · Built 1946 N8793ZCessna P206D · S/N P206-0593Cancelled Jun 14, 2013 · Sale reported, canceled · Built 1969 N6924SCessna 150H · S/N 15067624Cancelled Jun 10, 2013 · Sale reported, canceled · Built 1967 N999HGGates Lear Jet 25B · S/N 178Cancelled Jun 10, 2013 · Sale reported, canceled · Built 1974 N5717BCessna 182 · S/N 33717Cancelled May 10, 2013 · Sale reported, canceled · Built 1956 N81161Funk B85C · S/N 291Cancelled May 10, 2013 · Sale reported, canceled · Built 1946 N7321Aero Commander 560-E · S/N 797Cancelled May 7, 2013 · Registration expired, pending cancellation · Built 1959 · Rock Doctor Mudloging Inc N771WMGrumman Acft ENG Cor-Schweizer G-164A · S/N 1038Cancelled May 1, 2013 · Sale reported, pending cancellation · Built 1973 N99788Cessna 210C · S/N 21058109Cancelled May 1, 2013 · Sale reported, pending cancellation · Built 1963 N1965GCessna 421B · S/N 421B0859Cancelled Apr 30, 2013 · Sale reported, pending cancellation · Built 1974 N3019WBeech C90 · S/N LJ-639Cancelled Apr 30, 2013 · Sale reported, pending cancellation · Built 1974 N65126Mills TURNER T40-A · S/N 71Cancelled Apr 30, 2013 · Registration expired, pending cancellation · Built 1975 · Mills Dana P N6522GCessna 150L · S/N 15072022Cancelled Apr 30, 2013 · Registration expired, pending cancellation · Built 1970 · Eggleston Dean E N6588QAlon A2 · S/N A-88Cancelled Apr 30, 2013 · Registration expired, pending cancellation · Built 1966 · Zinn Albert M N30JAAndrews John PT-2B PROSTAR · S/N PT-1106Cancelled Apr 29, 2013 · Sale reported, pending cancellation · Built 1993 N31CKLearjet 23 · S/N 079Cancelled Apr 29, 2013 · Sale reported, pending cancellation · Built 1965 N91KDFort Wayne Air Service TA4J · S/N 921001Cancelled Apr 29, 2013 · Sale reported, pending cancellation N93BPLearjet 24A · S/N 24-169Cancelled Apr 29, 2013 · Sale reported, pending cancellation · Built 1968

Back to Okla City, OK