Skip to content

Jones Peter M BOEING/JONES 75

Registered aircraft · 15

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 ('1380105')
  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 ('1380105')
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.

N3972UPlane Fun Inc Tr Trustee · Snellville, GAS/N AR-26 N3977ASiegfried Thelma J Trustee · Downers Grove, ILBuilt 1983 · S/N AR-27 N3991EJohnson Kenneth E · Liberal, KSS/N AR-28 N3993BHughes Teresa A · Monroe, WIBuilt 1984 · S/N AR-30 N3993CSec Aviation Holdings LLC · Gainesville, GABuilt 1984 · S/N AR-31 N3993PFaller Matthew P · Port Orange, FLBuilt 1984 · S/N AR-33 N3993YSager Timothy P · Tullahoma, TNS/N AR-34 N3994AEuroaviation Inc Trustee · KematenBuilt 1985 · S/N AR-35 N4252Tired Iron Aviation LLC · Sheridan, WYS/N AR-39 N741BJCavanaugh Flight Museum · Denison, TXBuilt 1985 · S/N AR-36 N742BJLevine Stephen D · Cypress, TXS/N AR-40 N743BJGreat Tiger Airlines Co · Beach City, OHBuilt 1986 · S/N AR-41 N745BJRounds Chris · Waller, TXBuilt 1985 · S/N AR-38 N746BJSimply Living LLC · Fort Myers, FLFirst renewal noticeBuilt 1985 · S/N AR-37 N748BJWalk Michael · Englewood, FLS/N AR-42

Back to Jones Peter M BOEING/JONES 75