Skip to content

Registered aircraft · 361

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

N103EMSjm Aero LLC · Winter Haven, FLS/N 310R0083 N103FSHannah Lonnie · Williamson, WVBuilt 1979 · S/N 310R1834 N10BDCalkins Mark E · Longview, TXBuilt 1978 · S/N 310R1539 N111EAExecutive Air Inc · Roanoke, VAS/N 310R0245 N111NCDaxair Aviation LLC · Scottsdale, AZBuilt 1975 · S/N 310R0182 N113KKolstad Christopher Van · Galata, MTBuilt 1975 · S/N 310R0107 N114AMLon Air LLC · Longwood, FLBuilt 1977 · S/N 310R0887 N11GXWestrum Enterprises LLC · Norwalk, IABuilt 1976 · S/N 310R0645 N11TJKubic Daniel W · Advance, NCBuilt 1979 · S/N 310R1683 N1203WPro Aire Cargo & Consulting Inc · Oshkosh, WIBuilt 1980 · S/N 310R-2106 N121BKSeabee Training Corp · Birmingham, ALBuilt 1977 · S/N 310R0893 N122SBCessna Twin Flyers LLC · Calhoun, TNS/N 310R0873 N124DPBaja Air LLC · Wilmington, DEBuilt 1979 · S/N 310R1670 N126TMFlynfish Air LLC · Rome, GAS/N 310R1231 N1274GSol Aerial Surveys LLC · Las Vegas, NVBuilt 1974 · S/N 310R0001 N127MBBerger Max · Daytona Beach, FLBuilt 1976 · S/N 310R0654 N1280GSky Aviation And Consulting · Panorama City, CABuilt 1976 · S/N 310R0692 N1296GAir Dogs LLC · Watford City, NDBuilt 1976 · S/N 310R0698 N1297GPilot Mountain Aviation LLC · Marietta, OHBuilt 1974 · S/N 310R0003 N129ASPyxis Air LLC · Wilmington, DEBuilt 1976 · S/N 310R0663 N131PBTom Tatum Pa · Danville, ARBuilt 1975 · S/N 310R0514 N1321GInnovative Poultry Products LLC · Olar, SCBuilt 1976 · S/N 310R0701 N1338GWings Air Charter LLC · Wisconsin Rapids, WIBuilt 1974 · S/N 310R0022 N1339GLyon Aviation Inc · Pittsfield, MABuilt 1974 · S/N 310R0023 N133CWDeniro Corp · Hampton, NHBuilt 1978 · S/N 310R1260 N1342GSpector Steven D · Glenview, ILBuilt 1974 · S/N 310R0026 N1346GClear Blue Aviation LLC · Melbourne, FLBuilt 1974 · S/N 310R0029 N1349GWings Of Grace Ministries Inc · Melbourne, FLBuilt 1976 · S/N 310R0706 N1351G310 LLC · Conover, NCBuilt 1976 · S/N 310R0708 N1359GEaglehead Aviation LLC · Tifton, GABuilt 1976 · S/N 310R0714 N1371GFall Gregory F · Hanson, MABuilt 1976 · S/N 310R0725 N137DMiller Aviation LLC DBA · Huntington, INBuilt 1981 · S/N 310R2136 N13PKOaks Aviation LLC · Clear Lake, MNBuilt 1981 · S/N 310R2127 N142CTMiddleton Charles H · Hamilton, INBuilt 1976 · S/N 310R0629 N143SWBb&D Airways LLC · N Redngtn Bch, FLS/N 310R1856 N150BGMbw Aviation LLC · Bay City, MIS/N 310R-0635 N1565TForbes Consolidated Inc · New Smyrna Beach, FLBuilt 1974 · S/N 310R0063 N1581GKovach Kenneth R · Jefferson, OHBuilt 1979 · S/N 310R1593 N15TVDfl Management Corp · New Castle, DES/N 310R0945 N15WRAcmc Operations LLC · Cedar Park, TXBuilt 1975 · S/N 310R0553 N168EDTsg Aviation LLC · Wyandotte, MIBuilt 1975 · S/N 310R0134 N169DKStanton James · North Barrington, ILBuilt 1978 · S/N 310R1412 N1718ECaptain Kenny J LLC · Holiday, FLBuilt 1978 · S/N 310R1548 N1735ERsc Ventures LLC · Phoenix, AZBuilt 1978 · S/N 310R1555 N1737EKeystone Aerial Surveys Inc · Philadelphia, PABuilt 1978 · S/N 310R1556 N1768ERoyal Air Freight Inc · Waterford, MIBuilt 1978 · S/N 310R1566 N1784EHigh Road Time LLC · West Palm Beach, FLBuilt 1979 · S/N 310R1574 N1791ESol Aerial Surveys LLC · Las Vegas, NVBuilt 1979 · S/N 310R1576 N1795ERb Aviation LLC · Tyler, TXBuilt 1979 · S/N 310R1577 N1796GHorowitch Alan · San Diego, CABuilt 1975 · S/N 310R0048

Back to Cessna 310R