Skip to content

Registered aircraft · 486

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

N9560XSammons Richard Allen · Glen Arm, MDBuilt 1986 · S/N 18268556 N9573XLenyk Michael · Venice, FLBuilt 1986 · S/N 18268558 N9575HBoca Aircraft Partners Inc · Coral Springs, FLBuilt 1981 · S/N 18267965 N9577XColumbia Asset Trust Corp Trustee · Wichita, KSS/N 18268560 N9579EAdventist World Aviation · Wilson, NCBuilt 1984 · S/N 18268428 N9579XHayden Luke S · Yardley, PABuilt 1986 · S/N 18268561 N9602HC & J Flight Co LLC · Sardis, MSBuilt 1981 · S/N 18267969 N9611HTarheel Aviators LLC · Cary, NCBuilt 1981 · S/N 18267972 N9616ELove James H · Springville, ALBuilt 1984 · S/N 18268429 N9619EHofer Terril D · Maple Grove, MNBuilt 1984 · S/N 18268430 N961WSWalt Schwartz Aviation LLC · Louisville, KYBuilt 1985 · S/N 18268462 N9620EJones Benjamin J · Little Rock, ARBuilt 1984 · S/N 18268431 N9630XSea-S-Ta Aviation LLC · Alexandria, VABuilt 1986 · S/N 18268568 N9633XCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1986 · S/N 18268570 N9638XPiper Earl Holdings LLC · Newark, DEBuilt 1986 · S/N 18268572 N9649XRp Aviation LLC · Plattsmouth, NEBuilt 1986 · S/N 18268577 N9656XCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1986 · S/N 18268580 N9658XSale Reported · Ozark, ALSale reportedBuilt 1986 · S/N 18268582 N9660XDodson International Parts Inc · Rantoul, KSBuilt 1986 · S/N 18268583 N9669XThc Aero LLC · Boise, IDBuilt 1986 · S/N 18268584 N9687EFrohbieter Jack A · Newtown, PABuilt 1984 · S/N 18268437 N9698EPark Rapids Avionics Inc · Park Rapids, MNBuilt 1984 · S/N 18268438 N9704ECivil Air Patrol Inc · Maxwell Afb, ALBuilt 1984 · S/N 18268439 N9733HStephens Jack J · Kingwood, TXBuilt 1981 · S/N 18267980 N9736HBrentco Aerial Patrol Inc · Canton, OHBuilt 1981 · S/N 18267983 N9737HXyz Aviation LLC · Rineyville, KYBuilt 1981 · S/N 18267984 N9738HBallard Bradley J · Youngsville, NCBuilt 1981 · S/N 18267985 N9742HSingularity - Intelligence Amplified LLC · Conesus, NYBuilt 1981 · S/N 18267989 N9755HQualitair LLC Trustee · MichelstadtBuilt 1981 · S/N 18267997 N9758HBlue Sky Aviation Association Inc · Readington, NJBuilt 1981 · S/N 18268000 N9761HBrentco Aerial Patrol Inc · Canton, OHBuilt 1981 · S/N 18268003 N9767HSwanson Joseph C · Blairsville, GABuilt 1981 · S/N 18268008 N9769HBac Leasing Inc · Cape Girardeau, MOBuilt 1981 · S/N 18268009 N9771HJones Troy Tr · Wickenburg, AZBuilt 1981 · S/N 18268010 N9772HHale Job Daniel · Bethel, AKBuilt 1981 · S/N 18268011 N9773HCso Aviation LLC · Helena, MTS/N 18268012 N9774HCarnighan Kelly · New Albany, INBuilt 1981 · S/N 18268013 N9775EManu Aviation LLC · Honolulu, HIBuilt 1985 · S/N 18268445 N9779HThundering Herd Aviation LLC · Galena, OHFirst renewal noticeBuilt 1981 · S/N 18268017 N9780HN9780h LLC · Lagrange, GABuilt 1981 · S/N 18268018 N9781HBlair Leonard · Fleetwood, PABuilt 1981 · S/N 18268019 N9784HPokey Airlines LLC · Reno, NVBuilt 1981 · S/N 18268021 N9785HDorroh Brooks G · Ramona, CABuilt 1981 · S/N 18268022 N9786HTerra Mar Ceil LLC · Pompano Beach, FLBuilt 1981 · S/N 18268023 N9787HMiller Gregg A · New Port Richey, FLBuilt 1981 · S/N 18268024 N9788HUnited States Air Force · Usaf Academy, COBuilt 1981 · S/N 18268025 N9789HAerosess LLC · Clarendon Hills, ILBuilt 1981 · S/N 18268026 N9791HNoga Timothy · Corvallis, MTBuilt 1981 · S/N 18268027 N9793HYarmo Robert P · Pelham, NHBuilt 1981 · S/N 18268028 N9799ESkyhigh Trade LLC · Wilmington, DEBuilt 1984 · S/N 18268447

Back to Cessna 182R