Skip to content

Registered aircraft · 3,138

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

N1277FJohn D Strohsahl Pa Trustee · Fort Lauderdale, FLBuilt 1979 · S/N 17272982 N1291FRegistered aircraftBuilt 1979 · S/N 17272986 N1293FT-Craft Aero Club · Nampa, IDBuilt 1979 · S/N 17272987 N1294FClover Park Technical College · Lakewood, WABuilt 1979 · S/N 17272988 N1297FJprg Aviation Inc · Orlando, FLBuilt 1979 · S/N 17272990 N129SLLee Aero LLC · Wichita, KSBuilt 1979 · S/N 17273503 N129SYDaigle Danny · Greenville, MEBuilt 1978 · S/N 17270741 N1304FRoach Galen D · Saint John, KSBuilt 1979 · S/N 17272993 N1312EBuswell Aviation Inc · Salem, ORBuilt 1978 · S/N 17270950 N1315ETada Aero LLC · Worthington, OHBuilt 1978 · S/N 17270951 N1317EAbove And Beyond Aviation LLC · Austin, TXBuilt 1978 · S/N 17270952 N131JDMccurry Patty Trustee · Ocala, FLBuilt 1978 · S/N 17270668 N1322EStrohman William Edward · Algona, IABuilt 1978 · S/N 17270954 N1324ESorbi Aviation Inc · El Cajon, CABuilt 1978 · S/N 17270956 N1325FA&F Aviation Services LLC · Collierville, TNBuilt 1979 · S/N 17272995 N1328ESj28e LLC · Durango, COBuilt 1978 · S/N 17270958 N1346EMonillas Peter C · Martinez, CABuilt 1978 · S/N 17270964 N1351EJ & S Air Ventures LLC · Eagle Lake, FLBuilt 1978 · S/N 17270965 N1352EMclv2020 LLC · Las Vegas, NVBuilt 1978 · S/N 17270966 N1355FChi Aerospace Inc · Portsmouth, NHBuilt 1979 · S/N 17272998 N1356FJprg Aviation Inc · Orlando, FLS/N 17272999 N1360ETuskegee Airmen National Historical Museum Inc · Detroit, MIBuilt 1978 · S/N 17270968 N1370ESprocket Aircraft Management LLC · Kennesaw, GABuilt 1978 · S/N 17270972 N1372ECsa Aircraft Leasing LLC · Park City, UTS/N 17270974 N1373EEagle Aviation LLC · Spearfish, SDBuilt 1978 · S/N 17270975 N1374EKjeldgaard James K · Fremont, NEBuilt 1978 · S/N 17270976 N1377EFly Barely LLC · Manitowoc, WIBuilt 1978 · S/N 17270978 N137ALLegends Air Center LLC · Bentonville, ARBuilt 1976 · S/N 17268125 N1393EMossler Jonathan E · Edgewater, FLBuilt 1978 · S/N 17270983 N1395EHendricks Paul · Yellville, ARBuilt 1978 · S/N 17270984 N1398EMichael Elan · Encino, CABuilt 1978 · S/N 17270985 N13KKSanders Flight Training Center Inc · Jasper, ALBuilt 1977 · S/N 17268760 N13SKFlydreams Aircraft Group Inc · Fort Lauderdale, FLBuilt 1978 · S/N 17271183 N1401EUnited States Air Force Aero Club · Usaf Academy, COBuilt 1978 · S/N 17270986 N140PCNavigation Leasing LLC · Castle Rock, COBuilt 1976 · S/N 17268241 N1416ESalem Pilots Association · Salem, ORBuilt 1978 · S/N 17270989 N141PFFordham Aviation Inc · Eastman, GABuilt 1978 · S/N 17271503 N1422EA S Air LLC · Lantana, FLBuilt 1978 · S/N 17270991 N1424EFamily Rec Corp · Marysville, KSBuilt 1978 · S/N 17270993 N1429ESullins David A · Santa Barbara, CABuilt 1978 · S/N 17270996 N142THHill Thomas John · Saint Paul Park, MNS/N 17272047 N1445ESouth Aero LLC · Albuquerque, NMBuilt 1978 · S/N 17271004 N1449EChase Matthew S · Rock Hill, SCBuilt 1978 · S/N 17271005 N1459EN Hollywood Optimist Club Youth & Comm Svc Fndtn · Van Nuys, CABuilt 1978 · S/N 17271007 N145MLKuonen Christopher · Wellsboro, PABuilt 1976 · S/N 17268382 N1461EOracle Aviation LLC · Omaha, NEBuilt 1978 · S/N 17271009 N1463E1463 Echo LLC · Eau Claire, WIS/N 17271010 N1464ERegistration Pending · New Windsor, NYRegistration pendingBuilt 1978 · S/N 17271011 N1465EDandelion Wine LLC · Charleston, SCBuilt 1978 · S/N 17271012 N1466FGoody Birds LLC · Prattville, ALBuilt 1979 · S/N 17273005

Back to Cessna 172N