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.
N207CBRobinson Helicopter R44 II · S/N 11368N9KEEurocopter AS 350 B3 · S/N 3857N37737Douglas DC3C · S/N 44-76881N803BGHawker Beechcraft HS-125-800-A · S/N 258064N52353Cessna 182P · S/N 18262547N54AGBoeing 737-7JF · S/N 37592N240EBeech D18S · S/N A-84N17321Boeing 737-3TO · S/N 23372N223AWRobinson Helicopter R44 · S/N 1876N349JMRobinson Helicopter R44 · S/N 1881N726AMCessna 550 · S/N 550-0726N40120Harms Robert M KIT FOX SERIES 5 · S/N S9909-0215N1060CMooney M20A · S/N 1331N1592UCessna 207 · S/N 20700192N968WSmith Miniplane DSA-1-EW · S/N 6550N1785XCessna 210L · S/N 21060805N141RCCessna 172S · S/N 172S10320N1551ABeech B300 · S/N FL-24N652APBoeing 747-200 · S/N 23652N87SJPiper PA-31T · S/N 31T-7820077N7790QCessna 340 · S/N 340-0216N111TBCessna 310G · S/N 310G0007N41890Robinson Helicopter R44 II · S/N 12502N350RVHawker Beechcraft B300 · S/N FL-585N96SGHawker Siddeley DH.125-1A · S/N 25060N17345Boeing 737-3TO · S/N 23583N39343Boeing 737-3TO · S/N 23581N97GMDassault FALCON 2000EX · S/N 15N710WSCessna 402B · S/N 402B0558N14609Boeing 737-524 · S/N 27322N331APIsrael Aircraft Industries 1124 · S/N 205N163CSCirrus Design SR22 · S/N 3475N764KFGates Learjet 25D · S/N 234N14337Boeing 737-3TO · S/N 23575N14342Boeing 737-3TO · S/N 23580N161CSCirrus Design SR22 · S/N 3397N246XSchempp-Hirth STANDARD AUSTRIA SH1 · S/N 70N1732PPiper PA-22-150 · S/N 22-2522N18JGGalpin STARDUSTER TOO · S/N 1343N114FSCessna 411 · S/N 4110098N1435CPiper PA-22-135 · S/N 22-1235N1518TPiper PA-32-260 · S/N 32-7200044N666FHCessna 680 · S/N 680-0125N2112XCessna 560XLS · S/N 560-5830N3903GCessna 340A · S/N 340A0227N254JMCirrus Design SR22 · S/N 1918N25945Cessna 152 · S/N 15280873N12747Columbia Aircraft Mfg LC41-550FG · S/N 41639N179TSDiamond Aircraft Ind DA 42 · S/N 42.279N489DSDiamond Aircraft Ind DA 40 · S/N 40.489
Back to Houston, TX