Brandon, MS
Registered aircraft · 116
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 = 'MS' AND g.registrant_city = 'BRANDON' 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 = 'MS' AND g.registrant_city = 'BRANDON' 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.
N901PSBeech F90 · S/N LA-5N902VDBeech A100 · S/N B-201N9053ACessna 170A · S/N 18812N9065BJohnson Richard S-12XL · S/N 01000905N9091JPiper PA-42-720R · S/N 42-5501035N911KABeech 300 · S/N FA-44N912DGGilliland Dee RANS S-7 COURIER · S/N 0202316N91414Piper PA-38-112 · S/N 38-82A0027N923TBeech 35-33 · S/N CD-128N946EPPowrachute AIRWOLF 912 ULS · S/N A403ULSN947AMBeech C90A · S/N LJ-1238N953SMCessna 172RG · S/N 172RG0772N9574RBeech M35 · S/N D-6166N97HCCessna T310R · S/N 310R0651N986CCCirrus Design SR20 · S/N 2711N990LRPiper PA-31T · S/N 31T7820060
Back to Brandon, MS