Skip to content

Registered aircraft · 20

Aircraft with this engine 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 engine_model_code IN ('67008')
  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 engine_model_code IN ('67008')
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.

N12337Bole David M · Auburn, WABuilt 1932 · S/N 3504 N12352Dawson Steven L · East Troy, WIBuilt 1932 · S/N 3508 N12380Burke Charles M · Ocala, FLBuilt 1933 · S/N 3520 N17MGlover William S · Mount Pleasant, TXBuilt 1929 · S/N 7 N221MBowe Walter C Trustee · Sonoma, CAS/N 390 N261KYellowstone Aviation Inc · Jackson, WYBuilt 1929 · S/N 327 N292ESimply Living LLC · Fort Myers, FLBuilt 1929 · S/N 130 N499HDonner Brad D · Hurst, TXBuilt 1930 · S/N 101 N511NWestern Antique Aerophane & Automobile Museum · Hood River, ORBuilt 1929 · S/N 705 N532NShannon Air Museum LLC · Fredericksburg, VABuilt 1929 · S/N 733 N534NCoughlin Brian T · Cazenovia, NYBuilt 1929 · S/N 737 N648HExperimental Aircraft Association Inc · Oshkosh, WIBuilt 1929 · S/N 1224 N71068Cournoyer John J · Ellsinore, MOBuilt 1936 · S/N 3548 N831N21 Flying Club Inc · Independence, ORBuilt 1929 · S/N 426 N835NApogee Investments LLC · Grandview, TXBuilt 1939 · S/N 430 N8471Rambo Gene · Falls Church, VABuilt 1929 · S/N 1069 N876WCBluebird Equipment LLC · Eureka, MOBuilt 1930 · S/N 5001 N965KThomas John L · Port Orange, FLBuilt 1929 · S/N 2981 N996HBowe Walter C Trustee · Sonoma, CABuilt 1929 · S/N 374 N999HMoore Charles E · Gibsonville, NCBuilt 1929 · S/N 377

Back to Wright 540