Skip to content

Piper PA-22-135

Registered aircraft · 409

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

N1107CSale Reported · Rigby, IDSale reportedBuilt 1953 · S/N 22-953 N110FBurke Nicholas S · Eagle River, AKBuilt 1952 · S/N 22-888 N1124CBukowski Bruno · Phoenix, AZBuilt 1953 · S/N 22-966 N1130CLaw David L · Derby, KSBuilt 1953 · S/N 22-965 N1132CWinaught Michael A · Louisville, TNBuilt 1953 · S/N 22-969 N1136CCarruthers Steven L · Livingston, TNBuilt 1953 · S/N 22-972 N1164CWilliams Allen J · Greybull, WYBuilt 1953 · S/N 22-989 N1166CAmaya Leonardo H · Port Lavaca, TXBuilt 1953 · S/N 22-990 N1199TPritchard Thurston A · Orofino, IDS/N 22-1134 N1217CMacpherson David Ross · Cantonment, FLS/N 22-1019 N1224CIdaho Airplanes LLC · Boise, IDBuilt 1953 · S/N 22-1030 N1225CTroxler Maxwell C · Greensboro, NCBuilt 1953 · S/N 22-1028 N1227CMccall John L · Arlington, TXS/N 22-1034 N1230CRandall Daryl Robert · Sutter Creek, CABuilt 1953 · S/N 22-1046 N1232CLundquist Lance A · Wheaton, MNBuilt 1953 · S/N 22-1036 N1238CPeters Grover C · The Hills, TXBuilt 1953 · S/N 22-1050 N1241CPanagiotis Markopoulos · Suffolk, VABuilt 1952 · S/N 22-1049 N1243CEndahl Eric A · Iowa City, IABuilt 1953 · S/N 22-1059 N1248CCollier Luther Neal · Mc David, FLBuilt 1953 · S/N 22-1056 N1261CSale Reported · Denver, COSale reportedS/N 22-1053 N1263CWidman Ralph W · Lynchburg, OHBuilt 1953 · S/N 22-1058 N1270CSchnack Kenneth L · Crescent, IABuilt 1953 · S/N 22-1063 N1280CRoesch Karl L · Arlee, MTBuilt 1953 · S/N 22-1078 N1289CGordon Robert Earl · Sanford, NCS/N 22-1110 N1301CPiper Aviation Museum Foundation · Lock Haven, PABuilt 1953 · S/N 22-1095 N1303CRodriguez Isaac J · Fort Smith, ARS/N 22-1098 N1308CHahn Aviation Inc · Troy, OHBuilt 1953 · S/N 22-1112 N1312CApplegate Paul H · Queen City, MOBuilt 1953 · S/N 22-1104 N1320CToney Tasha Fay · Lafayette, INS/N 22-1116 N1335CDorn Kevin J · De Pere, WIBuilt 1953 · S/N 22-1136 N1343CNimer David K · Malad City, IDS/N 22-1142 N1344CCreasy Frank E · Suffolk, VABuilt 1953 · S/N 22-1144 N1391CSale Reported · Beech Creek, PASale reportedBuilt 1953 · S/N 22-1143 N1397CDerr Rodney W · Frackville, PAS/N 22-1154 N1399CShankster Thomas G · Aurora, COBuilt 1953 · S/N 22-1150 N1405CGbq LLC · New Prague, MNBuilt 1953 · S/N 22-1162 N1407CLafreniere Joseph A · Harmony, MNBuilt 1953 · S/N 22-1157 N1411CBraden James L · Hillsboro, KSS/N 22-1165 N1412CStanley Gregory S · Glasgow, MTBuilt 1953 · S/N 22-1173 N1427CGdm Properties LLC · Huron, OHBuilt 1953 · S/N 22-1179 N1428CHolder Ward S · Oxnard, CARegistration revokedBuilt 1953 · S/N 22-1180 N1429CLarge Jonathan B · Mahnomen, MNBuilt 1953 · S/N 22-1183 N1434CSherman Jeff Co Ow · Elkhart, INRegistration revokedBuilt 1953 · S/N 22-1189 N1437CChilders Daniel A · Hartwell, GAS/N 22-1192 N1440CChamberlain Howard D · Lisbon, OHBuilt 1953 · S/N 22-1194 N1480CJohnson Mark A · Thousand Oaks, CABuilt 1953 · S/N 22-1203 N1502PCarey Daniel F · Long Beach, NYBuilt 1954 · S/N 22-2366 N1506PStevens John P · Hernando, FLBuilt 1954 · S/N 22-2370 N1507PWagner Rickey J · Stacy, MNBuilt 1954 · S/N 22-2372 N1516PRichardson Sean W · Delta Junction, AKS/N 22-2381

Back to Piper PA-22-135