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.

N9322GHutchinson Darrold Trustee · Hingham, MTBuilt 1971 · S/N 18260862 N9330GHarris Ryan C · Gurley, ALBuilt 1971 · S/N 18260870 N9333GEdinger Larry D · Stroudsburg, PABuilt 1971 · S/N 18260873 N9337GHaller Lonette J · Mobile, ALBuilt 1971 · S/N 18260877 N9342GBaumann James J · Trabuco Canyon, CABuilt 1971 · S/N 18260882 N9343GOlivo Investments Group LLC · Richmond, TXBuilt 1971 · S/N 18260883 N9345GFrederick Paul M · Tucson, AZBuilt 1971 · S/N 18260885 N9347GNazir Donna Lacruz · Boca Raton, FLS/N 18260887 N9353GMisyukevich Konstantyn · Clarkston, MIBuilt 1971 · S/N 18260893 N9357GPpp Investments LLC · Lexington, MSBuilt 1971 · S/N 18260897 N9358GBig Sky Plane Holdings LLC · Kalispell, MTBuilt 1971 · S/N 18260898 N9361GGensky LLC · Center Point, IABuilt 1971 · S/N 18260901 N9363GPrecision Aviation LLC · Walker, MNBuilt 1971 · S/N 18260903 N9364GGreen Dwayne C · Santa Rosa, CABuilt 1971 · S/N 18260904 N9366GSchnackenberg Cody B · Edgemont, SDS/N 18260906 N9369GLenape Signals LLC · Orange, CAS/N 18260909 N9370GCorredoira Carlos A · Mcallen, TXBuilt 1971 · S/N 18260910 N9372GAcosta Gregory P · Mandeville, LABuilt 1971 · S/N 18260912 N9374GPreston Jonathan · Murrieta, CABuilt 1971 · S/N 18260914 N9380GSclafami Michael · New Waverly, TXBuilt 1971 · S/N 18260920 N9391GBlair Stanton M · Kingman, AZBuilt 1971 · S/N 18260931 N9415MCool Creek Aviation LLC · New Orleans, LABuilt 1976 · S/N 18264745 N9418M4 Blades Inc · Granada Hills, CABuilt 1976 · S/N 18264748 N9423MPaquette Ralph H Jr · Apalachin, NYBuilt 1976 · S/N 18264749 N9427MWillthedrill LLC · Las Vegas, NVBuilt 1976 · S/N 18264751 N9431MMeridian Airport Authority · Meridian, MSBuilt 1976 · S/N 18264752 N9435MEngelhardt Angelo Lomeli · Spring, TXBuilt 1976 · S/N 18264754 N9441MGuemes Aloft LLC · Portland, ORS/N 18264759 N9445MSky Masters Aviation Inc · Laguna Hills, CAS/N 18264761 N9447MWings Aircraft LLC · New Richmond, WIS/N 18264763 N9448MSoto Eduard D Trustee · Somers, MTBuilt 1976 · S/N 18264764 N944JHHiggins James R · Camargo, ILBuilt 1973 · S/N 18262033 N9451MSnow Jeffrey J · Mechanicsburg, PABuilt 1976 · S/N 18264766 N9478GExecutive Security Solutions LLC · Moody, ALBuilt 1974 · S/N 18263397 N9488MAero Guard Aviation Insurance LLC · Lincoln, NEBuilt 1976 · S/N 18264771 N9498EBowker Neal H · Tucson, AZS/N 18263915 N94LSPalms Property Management Inc · Heber City, UTBuilt 1973 · S/N 18262356 N952CCNewell Charles W · Naperville, ILBuilt 1975 · S/N 18263638 N953CCScruggs Ken · Plain City, OHBuilt 1975 · S/N 18264109 N9546GSale Reported · Emerson, IASale reported, canceledBuilt 1974 · S/N 18263402 N9555XWalker Scott · Mammoth Lakes, CABuilt 1974 · S/N 18263495 N955BCWilson Douglas S · Imperial, NES/N 18263036 N955MSSanz Mark L · Missoula, MTBuilt 1974 · S/N 18262965 N9589GKinate Mike · Colorado Springs, COBuilt 1974 · S/N 18263405 N9598GStecklein Daniel R · Hays, KSBuilt 1974 · S/N 18263406 N95FCDerscos LLC · Colorado Springs, COBuilt 1975 · S/N 18263694 N95MRH&M Air LLC · Georgetown, TXBuilt 1973 · S/N 18261797 N9612G4-F Flyers LLC · Haysville, KSBuilt 1974 · S/N 18263408 N9618GH&M Ltd · Warren, IDS/N 18263409 N9628GNicols Bruce D · Titusville, PABuilt 1974 · S/N 18263410

Back to Cessna 182P