Skip to content

Registered aircraft · 1,111

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

N97662Northwest Alabama Holdings LLC · Spruce Pine, ALBuilt 1984 · S/N 17276219 N97674Oc Flight Lessons LLC · Costa Mesa, CABuilt 1984 · S/N 17276220 N97681Buiqui Aerospace Corp · Kissimmee, FLBuilt 1984 · S/N 17276221 N97702Smith Jeffrey W · Yakima, WABuilt 1984 · S/N 17276222 N97705Angel Aviation Inc · Peoria, AZBuilt 1984 · S/N 17276223 N97749Beck Shylan · Blanding, UTBuilt 1984 · S/N 17276225 N97755Civil Air Patrol Inc · Maxwell Afb, ALBuilt 1984 · S/N 17276226 N97766Wiggins Air Patrol LLC · Wichita, KSBuilt 1984 · S/N 17276228 N97779Kool Wings Leasing LLC · Indianapolis, INBuilt 1984 · S/N 17276230 N97789Delta State University · Cleveland, MSBuilt 1984 · S/N 17276231 N97811Angel Aviation Inc · Peoria, AZBuilt 1984 · S/N 17276232 N9783PKent State University · Stow, OHBuilt 1984 · S/N 17276234 N9786LPerun Av LLC · Cliffside Park, NJBuilt 1986 · S/N 17276612 N97873Kent State University · Stow, OHBuilt 1984 · S/N 17276236 N97883Rick Aviation Inc · Newport News, VABuilt 1984 · S/N 17276237 N97919Christiansen Aviation LLC · Wilmington, DEBuilt 1984 · S/N 17276239 N97921Flywell Aviation LLC · Bowling Green, KYS/N 17276240 N97945Kent State University · Stow, OHBuilt 1984 · S/N 17276241 N97947Civil Air Patrol · Maxwell Afb, ALBuilt 1984 · S/N 17276242 N97984Woody George R · Clinton, ARBuilt 1984 · S/N 17276244 N97FRSmith Ralph E · Lyndonville, NYBuilt 1980 · S/N 17274188 N98120Blue River Aviation LLC · Palmer, AKBuilt 1984 · S/N 17276260 N98125Western Reserve Flight Center Inc · Mc Donald, OHBuilt 1984 · S/N 17276261 N9813LCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1986 · S/N 17276616 N9815LWestosha Flying Club Inc · Kenosha, WIBuilt 1986 · S/N 17276618 N98186Loyer Jeffrey W · Olympia, WAS/N 17276265 N98219White Jeffrey M · Carlsbad, CABuilt 1984 · S/N 17276266 N9823LSilverhawk Aviation Academy LLC · Caldwell, IDBuilt 1986 · S/N 17276623 N9824LSt Pete Aviation Services LLC · Saint Petersburg, FLBuilt 1986 · S/N 17276624 N98251Wings Over Texas Holdings LLC · Denton, TXBuilt 1984 · S/N 17276269 N98264Civil Air Patrol Inc · Maxwell Afb, ALBuilt 1985 · S/N 17276271 N98271Mastin Aviation Inc · Pasadena, MDBuilt 1984 · S/N 17276272 N9828LJohn D Strohsahl Pa Trustee · Fort Lauderdale, FLBuilt 1986 · S/N 17276625 N98306United States Air Force Owner · Usaf Academy, COBuilt 1985 · S/N 17276276 N98323Civil Air Patrol Inc · Maxwell Afb, ALBuilt 1985 · S/N 17276277 N98326Lum Barnett K · Temple City, CABuilt 1984 · S/N 17276278 N9834LCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1986 · S/N 17276628 N98352Civil Air Patrol Inc · Maxwell Afb, ALBuilt 1985 · S/N 17276281 N98354Jin Jin Aviation LLC · Anchorage, AKBuilt 1984 · S/N 17276282 N9837LIal Corp · Wilmington, DEBuilt 1986 · S/N 17276629 N98381Central Air Parts Inc · Staunton, ILBuilt 1985 · S/N 17276284 N98395Dury Aviation Services Inc · De Soto, ILBuilt 1985 · S/N 17276285 N98407Choice Aviation LLC · Hamilton, MTBuilt 1985 · S/N 17276287 N98410Mbk Leasing And Consulting LLC · Lakeland, FLBuilt 1984 · S/N 17276288 N9841LHalsmer Ann Lucille · Lafayette, INBuilt 1986 · S/N 17276632 N98424Pfister Thomas K · Minneapolis, MNBuilt 1985 · S/N 17276289 N98426Civil Air Patrol · Maxwell Afb, ALBuilt 1985 · S/N 17276290 N98428T&W Aviation LLC · Pinehurst, TXBuilt 1984 · S/N 17276291 N98456Civil Air Patrol Inc · Maxwell Afb, ALS/N 17276293 N98463Civil Air Patrol Inc · Maxwell Afb, ALBuilt 1985 · S/N 17276294

Back to Cessna 172P