Bellaire, TX
Registered aircraft · 22
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 = 'BELLAIRE' 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 = 'BELLAIRE' 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.
N103HMNeely Milton J LANCAIR LEGACY 2000 · S/N L2K-121N11LTGrumman American Avn. AA-5B · S/N AA5B0616N134BSBeech T-34A · S/N G-30N1686QCessna 150L · S/N 15072986N177TKCessna 177RG · S/N 177RG0781N225MMRockwell International 690B · S/N 11462N2528HSchweizer SGS 2-33A · S/N 428N312JGColumbia Aircraft Mfg LC41-550FG · S/N 41691N326CPCirrus Design SR22 · S/N 3133N381CBPiper PA-32R-301T · S/N 32R-8129068N41MPCirrus Design SR20 · S/N 10305N42034Piper J3C-65 · S/N 9087N454MFLearjet 45 · S/N 201N505DGGlaser-Dirks DG 500 ELAN · S/N 5E175X27N5805QMooney M20E · S/N 768N61SDBell 47G-3B-1 · S/N 3551N658AKCessna T182T · S/N T18209007N74MLCirrus Design SR22 · S/N 4982N779CCirrus Design SR22 · S/N 0444N79855AT Land JA35 · S/N JA537-12-18N8686QCessna U206F · S/N U20603468N9314CCessna 180 · S/N 31712
Back to Bellaire, TX