Skip to content

Registered aircraft · 140

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

N103RMValiair Lc Trustee · Casper, WYBuilt 1975 · S/N 310R0109 N107TTBpi Labs Inc · Evanston, WYBuilt 1978 · S/N 310R1345 N112WWAmerican Smooth Aviation LLC · Rock Hill, SCBuilt 1977 · S/N 310R1215 N140RBKessler Nicholas · Central Point, ORBuilt 1979 · S/N 310R1807 N1420NKlomhaus Paul · Poplar, WIBuilt 1978 · S/N 310R1398 N16EZAmerican Aerial Survey Inc · Rancho Murieta, CABuilt 1978 · S/N 310R1277 N1716EMccaskill William L · Hampton, VABuilt 1978 · S/N 310R1547 N1742ECole-Tac LLC · Rapid City, SDBuilt 1978 · S/N 310R1558 N176MMRair Air Inc · Stateline, NVBuilt 1976 · S/N 310R0710 N1781ECallaham John · Broken Bow, OKBuilt 1979 · S/N 310R1571 N1821EHth Companies Inc · Union, MOBuilt 1979 · S/N 310R1581 N1856EGv Air Inc · Medford, ORBuilt 1979 · S/N 310R1591 N18DLBelov Mikhail · Greenwood Village, COBuilt 1977 · S/N 310R1251 N1908GAir Z Flying Service Inc · Richmond Heights, OHBuilt 1974 · S/N 310R0055 N1918JCoastal Satellite Inc · Woodland Hills, CABuilt 1976 · S/N 310R0703 N197DB310 Flyers LLC · Lafayette, LAS/N 310R1809 N213MRogers Ronald J · Crystal Lake, ILBuilt 1978 · S/N 310R1335 N222STEau Claire Aviation LLC · Eau Claire, WIBuilt 1976 · S/N 310R0679 N22AMJays Aircraft Maintenance Inc · Costa Mesa, CABuilt 1979 · S/N 310R1634 N22GBHolland Kenneth F Trustee · Santa Clarita, CABuilt 1977 · S/N 310R1237 N232ASGuggenair LLC · Carbondale, COBuilt 1978 · S/N 310R1369 N234TCAg N234tc LLC · South Salt Lake, UTBuilt 1974 · S/N 310R0050 N240SQMigster LLC · Miami, FLBuilt 1975 · S/N 310R0273 N2635XN2635x LLC · Eau Claire, WIS/N 310R1642 N2638XSoftware 2000 Inc · Arroyo Grande, CABuilt 1979 · S/N 310R1666 N2641PChandler David G · Phoenix, AZBuilt 1979 · S/N 310R1679 N2642ACronin LLC · Jacksonville, FLBuilt 1979 · S/N 310R1682 N2642YStallings Ted W · Seldovia, AKS/N 310R1684 N2644VCrosby David · Potomac, MDBuilt 1979 · S/N 310R1812 N2664Lcj Holdings LLC · Youngsville, LAS/N 310R0195 N300BDAircraft Inc · White Bear Lake, MNBuilt 1975 · S/N 310R0258 N310ADChang Stephen · Santa Barbara, CABuilt 1976 · S/N 310R0538 N310AMCwr Enterprises Inc · Henderson, NCBuilt 1979 · S/N 310R1672 N310BARampey Alvin H Jr · Atlanta, GABuilt 1975 · S/N 310R0065 N310BFGv Air Inc · Medford, ORBuilt 1978 · S/N 310R1390 N310HBSmith William G · Huntsville, TXBuilt 1980 · S/N 310R1876 N310HDWwdd Enterprises LLC · Port Orange, FLBuilt 1975 · S/N 310R0519 N310HMInternational Air Services Inc Trustee · Carson City, NVBuilt 1978 · S/N 310R1282 N310JABruner Matthew · Scottsbluff, NEBuilt 1978 · S/N 310R-1319 N310JGMarc Inc · Bolton, MSBuilt 1979 · S/N 310R1567 N310JNAustin Baumgarten Inc · Tomah, WIBuilt 1977 · S/N 310R0979 N310JWWharton Melissa P · Wise, VABuilt 1977 · S/N 310R0956 N310KMStitt Consulting Inc · Titusville, FLBuilt 1979 · S/N 310R1675 N310LDAbq 421 LLC · Albuquerque, NMBuilt 1977 · S/N 310R0922 N310LPIsaacs W Bradford · Las Vegas, NVBuilt 1979 · S/N 310R1656 N310MAustin Security Inc · Battleboro, NCS/N 310R0554 N310MGGoroff Marc · Livermore, CABuilt 1976 · S/N 310R0724 N310MWKeystone Aerial Surveys Inc · Philadelphia, PABuilt 1976 · S/N 310R0823 N310PMGv Air Inc · Medford, ORBuilt 1976 · S/N 310R0670 N310PSRoe Fabricators Inc · Chester, PABuilt 1975 · S/N 310R-0559

Back to Cessna T310R