Brownwood, TX
Registered aircraft · 39
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 = 'BROWNWOOD' 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 = 'BROWNWOOD' 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.
N11363Cessna 150L · S/N 15075354N11803Curtiss Wright JR CW1 · S/N 1181N133QBeech H35 · S/N D-5319N1354BLuscombe 8E · S/N 5981N1366BLuscombe 8F · S/N 5993N1450CCessna T210K · S/N T21059318N2017BLuscombe 8A · S/N 6444N20833Piper J-3 · S/N 2133N214RKKurrle Robert W RV-14 · S/N 140333N219JAeropro CZ S R O A240 · S/N 693 24N2677NSchweizer SGU 2-22E · S/N 243N281GMMayo Gary S KOLB SLING SHOT · S/N SS00400028N3088MPiper PA-12 · S/N 12-1777N330SExtra Flugzeugproduktions UND EXTRA 300/SR · S/N 1037EN3523JAeroprakt Manufacturing SP Zoo A22LS · S/N 369N379LDQuandt David H LONG-EZ · S/N 1379N3860ASchweizer SGS 1-26A · S/N 17N397MCurtiss Wright TRAVEL AIR E-4000 · S/N 1317N4468HPiper PA-15 · S/N 15-256N450RKSouthern Powered Parachutes CONDOR · S/N 6025359N45839Luscombe 8A · S/N 2366N4904UCessna 210E · S/N 21058604N5476ZPiper PA-22-108 · S/N 22-9261N5508JBellanca 7GCBC · S/N 1048-78N5901ZPiper PA-22-108 · S/N 22-9766N5975JCessna 414 · S/N 414-0028N611TTSutherland Mark V VANS RV-10 · S/N 40292N6370SBeech V35B · S/N D-9832N65978Cessna 150L · S/N 15075753N6687WPiper PA-28-140 · S/N 28-20794N679KSMarshall Keith K RANS S-21 · S/N 06180008N8020TCessna 175A · S/N 56720N82295Hundere AL KITFOX MODEL 2 · S/N 369N85AZLetitia D Baker SAFARI 400 · S/N CH1501N8793TCessna 182C · S/N 52693N9122VMooney M20E · S/N 690024N94707Engineering & Research 415-E · S/N 4818N96937Taylorcraft BC12-D · S/N 9237N973JHRaytheon B200 · S/N BB-1953
Back to Brownwood, TX