Okc, OK
Cancelled registrations · 209
Query with SQL
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 = 'OKC' 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 = 'OKC' 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.
N402AFCessna 402B · S/N 402B1337N147MPMooney M20L · S/N 26-0027N3523LCessna 182T · S/N 18280964N9960PPiper PA-36-285 · S/N 36-7560071N759VCCessna 182Q · S/N 18266285N345VHRobinson Helicopter R22 BETA · S/N 2314N684RACessna 150H · S/N 15068698N2196PPiper PA-23 · S/N 23-805N125DHHawker Siddeley BH.125-400A · S/N NA762N7133RSmith Jeffrey M ROBERTSON ACFT B1-RD · S/N 103N99VJSchempp-Hirth CIRRUS · S/N 5N86500Fokker D-7 · S/N 524N179SBBeech 65 · S/N LC-222N811RBeech C90A · S/N LJ-1131N794MSix Chuter SKR II · S/N 2428N6551FCessna 150F · S/N 15063151N4018GHoover Todd CHALLENGER II STD · S/N CH2-0102-2184N83BHPiper PA-23-250 · S/N 27-3384N186JBBrecher John L BD-4 · S/N 361N1251RBellanca 14-19-3 · S/N 4340N2409NBoeing 737-242C · S/N 20496N4684RPiper PA-28-140 · S/N 28-21445N969VJDouglas DC-9-31 · S/N 47421N81AEClark Randolph L AMAX EAGLE · S/N 81AEN80480Carey Dennis EXEC · S/N 3007N511WQWright Ross W Q2 · S/N 2610N532PKWurzel Parsons-Keir ELITE LW RG · S/N 3RE057N83796Aeronca 7AC · S/N 7AC-2473N59NDCessna 152 · S/N 15285984N96DDPiper PA-23-250 · S/N 27-2057N6255YPiper PA-23-250 · S/N 27-3493N310NTNorth American NA-265-40 · S/N 282-77N4444XCessna 172L · S/N 17259490N7083DAntonov AN-2 · S/N 1G17602N7083EAntonov AN-2 · S/N 1G17344N72846Cessna 140 · S/N 10033N91SDChalmers / Grove CG-1 SUNDANCER · S/N GR-12N94813Engineering & Research ERCOUPE 415-E · S/N 4926N311VCessna 310C · S/N 35933N6978YPiper PA-23-250 · S/N 27-4346N395DSSteeves Davis W KR-2 · S/N 1394N65264Boeing A75N1(PT17) · S/N 75-381N219ERRolando Emil RANS CO S-7 COURIER · S/N S786002N61103Cessna 150J · S/N 15070802N321HSShehane Harold L SHA-GLASAIR · S/N 359N4391CPiper PA-46-310P · S/N 46-8508053N265SHBell 206L-3 · S/N 51447N9377DPiper PA-28-161 · S/N 28-7916319N80954Globe GC-1B · S/N 1147N8113TCessna 175B · S/N 17556813
Back to Okc, OK