Skip to content

Registered aircraft · 606

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

N95242Kane Aviation Holdings LLC · Bernardsville, NJBuilt 1998 · S/N 18280146 N9525DFlying Neutrons LLC · Lebanon, OHBuilt 1998 · S/N 18280147 N9525PGeorgetown Flying Club LLC · Pawleys Island, SCBuilt 1997 · S/N 18280177 N95260Barr Air Patrol LLC · Mesquite, TXBuilt 1998 · S/N 18280182 N9533GSmith James R · Delaware, NJBuilt 1998 · S/N 18280354 N9539DBohemia Aviation LLC · Niagara, WIS/N 18280184 N9539LSt Pete Aviation Services LLC · Saint Petersburg, FLBuilt 1998 · S/N 18280185 N9539PNichols Aviation LLC · Middletown, DEBuilt 1998 · S/N 18280186 N9539RAdams Scott A · Glenview, ILS/N 18280172 N9542WState Of North Carolina · Raleigh, NCBuilt 1998 · S/N 18280136 N9543FEvans Michael · Punta Gorda, FLBuilt 1998 · S/N 18280219 N9543GHi Low Aviation LLC · Alpine, TXBuilt 1998 · S/N 18280245 N9544QPhoto Services Unlimited · Augusta, MEBuilt 1998 · S/N 18280291 N9544SJourney Holdings LLC · Reform, ALBuilt 1998 · S/N 18280149 N9551WBcbc Aero Services LLC · Dover, DEBuilt 1998 · S/N 18280207 N9552RCauv LLC · Cincinnati, OHBuilt 1998 · S/N 18280167 N9553SHunters Adventures LLC · Kennesaw, GABuilt 1998 · S/N 18280254 N9557PHendrix Steven · Bakersfield, CAS/N 18280294 N9565MBitterroot Ventures LLC · Show Low, AZBuilt 1998 · S/N 18280274 N9568JJeep Kenneth M · Wadsworth, ILBuilt 1998 · S/N 18280275 N956SMMississippi Forestry Commission · Pearl, MSBuilt 2000 · S/N 18280783 N9570AUpper Fifteen Inc · Latham, NYBuilt 1998 · S/N 18280286 N9570VAwp Holdings LLC · Murphysboro, ILS/N 18280285 N9572AEagle Eye Marketing LLC · Reno, NVBuilt 1998 · S/N 18280279 N9574AHomeward Bound Enterprises LLC · Parker, COFirst renewal noticeS/N 18280824 N9581VMartin Northern Aviation LLC · Benton, ARBuilt 1998 · S/N 18280257 N9584QHoward Genetics Inc · Ardmore, OKBuilt 1998 · S/N 18280258 N965CWAir Capital Aviators Club · Wichita, KSBuilt 2000 · S/N 18280769 N9681Srividya Aviators LLC · North Brunswick, NJBuilt 1998 · S/N 18280233 N9681FSplashdown Aviation LLC · Dunedin, FLBuilt 1998 · S/N 18280268 N9696FShakman Michael L Trustee · Chicago, ILBuilt 1998 · S/N 18280269 N96TGCampana Aviation LLC · George West, TXBuilt 2000 · S/N 18280802 N9705SVandivier Calvin Leo · Navarre, FLBuilt 1997 · S/N 18280016 N971SPIllinois State Police · Springfield, ILBuilt 1999 · S/N 18280653 N974PCMontana Bizjets LLC · Missoula, MTBuilt 1997 · S/N 18280076 N974SGWalters Patrick W · Tallapoosa, GABuilt 1997 · S/N 18280083 N9774FTailwind Aviation Solutions LLC · Perry, GABuilt 1997 · S/N 18280006 N978RABdk Pegasus LLC · Bastrop, TXBuilt 1998 · S/N 18280213 N97RWWiplinger Robert D · Inver Grove Hts, MNS/N 18280387 N981WSNayrmarc LLC · Linden, MIBuilt 1998 · S/N 18280328 N982BRThompson H S Trustee · Oakdale, CABuilt 1998 · S/N 18280277 N984PDLegends Air Center LLC · Bentonville, ARBuilt 2000 · S/N 18280732 N98715Moses Ezra R · Windham, NHBuilt 1998 · S/N 18280356 N9879FClift Murray · Chewelah, WAS/N 18280057 N98840Aviator Air Flight School LLC · Grand Prairie, TXBuilt 1998 · S/N 18280358 N98853Registered aircraftBuilt 1998 · S/N 18280316 N9885FSky View LLC · Madison, MSBuilt 1998 · S/N 18280148 N98896Two Tails LLC · Las Vegas, NVBuilt 1998 · S/N 18280350 N988RAFifteen-Sixty LLC · Ottawa Hills, OHBuilt 1997 · S/N 18280022 N988TCSpaulding Bernard B · Terrell, TXBuilt 1998 · S/N 18280297

Back to Cessna 182S