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.
N510LBLindstrand Balloons 77A · S/N 5033N9761MMooney M20C · S/N 670055N4093VCessna 170 · S/N 18425N53722Fairchild M-62A · S/N T411158N97034Stinson 108-1 · S/N 108-1034N607BPMcdonnell Douglas Helicopter 600N · S/N RN036N317HSchlemeyer-Jungmiester Replica 1 · S/N 10N3180FCessna 177 · S/N 17700423N3941PPiper PA-22-150 · S/N 22-3616N3963PPiper PA-22-150 · S/N 22-3643N489WBCessna 421B · S/N 421B0223N9752MMooney M20C · S/N 670046N555CXCotton Galen M HELICYCLE · S/N 03-021-E24N56RDSikorsky S-76B · S/N 760368N265RWBourne Steven M SONERAI II L · S/N 0175N7019MCessna 175 · S/N 55319N809RDButcher Russell A RV9A · S/N 90781N66JRRushing BUSHBY MUSTANG II · S/N MII-350N5076MBeech 76 · S/N ME-62N212DHLithuanian Factory Of LAK-12 · S/N 6200N931NABoeing KC-135A · S/N 63-7998N8461TPiper PA-28-161 · S/N 28-8216057N8567CPiper PA-28-151 · S/N 28-7615118N8697RHoney Bee HB · S/N 2N65395Pilatus B4-PC11 · S/N 219N7711VAero Commander 520 · S/N 520-19N50YAYakovlev YAK-50 · S/N 853009N6724FCameron Balloons US V-77 · S/N 5761N2555GCessna 182B · S/N 51855N29243Aeronca 65-CA · S/N C10160N15781Boeing 727-232 · S/N 20636N7581MSchild August W S-14 · S/N A 0895084SN1372WMooney M20C · S/N 2653N1977VKennedy H F AX7 · S/N HAB6N5489UBeech 95-C55 · S/N TE-422N919NANorthrop T-38A · S/N 66-8385N8122GKamas Frank T GENESIS · S/N FK0501N7567WPiper PA-28-180 · S/N 28-1508N3648Canadair CT-33 · S/N 133648N40485Lindstrand Balloons 90A · S/N 5065N8415SCessna 182H · S/N 18256515N5343PCessna 152 · S/N 15284922N95289Harmenning HIGH FLYER DELUXE · S/N 006011N57PZBlakey Richard GENESIS · S/N 6E99/003N729CSNichols James S EINDECKER E3 · S/N 100903N55ESCustard Michael L LANCAIR ES · S/N 002MCN94775Ercoupe 415-E · S/N 4886N4486GSpitfire II SPITFIRE II · S/N 0502582002N5122CBeech B35 · S/N D-2407N38JBBolding VAN'S RV-3 · S/N 97
Back to Houston, TX