Beaumont, TX
Registered aircraft · 112
Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.
Query with SQL
duckdb -csv -c "SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code WHERE g.registrant_state = 'TX' AND g.registrant_city = 'BEAUMONT' ORDER BY g.n_number"
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 g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code WHERE g.registrant_state = 'TX' AND g.registrant_city = 'BEAUMONT' ORDER BY g.n_number
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.
N10526Champion 7CCM · S/N 7CCM-42N1271MGulfstream Aerospace G-V · S/N 538N1317HPiper PA-28-181 · S/N 28-7790304N1343SCessna 182P · S/N 18264906N1356WParks Richard A STARDUSTER SA-100 · S/N RAP-02N140PSThunder Balloons AX9-140 SII · S/N 1470USN145PREurocopter EC 130 B4 · S/N 7349N158RWHawker Beechcraft G58 · S/N TH-2221N160SMRaytheon B300 · S/N FL-215N162CBCessna 525A · S/N 525A0353N16535Piper PA-28-140 · S/N 28-7325293N196SACessna 206H · S/N 20608197N2046CSchweizer 269C-1 · S/N 0127N20523Ayres S2R-G10 · S/N G10-147N221TSS C Aerostar S A YAK-52TW · S/N 0112229N251AGAnderson Greenwood 51 · S/N 0001N2540MLancair LC41-550FG · S/N 41031N2543WMaxair DRIFTER · S/N 9134N262KFDenney Aerocraft KITFOX 2 · S/N TFE262N2748LCessna 172H · S/N 17255948N279SDSidney G Drake RANS S-4 COYOTE · S/N 00290N300SFGulfstream Aerospace G-IV · S/N 1250N305CDCirrus Design SR22 · S/N 1966N315UCameron Balloons A-315 · S/N 6557N31WFAviat A-1A · S/N 1461N336SBPiper PA-28-180 · S/N 28-7305489N33715Piper PA-28-140 · S/N 28-7525231N339TBBombardier BD-100-1A10 · S/N 20743N33APDassault-Breguet FALCON 50 · S/N 81N3419XMooney M20E · S/N 1118N345FMLearjet 45 · S/N 151N34XDobson Richard J GLASAIR SH-2R · S/N 653N350FCRaytheon B300 · S/N FL-214N3569QPiper PA-28R-201T · S/N 28R-7703115N3661HMooney M20K · S/N 25-0440N369YMHylio AG 230 · S/N 17906100367N378CSTextron T206H · S/N T20609678N37KHCirrus Design SR22 · S/N 4760N390HYHylio HYL-150 · S/N 17906110390Registration pendingN407DBBell 407 · S/N 53419N4106YBoeing PT-17 · S/N 75-7018N4112WPiper PA-32-300 · S/N 32-40175N413WDWelsh David E VANS RV-7 · S/N 70738N414SCCessna 182Q · S/N 18266352N416PCCirrus Design SR22 · S/N 4329N425JRGulfstream Aerospace LP GULFSTREAM 200 · S/N 055N43237Piper PA-28-151 · S/N 28-7415452N444LPRaytheon B200 · S/N BB-1816N4457ECameron Balloons U S A-300 · S/N 6228N4606WRockwell International 112TC · S/N 13096
Back to Beaumont, TX