Skip to content

Registered aircraft · 272

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

N4192VMerren Trennon R · Brady, TXBuilt 1948 · S/N 18525 N4197VBaker Air Service Inc · Baker, MTS/N 18530 N4203VAmelia Reid Aviation LLC · Wilton, CABuilt 1948 · S/N 18559 N4207VTeufel Gregory W · Lake Stevens, WABuilt 1948 · S/N 18563 N4210VHolman Ricardo · Pleasant Hill, ORBuilt 1948 · S/N 18566 N4214VGat Air & Ground LLC · Norwich, NYBuilt 1948 · S/N 18570 N4215VTriplett Taran R · Cheyenne, WYBuilt 1948 · S/N 18571 N4220VMckinley Jason · Coulterville, ILBuilt 1948 · S/N 18576 N4221VBashore Barry A · Pleasant Hill, OHBuilt 1948 · S/N 18577 N4223VMcdermotts Letsfly LLC · Somerton, AZBuilt 1948 · S/N 18579 N4224VDouglas Phillip A · Fredericktown, OHS/N 18580 N4225VSell Scott F · Moody, TXS/N 18581 N4227VRegistered aircraftBuilt 1948 · S/N 18583 N4229VMorris Christopher Lee Trustee · Mabank, TXBuilt 1948 · S/N 18585 N4232VBishop John · Annapolis, MDBuilt 1948 · S/N 18588 N4236VSpitler John E · Laramie, WYBuilt 1948 · S/N 18592 N4238VHamann David L · Los Lunas, NMBuilt 1948 · S/N 18594 N4240VLadage Terry L · Champaign, ILBuilt 1948 · S/N 18596 N4246VMesserly John A · Altus, OKBuilt 1948 · S/N 18602 N4250VSnyder Michael Scott · Erie, COBuilt 1948 · S/N 18606 N4252V212 Investments Of Montana LLC · Owasso, OKBuilt 1948 · S/N 18608 N4254VJohnston Daniel T · Cambridge, OHBuilt 1948 · S/N 18610 N4259VKurt Robert F · Rose Hill, KSS/N 18615 N4260VFranks Marvin L · Cedar Key, FLBuilt 1948 · S/N 18616 N4261VWells Bryan G · Stephenville, TXBuilt 1948 · S/N 18617 N4262VKinzie Industries LLC · Alva, OKBuilt 1948 · S/N 18618 N4263VUltra Flight LLC · Le Mars, IABuilt 1948 · S/N 18619 N4264VLubben Ryan D · Fergus Falls, MNBuilt 1948 · S/N 18620 N4265VByler Jonathan P · Inman, SCBuilt 1948 · S/N 18623 N4269VDouglas Phillip A · Fredericktown, OHBuilt 1948 · S/N 18627 N4272VShaw Christopher · Porterville, CAFirst renewal noticeBuilt 1948 · S/N 18630 N4277VBoyd William L · Hillsboro, ORS/N 18635 N4278VDoherty Michael J · Le Sueur, MNBuilt 1948 · S/N 18636 N4279VCummins Gary L · Sunrise Beach, MOBuilt 1948 · S/N 18697 N4281VWalko Ann-Marie · Westport Island, MEBuilt 1948 · S/N 18699 N4286VArquer Nicholas R · Rancho Cucamonga, CABuilt 1948 · S/N 18700 N4288VPeck Kenneth L · Smithville, TXBuilt 1948 · S/N 18646 N4289VRosborough Todd · Medford, ORBuilt 1948 · S/N 18647 N4292VPowers James E · Elk, WABuilt 1948 · S/N 18650 N4294VDekryger John · Fremont, MIBuilt 1948 · S/N 18652 N4339BCurrie Andrew C · Oscoda, MIBuilt 1955 · S/N 26683 N4401VEwald Christopher R · Blanding, UTBuilt 1948 · S/N 18534 N4403VEgbert Harry T · Clarks Point, AKBuilt 1948 · S/N 18536 N4406VPacific Aviation Aircraft Management Inc · Fresno, CABuilt 1948 · S/N 18539 N4408VScott Tony D · Mangum, OKBuilt 1948 · S/N 18541 N4410VMorris Roy S · Shorter, ALBuilt 1948 · S/N 18543 N4414VVan Noy Greg A · Bozeman, MTBuilt 1948 · S/N 18547 N4416VWiebe Aron Fehr · Seminole, TXBuilt 1948 · S/N 18549 N4423VThomas Jessica A · Bethel Island, CABuilt 1948 · S/N 18554 N4436BHarris Derek A · Marion, TXBuilt 1955 · S/N 26780

Back to Cessna 170