Skip to content

Registered aircraft · 477

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

N1009AWilliams Wendell · Anchorage, AKBuilt 1950 · S/N 18581 N101KCH O Aircraft Inc · Maple Grove, MNS/N 18-649 N101SCAnderson Benjamin T · Havre De Grace, MDBuilt 1964 · S/N 18-6200 N1023AWhite Leland T · Deer Park, WABuilt 1951 · S/N 18-595 N102LWWulff Allan · Reston, VABuilt 1955 · S/N 18-4383 N1034AHawk Don · Shady Cove, ORS/N 18-606 N1041AWinkelman Donald L · Anchorage, AKBuilt 1951 · S/N 18-619 N1045ALange Bryan C · Harrison, NEBuilt 1951 · S/N 18-622 N104TCarey Daniel F · Rockville Centre, NYS/N 18-2218 N1051ARegistered aircraftBuilt 1951 · S/N 18-641 N1059AButler Billy D · Hilger, MTBuilt 1951 · S/N 18-630 N105JCHeckathorn Chad W Trustee · Elk Point, SDBuilt 1950 · S/N 18-308 N1065ANordhaus Robert · Lake Geneva, WIBuilt 1951 · S/N 18-648 N1066AYounggren James H · Hallock, MNBuilt 1951 · S/N 18-646 N1072AScarboro Thomas E · North Pole, AKBuilt 1951 · S/N 18-655 N1073APeters Steven M · Parkersburg, WVBuilt 1951 · S/N 18-657 N1076ATri City Airframe LLC · Kalispell, MTS/N 18-659 N1081AHoyer Larry B · Fort Peck, MTBuilt 1951 · S/N 18-663 N10842Cranor Douglas R · Valdez, AKBuilt 1951 · S/N 18-671 N1087AScotton Bradley D · Galena, AKBuilt 1951 · S/N 18-673 N1089AReeder Julian S Jr · Nenana, AKS/N 18-680 N1097ARanch Aero LLC · Sterling City, TXS/N 18-685 N1109AOrton Aviation LLC · Walker, MNBuilt 1951 · S/N 18-701 N1109JOrton Aviation LLC · Walker, MNBuilt 1950 · S/N 18-392 N1109WOrton Aviation LLC · Walker, MNBuilt 1957 · S/N 18-5946 N1128ACarson Dean B · Anchorage, AKBuilt 1951 · S/N 18-721 N1130ACoxon William O IV · Church Hill, MDBuilt 1951 · S/N 18-723 N1131ARizzo Christian · Clover, SCBuilt 1951 · S/N 18-725 N1157CCavill Wayne E · Ryegate, MTBuilt 1953 · S/N 18-2458 N1160AAday Bennie J · Las Cruces, NMS/N 18-757 N1175ABurmeister Aaron R · Nenana, AKBuilt 1951 · S/N 18-777 N117TLOver-Head Productions Inc · Wilmington, DES/N 18-2231 N1185ALovgren Dean · Morrowville, KSBuilt 1951 · S/N 18-792 N118DKReynolds Thomas J · Dillon, MTS/N 18-7540 N1192AMyers Dale C · King Salmon, AKBuilt 1951 · S/N 18-802 N1200ABay Kelly M Trustee · Glennallen, AKBuilt 1951 · S/N 18-1200 N1202AEldringhoff Jim · Wecota, SDBuilt 1951 · S/N 18-810 N1209ACorbin Richard · Waterville, NYBuilt 1951 · S/N 18-820 N1214ARegistered aircraftBuilt 1951 · S/N 18-828 N1219AFeltman Joshua C · Kenai, AKS/N 18-834 N1222ADawley Creek Ranch Nv LLC · Ruby Valley, NVBuilt 1951 · S/N 18-837 N1226AWalsh Brendan · Seattle, WAS/N 18-841 N1244APickard Martha Anne Gabriel · Hudson, OHBuilt 1957 · S/N 18-1037 N1248ABaugh Andrew Lawrence · Anchorage, AKBuilt 1951 · S/N 18-1041 N124GSDetommaso James F · North Pole, AKBuilt 1956 · S/N 5287 N1251APappas Timothy G · Big Lake, AKS/N 18-1047 N1259CBowers Michael · Chugiak, AKBuilt 1953 · S/N 18-2500 N1264APierskalla Nicolas B · Wasilla, AKBuilt 1951 · S/N 18-1060 N1265AWalker Matthew J Trustee · Delta Junction, AKS/N 18-1061 N1270ASnow Richard C · Wasilla, AKBuilt 1951 · S/N 18-1065

Back to Piper PA-18