Skip to content

Registered aircraft · 61

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

N1000QErnest Obregon · Oakley, CAS/N 310P0195 N12VLCrow Edward N Jr · Silverdale, WAS/N 310P0171 N222AWJust Planes Inc · Hobbs, NMBuilt 1969 · S/N 310P-0106 N23PFBagge Tom · Monticello, IABuilt 1968 · S/N 310P0044 N247EFNobles Vernon H Jr · Calabasas, CABuilt 1968 · S/N 310P0023 N310AWBetty Eric · Old Hickory, TNBuilt 1969 · S/N 310P0231 N310CMAir Positive LLC · Selbyville, DEBuilt 1969 · S/N 310P-0178 N310GRDailey Jordan · Umatilla, FLBuilt 1968 · S/N 310P0064 N310VHVan Horn Jeffrey · Jonesboro, ARBuilt 1969 · S/N 310P0180 N36CGDay Edwin Daniel · Richland, WABuilt 1969 · S/N 310P0075 N36DLCroll Robert H III · Jacksonville, ORBuilt 1969 · S/N 310P0113 N414SGCloud Niner Aviation LLC · Zephyrhills, FLS/N 310P0067 N46CGGlobal Building Investments Inc · Scottsdale, AZS/N 310P0146 N46RKAir Positive LLC · Selbyville, DEBuilt 1969 · S/N 310P0122 N500RFJones Anthony Blake · Sylacauga, ALBuilt 1968 · S/N 310P0026 N53PTRegistration Pending · Anacortes, WARegistration pendingS/N 310P0126 N558BTKeesling Roger L · Starkville, MSBuilt 1969 · S/N 310P0220 N5701MConsulat Inc · Cheyenne, WYS/N 310P-0001 N5709MClear Blue Western Sky LLC · Anthem, AZBuilt 1968 · S/N 310P-0009 N5711MSwager Joel P · Ione, CAS/N 310P0011 N5712MDay Star Aviation Inc · Locust Grove, GABuilt 1968 · S/N 310P0012 N5715MExpress Air LLC · Wilmington, DEBuilt 1968 · S/N 310P0015 N5720MSongbird Aviation Inc · Lawrenceville, GABuilt 1968 · S/N 310P0020 N5721MWood Michael D · Huntington Beach, CABuilt 1968 · S/N 310P0021 N5731MZortman Micky P · Mexico, MOS/N 310P0031 N5741MCoolidge Robert · Rio Vista, TXBuilt 1968 · S/N 310P0041 N5746MFlyaware Inc · Lewes, DENon-citizen corporation, flight hours not reportedS/N 310P0046 N5762MNewby Aviation LLC · Pingree Grove, ILBuilt 1968 · S/N 310P0062 N5768MHeal Your Heart LLC · Redding, CABuilt 1968 · S/N 310P0068 N5781MRudnik Andrew S · Ann Arbor, MIBuilt 1969 · S/N 310P0081 N5782MGingell Robert A · Sunnyvale, CABuilt 1969 · S/N 310P0082 N5783MBig Turbine Engines LLC · Wilmington, DEBuilt 1969 · S/N 310P0083 N5794MMatlach Matthew · Brandon, FLBuilt 1969 · S/N 310P0094 N5816MHolloway Aero LLC · Chino Hills, CAS/N 310P0116 N5817MHonan William · Rainbow City, ALBuilt 1969 · S/N 310P0117 N5818MGlidepath Aviation LLC · West Jordan, UTBuilt 1969 · S/N 310P0118 N5819MJones Kathleen W · Springfield, ORBuilt 1969 · S/N 310P0119 N5821MMarc Inc · Bolton, MSBuilt 1969 · S/N 310P0121 N5845MPointhigh Partners Lp · Dallas, TXBuilt 1969 · S/N 310P0145 N5850MJones Michael J · Cypress, TXBuilt 1969 · S/N 310P0150 N5854MJantzen Equipment LLC · Madrid, NEBuilt 1969 · S/N 310P0154 N5857MVenturi Corp · Staunton, ILBuilt 1969 · S/N 310P0157 N5862MPortland Holdings LLC · Vista, CABuilt 1969 · S/N 310P0162 N586JRHuerta Holdings Inc · Santa Ana, CABuilt 1969 · S/N 310P0165 N5872MDixon Jack · Casa Grande, AZBuilt 1969 · S/N 310P0172 N5877MBrook Ash Inc · Waxahachie, TXS/N 310P0177 N5885MButler Richard A · Portland, TXBuilt 1969 · S/N 310P0185 N5911MYataco Enrique · Dothan, ALS/N 310P0211 N5913MWallace Larry Wayne · Millsap, TXBuilt 1969 · S/N 310P0213 N5914MBogie Aviation LLC · Newton, NJBuilt 1969 · S/N 310P0214

Back to Cessna 310P