Skip to content

Registered aircraft · 12

Aircraft of this model in the FAA registry, by N-number.

Query with SQL

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN ('0260102')
  ORDER BY 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 n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN ('0260102')
ORDER BY 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.

N108AGBristow LLC · Lake Charles, LABuilt 2005 · S/N 14053 N119RWRegistration Pending · Huntingdon Valley, PARegistration pendingBuilt 2006 · S/N 14508 N119WGHigh Performance Helicopters Corp · Crestline, CABuilt 2005 · S/N 14502 N316PDLonghorn Air LLC · Wilmington, DEBuilt 2003 · S/N 14038 N319PDAerotrust Services Corp Trustee · Wilmington, DEBuilt 2004 · S/N 14040 N58CMCrystal Motorsports LLC · Crystal River, FLS/N 14030 N671MHMansfield Heliflight Inc · Milton, VTS/N 14507 N709CGBristow LLC · Lake Charles, LAS/N 14052 N715RTBristow LLC · Lake Charles, LABuilt 2006 · S/N 14516 N72SLMhm Logistics LLC · Wilmington, DEBuilt 2005 · S/N 14501 N794DMRed River Aircraft Leasing LLC · Anchorage, AKBuilt 2006 · S/N 14512 N822MMBristow LLC · Lake Charles, LABuilt 2005 · S/N 14055

Back to Agusta A119