Registered aircraft · 20

Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.

Query with SQL

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 = 'LA' AND g.registrant_city = 'BREAUX BRIDGE' ORDER BY g.n_number

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 = 'LA' AND g.registrant_city = 'BREAUX BRIDGE'
  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 = 'LA' AND g.registrant_city = 'BREAUX BRIDGE'
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.

N11650Bellanca 7ECA · S/N 839-72Built 1972 · Dupuis Charles Jr N122LFLanni Charles T SKYRANGER II · S/N SKR0603698Soignier Kenneth E N1234KMooney M20E · S/N 995Built 1966 · Latiolais Travis N172EZCessna 172E · S/N 17250712Built 1964 · Castille Leonard E N17637Sharar Robert W SHARO L 10 · S/N 7168Built 1997 · Pridgen Blaine D N1836EDavid Brown/U Balldin/T Morgan ZENITH STOL CH701 · S/N 7-5983Built 2015 · Broussard Howard P Jr N194PJPilatus PC-24 · S/N 194Built 2020 · Guidry Aviation LLC N30693Head Balloons AX7-77 · S/N 275Built 1999 · Colegate Terry N323JRCessna S550 · S/N S550-0129Built 1987 · S550 LLC N51978Shaw STITS SA3B · S/N GBS1Built 1978 · Bonin Kenneth P N52995Graves Cecil M JR QUICKSILVER GT 500 · S/N 142Built 1992 · Vincent Kent R N52DD & D Special D-1 · S/N 62-1Built 1977 · Leblanc Brent C N589DCDJI AGRAS T50 · S/N 65AZKAW0020111Herbert Chaz M N5DXDuncan William B DUNCAN AIRCAMPER · S/N 1ALatiolais Travis N668LSSquillante Louis G SONEX · S/N 1208Bonin Kenneth P N67AJBell Textron Canada 407 · S/N 56318Victor Bravo LLC N7229YAero Designs PULSAR XP · S/N 438Built 1997 · Leblanc Brent C N8739Bellanca 7GCAA · S/N 256-73Built 1973 · Pridgen Blaine D N915MBBradford Max SUPER CUB REP P-18 · S/N 1Built 2004 · Barras David G N915WBCessna 172M · S/N 17261221Built 1972 · Bordelon Warren P

Back to Breaux Bridge, LA