Skip to content

Registered aircraft · 706

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

N6303TPink Pilot LLC · Madison, WIBuilt 1983 · S/N R18201965 N6304TOverseas Flyway LLC · Tavernier, FLBuilt 1983 · S/N R18201966 N6319TSunland Aviation LLC · Swansboro, NCBuilt 1984 · S/N R18201977 N6321TTwo One Tango LLC · Waynesboro, PABuilt 1984 · S/N R18201978 N6332T32 Tango Aviation LLC · Beaverton, ORBuilt 1984 · S/N R18201984 N6346TNemec Jeffery W · Bowling Green, KYBuilt 1984 · S/N R18201989 N6347TWang Peter Z · Germantown, MDS/N R18201990 N6355TBrazos Valley Flight Services LLC · College Station, TXBuilt 1984 · S/N R18201994 N6369TRegistered aircraftBuilt 1984 · S/N R18201998 N6374TPlane Fun Inc Tr Trustee · Snellville, GAS/N R18202001 N6377TTango Romeo Golf LLC · Wilmington, DES/N R18202003 N6391TWebco Aviation LLC · Clay, KYBuilt 1985 · S/N R18202009 N6398SInternational Air Services Inc Trustee · Carson City, NVS/N R18201670 N6399T2f Trade LLC · Collinsville, TXBuilt 1985 · S/N R18202011 N64027Snyder Brent R · Dallas, TXBuilt 1985 · S/N R18202021 N6418TRobo Flight Air Support LLC · Inver Grove Height, MNBuilt 1985 · S/N R18202016 N6420TJetran LLC · Horseshoe Bay, TXS/N R18202017 N6426TS O W Aviation LLC · Crystal River, FLS/N R18202019 N6433TCole Richard J · Rolla, MOBuilt 1985 · S/N R18202022 N644Wine Street Aviation LLC · Livermore, CABuilt 1982 · S/N R18201927 N6444TYankee Flying Club Inc · Maple Grove, MNBuilt 1985 · S/N R18202026 N6465THurricane Corp · New York, NYS/N R18202033 N6476TAngel Air Ltd · Smithvile, OHBuilt 1986 · S/N R18202035 N6477TPhillips Christopher R · Peoria, AZBuilt 1986 · S/N R18202036 N6504SNurmi Forrest Cal · Burlington, WABuilt 1980 · S/N R18201687 N65268Armstrong Chad William · Otsego, MNBuilt 1979 · S/N R18201008 N6562SWhite John Scott · Summerfield, NCBuilt 1981 · S/N R18201691 N656DGD Gordon Aviation Inc · La Jolla, CABuilt 1977 · S/N R18200042 N681JBJuliet Bravo Aviation LLC · South Padre Island, TXBuilt 1980 · S/N R18201672 N695XCloud 9 Aviation LLC · Bismarck, NDBuilt 1980 · S/N R18201592 N700MTJoey O'S LLC · Darlington, PAS/N R18200996 N701SDRescue Ministry Corp · Haines City, FLBuilt 1980 · S/N R18201548 N702SDVaughn Gregory T · Santa Fe, TXS/N R18200293 N703BSOne Grand Adventure LLC · Green Bay, WIS/N R18201930 N705RStatewide Contract Services LLC · Lowell, ORBuilt 1986 · S/N R-18202037 N706HPFlorida Highway Patrol · Tampa, FLBuilt 1985 · S/N R18202013 N707CTShaak John C · Newnan, GABuilt 1978 · S/N R18200320 N711DTMcclellion W Richard · Anderson, SCBuilt 1979 · S/N R18201061 N711EZSparrow International LLC · Littleton, COBuilt 1977 · S/N R18200135 N7131SMaya Aircraft Holdings LLC · Lee, NHBuilt 1981 · S/N R18201697 N7139TPhilpot John Michael · Liberty, MOS/N R18200025 N7140TMurray Robert S Trustee · Shingle Springs, CABuilt 1977 · S/N R18200026 N7150SGabrial Aviation LLC · New Berlin, WIBuilt 1981 · S/N R18201699 N718MJValiair Ltd Co Trustee · Casper, WYBuilt 1978 · S/N R18200461 N71WFRobins David M · Tehachapi, CAS/N R18200618 N721KCVan Brunt Paul A · East Bethel, MNBuilt 1977 · S/N R18200090 N7301WFry Mark · Danville, PABuilt 1977 · S/N R18200051 N7302WSanders Robert E · Whitewater, MOBuilt 1977 · S/N R18200052 N7303YCedar River Flyers · Seattle, WABuilt 1977 · S/N R18200114 N7304TGalaxy Aviation LLC · Nantucket, MAS/N R18200027

Back to Cessna R182