Bridgeport, TX
Registered aircraft · 38
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 = 'BRIDGEPORT' 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 = 'BRIDGEPORT' 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.
N1206ZBeech N35 · S/N D-6678N1299UCessna 172M · S/N 17266993N145JKCessna 180H · S/N 18051549N156DCPiper PA-24-250 · S/N 24-2751N181TXCessna TU206G · S/N U20606408N182CSCessna 182Q · S/N 18265579N209CSCessna T206H · S/N T20609002N217STPoland Mig17 LIM 6 · S/N 1J0514N222JGBeech 95 · S/N TD-215N2431UCessna 172D · S/N 17250031N25GAScottish BULLDOG MDL 120/121 · S/N BH120/275N2778TBeech 95-C55 · S/N TE-378N298TTPilatus PC-12/45 · S/N 298N300LCCessna 172M · S/N 17261520N317MGMikoyan Gurevich SB LIM-2 · S/N 1A09012N32198Piper PA-28-140 · S/N 28-7525035N321STMikoyan Gurevich MIG 21 · S/N 07695165N3323YCessna 182E · S/N 18254323N33MUBeech F33A · S/N CE-1742N421MWCessna 421 · S/N 421-0058N425TJCessna 425 · S/N 425-0114N43765Piper PA-32R-300 · S/N 32R-7780524N4583CCessna 170B · S/N 25527N46SEPiper PA 46-350P · S/N 4622131N551MSCessna 501 · S/N 501-0147N5752CCessna 170A · S/N 19706N57TGGallo Anthony F RV7A · S/N 70536N57XLDehavilland DHC-2 · S/N 1680N613XWWestland Helicopters WESTLAND SCOUT AH1 · S/N F9741N645KBoeing E75 · S/N 75-5080N6605ACessna 172 · S/N 28705N6803PPiper PA-24-250 · S/N 24-1936N76074Cessna 140 · S/N 10468N7800WMikoyan Gurevich MIG 15UTI · S/N 1A06011N8702YPiper PA-30 · S/N 30-1850N8705PPiper PA-24-260 · S/N 24-4152N8798CPiper PA-22 · S/N 22-1411N92347Piper J3C-65 · S/N 16801
Back to Bridgeport, TX