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.

N6345ZAerial Transport LLC · Dover, DEBuilt 1981 · S/N U20606246 N6357XMaanum Scott R · Park Rapids, MNBuilt 1980 · S/N U20605863 N6358SStancil Joseph E Jr · Eagle River, AKBuilt 1982 · S/N U20606557 N6392ZFlorence Michael · Portsmouth, NHBuilt 1981 · S/N U20606264 N6405XArctic Aviation Leasing LLC · Anchorage, AKBuilt 1980 · S/N U20605870 N6491ZAndolina Richard F Jr · Hornell, NYBuilt 1981 · S/N U20606293 N6492UWisber Peter F Jr · Perkasie, PABuilt 1979 · S/N U20605489 N651SPNew York State Police · Latham, NYBuilt 1986 · S/N U20606996 N6610RSonday Terrance · Spring, TXBuilt 1984 · S/N U20606822 N670JHNatural Resources Engineering Co Pa · Superior, WIFirst renewal noticeBuilt 1978 · S/N U20604489 N67JAJaars Inc · Waxhaw, NCBuilt 1980 · S/N U20605781 N68JFAjs Aviation LLC · Warroad, MNS/N U20606728 N6994MParish John L Sr · Tullahoma, TNBuilt 1978 · S/N U20604513 N6MFMission Aviation Fellowship · Nampa, IDS/N U20605926 N707WJLandry Don T · Thousand Oaks, CABuilt 1977 · S/N U20604054 N7162DFaulkner Winthrop Sewell · Anchorage, AKBuilt 1978 · S/N U20604342 N721NRUS Department Of The Interior · Boise, IDBuilt 1985 · S/N U20606902 N7222NN B Tweet & Sons · Nome, AKBuilt 1976 · S/N U20603568 N723FClear Skies LLC · Stuart, FLBuilt 1983 · S/N U20606714 N7247NMartin Christian E · Amagansett, NYBuilt 1976 · S/N U20603582 N7267NSwalling John C · Anchorage, AKBuilt 1976 · S/N U20603594 N7269NAk Air Leasing LLC · Homer, AKBuilt 1976 · S/N U20603595 N7276NDancer Aviation LLC · Delphos, OHBuilt 1976 · S/N U20603597 N727NEDeeair Ltd · Dayton, OHBuilt 1979 · S/N U20605152 N728United States Department Of Interior · Boise, IDBuilt 1985 · S/N U20606877 N7304NCoastal Aviation Export LLC · Wilmington, DEBuilt 1976 · S/N U20603607 N7320GDelaware Aircraft Trust LLC Trustee · New Castle, DEBuilt 1977 · S/N U20603763 N732JMGarcia Victor C · Cameron Park, CABuilt 1978 · S/N U20604685 N732NSCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1978 · S/N U20604704 N732RURegistered aircraftBuilt 1978 · S/N U20604713 N732YZNevada Helicopter Leasing LLC · Greenwood Village, COBuilt 1979 · S/N U20604741 N733KDLake Clark Holdings LLC · Port Alsworth, AKBuilt 1978 · S/N U20604772 N7349CMcbride Patrick J · Anchorage, AKBuilt 1977 · S/N U20603888 N734CXMount Crillon LLC · Juneau, AKBuilt 1978 · S/N U20604823 N734EJLavery Sam · Morgantown, WVBuilt 1978 · S/N U20604828 N734GWRwr Air Inc · Tok, AKBuilt 1978 · S/N U20604832 N734HXWaters Aero- Marine Inc DBA · South Thomaston, MES/N U20604837 N734PPKelley Jon B · Anchorage, AKBuilt 1979 · S/N U20604855 N734WEMattie Joseph G · Ester, AKBuilt 1979 · S/N U20604883 N735CEKangas Randy P · Fairbanks, AKS/N U20604899 N735JTStationair 6 LLC · Corinth, MSBuilt 1979 · S/N U20604930 N735LSPatrick Andrew · Boise, IDBuilt 1979 · S/N U20604937 N735MPHelms Aviation Inc · Long Lake, NYBuilt 1979 · S/N U20604940 N735MWWaddell Byron · Henderson, NVBuilt 1979 · S/N U20604942 N735MYVanderpool Robert W · Red Devil, AKBuilt 1979 · S/N U20604943 N735QPCulver Marc D · Anchorage, AKBuilt 1979 · S/N U20604952 N735XVGps Land Company LLC · Brandon, MSBuilt 1979 · S/N U20604980 N7360CKacoyanis John George · Bedford, NHS/N U20603898 N7367CRuebling Edward X · Anchorage, AKBuilt 1977 · S/N U20603905 N7375NEllison Air Inc · Anchorage, AKS/N U20603641

Back to Cessna U206G