Skip to content

Registered aircraft · 277

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

N100ELLeading Edge Leasing LLC · Wilmington, DES/N 310Q-0688 N100JHSonic Aviation LLC · Carrollton, MSBuilt 1971 · S/N 310Q0421 N100TGBengtson Todd · Tyler, TXBuilt 1974 · S/N 310Q1150 N105CWStone George Michael Jr Trustee · Weeki Wachee, FLBuilt 1974 · S/N 310Q-0936 N10ETTech Nav LLC · Columbus, INBuilt 1971 · S/N 310Q0415 N10FCKnott Me LLC · Phoenix, AZBuilt 1973 · S/N 310Q0796 N110CSFlorida Keys Flight Academy LLC · Marathon, FLBuilt 1972 · S/N 310Q0616 N117KZRichards Robert · Waco, TXS/N 310Q0964 N117TCChristensen Del S · Friendswood, TXBuilt 1973 · S/N 310Q0786 N1202GTyler Brenda · Mountain Top, PABuilt 1974 · S/N 310Q1057 N1205GKnapp James Ross · Apex, NCBuilt 1974 · S/N 310Q1060 N121DRJohnson And Son Enterprises · Dunn, NCBuilt 1974 · S/N 310Q1046 N121LATgl Inc · Wilmington, DEBuilt 1973 · S/N 310Q0973 N1228GMcdaniel Dean K · Mesa, AZBuilt 1974 · S/N 310Q1081 N122AMHarper David · New Richmond, WIBuilt 1973 · S/N 310Q0943 N122EOne Two Two Echo Aviation LLC · Cincinnati, OHBuilt 1973 · S/N 310Q0984 N123CWCoastal Wings LLC · Fort Lauderdale, FLS/N 310Q0975 N123MNFoster Aviation And Mobile Maintenance LLC · Dublin, VABuilt 1972 · S/N 310Q0602 N1240GBas Part Sales LLC · Greeley, COBuilt 1974 · S/N 310Q1091 N1242GHeathington A H · Georgetown, TXBuilt 1974 · S/N 310Q1093 N1247GNafziger Aviation Leasing LLC · Wittman, MDBuilt 1974 · S/N 310Q1098 N1258GConroy Bruce M · Martinez, CABuilt 1974 · S/N 310Q1109 N1267GChesnut James Scott · Oak Point, TXBuilt 1974 · S/N 310Q1118 N1271GSee Christopher · Owenton, KYS/N 310Q1122 N1276GCarter Joseph C · Brookline, NHBuilt 1974 · S/N 310Q1126 N1279GHodgman Gary W · Greenville, TXBuilt 1974 · S/N 310Q1129 N1292GBahig Saliba · Scottsdale, AZBuilt 1974 · S/N 310Q1141 N1293VEgmond Aircraft LLC · Lewes, DES/N 310Q1038 N12CYYeagle Aviation Inc · Port Saint Lucie, FLBuilt 1971 · S/N 310Q0247 N1306GCitadel Engineering Inc · Ellendale, DEBuilt 1974 · S/N 310Q1148 N1308GRed Over White Aviation · Louisville, KYBuilt 1974 · S/N 310Q1149 N1311GGranite Mountain Flight Training LLC · Prescott, AZBuilt 1974 · S/N 310Q1152 N1314GBas Part Sales LLC · Greeley, COBuilt 1974 · S/N 310Q1154 N1322GSmetters Jeffrey L · Crystal Lake, ILBuilt 1974 · S/N 310Q1160 N141DEEssex Lisa · Oceanside, CABuilt 1973 · S/N 310Q-0805 N145SWShore Gerry · Inez, TXBuilt 1973 · S/N 310Q-0614 N1549TPalmer Jonathan L · The Woodlands, TXBuilt 1973 · S/N 310Q0755 N15JDSwanson Alec · Hanahan, SCBuilt 1972 · S/N 310Q0476 N187WWOsprey Aviation LLC · Riva, MDBuilt 1971 · S/N 310Q0252 N19DBDcs Air LLC · Pulaski, WIBuilt 1972 · S/N 310Q0668 N19LFN19lf Corp · Oak Lawn, ILBuilt 1972 · S/N 310Q0622 N20162Wateractive43 LLC · Auburn, CABuilt 1974 · S/N 310Q-1004 N20NGTas Aviation Of Defiance Inc · Defiance, OHBuilt 1971 · S/N 310Q0276 N21430Burns Preston · Spruce Pine, ALBuilt 1990 · S/N 310Q1073 N214WGriffeth John · Branson, MOBuilt 1969 · S/N 310Q0061 N218USouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 310Q0507 N21CSHendrix Peter A · Plantation, FLBuilt 1973 · S/N 310Q0963 N21FC310 Pals LLC · Lake City, FLBuilt 1974 · S/N 310Q1080 N21KBLow Carl S III · Aurora, TXBuilt 1973 · S/N 310Q0777 N22ECDoose Christopher A · Memphis, TNBuilt 1973 · S/N 310Q0732

Back to Cessna 310Q