None, OK
Cancelled registrations · 414
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 = 'NONE' 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 = 'NONE' 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.
N458PTCessna 208B · S/N 208B1073N246RFEurocopter AS 350 B2 · S/N 3171N85365Bell Helicopter HH-1N · S/N 158235N90835Bell UH-1N · S/N 135136N209SRStroh James W KOLB MARK 3 XTRA · S/N M3X16-2-000113N194AABoeing 757-223 · S/N 32388N6493PPiper PA-24-250 · S/N 24-1613N426MHCub Crafters CC19-180 · S/N CC19-0021N413GXAirbus A321-211 · S/N 01503N562BLBiuro Projektowe B Bogumil Ber SZD-56-2 DIANA-2 · S/N 562106002N406LACessna 525A · S/N 525A0231N52BMPiper PA-31T2 · S/N 31T-8166075N683TYRobinson Helicopter R44 II · S/N 14462N967AZAtr-Gie Avions De Trnsp Rgnl ATR 72-212A · S/N 0714N999THHoward Thomas J JR HOWARD CANARD · S/N 001N797VSCessna 650 · S/N 650-0151N960VNCompagnie Daher TBM 700 · S/N 1567N252AMEmbraer Executive EMB-500 · S/N 50000382N366LLAgustawestland Philadelphia AW119MKII · S/N 15013N280LJLearjet 60 · S/N 280N932ASCessna T337H · S/N 33701879N208AHCessna 208B · S/N 208B1253N31CGHawker Beechcraft B200GT · S/N BY-66N307FLBoeing 737-800 · S/N 30073N771JBHawker Beechcraft C90GT · S/N LJ-1848N517ERCessna 172S · S/N 172S8921N58DTPiper PA-31-350 · S/N 31-8152035N301NTInsitu INTEGRATOR · S/N 3-22-1301N641VAAirbus A320-214 · S/N 3656N775DAMooney M20E · S/N 486N60FWAce Aeronautics UH-60A · S/N 80-23439N978BECessna 680 · S/N 680-0070N414HWCessna 414A · S/N 414A0114N71TREurocopter AS 350 B3 · S/N 3388N137XSheridan Jerome LANCAIR IV-P · S/N LIV-165N8308FHughes 369HS · S/N 260796SN568SPScoda Aeronautica Ltda SUPER PETREL LS · S/N S0356N96507Cessna 172P · S/N 17276082N61MDEurocopter AS 365 N2 DAUPHIN · S/N 6462N3937QCessna 172L · S/N 17260037N250RRCameron Balloons US A-250 · S/N 6634N891DFCessna 208B · S/N 208B1148N103XXSlingsby T67C · S/N 2103N451TAMcdonnell Douglas A4N · S/N 159819N508TPTextron B300 · S/N FL-1071N483CMGulfstream Aerospace GIV-X (G450) · S/N 4116N816PCCirrus Design SR22T · S/N 0475N253CXCessna 750 · S/N 750-0253N5471ATextron 208B · S/N 208B5471N4855Leigh Aerosystems SKYEYE R4G-50 · S/N 002
Back to None, OK