Bedford, IN
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 = 'IN' 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 = 'IN' 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.
N114JAeropro CZ EUROFOX LSA · S/N 24507N1201JMooney M20J · S/N 24-0504N1389FCessna 172G · S/N 17254884N13TXBarger H A RV-4 · S/N 1625N2043QCessna 177RG · S/N 177RG0443N2086HKern Raymond L KER 2000 · S/N H2-96-7-295Registration expired, pending cancellationN2564NPiper PA-38-112 · S/N 38-79A0923N2883GChampion 7GCAA · S/N 109N293TPiper PA-18 105 · S/N 18-2407N303CJBeech 200 · S/N BB-596N3165ZPiper PA-22-150 · S/N 22-7116N405ACCampbell Arnold CHALLENGER 2 · S/N CH208951383N42684Piper J3C-65 · S/N 14979N441LMRobinson Helicopter R44 II · S/N 14736N4461WBeech 95-B55 (T42A) · S/N TC-1677N4692XCessna 150G · S/N 15064742N50520Pegasus QUANTUM 15-912 · S/N 7615N53DZZahtilla Dirk L EXCALIBUR · S/N 1095N5902ACessna 172 · S/N 28502N5971DPiper PA-18-150 · S/N 18-5430N59EEPiper PA-23-250 · S/N 27-3390N62471Stinson L-5 · S/N 76-392N7986PEavision EA-J150 · S/N JMZKJ150UAV602595245N9580RBeech M35 · S/N D-6178N9764SMooney M20K · S/N 25-0519N9822UGrumman American Avn. AA-5A · S/N AA5A0222
Back to Bedford, IN