Skip to content

Registered aircraft · 2,099

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

N555KSKlotz Aviation LLC · Holcomb, KSBuilt 1974 · S/N 18263379 N55MRQc Executive Aviation LLC · Sheridan, WYBuilt 1974 · S/N 18262983 N55NABloomhardt Theodore E · Hinesburg, VTBuilt 1974 · S/N 18262915 N55WBMetro Flyers Ltd · Wilmington, DEBuilt 1975 · S/N 18263900 N5601JGoos Lynn A · Silver City, IABuilt 1974 · S/N 18263458 N5603JMiller Duane A · Redlands, CABuilt 1974 · S/N 18263460 N5604JJohnson David A · Sunrise Beach, TXBuilt 1974 · S/N 18263461 N5610JRael Pedro G · Los Lunas, NMBuilt 1974 · S/N 18263465 N5611JJr'S Auto Care Center Inc · Gualala, CABuilt 1974 · S/N 18263466 N5612JNovember Aviation Corporation · Hobart, WABuilt 1974 · S/N 18263467 N5613JMorgan Edward A · Buchanan Dam, TXBuilt 1974 · S/N 18263468 N5620JPearce Gregory W · Eagle River, AKBuilt 1974 · S/N 18263474 N5628JAviate 208 LLC · Oconomowoc, WIBuilt 1974 · S/N 18263476 N562ATOmahen Gilbert H · Northridge, CABuilt 1974 · S/N 18263227 N5637GN2893e LLC · Reno, NVBuilt 1974 · S/N 18263304 N5659JGilbert Duane A · Reno, NVBuilt 1974 · S/N 18263481 N565KGGilley Jerry · Maryville, TNBuilt 1973 · S/N 18261775 N5669JWeber David A · Bryan, TXBuilt 1974 · S/N 18263486 N5676JLunsford Group Inc · Asheville, NCBuilt 1974 · S/N 18263490 N5677JGfp Reserve LLC · Punta Gorda, FLS/N 18263491 N5679JFitzgerald Aviation LLC · Bluffton, SCBuilt 1974 · S/N 18263493 N567TXWatts Brian W · Houston, TXBuilt 1974 · S/N 18263069 N568JKBell Frank D · Tuxedo, NCS/N 18262340 N568QAWhite Fence Aero LLC · Denver, COBuilt 1971 · S/N 18260932 N5692JSeawings LLC · Holualoa, HIBuilt 1974 · S/N 18263494 N5723JMcdonald Larry H · Little River, SCBuilt 1974 · S/N 18263498 N572DHSportsmans Recon LLC · Hartwell, GABuilt 1974 · S/N 18263024 N5737JSkolnik Adam R · Clermont, FLBuilt 1974 · S/N 18263506 N5740JStonestreet Arlie D Trustee · Pratt, KSBuilt 1974 · S/N 18263509 N5745JJohnson Charles R · Aurora, OHBuilt 1974 · S/N 18263512 N5746JPassage Way Farms · Lyon, MSBuilt 1974 · S/N 18263513 N5748JWallner Patrick J · Redding, CABuilt 1974 · S/N 18263515 N5755JBagge John A · Independence, IABuilt 1974 · S/N 18263520 N5759JThree Six Golf Ltd · Cary, NCBuilt 1974 · S/N 18263522 N575PMLiebfried Andrew H · Lunenburg, MABuilt 1975 · S/N 18264045 N5769JRegistration Pending · Derby, KSRegistration pendingBuilt 1974 · S/N 18263527 N5778JTwin Falls Fliers Inc · Twin Falls, IDBuilt 1974 · S/N 18263530 N5788JEagle Aviation Inc · Elizabeth, COBuilt 1975 · S/N 18263536 N5789JDonaldson Robert D · Kingston, NYBuilt 1975 · S/N 18263537 N5797FWright James J · Owens Cross Roads, ALBuilt 1973 · S/N 18261914 N5797JLindsay Properties LLC · Kosciusko, MSBuilt 1975 · S/N 18263543 N5804JScott Amy · Henniker, NHS/N 18263547 N5814JFoster Chris A · Camas, WABuilt 1975 · S/N 18263551 N5822JFinch Eric · Cypress, TXBuilt 1975 · S/N 18263556 N58442Van Vleet Dennis · Kingman, AZBuilt 1973 · S/N 18262066 N58443Szeliga Mark H · Bethel, MEBuilt 1973 · S/N 18262067 N58454Thiele John E · Harrison, IDBuilt 1973 · S/N 18262074 N58457Registered aircraftBuilt 1973 · S/N 18262075 N58458Prairie Wings Aviation LLC · Victoria, TXBuilt 1973 · S/N 18262076 N58465Ram Air LLC · Portland, MEBuilt 1973 · S/N 18262079

Back to Cessna 182P