Houston, TX
Cancelled registrations · 2,439
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 = 'TX' AND d.registrant_city = 'HOUSTON' 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 = 'TX' AND d.registrant_city = 'HOUSTON' 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.
N211SSShannon Stan RV-6 · S/N 21620N89YCDehavilland DHC-2 MK. I(L20A) · S/N 1264N432AQBritish Aerospace BAE 125 SERIES 800A · S/N NA0434N190DJJones 190-A3 · S/N 1401N1034UPiper PA-34-200 · S/N 34-7250015N751CWWood Coleman VANS RV-7 · S/N 71648N2665AClapp Daniel W GT 400 · S/N 082197HN759ADehavilland DHC-8-202 · S/N 435N724ADehavilland DHC-8-202 · S/N 440N725ADehavilland DHC-8-202 · S/N 441N76XEIglesias Hector Eduardo VANS RV7 · S/N 72622N254SNSpriggle Richard J SONEX · S/N 0419N282DHDehavilland DH82A · S/N A17-64N5337JCessna 404 · S/N 404-0659N739TECessna 172N · S/N 17270786N181RReed Farn VANS ACFT RV-6 · S/N 21880N8838FPiper PA-34-200T · S/N 34-7770095N4520SBeech 58 · S/N TH-660N727BTLearjet 31A · S/N 082N75671Boeing E75N1 · S/N 75-5303N708HBell Helicopter Textron Canada 412EP · S/N 36198N709HBell 412EP · S/N 36199N34435Aeronca 65-CA · S/N C14571N142DDouglas DC3A-S4C4G · S/N 1946N1015RRaven Industries RX6 · S/N RX6-174N339CAHawker Siddeley HS.125 SERIES 700A · S/N NA0213N20PJHawker Siddeley DH.125-400A · S/N NA734N102BPHawker Siddeley HS.125 SERIES 700A · S/N NA0226N817ALBoeing 737-2X6C · S/N 23292N56KSDouglas DC3C · S/N 25769N722ABritish Aerospace BAE 125 SERIES 800A · S/N 258200N487TCCessna 182T · S/N 18281486N211LSIndus T211 THORPEDO · S/N 001SN105GKRobinson Helicopter R44 II · S/N 10527N1458UCessna 172M · S/N 17267125N6383WHowes Rodney H RV-6 · S/N 22415N601JTSwearingen SA-226T · S/N T319N2256QCessna 411 · S/N 411-0134N800THHelio H800 · S/N H-17N19QQFokker F.27MK 600 · S/N 10349N19NNFokker F.27MK 600 · S/N 10385N644EMMitsubishi MU-2B-60 · S/N 1534 S.A.N906AHAgusta A109E · S/N 11644N397RACessna 340A · S/N 340A0009N38RSCessna 401A · S/N 401A0086N65482Cessna 172P · S/N 17275761N98483Cessna 172P · S/N 17276298N91454North American NAVION · S/N NAV-4-99N216LJBeech 65-A90 · S/N LJ-190N37078Mcdonnell-Douglas DC-10-30 · S/N 46926
Back to Houston, TX