Skip to content

Registered aircraft · 3,572

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

N1374USkydance Aviation LLC · Norfolk, VABuilt 1976 · S/N 17267045 N13751Stegmaier Ann C · Eagan, MNBuilt 1974 · S/N 17262992 N13752Coffman Aviation Inc · Jacksonville, FLBuilt 1974 · S/N 17262993 N13753Reeves Christopher A · Statesville, NCBuilt 1974 · S/N 17262994 N13754Durrum Frank D III · Mount Pleasant, TXBuilt 1974 · S/N 17262995 N13770Countryside Academy · Benton Harbor, MIBuilt 1974 · S/N 17263001 N13778Weitekamp Shawn Paul · Roanoke Rapids, NCBuilt 1974 · S/N 17263003 N1377UWifa (Washington International Flight Academy) LLC · Wilmington, DEBuilt 1976 · S/N 17267048 N13786Diapaola Anthony Sr · New Eagle, PABuilt 1974 · S/N 17263004 N13796Positive Attitude Ia LLC · Gaithersburg, MDBuilt 1974 · S/N 17263006 N1379UHigh Flight Academy LLC · Allison Park, PABuilt 1976 · S/N 17267050 N137FST Aviation Services Inc · Canovanas, PRBuilt 1975 · S/N 17266030 N13805Gateway Flight Center LLC · Port Lavaca, TXBuilt 1974 · S/N 17263009 N13806Mpr Aviation LLC · Mcpherson, KSBuilt 1974 · S/N 17263010 N13807Blues Air LLC · Shelby, MSBuilt 1974 · S/N 17263011 N1380USky Clear LLC · Chicago, ILBuilt 1976 · S/N 17267051 N13810Charlie Lima 1 LLC · Jacksonville, FLBuilt 1974 · S/N 17263012 N13821Lexington Flying Club · Lexington, KYBuilt 1974 · S/N 17263015 N13830Iowa Lakes Community College · Estherville, IABuilt 1974 · S/N 17263017 N13834Hastings Air LLC · Hastings, NEBuilt 1974 · S/N 17263018 N1383URegistered aircraftBuilt 1976 · S/N 17267054 N13849Durkee Robert J · Prineville, ORBuilt 1974 · S/N 17263021 N13874Missionair LLC · Livingston, NYBuilt 1974 · S/N 17263026 N1387UCp Aircraft Leasing LLC · Danville, CABuilt 1976 · S/N 17267058 N13884Triple F Aviation LLC · Scott City, KSS/N 17263028 N13887Jkg LLC · Murfreesboro, TNBuilt 1974 · S/N 17263029 N13889Carver Brian J · Rockwell City, IABuilt 1974 · S/N 17263030 N1388UBeining Grant P · Fullerton, CABuilt 1976 · S/N 17267059 N13890Registration Pending · Commerce, GARegistration pendingBuilt 1974 · S/N 17263031 N13902Campbell Travis G · Starr, SCBuilt 1974 · S/N 17263035 N13905Positive Rate LLC · Rutherford, NJBuilt 1974 · S/N 17263036 N1391UArctic Winds Inc · King Salmon, AKS/N 17267062 N13923Timoszyk James S · Wayne, MIBuilt 1974 · S/N 17263039 N13938Seattle Offshore Dmi Inc · Bothell, WAS/N 17263041 N1393USelim Shahir P · Hollywood, FLBuilt 1976 · S/N 17267064 N13941Wings Over Texas Holdings LLC · Denton, TXBuilt 1974 · S/N 17263044 N13942Rohrer Mary · Fredericksburg, TXBuilt 1974 · S/N 17263045 N13943Tell Christopher A · Colville, WAS/N 17263046 N13944Ripp Ted · Pulaski, TNBuilt 1974 · S/N 17263047 N13946Air Capital Aviators Club · Wichita, KSBuilt 1974 · S/N 17263048 N1395UBentley Robert H · Lockport, ILBuilt 1976 · S/N 17267066 N1397URock Solid Aviation LLC · Lake Charles, LABuilt 1976 · S/N 17267068 N1399UOc 172 Group LLC · Costa Mesa, CAFirst renewal noticeBuilt 1976 · S/N 17267070 N13JTHoltzclaw Timothy M · O Brien, FLBuilt 1972 · S/N 17261008 N13TPLehman Aviation LLC · Remington, INBuilt 1976 · S/N 17267454 N1403VSmith Dennis A Trustee · Salem, ORBuilt 1974 · S/N 17263550 N1405UGuardian Aerial Patrol LLC · Edmond, OKBuilt 1976 · S/N 17267075 N1407UN R I Flying Club · Walnut Creek, CABuilt 1976 · S/N 17267077 N1411UOxley Kevin L · Huntington, INBuilt 1976 · S/N 17267080 N1414VMoeller Rita L · Rescue, CABuilt 1974 · S/N 17263559

Back to Cessna 172M