Skip to content

Registered aircraft · 21

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

N103ECAerial Surveys International LLC · Watkins, COBuilt 1967 · S/N 401-0135 N105KAGillespie Todd · Trenton, SCS/N 401-0238 N12QHawkes F Bryant · Lake Dallas, TXBuilt 1966 · S/N 401-0014 N2JJAerial Surveys International LLC · Watkins, COBuilt 1968 · S/N 401-0235 N3239Q92nd West Aviation Inc · Lonoke, ARBuilt 1967 · S/N 401-0039 N3264QWilton William H · Kailua Kona, HIBuilt 1967 · S/N 401-0064 N3268QSuperior Food Distributors LLC · Naples, FLBuilt 1967 · S/N 401-0068 N34MMSchubee Air Inc · Watkins, COBuilt 1967 · S/N 401-0125 N401ATBlum John J · Montgomery, TXBuilt 1966 · S/N 401-0010 N401BTKlena Bradley D · Maryville, TNS/N 401A0002 N401CFStuewe Charles D · Chino Hills, CABuilt 1967 · S/N 401-0115 N401KN401k LLC · Lonoke, ARBuilt 1967 · S/N 401-0038 N401MROk Av8r LLC · Iowa Park, TXBuilt 1967 · S/N 401-0159 N401RSTraining Services Inc DBA · Virginia Beach, VABuilt 1967 · S/N 401-0073 N401WWAttitude Aviators Inc · North Myrtle Beach, SCBuilt 1968 · S/N 401-0275 N4076QSandoval Juan · Valley Stream, NYBuilt 1968 · S/N 401-0176 N407RKMoore John C · San Miguel, CABuilt 1968 · S/N 401-0181 N550FSRegistration Pending · Sheboygan Falls, WIRegistration pendingBuilt 1968 · S/N 401-0289 N7864FKeller Russell L · Runaway Bay, TXBuilt 1968 · S/N 4010207 N807WSInter Island Freight LLC · Deerfield Beach, FLBuilt 1968 · S/N 4010300 N909AAKings Wings Inc · Jupiter, FLBuilt 1968 · S/N 401-0227

Back to Cessna 401