Skip to content

Registered aircraft · 162

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

N1000HMumm Scott A · Brodhead, WIBuilt 1948 · S/N 15AC-2 N1003HLight Winds Aviation LLC · Bay City, MIBuilt 1948 · S/N 15AC-5 N1005HMaier Dennis J · Morristown, SDBuilt 1948 · S/N 15AC7 N1009HHardey John R · Wasilla, AKBuilt 1948 · S/N 15AC-11 N1010HA2 Aero LLC · Ann Arbor, MIBuilt 1949 · S/N 15AC-347 N1011HUlm Gabrielle Nicole · North Pole, AKBuilt 1948 · S/N 15AC-13 N1013HWhite Theodore F · Willow, AKBuilt 1948 · S/N 15AC-15 N1028HConnell Michael J · Decorah, IABuilt 1948 · S/N 15AC-31 N1031HHardy John R · Wasilla, AKBuilt 1948 · S/N 15AC-34 N1034HBuergel Sandra J · East Aurora, NYBuilt 1948 · S/N 15AC-37 N1035HKnapp Louis L · Fairbanks, AKBuilt 1948 · S/N 15AC-38 N1048HBeuschel Timothy W · Mount Pleasant, WIS/N 15AC-59 N1049HSavage David E · American Falls, IDBuilt 1948 · S/N 15AC-62 N1051HPoulter John W · Sharpsburg, GABuilt 1948 · S/N 15AC-66 N1052HFay Bernard E · Eagle, AKBuilt 1948 · S/N 15AC-69 N1054FGilson Gareth F · Phoenix, AZS/N 15AC-68 N1055HReddell Justin · Jasper, ARBuilt 1948 · S/N 15AC-70 N1060HJohnston Jeffery A · Eagle River, AKBuilt 1948 · S/N 15AC-76 N1067HAmerell Kathryn · Wasilla, AKS/N 15AC-86 N1070HGeary Charles L · Wasilla, AKBuilt 1948 · S/N 15AC-89 N1071HBeck Douglas J · Bloomington, MNBuilt 1948 · S/N 15AC-90 N1072HBeckman Thomas J · Pocahontas, ARBuilt 1948 · S/N 15AC-91 N1075HBartholomew Dana C · Madison, WIBuilt 1948 · S/N 15AC-94 N1077HHadley Everett F · Dayville, CTBuilt 1948 · S/N 15AC-96 N1088HAerotechniques LLC · South Kent, CTBuilt 1948 · S/N 15AC-52 N1091HHuber Gregory A · Medina, OHBuilt 1948 · S/N 15AC-112 N1096HRegistration Pending · Wasilla, AKRegistration pendingBuilt 1948 · S/N 15AC-116 N1097HPoulter Thomas R · Chelsea, MIBuilt 1948 · S/N 15AC-117 N1099HTzenis Michael · Lakeville, MNBuilt 1948 · S/N 15AC-119 N1114HKendall John · Three Lakes, WIS/N 317 N1115HSmitholum Adam O · Tok, AKS/N 15AC-135 N1122HEdge Derek Thomas · Center Barnstead, NHBuilt 1948 · S/N 15AC-137 N1124HNolan Robert C II · Las Vegas, NVBuilt 1948 · S/N 15AC-139 N1125HClark David D · Nenana, AKBuilt 1948 · S/N 15AC-140 N1131HLeisner David L · Palmer, AKBuilt 1948 · S/N 15AC-146 N1132HWallis Frederick W · Healy, AKBuilt 1948 · S/N 15AC-145 N1134HFeldhusen Lawrence E · Yankeetown, FLBuilt 1948 · S/N 15AC-148 N1135HSale Reported · Fort Smith, ARSale reportedBuilt 1948 · S/N 15AC-151 N1136HMusgrove Louis A Jr · Cumming, GABuilt 1948 · S/N 15AC-144 N1138HAgaliotis Paul E · San Martin, CABuilt 1948 · S/N 15AC-149 N1142HSimmons Donald E · Clifton Park, NYBuilt 1948 · S/N 15AC-153 N1148HReed Charles H · Shelbyville, KYBuilt 1948 · S/N 15AC-163 N1152HWeiler Coen A · Ashville, OHBuilt 1948 · S/N 15AC-165 N1154HLechner Burdette J · Kodiak, AKBuilt 1948 · S/N 15AC-167 N1162HRegistered aircraftBuilt 1948 · S/N 15AC-175 N1163HMiller William A · Williamson, GABuilt 1948 · S/N 15AC-176 N1164HHall Nathan M · Shepherd, MTBuilt 1948 · S/N 15AC-179 N1170HBeckman Thomas J · Pocahontas, ARBuilt 1948 · S/N 15AC-183 N1175HKrummrey Steven C · Munith, MIBuilt 1948 · S/N 15AC-188 N1178HLarter Edward A · Franklin, NHBuilt 1948 · S/N 15AC-199

Back to Aeronca 15AC