Skip to content

Piper PA-22-108

Registered aircraft · 587

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

N108CSFlight Expo Inc · Zimmerman, MNS/N 22-9054 N121BAPapst David · Freeland, MIS/N 22-9815 N12465Sherburn Daniel E · Spring Lake, MIBuilt 1961 · S/N 22-9057 N16MBLancaster Wesley A · Saint Augustine, FLBuilt 1961 · S/N 22-8387 N209SAInternational Air Services Inc Owner Trustee · Carson City, NVS/N 22-8448 N235AUNorcross Ashley S · Anchorage, AKS/N 22-9772 N24146Wright Jeffrey N · Copper Center, AKBuilt 1961 · S/N 22-8258 N243SAInternational Air Services Inc Trustee · Carson City, NVBuilt 1961 · S/N 22-8376 N2929TTampa Bay Flying Club Corp · Tampa, FLS/N 22-9630 N3114FByrd Ronald R · Polk City, FLS/N 22-8615 N3210Perry Daryl C · Sanford, NCBuilt 1961 · S/N 22-8079 N3KEBlevins Myrl Dean · Wytheville, VABuilt 1962 · S/N 22-9244 N4500ZBielefeld James L · Kenai, AKBuilt 1960 · S/N 22-8000 N4502ZBoyer Bruce A · Toledo, OHBuilt 1960 · S/N 22-8002 N4503ZDoran Daniel E · Lake In The Hills, ILS/N 22-8003 N4509ZLawrence Bobby L · Willis, TXBuilt 1960 · S/N 22-8011 N4510ZLamphere Michael T · Whitehall, NYBuilt 1960 · S/N 22-8012 N4511ZKim Andrew · Upland, CABuilt 1960 · S/N 22-8013 N4518ZHoecher Robert T · Anchorage, AKBuilt 1960 · S/N 22-8020 N4521ZWeichert Eric S · Janesville, MNBuilt 1960 · S/N 22-8008 N4526ZArmstrong Brandon M · Sierra Vista, AZBuilt 1961 · S/N 22-8029 N4529ZDaigle Michael R · Andover, NHBuilt 1961 · S/N 22-8032 N4530ZKirby Andrew P · Strattanville, PABuilt 1960 · S/N 22-8035 N4531ZFelts Jacob I · Kalispell, MTBuilt 1960 · S/N 22-8036 N4534ZKay Bennie L · Brigham City, UTBuilt 1960 · S/N 22-8039 N4540ZBerdine Kenneth B · Arnoldsburg, WVBuilt 1961 · S/N 22-8045 N4542ZWaters Caleb M · Merritt Island, FLBuilt 1961 · S/N 22-8047 N4543ZSvec Adolph Ralph · Marengo, ILBuilt 1961 · S/N 22-8048 N4544ZTinker David G · Emlenton, PABuilt 1961 · S/N 22-8049 N4546ZPutter Jerry · Wellington, KSBuilt 1961 · S/N 22-8051 N4553ZRisbon Scott W · Crystal Spring, PABuilt 1961 · S/N 22-8058 N4563ZKnutson Wayne R · Thompson, NDS/N 22-8070 N4564ZJones Brad · Oak Hill, FLBuilt 1961 · S/N 22-8071 N4566ZPackett Roger L · Yachats, ORBuilt 1961 · S/N 22-8074 N4573ZMatty Elizabeth · Tucson, AZS/N 22-8082 N4576ZBauman Solomon A · Lyle, WAS/N 22-8085 N4582ZWriedt Dirk · South Beloit, ILBuilt 1961 · S/N 22-8091 N4584ZCompton Michael · Crabtree, ORBuilt 1961 · S/N 22-8093 N4588ZEta Of Missouri Inc · Lone Jack, MOBuilt 1961 · S/N 22-8097 N4590ZSpeck Daniel N · Waverly, NYBuilt 1961 · S/N 22-8099 N4591ZColt Flying Club LLC · Lebanon, PAS/N 22-8100 N4594ZRichard Waldren LLC · Newberg, ORBuilt 1961 · S/N 22-8104 N4596ZEscue Dean · Milford, NJBuilt 1961 · S/N 22-8106 N4597ZEgan Richard G · Tallahassee, FLBuilt 1961 · S/N 22-8109 N4602ZMoorefield Oscar W · Monroe, GABuilt 1961 · S/N 22-8116 N4603ZN4603z Colt Flyers LLC · Kenmore, WAS/N 22-8117 N4610ZGrantham Farley · Bush, LAS/N 22-8124 N4611ZRichard Waldren LLC · Newberg, ORBuilt 1961 · S/N 22-8125 N4616ZBest David Eugene · Newalla, OKBuilt 1961 · S/N 22-8130 N4618ZFilhart Robert · Rosebush, MIBuilt 1961 · S/N 22-8132

Back to Piper PA-22-108