Skip to content

Piper PA-18-125

Registered aircraft · 90

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

N100SXKing Samuel E · Battle Mountain, NVBuilt 1951 · S/N 18-709 N1011AMachamer John K · Gettysburg, PABuilt 1950 · S/N 18-582 N1017AEllis Wendell K · Gakona, AKBuilt 1950 · S/N 18-587 N1029ALange Cole Kenneth · Oglala, SDBuilt 1954 · S/N 18-600 N102TRegistration Pending · Anchorage, AKRegistration pendingBuilt 1954 · S/N 18-2216 N1042APetrie Michael · Chugiak, AKBuilt 1951 · S/N 18-616 N1048AUnderdahl Kirby L · Hamilton, MTBuilt 1951 · S/N 18-626 N1050AMcmahan Charles B · Gakona, AKBuilt 1951 · S/N 18-628 N10572Jefferson Jake O · Wasilla, AKS/N 18-933 N1069ALemmer Mark D · Atkinson, NEBuilt 1951 · S/N 18-652 N1075ABates Hobart C · Dexter, MIBuilt 1951 · S/N 18-667 N1103AUmlauf Paul M · Soldotna, AKBuilt 1951 · S/N 18-691 N1104AHill Brock E · Palouse, WABuilt 1951 · S/N 18-692 N1105AVan Voast Mark A · Turner, MTBuilt 1951 · S/N 18-693 N1106AMountain Air Spray Co · Craig, COBuilt 1951 · S/N 18-694 N1111AKnutson Wayne R · Tioga, NDBuilt 1951 · S/N 18-703 N1112ABallek Jeffery A · North Pole, AKBuilt 1951 · S/N 18-704 N1129ABredin William B · Anchorage, AKBuilt 1951 · S/N 18-722 N1149AFodor Scott M · Barryton, MIBuilt 1951 · S/N 18-743 N1150AMountain Air Spray Company · Craig, COBuilt 1951 · S/N 18-744 N1151ALangdon William W · Lebanon, ORBuilt 1951 · S/N 18-745 N1153AHolder Robert W · Pittsfield, PABuilt 1968 · S/N 18-747 N1169AK-Air Service LLC · Gakona, AKBuilt 1951 · S/N 18-767 N1170AAbbott Barry R · Sterling, AKBuilt 1951 · S/N 18-768 N1195AParker Stephen H · Montgomery, TXBuilt 1951 · S/N 18-803 N1197ABouchard Ron · Lambert, MTBuilt 1951 · S/N 18-804 N1210ACaneen Jeremy M · Wasilla, AKBuilt 1951 · S/N 18-823 N1221AGerbi Charles R Trustee · Auke Bay, AKBuilt 1951 · S/N 18-832 N1233ADecker Leon T · Hollister, CABuilt 1951 · S/N 18-848 N1238AArnold Joe R · Burns, ORBuilt 1951 · S/N 18-1031 N1246AGay Ranch Inc · Broadus, MTBuilt 1951 · S/N 18-1039 N1249AAirmotive Service LLC · Brigham City, UTBuilt 1951 · S/N 18-1042 N1253ALange Keith J · Wasilla, AKBuilt 1951 · S/N 18-1049 N1258ALake Country Lodge Inc · Port Alsworth, AKS/N 18-1053 N1259AHigh Exposure Inc · Wilmington, DEBuilt 1951 · S/N 18-1054 N125FGState Of Alaska · Kodiak, AKBuilt 1951 · S/N 18-1046 N1263AMurphy Janet A · Stafford, KSBuilt 1951 · S/N 18-1059 N1268ATegerdine Charley D · Sterling, AKBuilt 1951 · S/N 18-1063 N1283AFritz David A · Wasilla, AKBuilt 1951 · S/N 18-1087 N1294AHubbard John H · Riverside, WAS/N 18-1097 N1304ABilben Steve W · Kasilof, AKBuilt 1951 · S/N 18-1108 N1305AAir Dakota Flite Inc · Hettinger, NDBuilt 1951 · S/N 18-1109 N1312ABowen Haldor S · Sandpoint, IDBuilt 1951 · S/N 18-1114 N1314AK & D Livestock Inc · Volborg, MTBuilt 1951 · S/N 18-1120 N1317ADixon Douglas C · Anchorage, AKBuilt 1951 · S/N 18-1124 N1322AWrobel Sean M · Weatherford, TXBuilt 1951 · S/N 18-1128 N1324AJagow Charles P · Fairbanks, AKBuilt 1951 · S/N 18-1134 N1334ABrowne Alfred A · Gardnerville, NVBuilt 1951 · S/N 18-1147 N1336APluhar Charles J · Cohagen, MTBuilt 1951 · S/N 18-1151 N1348AMiller Adam S · Bend, ORS/N 18-1175

Back to Piper PA-18-125