Bolton, MS
Registered aircraft · 37
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 = 'BOLTON' 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 = 'BOLTON' 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.
N101MCSwearingen SA-226T · S/N T234N111SDCessna T-310P · S/N 310P0200N1463PPiper PA-23-150 · S/N 23-526N146JPiper PA-31-350 · S/N 31-7852005N196AGPiper PA-31-350 · S/N 31-7952036N27VGriswald James E QUESTAIR MODEL 20 · S/N 002N303ABCessna T303 · S/N T30300028N310JGCessna T310R · S/N 310R1567N314BBCessna T310R · S/N 310R1836N314HBCessna T310R · S/N 310R1586N31JVSwearingen SA227-TT · S/N TT-453N35367Cessna 172R · S/N 17281068N3589XPiper PA-31-350 · S/N 31-8052138N359CPiper PA-31-325 · S/N 31-7912109N364NYCessna T310R · S/N 310R-0718N4109APiper PA-23-250 · S/N 27-4459N45014Piper PA-31-350 · S/N 31-8052171N527BMCessna P206 · S/N P2060035N5337CCessna T310R · S/N 310R1543N5821MCessna 310P · S/N 310P0121N6114VBeech S35 · S/N D-7780N6184QCessna 320F · S/N 320F-0034N6GRPiper PA-31-350 · S/N 31-7752130N727MAPiper PA-31-350 · S/N 31-7652048N737SBeech 95-B55 (T42A) · S/N TC-1297N765KPPiper PA-31-350 · S/N 31-8253012N7697HPiper PA-12 · S/N 12-588N79429Cessna 172K · S/N 17258078N818BRPiper PA-31-350 · S/N 318152102N890HPiper PA-31-350 · S/N 31-8052194N900CGPiper PA-31-325 · S/N 31-7612002N92UJones Robert K QUESTAIR MODEL 21 · S/N 0001N931SAPiper PA-31-350 · S/N 317552036N9574BCessna 172RG · S/N 172RG0891N95764Cessna 182Q · S/N 18266622N973JMCessna 182Q · S/N 18266734N9900Swearingen SA-226T · S/N T-266
Back to Bolton, MS