Skip to content

Registered aircraft · 347

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 ('2073356', '2073315', '2073314')
  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 ('2073356', '2073315', '2073314')
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.

N740United States Department Of Interior · Boise, IDBuilt 1980 · S/N U20605724 N7433NFixed Gear LLC · Sherwood, ARBuilt 1977 · S/N U20603660 N7448NCcx-2000-0111 LLC · Garberville, CABuilt 1977 · S/N U20603662 N749KPKalinin Partners LLC · Juneau, AKBuilt 1980 · S/N U20605554 N749SPNew York State Police · Latham, NYBuilt 1986 · S/N U20606957 N7539NDavis Dale L · Boerne, TXBuilt 1977 · S/N U20603666 N7567QJolley Joseph J · Anchorage, AKBuilt 1978 · S/N U20604275 N7569NArctic Aviation Leasing LLC · Anchorage, AKBuilt 1977 · S/N U20603679 N756AHKincaid Linda C · North Pole, AKBuilt 1977 · S/N U20603932 N756ANJelinek Tyson · Iola, KSBuilt 1977 · S/N U20603937 N756BBCampbell Steven P · Annapolis, CABuilt 1977 · S/N U20603950 N756BNBeck Skydiving & Rigging LLC · Bixby, OKBuilt 1977 · S/N U20603961 N756BYW Yerxa LLC · Colusa, CAS/N U20603971 N756CLEgli Sam · King Salmon, AKBuilt 1977 · S/N U20603983 N756CTKamlowsky Scott A · Anchorage, AKBuilt 1977 · S/N U20603990 N756DJSutton Aircraft Salvage LLC · Palmer, AKS/N U20604005 N756DKMeyer David A · Torrance, CABuilt 1977 · S/N U20604006 N756DLSierra Sky Aviation LLC · Kalispell, MTBuilt 1977 · S/N U20604007 N756DNSkyler Aviation Inc · San Diego, CABuilt 1977 · S/N U20604009 N756DUCordova Air Service Inc · Cordova, AKS/N U20604015 N756EJPacker Louis M · Wasilla, AKS/N U20604029 N756FMTope Transportation Co · Wasilla, AKFirst renewal noticeBuilt 1977 · S/N U20604056 N756FNLevitt Charles J · Dover Plains, NYBuilt 1977 · S/N U20604057 N756GFKlaiber Carl F · Concord, NCBuilt 1977 · S/N U20604074 N756GWSparrow Group LLC · Cheyenne, WYS/N U20604089 N756HC242 Six Logistics LLC · Wilmington, DES/N U20604095 N756HQMaricopa County Sheriffs Office · Phoenix, AZS/N U20604107 N756HRPeters Aire LLC · Brainerd, MNBuilt 1977 · S/N U20604108 N756JCBeluga LLC · Wasilla, AKBuilt 1977 · S/N U20604119 N756JGNeal J Mckenny Corp Inc · Fortuna, CABuilt 1977 · S/N U20604123 N756KCScaletta Enterprises LLC · Middleton, WIBuilt 1977 · S/N U20604143 N756KPVne Holdings Group LLC · North Canton, OHBuilt 1977 · S/N U20604154 N756LCTaiga Mining Company Inc · Anchorage, AKBuilt 1977 · S/N U20604167 N756MAFly-N-Bus Aviation LLC · Parker, COBuilt 1977 · S/N U20604189 N756MPEarp Kevin W · Eagle River, AKBuilt 1977 · S/N U20604202 N756MZSchreck Lynn G · Elk City, OKBuilt 1977 · S/N U20604212 N756NGPerrigue Thomas E · Bishop, TXBuilt 1977 · S/N U20604219 N756PFTaiga Mining Co Inc · Anchorage, AKBuilt 1977 · S/N U20604242 N756PYAssociated Pilots Inc · Concord, MABuilt 1978 · S/N U20604259 N756QGKetchum Craig L · Anchorage, AKBuilt 1978 · S/N U20604267 N756QPKako Retreat Center Inc · Russian Mission, AKS/N U20604274 N756RSMiddle Fork Aviation Inc · Challis, IDBuilt 1978 · S/N U20604301 N756SGWaters Aero Marine Inc · South Thomaston, MEFirst renewal noticeBuilt 1978 · S/N U20604315 N756SLCecs LLC · Lakewood, NYBuilt 1978 · S/N U20604319 N756UKAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1978 · S/N U20604365 N756UWTrue North Air LLC · Anchorage, AKBuilt 1978 · S/N U20604376 N756VCDavis Michelle R · Port Alsworth, AKBuilt 1978 · S/N U20604382 N756WJBritt Westley · New Paltz, NYBuilt 1978 · S/N U20604412 N756WRReinbold Frederick K · Anchorage, AKBuilt 1978 · S/N U20604566 N756XEKachemak Air Service LLC · Homer, AKBuilt 1978 · S/N U20604432

Back to Cessna U206G