Skip to content

Registered aircraft · 277

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

N10PSCarson Glen W · Garber, OKBuilt 1955 · S/N 22-2687 N1106CRiver Town Aviation LLC · Williamstown, WVS/N 22-948 N1123CTuschhoff Stetson Rd · Jackson, MOBuilt 1953 · S/N 22-960 N1140CAtkins Alvin R · Barnstead, NHBuilt 1953 · S/N 22-973 N1167CMountain Bluebird Aviation LLC · Kalispell, MTBuilt 1953 · S/N 22-992 N1168CPartridge James R · Chino Valley, AZBuilt 1953 · S/N 22-994 N118UCypher Tosha · Palmer, AKS/N 22-3988 N11DUMcginnis Terry S · Surprise, AZBuilt 1958 · S/N 226252 N11PAFelpel Craig D · Palmer, AKBuilt 1956 · S/N 22-321 N1200CSmith Rod B · De Kalb, MOBuilt 1953 · S/N 22-1007 N1226CFortine Joseph A · Adin, CABuilt 1953 · S/N 22-1031 N1264CCoulter Clint C · Texline, TXBuilt 1953 · S/N 22-1060 N1282CSpivey Harold E · Thomaston, GABuilt 1953 · S/N 22-1076 N1283CZawada Matthew J · Roberts, MTBuilt 1953 · S/N 22-1079 N1300CSelf James M · Fennville, MIBuilt 1953 · S/N 22-1102 N1324CLawrence Mark J · Rouses Point, NYS/N 22-1131 N1346CWorden Gail · Burt, MIS/N 22-1145 N1404ALindinger John I · Auburn, NEBuilt 1951 · S/N 22-318 N1411APetz Matthew M · Sandpoint, IDBuilt 1951 · S/N 22-323 N1415AHock Wesley S · Holbrook, NEBuilt 1951 · S/N 22-326 N1418CWaaam Volunteer Flying Association LLC · Hood River, ORS/N 22-1175 N1421AKoplitz Wesley D · Oshkosh, WIS/N 22-336 N1424AStacey Steve L · Hutchinson, KSBuilt 1951 · S/N 22-338 N1431AKoiter Jason A · Prescott Valley, AZBuilt 1951 · S/N 22-347 N1456AMcbride Michael S · Allentown, PABuilt 1951 · S/N 22-359 N1457ASanderson Michael E · Newberg, ORS/N 22-357 N1465ALarsen Caesar S · Pleasanton, CABuilt 1951 · S/N 22-372 N1469AJohnson Steven C · Cheyenne, WYBuilt 1952 · S/N 22-377 N1471AJames Norris J · Kannapolis, NCBuilt 1952 · S/N 22-378 N1472ASmith Wesley P · Donnelly, IDBuilt 1952 · S/N 22-379 N1474ARichard Waldren LLC · Newberg, ORS/N 22-385 N1478ABehr Casper J · Neavitt, MDBuilt 1952 · S/N 22-392 N1479AOlson Phillip Francis · Tenino, WABuilt 1952 · S/N 22-391 N1481AViseur Michael E · Tulsa, OKBuilt 1952 · S/N 22-389 N1482CKnutsen Wayne R · Thompson, NDBuilt 1953 · S/N 22-1205 N1492AKessler David Keith · Mineral Wells, TXBuilt 1952 · S/N 22-400 N1494AHelton Tom H · Santa Ana, CABuilt 1952 · S/N 22-398 N1495ARamos Benjamin · Yuma, AZS/N 22-402 N1497ASlagle Steven D · Auburn, WABuilt 1952 · S/N 22-417 N1498ASpivey Larry B · Milledgeville, GABuilt 1952 · S/N 22-403 N1503PRegistered aircraftBuilt 1954 · S/N 22-2367 N1616POwen David C · Fort Myers, FLBuilt 1954 · S/N 22-2430 N1632PWilley Larry E · Fremont, OHBuilt 1954 · S/N 22-2446 N1646PGerigs Trucking And Leasing Inc · Hoagland, INBuilt 1954 · S/N 22-2462 N1648ARenner Daniel T · Crooks, SDS/N 22-411 N1649AHudgin James P · Lewisburg, TNBuilt 1952 · S/N 22-412 N1655AConnell Romeao J · Gresham, ORS/N 22-419 N1659ARowell Tony A · Westerville, OHBuilt 1952 · S/N 22-415 N1663POakes Stephen · Joshua Tree, CAS/N 22-3089 N1673ASheeley Patrick D · High Falls, NYBuilt 1952 · S/N 22-436

Back to Piper PA-22