Skip to content

Registered aircraft · 50

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

N1915WPasha Mohammad A · Muscatine, IABuilt 1971 · S/N 310Q0429 N220XPOleary Patrick G · Lake Tapps, WAS/N T310Q01020 N222MDElx Aviation LLC · Hartford, MIBuilt 1974 · S/N 310Q1013 N27KCLaperle Brian · Colebrook, NHBuilt 1974 · S/N 310Q1134 N28409Gilmore Sherry · Sallisaw, OKS/N 310Q0666 N28849Roonie Inc · Wilmington, DES/N 310Q0036 N302MCB & G Ventures LLC · Kalispell, MTBuilt 1973 · S/N 310Q0909 N308CFBaba Kenneth D · Sierra Vista, AZBuilt 1973 · S/N 310Q0804 N30ETZaldivar Carlos · Miami, FLBuilt 1971 · S/N 310Q0266 N310BLAlsager Joshua D · Kindred, NDS/N 310Q0069 N310CESwainston Ian · Las Vegas, NVBuilt 1974 · S/N 310Q1063 N310DChispa Air LLC · Cedar Park, TXBuilt 1969 · S/N 310Q0002 N310DHFavero Robert B · Weed, CABuilt 1974 · S/N 310Q1086 N310EWAerial Imaging Inc · South Bend, INBuilt 1973 · S/N 310Q0935 N310FJSimmonds Don M · Sandpoint, IDS/N 310Q0542 N310GCCook Kevin M · Missouri City, TXBuilt 1973 · S/N 310Q0838 N310JPBrock Kyle · Riverdale, CABuilt 1972 · S/N 310Q0648 N310TQRegistration Inc · Kalispell, MTS/N 310Q0818 N310TTTriple J Flying Inc · Wilmington, DEBuilt 1973 · S/N 310Q0810 N317TRRcs Aeronautical Inc · San Antonio, TXBuilt 1973 · S/N 310Q0787 N3322XAllgood Michael K · Saint Augustine, FLBuilt 1974 · S/N 310Q1030 N355SCSmith Loren D · Great Falls, MTBuilt 1973 · S/N 310Q0795 N372CCLemieux Kenneth G · Oneida, TNBuilt 1974 · S/N 310Q1071 N372FCHeartland Aviation Inc · Alliance, NEBuilt 1971 · S/N 310Q0215 N39BTMidwest Aerial Photography · Galloway, OHBuilt 1974 · S/N 310Q1137 N400GMN400gm LLC · Salisbury, MDBuilt 1974 · S/N 310Q1000 N444HTTaktos Ltd · Corvallis, ORBuilt 1973 · S/N 310Q0739 N455XTreat-Yo-Self Confections Inc · Corona, CABuilt 1973 · S/N 310Q1007 N67RKRiley Matthew · Xenia, OHS/N 310Q1107 N69571Michaels Daniel T · Mars, PABuilt 1973 · S/N 310Q0789 N69983Ruble Air LLC · Mechanicsburg, PABuilt 1974 · S/N 310Q1055 N6RWMagee Creek Wings & Things LLC · Rice, WABuilt 1973 · S/N 310Q0751 N6SQTate Thomas E · Glendale, CABuilt 1972 · S/N 310Q0625 N728SCQuist David Andrew · Lake Jackson, TXS/N 310Q0989 N748MGEl Paso Aero Inc · El Paso, TXBuilt 1974 · S/N T310Q1128 N7508QZulu Hours LLC · Moneta, VABuilt 1969 · S/N 310Q0008 N7516QS Flight LLC · Evergreen, COBuilt 1972 · S/N 310Q0530 N7530QBas Part Sales LLC · Greeley, COBuilt 1970 · S/N 310Q0030 N7556QKent Schreiber Company · Greencastle, PABuilt 1972 · S/N 310Q0604 N757CAKenyon Walter C · Eureka Springs, ARBuilt 1972 · S/N 310Q-0535 N7584QArnold Brandon M · Roswell, NMBuilt 1970 · S/N 310Q0084 N767RRRed Leasing LLC · Juneau, AKBuilt 1972 · S/N 310Q0455 N7702QRobinson Meyer · Daphne, ALBuilt 1970 · S/N 310Q0202 N7704QNyerges James R · Pflugerville, TXS/N T310Q0204 N789BDTroy Farms Lp · Delano, CABuilt 1973 · S/N 310Q0922 N7909QSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1972 · S/N 310Q0620 N8179QCruce Aircraft Services LLC · Clewiston, FLBuilt 1972 · S/N 310Q0635 N8188QI Will Rise LLC · Chattanooga, TNBuilt 1972 · S/N 310Q0638 N881PJJohnson Patrick Allen · Olive Branch, MSBuilt 1973 · S/N 310Q0754 N9RVPotter Steven R · Grapevine, TXS/N 310Q0234

Back to Cessna T310Q