Skip to content

Registered aircraft · 1,177

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

N2971CTailwinds Air Inc · Morganza, LABuilt 1954 · S/N 30871 N2972AEaston Bob C · Lasalle, COBuilt 1953 · S/N 30172 N2973ARed Aero LLC · Grand Junction, COBuilt 1953 · S/N 30173 N2973CHayton James B · Sedro Woolley, WABuilt 1954 · S/N 30873 N2975APike Martin Craig · Mountain Home, IDS/N 30175 N2975CBarton Matthew R · Prescott, AZBuilt 1954 · S/N 30875 N2976AGore Thomas H · Mill Valley, CABuilt 1953 · S/N 30176 N2977CGastrich Cynthia A · Wasilla, AKBuilt 1954 · S/N 30877 N2978ASherwood Jesse Lee · Homer, AKS/N 30178 N2978CPratt Guy D · Oregon City, ORS/N 30878 N2980CBrown Cow LLC · Eagle River, AKS/N 30880 N2982ASkywagon Pilots Inc · Santa Clara, CABuilt 1953 · S/N 30182 N2984CRosser Brian K · Minden, NVBuilt 1954 · S/N 30884 N2985CBraham John P · Fairbanks, AKBuilt 1954 · S/N 30885 N2986AMorris Blain E · Delta Junction, AKBuilt 1953 · S/N 30186 N2987CYount Lawrence F · Shelton, WABuilt 1954 · S/N 30887 N2990ATottle K M DBA · Limington, MEBuilt 1953 · S/N 30190 N2990CLyng Stephen G · Kenosha, WIBuilt 1954 · S/N 30890 N2993CFrei Jayci N · Grangeville, IDS/N 30893 N2994ADicicco Matthew Trustee · Los Gatos, CABuilt 1953 · S/N 30194 N2996CSutton Aircraft Salvage LLC · Palmer, AKBuilt 1954 · S/N 30896 N2997CSmith Philip W · Copeland, KSBuilt 1955 · S/N 30897 N2999AFindly Raymond Lee · Ravenna, KYBuilt 1953 · S/N 30199 N2999CCarnine Daniel L · Seeley Lake, MTBuilt 1954 · S/N 30899 N29KMDebonair Consulting Inc · Wilmington, DEBuilt 1955 · S/N 31579 N3100CBannon Daren · Douglass, KSBuilt 1954 · S/N 31156 N3100DDiel Mark A · Walnut Creek, CABuilt 1955 · S/N 31898 N3101CFreefall Fever Inc · Edgewater, FLBuilt 1954 · S/N 30900 N3102DOsowski Christopher J · Anchorage, AKBuilt 1955 · S/N 31900 N3103CBay Kelly M Trustee · Glennallen, AKBuilt 1954 · S/N 30902 N3105DHenderson Raymond N · Kosciusko, MSBuilt 1955 · S/N 31903 N3106CPetrie Michael · Chugiak, AKBuilt 1954 · S/N 30905 N3108DOchsenbauer David J · Ashland, WIBuilt 1955 · S/N 31906 N3112CBagley Benjamin H · Rome, GAS/N 30911 N3113DWooliver Steve P · Wasilla, AKBuilt 1955 · S/N 31911 N3115DSmith Gregory · Lewistown, MTBuilt 1955 · S/N 31913 N3117DTwin Oaks Aircraft Maintenance LLC · Hillsboro, ORBuilt 1955 · S/N 31915 N3118DNau Howard A · Melba, IDBuilt 1955 · S/N 31916 N3121DFrey Jerry P · Fallon, NVBuilt 1955 · S/N 31919 N3123CRmc Aviators LLC · Wilmington, DEFirst renewal noticeBuilt 1954 · S/N 30922 N3124DBurch David C · Flushing, MIBuilt 1955 · S/N 31922 N3125DDavis Ronald L Jr · Soldotna, AKBuilt 1955 · S/N 31923 N3126CWest Leland Dan · Elverta, CAS/N 30925 N3126DMyers Martin John Trustee · Juneau, AKBuilt 1955 · S/N 31924 N3127CChaar LLC · Lock Haven, PAS/N 30926 N3127DE & S Group LLC DBA · Columbia, CABuilt 1955 · S/N 31925 N3127EAllison John W Jr · Brighton, COBuilt 1953 · S/N 30087 N3128DCopsey Harvey J · Tucson, AZBuilt 1955 · S/N 31926 N3129DHawgs Landing LLC · Warrensburg, MOBuilt 1955 · S/N 31927 N3130CUlrich Alex E · Atlanta, ILBuilt 1954 · S/N 30929

Back to Cessna 180