Skip to content

Registered aircraft · 784

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

N4031DSurette Phillip · Vail, COBuilt 1957 · S/N 34731 N4032DPentecost Benjamin · Puyallup, WABuilt 1957 · S/N 34732 N4033DJacquin Aviation Inc · Markham, ILBuilt 1957 · S/N 34733 N4035DWylie Joshua H · Landgrove, VTBuilt 1957 · S/N 34735 N4036DWilson Kevin B P · La Mesa, CABuilt 1957 · S/N 34736 N4039DKruger Daniel G · Stateline, NVBuilt 1957 · S/N 34739 N4045DTlm Properties LLC · Gladewater, TXBuilt 1957 · S/N 34745 N4047DEiff John E · Deland, FLFirst renewal noticeBuilt 1957 · S/N 34747 N4049DUnwrapped LLC · Dover, DEBuilt 1957 · S/N 34749 N4050DKesling Aviation LLC · Orange Beach, ALBuilt 1957 · S/N 34750 N4051DOlson Scott L · Girdwood, AKS/N 34751 N4053DGardner Dale R · North Logan, UTBuilt 1957 · S/N 34753 N4055DLoup Technologies Inc · Longmont, COBuilt 1957 · S/N 34755 N4058DKenley Douglas T · Palmer, AKBuilt 1957 · S/N 34758 N4061DDavis Russell C · Bakersfield, CABuilt 1958 · S/N 34761 N4062DJohnson Gunnar W · Unalakleet, AKBuilt 1958 · S/N 34762 N4067DBlackwood William C · Irvington, ALBuilt 1958 · S/N 34767 N4071DNew Richard A · Deming, WABuilt 1958 · S/N 34771 N4073DKarsell Kris J · Duluth, MNBuilt 1958 · S/N 34773 N4074DDimitriadis Joseph T · Las Vegas, NVBuilt 1958 · S/N 34774 N4077D234kq LLC · Eagle, IDBuilt 1957 · S/N 34777 N4078DFinney James R · Howe, TXBuilt 1957 · S/N 34778 N4079DErnst Gregory R · Eagle Creek, ORBuilt 1957 · S/N 34779 N4080DCrane Gary W · Gig Harbor, WABuilt 1957 · S/N 34780 N4081DEarl Tim G · Plymouth, CAS/N 34781 N4082DSharp Nicholas · Valdez, AKBuilt 1957 · S/N 34782 N4083DAerohawk Aviation Inc · Idaho Falls, IDBuilt 1957 · S/N 34783 N4086DThompson George M · Fairbanks, AKBuilt 1957 · S/N 34786 N4088DIron Horse Aviation LLC · Omak, WABuilt 1957 · S/N 34788 N4089DGaffney Justin L · Arcata, CABuilt 1958 · S/N 34789 N4093DZito Nick D · Ellensburg, WABuilt 1957 · S/N 34793 N4094DManker Lance M · North Platte, NEBuilt 1957 · S/N 34794 N4095DRedfern Ronnie M · Fairbanks, AKBuilt 1957 · S/N 34795 N4096DSkydive Cape Cod Inc · Caddo Mills, TXBuilt 1958 · S/N 34796 N4098DAspegren Robert N · Vacaville, CABuilt 1958 · S/N 34798 N424NTLattin Travis · Beloit, KSBuilt 1957 · S/N 34555 N424PSRegistered aircraftBuilt 1958 · S/N 51295 N43HLKimbrell Heath G · Quinlan, TXBuilt 1957 · S/N 34652 N4428DJst Management LLC · Zephyrhills, FLS/N 34727 N45CSSadowski Curtis D · Taylorville, ILBuilt 1958 · S/N 51391 N4701DMiller Larry L · Dade City, FLBuilt 1957 · S/N 34801 N4709DMagalsky Jacob J · Wilsall, MTBuilt 1957 · S/N 34809 N4711DTimmons Colton R · Parker, COBuilt 1957 · S/N 34811 N4712DWerkema Thomas L · Caledonia, MIBuilt 1957 · S/N 34812 N4714DWallace Brian T · Ogden, UTBuilt 1957 · S/N 34814 N4715DPetracca Carmine J · Lewiston, IDBuilt 1957 · S/N 34815 N4716DDavenport Reginald · Evans, WABuilt 1957 · S/N 34816 N4718DAviation Of North Florida LLC · Jacksonville, FLBuilt 1958 · S/N 34818 N4721DCarm'S LLC · Beaver Springs, PAS/N 34821 N4728DMoore James Herbert III · Fairbanks, AKS/N 34828

Back to Cessna 182A