Skip to content

Registered aircraft · 100

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

N113PATundra Aviation Inc · Casselton, NDBuilt 1948 · S/N 14-113 N14398Dyke Milo D · Hazen, NDBuilt 1949 · S/N 14-516 N1477Rubbert Jan D · Upham, NDS/N 14-77 N1493HThomas Allen C · Willow, AKS/N 14-93 N372TBeautte James E · Fairland, OKBuilt 1948 · S/N 14-492 N3837PPlancich Don A · Sterling, AKS/N 14-154 N4200HFoss David K · Anchorage, AKBuilt 1948 · S/N 14-3 N4201HWattenbarger Jay K · Fairbanks, AKS/N 14-4 N4203HIvy Mark A · Anchorage, AKBuilt 1948 · S/N 14-6 N4204HAndrews Billy G · Wasilla, AKS/N 14-7 N4205HSwift Leonard M · Goldendale, WABuilt 1948 · S/N 14-8 N4206HLeonard James P · Eagle River, AKBuilt 1948 · S/N 14-9 N4207HGage Duane · Princeton, IDBuilt 1948 · S/N 14-10 N4208HDahmes Bradley M · Hawick, MNBuilt 1948 · S/N 14-12 N4209HKirby Ronald S · Delta Junction, AKBuilt 1948 · S/N 14-11 N4210HGage Ricky Duane · Lewiston, IDBuilt 1948 · S/N 14-13 N4213HWiese Ryan Mark · Eagle River, AKBuilt 1948 · S/N 14-16 N4214HGranger Andrew J · Denver, COS/N 14-101 N4215HDavis John N · Port Alsworth, AKBuilt 1948 · S/N 14-18 N4217HBowser Dwight H · Anchorage, AKBuilt 1948 · S/N 14-20 N4219HHardman Lorin D · Wasilla, AKBuilt 1948 · S/N 14-22 N4226HAngel Aviation Inc · Peoria, AZS/N 14-29 N4229HGranger Andrew J · Denver, COBuilt 1948 · S/N 14-32 N4233HDetwiler Jeffrey D · Lancaster, PAS/N 14-36 N4236HMakar Michael J · Anchorage, AKBuilt 1948 · S/N 14-39 N4237HHolden Daniel N · Anacortes, WABuilt 1948 · S/N 14-40 N4240HSorensen Michael J · Mayer, MNBuilt 1948 · S/N 14-42 N4241HSkinner James A · Anchorage, AKS/N 14-44 N4245HLlewellyn John M · Monroe, WAS/N 14-48 N4246HAndrews Tyler E · Anchorage, AKBuilt 1948 · S/N 14-49 N4249HGapen Patrice M · Cheyenne, WYBuilt 1952 · S/N 14-52 N4250HMincher Charles Mf · Dillingham, AKBuilt 1948 · S/N 14-53 N4252HHoutz Allen D · Kenai, AKBuilt 1948 · S/N 14-55 N4257HGilman James C · Butte, MTBuilt 1948 · S/N 14-60 N4259HLambe Steven S · Anchorage, AKBuilt 1948 · S/N 14-62 N4260HDevoe Don F · Anchorage, AKBuilt 1948 · S/N 14-63 N4263HSchneider Michael J · Anchorage, AKBuilt 1948 · S/N 14-67 N4265HAngel Aviation Inc · Peoria, AZBuilt 1948 · S/N 14-69 N4270HShields Edwin G · York, SCBuilt 1948 · S/N 14-75 N4272HOwen Toy C · Anchorage, AKBuilt 1948 · S/N 14-76 N4276HTailwind Aviation Inc · Wasilla, AKBuilt 1948 · S/N 1480 N4278HWrigley David C · Anchorage, AKBuilt 1948 · S/N 14-83 N4279HDeal Glen K · Palmer, AKBuilt 1948 · S/N 14-84 N4281HWilliams Wendell B · Anchorage, AKBuilt 1948 · S/N 14-86 N4283HRubbert Jan D · Upham, NDBuilt 1948 · S/N 14-88 N4285HPralle Jeffory K · Wasilla, AKBuilt 1948 · S/N 14-90 N4288HHoogendorn Homer E · Wasilla, AKBuilt 1948 · S/N 14-78 N4290HOwen Toy C · Anchorage, AKS/N 14-94 N4291HDuclos Jack B · Anchorage, AKBuilt 1949 · S/N 14-95 N4292HRoss Peter W Trustee · Lufkin, TXBuilt 1948 · S/N 14-45

Back to Piper PA-14