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.

N423LL79bravo Leasing LLC · Lincoln, DEBuilt 1975 · S/N 18264071 N424DDMaple Aviation LLC · Big Fork, MTBuilt 1972 · S/N 18261424 N425MBPauls Valley Fly Boys LLC · Davis, OKBuilt 1976 · S/N 18264927 N425TASkyhawks Inc · Westminster, COBuilt 1976 · S/N 18264951 N427GBBoies Guy J · Mason, TXBuilt 1973 · S/N 18262174 N42WDRegistration Pending · Seattle, WARegistration pendingBuilt 1972 · S/N 18261403 N431MLFarr Francis A · Bozeman, MTBuilt 1975 · S/N 18263538 N43JKEvans James · Millbrae, CABuilt 1973 · S/N 18262576 N444AASipola Don H · Virginia, MNBuilt 1973 · S/N 18261920 N445DCWith Wings As Eagles Aviation LLC · Middletown, DEBuilt 1975 · S/N 18263690 N448ALWheeler Alexa L · Tavernier, FLBuilt 1973 · S/N 18262250 N449VYKirkham Matthew · Cazenovia, WIBuilt 1973 · S/N 18262199 N44DRFiretextresponse LLC · Sumner, ILBuilt 1975 · S/N 18263596 N44JFEureka E Solutions Inc · Austin, TXBuilt 1973 · S/N 18262579 N44RBAmj Air LLC · Holland, MIBuilt 1973 · S/N 18261829 N4563WE&V Air LLC · Chatsworth, GABuilt 1973 · S/N 18262363 N456JGGronemeyer Jens · Deland, FLS/N 18264380 N458SRDr2 Aviation LLC · Valdosta, GABuilt 1972 · S/N 18261409 N45WCClark John A · Louisville, MSBuilt 1975 · S/N 18263673 N4630KCorbin Rex W · Benton, KSBuilt 1975 · S/N 18263632 N4633KBauer Aviation LLC · Sunbury, OHBuilt 1975 · S/N 18263635 N4638KWiggins Air Patrol LLC · Wichita, KSS/N 18263640 N4639KMyers Gary L Trustee · Onida, SDBuilt 1975 · S/N 18263641 N463MAnssec LLC · Lake In The Hills, ILBuilt 1975 · S/N 18263661 N4640KLarson Family Farms LLC · Haxtun, COBuilt 1975 · S/N 18263713 N4645KOrange Air Inc · Harbor City, CANon-citizen corporation, flight hours not reportedBuilt 1975 · S/N 18263647 N4646KPloense Justin M · Big Bear City, CAS/N 18263648 N4654KHoffman Matthew A · Baltimore, MDBuilt 1975 · S/N 18263656 N465CGApogee Air LLC · Newark, CABuilt 1974 · S/N 18262873 N4660KFoster Gary Paul · Willow, AKS/N 18263662 N4667KFletcher Mountain Aviation LLC · Hampden, MEBuilt 1975 · S/N 18263668 N4670KMaloy Steven · Andrews, NCBuilt 1975 · S/N 18263671 N4678KGarcia Roberto P · Spring Hill, FLFirst renewal noticeBuilt 1975 · S/N 18263679 N4680KIntrepid Red Baron Inc · New Franken, WIBuilt 1975 · S/N 18263681 N4681KBluestone Ryan Joseph · Lake Havasu City, AZBuilt 1975 · S/N 18263682 N4683KKrohn Ronald C · Pauma Valley, CABuilt 1975 · S/N 18263684 N4686KMcdonald Robert M · Oak Point, TXBuilt 1975 · S/N 18263687 N468PSVoigt Aviation Inc · Park Rapids, MNBuilt 1973 · S/N 18262256 N4691KDenner Bruce R · Nashua, NHS/N 18263692 N4696K96 Kilo LLC · Modesto, CABuilt 1975 · S/N 18263697 N4697KMorgan James D · Denali Park, AKBuilt 1975 · S/N 18263698 N4698KRegistered aircraftBuilt 1975 · S/N 18263699 N46PGRegistered aircraftBuilt 1972 · S/N 18261414 N4702KUniversity Auto Sales Inc · Pell City, ALBuilt 1975 · S/N 18263701 N4703KSkeffington Robert C · Topsfield, MABuilt 1975 · S/N 18263702 N4705KYi Ranches Lp · Reedley, CABuilt 1975 · S/N 18263704 N4706KWitman Michael R · Milliken, COBuilt 1975 · S/N 18263705 N4707KKcsi Aerial Patrol Inc · Bakersfield, CABuilt 1975 · S/N 18263706 N47084Tabor Peter C · Durango, COBuilt 1975 · S/N 18263783 N4709KAlexander & Knizley Inc DBA · Mobile, ALBuilt 1975 · S/N 18263708

Back to Cessna 182P