Skip to content

Registered aircraft · 35

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 ('9600422', '9600522')
  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 ('9600422', '9600522')
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.

N101YSnj Component Holdings LLC · Kalispell, MTBuilt 1930 · S/N 3272 N107YTj Air Holdings Inc Trustee · Wilmington, DEBuilt 1930 · S/N 3277 N110YRoberts David C · Scottsdale, AZBuilt 1930 · S/N 3298 N11202Johnson Daniel L · Westerville, OHBuilt 1930 · S/N 3389 N11210Senger Bruce D · Mount Solon, VABuilt 1930 · S/N 3393 N11221Gray Eagle Farms LLC · Southampton, NJBuilt 1938 · S/N 3415 N11223Hoover Michael B · Ridgeland, WIS/N 3416 N11229Roussopoulos Gary Lee · Santa Cruz, CAS/N 3456 N11237Dekle John B · Thomasville, GAS/N 3439 N11245Khalid Rauf J · Indianapolis, INBuilt 1931 · S/N 3405 N11254Daniel Sharon L · Southampton, NJBuilt 1931 · S/N 3457 N11256Bennett Robert M · Felton, DEBuilt 1931 · S/N 3460 N11259Leedom David A · Escondido, CABuilt 1931 · S/N 3462 N11264Cirone James R · Pampa, TXBuilt 1931 · S/N 3464 N113YSparrowhawk Aviation LLC · Moraine, OHS/N 3297 N11456Moloney Phillip M · Lexington, KYS/N 3471 N124YHaley Billie Jo · San Martin, CABuilt 1930 · S/N 3303 N127YDeno Gerald G · Battle Creek, MIBuilt 1930 · S/N 3287 N129YBowe Andrew J Jr · Poplar Grove, ILBuilt 1930 · S/N 3308 N130YRichards T D · Saint Jo, TXBuilt 1930 · S/N 3310 N139YFuller Randy M · Mooresville, NCS/N 3313 N140YDream Wacos LLC · Oklahoma City, OKS/N 3317 N143YWestern Antique Aeroplane & Automobile Museum · Hood River, ORBuilt 1931 · S/N 3417 N144YOld Style Aircraft LLC · Ellsinore, MOS/N 3319 N603YAyres Jayson L · Bettendorf, IABuilt 1930 · S/N 3316 N632YKhalid Rauf J · Indianapolis, INBuilt 1930 · S/N 3343 N663YSnyder Kenneth C · Lonsdale, MNBuilt 1930 · S/N 3356 N677NMorozowsky Anthony M · Zanesville, OHS/N 3222 N686YRare Aircraft Ltd · Faribault, MNS/N 3378 N850VKhalid Rauf J · Indianapolis, INS/N 3262 N854VWest Thomas L · Healdsburg, CAS/N 3269 N855VC2 Holdings 21 LLC · Chesapeake, VABuilt 1930 · S/N 3267 N859VSimply Living LLC · Fort Myers, FLBuilt 1930 · S/N 3271 N862VRegistered aircraftBuilt 1930 · S/N 3276 N863VSnyder Kenneth C · Lonsdale, MNBuilt 1930 · S/N 3278

Back to Waco RNF