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.

N9645GConnolly Michael T · Ferndale, WABuilt 1974 · S/N 18263413 N964AFBoerner Robert L Trustee · El Cajon, CABuilt 1972 · S/N 18261562 N9657GAirmates Flying Club Inc · Northfield, NJBuilt 1974 · S/N 18263421 N9661GAvco Patrol LLC · Lyndon, KSBuilt 1974 · S/N 18263422 N9666GDl Elk Outfitters Inc · Cascade, MTBuilt 1974 · S/N 18263423 N9691GFox Michael F · Hernando, FLBuilt 1974 · S/N 18263431 N9699GCruikshank Brian S · Portland, ORBuilt 1974 · S/N 18263434 N969RM182 LLC · Battle Ground, WABuilt 1974 · S/N 18263050 N971BBColon Hector L · Gainesville, GABuilt 1974 · S/N 18263473 N975PCBeck Steven · San Clemente, CABuilt 1975 · S/N 18263546 N9770GLam Tack C · Los Angeles, CABuilt 1974 · S/N 18263437 N9802EPouya Hamid · San Jose, CABuilt 1975 · S/N 18263916 N980LKmq Data Acquisitions LLC · Chugiak, AKBuilt 1973 · S/N 18262273 N9813ER&L Enterprise Group LLC · Wilmington, DEBuilt 1975 · S/N 18263919 N9821ERegistered aircraftBuilt 1975 · S/N 18263921 N9822ESample John A · Gonzales, TXBuilt 1976 · S/N 18263922 N9828ETa Wellner Group LLC · Lake Oswego, ORS/N 18263923 N9840ELjmf17 LLC · Hayes, KSBuilt 1975 · S/N 18263926 N9869ESystems Management Consulting Group LLC · St Michaels, MDBuilt 1975 · S/N 18263930 N9871EBonac Air Flying Club · Montauk, NYBuilt 1975 · S/N 18263932 N9876ERegistered aircraftBuilt 1975 · S/N 18263937 N9876MErkie Norman R · Denison, TXBuilt 1976 · S/N 18264774 N9878EKd Flyers Inc · Lewes, DEBuilt 1975 · S/N 18263939 N9879MJersey Cowboy Venture LLC · Casper, WYBuilt 1976 · S/N 18264777 N987RPPegasus Flight LLC · Bluffton, SCS/N 18264863 N9880EClint Bowyer Racing Inc · Clemmons, NCBuilt 1975 · S/N 18263941 N9881ESchmitt Rudy · Bulverde, TXS/N 18263942 N9881MDietz David Brian · East Canton, OHBuilt 1976 · S/N 18264779 N9882EWilson Randall R · Roseville, CABuilt 1975 · S/N 18263943 N9883MJacques Tommy E Jr · Montgomery, ALBuilt 1976 · S/N 18264781 N9885MTroy Oakland Pilots Flying Club Inc · Troy, MIBuilt 1976 · S/N 18264783 N9886EHodson Don W · Marion, KSBuilt 1975 · S/N 18263947 N9886MJohnson Leroy W · Nelson, NES/N 18264784 N9888EHarrison Cladis · Westfield, NJBuilt 1975 · S/N 18263949 N9889EDragonstone LLC · Beaverton, ORBuilt 1975 · S/N 18263950 N9889MFree Lutheran Association Of Pilot Supporters Inc · Plymouth, MNBuilt 1976 · S/N 18264786 N9892MBogner Aviation LLC · Dover, DEBuilt 1976 · S/N 18264789 N9894EDebski Matthew B · Belmont, CABuilt 1975 · S/N 18263955 N9897MAcme Aviation USA LLC · Nashville, TNBuilt 1976 · S/N 18264794 N9898ELamar Rosa E · Santa Paula, CAS/N 18263958 N98TCPositiv8 LLC · Wilmington, DEBuilt 1974 · S/N 18263411 N9901EBas Part Sales LLC · Greeley, COBuilt 1975 · S/N 18263961 N9902EOtto Real Estate Investment Inc · Bakersfield, CABuilt 1975 · S/N 18263962 N9903MRegistered aircraftBuilt 1976 · S/N 18264799 N9906MWhorton Darren · Nashville, TNBuilt 1976 · S/N 18264802 N9908EAndrews Allen P · Longview, TXBuilt 1975 · S/N 18263968 N990CKSaucier Christopher A · Marion, MTBuilt 1976 · S/N 18265006 N990WPThomas Field Flying Club LLC · Holly Springs, MSBuilt 1973 · S/N 18262238 N9910ESmoke Eagles Inc · Newport Beach, CABuilt 1975 · S/N 18263970 N9913EHobot LLC · Springdale, ARBuilt 1975 · S/N 18263973

Back to Cessna 182P