Skip to content

Registered aircraft · 513

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

N1320DHarlan Dale L · Big Lake, AKBuilt 1951 · S/N 19896 N1331DSawyer Eugene M · Santa Rosa, CABuilt 1951 · S/N 19907 N1337DThompson Taylor A · Highland Park, ILBuilt 1951 · S/N 19913 N1341DBuilders Guild Inc · Mesa, AZBuilt 1951 · S/N 19917 N1342DCaso Joseph J · Amity Harbor, NYS/N 19918 N1343DHaanen Jeffrey J · Browns Valley, MNBuilt 1951 · S/N 19919 N1344DWolf Ronald T · Abbeville, LABuilt 1951 · S/N 19920 N1345DBraner Richard C Trustee · Oakdale, CABuilt 1951 · S/N 19921 N1349DBishop Donald Joseph · Cary, NCBuilt 1951 · S/N 19925 N1350DBock Ray P · Alpena, MIBuilt 1951 · S/N 19926 N1351DReep Jennifer B · Stone Mountain, GABuilt 1951 · S/N 19927 N1354DKepler Rodney S · Fargo, NDBuilt 1951 · S/N 19930 N1355DDaly Trucking LLC · Paxton, NES/N 19931 N1356DApte John W · Biddeford, MEBuilt 1951 · S/N 19932 N1359DPribbenow John L · Anchorage, AKBuilt 1951 · S/N 19935 N1361DVasko Laszlo · Harvard, MABuilt 1951 · S/N 20107 N1362DGulf Elm Corp · Wilmington, DEBuilt 1951 · S/N 20108 N1364DSpiro Paul M · Anchorage, AKBuilt 1951 · S/N 19940 N1366DOwens Anthony F · Guntersville, ALS/N 19942 N1369DDuckworth Edward I · Liberty, MOBuilt 1951 · S/N 19945 N1371DFrank Taylor Joseph · Tamarac, FLBuilt 1951 · S/N 19947 N1377DJohnson Lawrence F · Anchorage, AKBuilt 1951 · S/N 19953 N1378DPalmerlee John B · Santa Rosa, CABuilt 1951 · S/N 19954 N1379DGods Chosen Flyers LLC · Apex, NCBuilt 1951 · S/N 19955 N1386DDeford Shawn J · Hope, AKBuilt 1951 · S/N 20109 N1388DGroceman Bernard F · Jackson, MOBuilt 1951 · S/N 19964 N1392DChalender Robert Christopher · Cocoa, FLS/N 19968 N1396DFlying Dutchman Aviation LLC · Richmond, TXBuilt 1951 · S/N 19972 N1401DRegistered aircraftBuilt 1951 · S/N 19984 N1408DParks James M · Potsdam, NYBuilt 1951 · S/N 19991 N1409DArcher William Todd · North Pole, AKBuilt 1951 · S/N 19992 N1410DMahaffey James P · Grand Prairie, TXBuilt 1951 · S/N 19993 N1412DKing Matthew W · Wilmington, NCBuilt 1951 · S/N 19995 N1415DMurphy James S · Skaneateles, NYBuilt 1951 · S/N 20131 N1418DScheer R Michael · Wilmington, NYBuilt 1951 · S/N 20001 N1424DN1424d LLC · Collinsville, OKBuilt 1951 · S/N 20136 N1427DSheets George M · Tonkawa, OKBuilt 1951 · S/N 20010 N1433DWenger Arthur B · Wickenburg, AZBuilt 1951 · S/N 20016 N1434DWesner Philip F · Ashland, WIBuilt 1951 · S/N 20017 N1436DAsk Worldwide LLC · Ovid, MIBuilt 1951 · S/N 20019 N1438DOlinde Aerospace LLC · Palm Bay, FLBuilt 1951 · S/N 20021 N1447DSimmons Dennis L · Wichita, KSS/N 20030 N1455DSherwood Kenneth M · Northville, NYBuilt 1951 · S/N 20038 N1462DWarner Aric D · Rosamond, CAS/N 20045 N1463DSorrell Edward S · Vero Beach, FLBuilt 1951 · S/N 20046 N1465DHendrickson Elisabeth · Kerrick, MNBuilt 1951 · S/N 20080 N1468DAhrens David R · Guthrie Center, IABuilt 1951 · S/N 20051 N1471DSchwarzkopf Michael A · St Peters, MOBuilt 1951 · S/N 20054 N1473DDrake Wm Ronald · Marshall, MOBuilt 1951 · S/N 20056 N1478DBailey James W Jr · Burleson, TXBuilt 1951 · S/N 20061

Back to Cessna 170A