Bedford, MA
Registered aircraft · 26
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 = 'MA' AND g.registrant_city = 'BEDFORD' 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 = 'MA' AND g.registrant_city = 'BEDFORD' 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.
N141NEAirbus Helicopters Deutschland MBB-BK117 D-3 · S/N 20145N142NEAirbus Helicopters Deutschland MBB-BK117 D-3 · S/N 21163N143NEAirbus Helicopters Deutschland MBB-BK 117 D-2 · S/N 20218N144NEAirbus Helicopters Deutschland MBB-BK117 D-3 · S/N 20208N145NEAirbus Helicopters Deutschland MBB-BK117 D-3 · S/N 20098N205ZMPipistrel Lsa S R L ALPHA TRAINER · S/N 917 AT 912 LSAN216ARGulfstream Aerospace GVII-G500 · S/N 72186N246NEAirbus Helicopters Deutschland MBB-BK117 D-3 · S/N 21215N247NEAirbus Helicopters MBB-BK117 D-3 · S/N 21291N3680RBeech A36 · S/N E-1717N40006Piper PA-28-161 · S/N 28-7716314N424SEDemeyer Scott BUSHBY MUSTANG II · S/N 3825N548CDCirrus Design SR20 · S/N 1582N5813TCessna 185C · S/N 185-0713N631RJCirrus Design SR22 · S/N 3425N777ZVDiamond Aircraft Ind DA 40 · S/N 40.364N789THDJI MAVIC PRO · S/N 08QDE3H01203K1N801PRGulfstream Aerospace GVI (G650ER) · S/N 6570N824SSGulfstream Aerospace GVI (G650ER) · S/N 6598N858WRaytheon 58 · S/N TH-2060N898MBombardier BD-700-1A10 · S/N 60156N901GXBombardier BD-700-1A10 · S/N 9001N9045Bombardier BD-700-1A10 · S/N 60045N9046Bombardier BD-700-1A10 · S/N 60056N9047Bombardier BD-700-1A10 · S/N 60087N9048GBombardier BD-700-1A10 · S/N 60115
Back to Bedford, MA