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.

N1349HRose Randy James · Egg Harbor, WIBuilt 1949 · S/N 15AC-392 N1352HMorris Dennie R · North Fort Myers, FLBuilt 1949 · S/N 15AC-396 N1353HHeredia Richard A · Gilroy, CABuilt 1949 · S/N 15AC397 N1354HOwen Toy C · Anchorage, AKBuilt 1949 · S/N 15AC-398 N1356HHatley Byron J · Sparks, NVBuilt 1949 · S/N 15AC-403 N1357HPolhemus John W Jr · Bowie, TXS/N 15AC-404 N1361HWebb Randol B Jr · Sherman, CTBuilt 1949 · S/N 15AC-408 N1365HConger Gary L · Oneida, WIBuilt 1949 · S/N 15AC-413 N1368HWestlake Aviation LLC · Seattle, WABuilt 1949 · S/N 15AC-417 N1372HNelson Chester C · Little Falls, MNBuilt 1949 · S/N 15AC-421 N1376HMikos Nicholas J · Anchorage, AKS/N 15AC-425 N1378HPinsky Harold M · Ann Arbor, MIBuilt 1949 · S/N 15AC-427 N1381HSolek Kyle M · Copper Center, AKS/N 15AC430 N1384HGoodhue David H · Vancouver, WABuilt 1949 · S/N 15AC-434 N1387HAbrahamson Joe Trustee · Phoenix, AZFirst renewal noticeBuilt 1949 · S/N 15AC-438 N1391HFronhofer Mark · Franklin, VTBuilt 1949 · S/N 15AC-442 N1396HRiggin Flight Service Inc · Madison, SDS/N 15AC-447 N1398HMiller Debra L · Anchorage, AKS/N 15AC-449 N1403HSutter Richard J · Kooskia, IDBuilt 1950 · S/N 15AC-454 N1410HCramer Justin R · Eagle River, AKBuilt 1949 · S/N 15AC-462 N1413HBloomfield Management Inc · Dodgeville, WIBuilt 1949 · S/N 15AC-433 N1414HSardella Jeff · Knoxville, TNS/N 15AC470 N1415HGullickson Gregory D · Anchorage, AKBuilt 1949 · S/N 15AC-471 N1417HHoag Michael R · Three Rivers, MIBuilt 1949 · S/N 15AC-475 N1418HErickson Richard F · Wasilla, AKS/N 15AC-478 N1420HWagner James M Trustee · Reno, NVS/N 15AC-477 N1421HNelson Chester C · Little Falls, MNBuilt 1950 · S/N 15AC-482 N1422HNedley A Lloyd · Birmingham, MIRegistration revokedBuilt 1950 · S/N 15AC484 N1423HSchneider Paul · Silverdale, WABuilt 1950 · S/N 15AC-485 N1427HMolt Keaton V · Burns, ORBuilt 1950 · S/N 15AC-491 N1428HParrish Sidney J · Manley Hot Springs, AKBuilt 1950 · S/N 15AC-489 N1430HHardy John R · Wasilla, AKBuilt 1949 · S/N 15AC-493 N1433HCowley Curt J · Independence, ORBuilt 1950 · S/N 15AC-496 N1441HHolder Jimmy R · North Pole, AKS/N 15AC-506 N1448HWilder Jon R Jr · Glenfield, NYBuilt 1950 · S/N 15AC-517 N1450HSoltis Francis J · Chugiak, AKBuilt 1950 · S/N 15AC-519 N1451HCavanaugh Darrel N · Wasilla, AKFirst renewal noticeBuilt 1950 · S/N 15AC-520 N1452HWilliams Saul C · Fairbanks, AKBuilt 1950 · S/N 15AC-521 N1455HKephart Walter F · Anchorage, AKBuilt 1949 · S/N 15AC-525 N1456HLafrance Edward J · Ellensburg, WAS/N 15AC-524 N1459HLuke Daniel J · Burlington, WIS/N 15AC-528 N1460HNeeves Aviation And Flying LLC · Sioux Falls, SDBuilt 1950 · S/N 15AC-530 N1462HParrott David C · Harrison, MEBuilt 1950 · S/N 15AC-532 N1464HKnight Aaron P · Marion, INBuilt 1950 · S/N 15AC-534 N1471HWestern Antique Aeroplane & Automobile Museum · Hood River, ORBuilt 1951 · S/N 15AC-541 N1473HMyburgh Hendrik T · Sunnyvale, CABuilt 1951 · S/N 15AC-543 N1475HHebbard Gary D · Bethel, OHS/N 15AC-546 N1491HMacveigh Craig A · New Carlisle, OHS/N 15AC-561 N150BSSpry Brad T · Walker, MNBuilt 1948 · S/N 15AC-348 N159Nelson Chester C · Little Falls, MNS/N 15AC-43

Back to Aeronca 15AC