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.
N23535Beech A36 · S/N E-1177N5079PPiper PA-24-180 · S/N 24-85N9627QCessna 172M · S/N 17265711N29297Cessna 172M · S/N 17264115N64512Cessna 172M · S/N 17265271N140MLPiper PA-28-140 · S/N 28-7525017N41753Rhett Edmund Middleton TOM CAN · S/N TC001N999FFVerdev PITTS S1-S · S/N PV-00684N712MQGulfstream Aerospace G1159B · S/N 104N7344VBellanca 17-30 · S/N 30221N121BSStrange Robert F JR RUTAN LONGE EZ · S/N 226N2111UBrantly B-2 · S/N 157N4397TPiper PA-28-140 · S/N 28-7225163N9872LGrumman American Avn. AA-1B · S/N AA1B-0472N32KKPiper PA-32R-300 · S/N 32R-7680117N7742RDJI PHANTOM 3 PROFESSION · S/N P76DCF12013300N39821Bellanca 17-30A · S/N 73-30494N5892LAmerican AA-5 · S/N AA5-0092N2547APiper PA-38-112 · S/N 38-78A0747N2014ACameron Balloons US V-77 · S/N 5359N2893Wickson Stuart BENSEN B-8M · S/N 4457034N828TCThunder & Colt Airborne Amer AX8-90 S 2 · S/N 2473USAN9497XCessna 210A · S/N 21057797N33626Briegleb BG-12BD · S/N IR230N3983ECameron Balloons US V-90 · S/N 5672N9983LCessna 182P · S/N 18264043N7277ECessna 182B · S/N 52277N696MHPiaggio Aero Industries P180 · S/N 1172N8184VCessna A188 · S/N 188-0434N6253ZSells Lloyd D AIR COMMAND 532 · S/N 532LSN39HTTurner H C SA 102.5 · S/N SNOOP-3N51878Cook AX-3 · S/N 001N995LBeech C18S · S/N 6029N950WSiai-Marchetti S.205/22R · S/N 4-150N1285KLuscombe 8A · S/N 4012N71559Luscombe 8A · S/N 2986N72964Cessna 120 · S/N 10162N736TNCessna R172K · S/N R1722777N74SFBeech E18S · S/N BA-258N7559HCessna A185F · S/N 18503395N76EZBrewer KR-1 · S/N 14538214N7769PPiper PA-24-250 · S/N 24-2985N777AEBeech 70 · S/N LB-34N777KMPiper PA-34-200T · S/N 34-7770221N8246GCessna A188B · S/N 18801264N88868Lockheed 149-46 · S/N 2067N421PKCessna 421B · S/N 421B0830N5262NThomas James W J-3 KITTEN · S/N 178N557CLRoe Cleo WITTMAN TAILWIND W10 · S/N 557N302CTFlight Design CTSW · S/N 07-06-06
Back to Houston, TX