Skip to content

Registered aircraft · 19

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

N28151Stewart Thomas · Churchville, NYBuilt 1940 · S/N 5-119 N3044LMack Anita T · Scott Afb, ILBuilt 1942 · S/N 5-1410 N32557Experimental Aircraft Association · Watertown, NYBuilt 1940 · S/N 5-335 N35415Irving Kyle P · Wasilla, AKS/N 5-666 N38532Fellman Lukas H · Anchorage, AKS/N 5-1394 N41360Cross Thomas Ad · Yacolt, WABuilt 1945 · S/N 5-1395 N52920Ward David K · Enumclaw, WAS/N 5-1427 N62074Stoll Manufacturing Inc · Marysville, KSBuilt 1943 · S/N 5-1495 N65925Mccartney Kenneth R · Amarillo, TXBuilt 1941 · S/N 5-1407 N65940Bavarian Barnstormers 2 Inc · North Fort Myers, FLNon-citizen corporation, flight hours not reportedBuilt 1943 · S/N 5-1461 N66512Capp Sam · Juneau, AKBuilt 1942 · S/N 51426 N66545Mcclellion William R III · Anderson, SCBuilt 1942 · S/N 5-1416 N68287Lockwood Albert G · Eden, IDS/N 5-1475 N68490Chersky Brian · Santa Maria, CABuilt 1943 · S/N 5-1456 N68931Denman Diana L · Plain, WIBuilt 1943 · S/N 5-1436 N718EBerry Darrel · Camden, TNBuilt 1943 · S/N 30280 N7JSPeters Justin A · Pearce, AZBuilt 1943 · S/N 5-1435 N9880HAbell Alan R · Elgin, ILBuilt 1943 · S/N 51434 N9993HCarlsfrom Thomas A · Bonita Springs, FLBuilt 1943 · S/N 5-1473

Back to Piper J5C