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.

N3805DThurier Lawrence V · Stevens Point, WIBuilt 1957 · S/N 34505 N3808DByrd David P · King Salmon, AKBuilt 1957 · S/N 34508 N3809DRhoads William · Williamsburg, VABuilt 1957 · S/N 34509 N3810DAdlard Thomas Andrew · Dinuba, CAS/N 34510 N3811DRegistration Pending · Turner, MTRegistration pending, pending cancellationBuilt 1957 · S/N 34511 N3814DReeder Travis · Marana, AZBuilt 1957 · S/N 34514 N3815DAlaska Homested Lodge Inc · Soldotna, AKBuilt 1957 · S/N 34515 N3817DOff The Step Inc · Creswell, ORBuilt 1957 · S/N 34517 N3822DGifford David M · Las Vegas, NVBuilt 1957 · S/N 34522 N3823DPfaff John W · Laytonville, CABuilt 1957 · S/N 34523 N3824DDavis Marc · Hilsboro, ORBuilt 1957 · S/N 34524 N3825DSelf Robert R · Tuttle, OKS/N 34525 N3827DKendallville Flying Service Inc · Saint Joe, INBuilt 1957 · S/N 34527 N3828DWarner Thomas E · Beloit, OHBuilt 1957 · S/N 34528 N382GCLacomette Ted W · Tijeras, NMBuilt 1957 · S/N 34195 N3830DDouble J Mining LLC · Palmer, AKBuilt 1957 · S/N 34530 N3832DKim Sungtae · Fort Worth, TXS/N 34532 N3834DMilan Ruth A · Edmonds, WABuilt 1957 · S/N 34534 N3837DCameron Russell A · Fort Benton, MTBuilt 1957 · S/N 34537 N3839DHot Rod Aviation LLC · Fayetteville, ARS/N 34539 N3840DLangbehn Lee W · Great Falls, MTBuilt 1957 · S/N 34540 N3843DNichols Bryan M · Canute, OKBuilt 1957 · S/N 34543 N3845DTeam Gateway LLC · Lewes, DEBuilt 1957 · S/N 34545 N3846DAshiku Phillip · Ukiah, CABuilt 1957 · S/N 34546 N3847DPrice David W · Lynn Haven, FLBuilt 1957 · S/N 34547 N3849DMellor Bradford A · Spanish Fork, UTS/N 34549 N3851DSale Reported · Darby, MTSale reported, pending cancellationBuilt 1957 · S/N 34551 N3853DMccabe Ryan · Las Vegas, NVS/N 34553 N3854DTjp@Jax Inc · Zephyrhills, FLBuilt 1957 · S/N 34554 N3862DReady Aim Flyer LLC · New Castle, DES/N 34562 N3863DDulley Tony A · Nine Mile Falls, WABuilt 1957 · S/N 34563 N3867DPrestige Air Worldwide LLC · Seneca, SCBuilt 1957 · S/N 34567 N3868DRegistered aircraftBuilt 1957 · S/N 34568 N3869DOwens Hay LLC · Crane, ORBuilt 1957 · S/N 34569 N3870DKlad-Air LLC · Catlett, VABuilt 1957 · S/N 34570 N3875DJames D Wirt · Goldsby, OKBuilt 1957 · S/N 34575 N3876DBurns William Greg · Eloy, AZBuilt 1958 · S/N 34839 N3879DHolberton George L · White City, ORBuilt 1957 · S/N 34579 N3880DWallace David L · Huntersville, NCBuilt 1957 · S/N 34580 N3884DBryant Melvin Barry · Cascade, IDBuilt 1957 · S/N 34584 N3886DHarper Shawn W · Bayfield, COBuilt 1957 · S/N 34586 N3887DWin Win Aviation Inc · Wake Forest, NCBuilt 1957 · S/N 34587 N3888DAviation Of North Florida LLC · Jacksonville, FLBuilt 1957 · S/N 34588 N388WAuza Joseph · Casa Grande, AZBuilt 1956 · S/N 33876 N3892DWeiss Steven John · Las Vegas, NVBuilt 1957 · S/N 34592 N3893DGardner Jay A · Agua Dulce, CABuilt 1957 · S/N 34593 N3896DMills Air Service Inc · Marstons Mills, MABuilt 1957 · S/N 34596 N3901DDanford Scott M · Chickamauga, GAS/N 34601 N3904DOreilly Thomas P · Oscoda, MIS/N 34604 N3905DKoehn Jerry L · Cimarron, KSBuilt 1957 · S/N 34605

Back to Cessna 182A