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.

N100QBShutt Ryan T · Eden, NYBuilt 1979 · S/N R18201185 N1040PShogren Dennis · Grand Terrace, CAS/N R18200368 N105AAWehrmacher James P · Crawford, COBuilt 1978 · S/N R18200483 N107RHHenderson Robert T Jr · Sunny Isles Beach, FLBuilt 1977 · S/N R18200093 N10GLMakulu Adventures LLC · Fort Pierce, FLBuilt 1983 · S/N R18201934 N11131Gaglioti John · Monterey, CABuilt 1983 · S/N R18201942 N11133Hanus David S · Mound, MNBuilt 1983 · S/N R18201943 N1126CBriggs Jonathan · Merritt Island, FLBuilt 1981 · S/N R18201689 N11541Upskirt Aviation LLC · Fredericktown, MOS/N R18201914 N1188NLll Aviation LLC · Durango, COBuilt 1978 · S/N R18200538 N118SGWilt Jared · Gardners, PABuilt 1977 · S/N R18200115 N122MWWalker Kyle E · Lawrence, KSBuilt 1979 · S/N R18201276 N124HKDavid A Desimone LLC · Newnan, GAS/N R18201621 N125KCOtto Pilot Aviation LLC · Midland City, ALBuilt 1982 · S/N R18201805 N132HMMichels Agribusiness Inc · Plentywood, MTBuilt 1978 · S/N R18200844 N143LWMurphy Law Office Pc · Rapid City, SDBuilt 1979 · S/N R18201265 N164JMWind Sand & Stars Aviation LLC · San Diego, CABuilt 1978 · S/N R18200158 N1656RBollenbacher Jeffery · Terre Haute, INBuilt 1978 · S/N R18200498 N1657REnroute Direct LLC · Woodstock, GABuilt 1978 · S/N R18200499 N1661RStrong Mitchell · Batavia, NYS/N R18200502 N1664RState Of Montana · Helena, MTBuilt 1978 · S/N R18200503 N1668REdwards Air Force Base Aero Club · Edwards Afb, CABuilt 1978 · S/N R18200505 N1672RBriggs Donald L · Santa Barbara, CABuilt 1978 · S/N R18200507 N1673RGregory John F · Emmitsburg, MDBuilt 1978 · S/N R18200508 N1676RBlue Side Up LLC · Elbert, COBuilt 1978 · S/N R18200510 N1680RSchulze Roger F · Hanford, CABuilt 1978 · S/N R18200512 N1682RDelcamp Don D · Troy, OHBuilt 1978 · S/N R18200513 N1693RLeap Aviation Inc · Wilmington, DEBuilt 1978 · S/N R18200518 N1695RLehne Michael · Portland, ORBuilt 1978 · S/N R18200519 N1696RMoore Alan · Glenwood, ARS/N R18200520 N1698RRussell Robert Q · Genoa City, WIBuilt 1978 · S/N R18200521 N1699RMacdonald Eric J · Belleville, MIBuilt 1978 · S/N R18200522 N16AHendrix Aviation LLC · Benton, ARBuilt 1978 · S/N R18200405 N1702RDaniel Boone Flying Club Inc · Booneville, MOBuilt 1978 · S/N R18200523 N17059N79107 LLC · Orrville, OHBuilt 1982 · S/N R18201915 N1705RCox Brian Allen · Pasadena, CABuilt 1978 · S/N R18200525 N17132Harvey Laurence C · Lincoln, NEBuilt 1982 · S/N R18201921 N1713RNevada General Enterprises Ltd · Reno, NVBuilt 1978 · S/N R18200530 N1716RRegistration Pending · Krum, TXRegistration pendingBuilt 1978 · S/N R18200531 N171MHEvolution Solid LLC · Salem, ORBuilt 1981 · S/N R182-01766 N1721RStecher Allan · Thornton, COBuilt 1978 · S/N R18200534 N1724RBlue Eagle Aviation LLC · Azle, TXS/N R18200536 N1732RHeath William D Jr · Bremen, GABuilt 1978 · S/N R18200539 N1737RMorales Richard · Palm Springs, CABuilt 1978 · S/N R18200541 N1746RSky West Aviation Inc Trustee · Albuquerque, NMS/N R18200543 N1747RFite Rodney Edward · San Lorenzo, CABuilt 1978 · S/N R18200544 N174GPLittle Terry J · New Port Richey, FLBuilt 1979 · S/N R18201136 N1751RB&E Flying LLC · Morse Bluff, NEBuilt 1978 · S/N R18200545 N1755RMchugh Charles D · Gilbert, AZBuilt 1978 · S/N R18200547 N1757RKemna Barry J · Dallas, TXBuilt 1978 · S/N R18200548

Back to Cessna R182