Skip to content

Registered aircraft · 420

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

N9629SSchick Jason · Faulkton, SDS/N 59 N9631SFreedom Aviation Of America LLC · Newcastle, TXBuilt 1966 · S/N 39 N9635SPake Bradley P · Felton, MNBuilt 1966 · S/N 374 N9644SClausen Robert G · Argyle, MNS/N 391 N9647SGarrett Flying Service · Danbury, TXS/N 394 N9649SHowell Alice R · Bainbridge, GAS/N 396 N9653SNy Barnstormers LLC · Maine, NYBuilt 1966 · S/N 314 N9660SHughes Alan J · Edison, OHBuilt 1966 · S/N 245 N9665SDendy Dwight E · Caledonia, ILBuilt 1966 · S/N 251 N9670SDowns Steve M · Camden, TNBuilt 1966 · S/N 397 N9679SBistline John A · Cedar City, UTS/N 273 N9682SRoethlisberger John · Beaver Falls, PABuilt 1966 · S/N 469 N9685SSymond Clarence B · Eastover, NCBuilt 1966 · S/N 551 N9690SAck & Co LLC · East Helena, MTBuilt 1966 · S/N 418 N9693SSale Reported · Kenmare, NDSale reportedBuilt 1966 · S/N 426 N9699SBaumann Matt · Chewelah, WABuilt 1966 · S/N 430 N973BWBattle Flag Inc · Wilmington, DEBuilt 1997 · S/N 1361-97 N982GCollester Rodney D · Danville, INBuilt 1967 · S/N 7ECA-321 N9976YRogue Air LLC · Miller, SDBuilt 1964 · S/N 7ECA-1 N9994YSale Reported · Quincy, WASale reportedBuilt 1964 · S/N 8

Back to Champion 7ECA