Brownsville, TX
Registered aircraft · 48
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 = 'BROWNSVILLE' 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 = 'BROWNSVILLE' 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.
N100AWCessna 172 · S/N 28479N106RMCessna TR182 · S/N R18201932N108EACessna 172RG · S/N 172RG0674N1123UCessna T210N · S/N 21064667N115ESCirrus Design SR22T · S/N 1951N127KDCessna 172M · S/N 17267210N152DBPiper PA-32R-301T · S/N 3257135N165RAAmerican Champion 7GCBC · S/N 1367-2004N166RSBellanca 7ECA · S/N 876-72N171JSCessna 340 · S/N 340-0072N180BWCessna T182T · S/N T18208552N225EATextron 182T · S/N 18283273N228GSEmbraer-Empresa Brasileira De EMB-500 · S/N 50000112N2489UCessna 172D · S/N 17250089N2963MPiper PA-12 · S/N 12-1357N326TCBeech 60 · S/N P-121N32909Cessna 182N · S/N 18260423N3907YCessna 210D · S/N 21058407N4132DPiper PA-28-181 · S/N 2843234N4151Ercoupe 415-D · S/N 3003N4331DPiper PA-28-236 · S/N 28-8411004N4343KNavion NAVION A · S/N NAV-4-1343N441USBoeing 737-4B7 · S/N 24812N456PSMooney M20R · S/N 29-0335N45DNNewman Jimmie AEROSPORT II · S/N 1N47731Taylorcraft DCO-65 · S/N L-4628N5053DCessna 182A · S/N 51153N508MABeech B24R · S/N MC-318N5506ZBellanca 7GCAA · S/N 364-78N566GGPiper PA-46-701TP · S/N 46020077N6271TCessna 150E · S/N 15060971N65877Boeing E75N1 · S/N 75-8274N7014ACessna 172 · S/N 29114N707CDCessna 210C · S/N 21058207N728HHBritish Aerospace BAE 125 SERIES 800A · S/N 258166N72PPErcoupe 415-C · S/N 2051N7476JPiper PA-28R-180 · S/N 28R-30831N767MRBeech B-60 · S/N P-531N7729FCessna 150F · S/N 15063829N7827WPiper PA-28-180 · S/N 28-1842N78DTDiamond Aircraft Ind DA 62 · S/N 62.C075N900HACessna 525A · S/N 525A0039N904KCCostruzioni Aeronautiche Tecna P-MENTOR · S/N 1104/USN907JEBeech 400 · S/N RK-107N934CRCessna 414A · S/N 414A0856N936AFCessna 421C · S/N 421C0606N9429XCessna 182R · S/N 18268521N9564TCessna 210 · S/N 57364
Back to Brownsville, TX