Skip to content

Registered aircraft · 423

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

N1869XFlying Yankees Inc · Nashua, NHBuilt 1964 · S/N 18255969 N1871XEveland Scott B · Waukesha, WIBuilt 1964 · S/N 18255971 N1872XHogsett Steve R · Barboursville, WVBuilt 1965 · S/N 18255972 N1876XCrow Bill D · Yorba Linda, CABuilt 1965 · S/N 18255976 N1877XOrehotsky David W · Dallas, PABuilt 1964 · S/N 18255977 N1880XKarod John W · Union, MEBuilt 1964 · S/N 18255980 N1882XWagner Robert W · Casper, WYBuilt 1965 · S/N 18255982 N1884XKaines John L · Ludington, MIBuilt 1965 · S/N 18255984 N1892XCuvar Philip M · Granite City, ILBuilt 1965 · S/N 18255992 N1894XCorso Aviation LLC · Southlake, TXBuilt 1964 · S/N 18255994 N1896XSmr Holdings LLC · Martinsburg, WVBuilt 1964 · S/N 18255996 N1900XAtkinson Ron D · Myrtle Creek, ORBuilt 1965 · S/N 18256000 N1901XBuehler Jon R Trustee · Scott City, KSBuilt 1965 · S/N 18256001 N1902XKelly Jerome · Babbitt, MNBuilt 1965 · S/N 18256002 N1903XAivcon Inc · Charlevoix, MIBuilt 1965 · S/N 18256003 N1906XLawless Mark · Des Moines, IABuilt 1965 · S/N 18256006 N1909XBowie Dana M · England, ARBuilt 1965 · S/N 18256009 N1911XSs Aviation LLC · Preston, IDBuilt 1965 · S/N 18256011 N1912XWhite Charles S · Anacortes, WABuilt 1965 · S/N 18256012 N1913XYates Craig J · Indialantic, FLBuilt 1965 · S/N 18256013 N1920XJensen Richard Vaughn · Emmett, IDBuilt 1965 · S/N 18256020 N1922XHerman Joseph T · Lovell, WYBuilt 1965 · S/N 18256022 N1924XTahiac Aviation LLC · Berryton, KSS/N 18256024 N1925XBtak LLC · New Baden, ILBuilt 1965 · S/N 18256025 N1926XWilkerson Kelvin E Jr · Kannapolis, NCBuilt 1965 · S/N 18256026 N1930XDuff James J · Pueblo, COBuilt 1965 · S/N 18256030 N1931XRuffner Ryon Garrett · Argyle, TXBuilt 1965 · S/N 18256031 N1933XHall Michael D · Athens, ALBuilt 1965 · S/N 18256033 N1934XMarshall Michael R · Collierville, TNBuilt 1965 · S/N 18256034 N1936XNelson William T · Benton, KYBuilt 1965 · S/N 18256036 N1937XOrtiz Marquez Ricardo A · Melbourne, FLBuilt 1965 · S/N 18256037 N1939X1939xray LLC · Chester, SCBuilt 1965 · S/N 18256039 N1945XStepps Dana · Humboldt, TNBuilt 1965 · S/N 18256045 N1948XGreenwood Auto LLC · Itta Bena, MSBuilt 1965 · S/N 18256048 N1951XSkyline Aircraft Maintenance Inc · Nampa, IDBuilt 1965 · S/N 18256051 N1954XStull David H · Sausalito, CABuilt 1965 · S/N 18256054 N1957XDrummond Michael S · Burlington, NCBuilt 1965 · S/N 18256057 N1958XOrth Matthew B · Marion, KSS/N 18256058 N1960XPena Fermina · Brentwood, NYBuilt 1964 · S/N 18256060 N1967XInternational Air Services Inc Trustee · Carson City, NVBuilt 1965 · S/N 18256067 N1969XCrouch Jeffrey L · Rockingham, NCBuilt 1965 · S/N 18256069 N1970XJohnson Christopher S · Portland, ORBuilt 1965 · S/N 18256070 N1971XHigh Country Air Service LLC · Albuquerque, NMBuilt 1965 · S/N 18256071 N1973XSuttle Joseph Scott · Moody, ALBuilt 1965 · S/N 18256073 N1975XFirefly Aviation LLC · Apison, TNBuilt 1965 · S/N 18256075 N1976XGmss LLC · San Diego, CABuilt 1965 · S/N 18256076 N1981XB2 Aviation LLC · Sisters, ORBuilt 1965 · S/N 18256081 N1982XWheeler Joseph T · Chandler, AZS/N 18256082 N1984X140kts LLC · Quilcene, WABuilt 1965 · S/N 18256084 N1988XN1988x LLC · Erie, COBuilt 1965 · S/N 18256088

Back to Cessna 182H