Beaumont, TX
Cancelled registrations · 151
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 = 'BEAUMONT' 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 = 'BEAUMONT' 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.
N150WMCessna 150M · S/N 15079087N4625RPiper PA-28-140 · S/N 28-21376N51JJohnson GYRO COPTER · S/N 1N8812RDowner BELLANCA 14-19-3 · S/N 4164N7107SHoffman Thomas R CHALLENGER I · S/N TRH0436N2592MBalloon Works FIREFLY 7-15 · S/N F7-794N9297ACessna 170A · S/N 19058N712EBeech A65 · S/N LC-241N761FLCessna 210M · S/N 21062221N770AJBeech C90A · S/N LJ1272N9273TBell OH-58C · S/N 71-20495N7038VMooney M20F · S/N 22-1385N156SDCessna 310J · S/N 310J0156N1027TAir Tractor AT-402 · S/N 4020741N28738Luscombe 8A · S/N 1499N7804TCessna 172A · S/N 47404N7734ZPiper PA-25-235 · S/N 253909N4134XAero Commander 100 · S/N 233N585DKr-1 DARST EUGENE · S/N 5444N153QBeech 95-B55 (T42A) · S/N TC761N2648GCessna 182B · S/N 51948N920RESatterwhite Ramon RALLY 3 · S/N 25258N2436FPiper PA-38-112 · S/N 38-79A0439N756WDCessna U206G · S/N U20604407N4326Grumman G-164A · S/N 1039N5388Grumman Acft ENG Cor-Schweizer G-164A · S/N 1146N2615CCessna 310 · S/N 35015N7192VMooney M20F · S/N 22-1190N3238PPiper PA-23-160 · S/N 23-1183N38252Piper J5A · S/N 18-7567N38252Piper J5A · S/N 5-924N84612Cessna 172K · S/N 17258547N8262UCessna 172F · S/N 17252162N4546NBoeing E75 · S/N 75-5195N59750Boeing E75 · S/N 75-4703N5223PPiper PA-24 · S/N 24-250N917HPPiper PA-28-140 · S/N 28-24440N6700GCessna 150L · S/N 15072200N593TSmith B-7M · S/N 1N70965Piper J3C-65 · S/N 17992N5362NBoeing E75 · S/N 75-5795N36342Taylorcraft DC-65 · S/N 4079N7502ZPiper PA-25-235 · S/N 25-3529N4984YPiper PA-25-235 · S/N 25-4790N5350NBoeing E75 · S/N 75-5070N1207BLuscombe 8A · S/N 5834N9296MMooney M20E · S/N 1229N28098Piper J3F-60 · S/N 4576N3072XCessna 150F · S/N 15064472N968QBeech 65 · S/N LC-120
Back to Beaumont, TX