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.

N3925VBasta Edward L · Cascade Locks, ORS/N 18235 N3929VSparks Claude W Jr · Winter Park, FLBuilt 1948 · S/N 18248 N3934VHaddock Jared · Mount Vernon, WABuilt 1948 · S/N 18253 N3941VFrazier Jonas · Davie, FLS/N 18260 N3942VMossman Andrew D · Pickerington, OHBuilt 1948 · S/N 18261 N3943VHardman Kyle B · Shady Shores, TXBuilt 1948 · S/N 18262 N3947VCooper Charles N III · Sardinia, OHBuilt 1948 · S/N 18266 N3948VKlein Jordan Jr · Summerfield, FLS/N 18267 N3949VShort Thomas · Noblesville, INBuilt 1948 · S/N 18268 N3950VPartridge Leslie R · Spicewood, TXS/N 18269 N3951VBrosh Donald R · Centennial, COBuilt 1948 · S/N 18376 N3954VMoyer Michael · Duarte, CABuilt 1948 · S/N 18273 N3956VBell Robert D · Okeechobee, FLS/N 18275 N3958VKelsall William J · Coatesville, PABuilt 1948 · S/N 18277 N3962VLewis Aaron J · Salado, TXFirst renewal noticeBuilt 1947 · S/N 18281 N3963VAndresen Melvin D · Yukon, OKBuilt 1948 · S/N 18282 N3970VLapalm Mark W · Wasilla, AKBuilt 1948 · S/N 18289 N3972VShockey Duane L · San Diego, CABuilt 1948 · S/N 18291 N3976VOliver Benton J · Milton, FLS/N 18295 N3979VWright Steven A · Odessa, FLBuilt 1948 · S/N 18298 N3980VRegistered aircraftS/N 18299 N3981VConstantine Lucas · Anchorage, AKBuilt 1948 · S/N 18300 N3983VInman Dentis Ray · Whiteville, TNBuilt 1948 · S/N 18302 N3988VPelotte Matthew J · Waterville, MEBuilt 1948 · S/N 18307 N3989VFelten William J · Sagle, IDBuilt 1948 · S/N 18308 N3992VBerryman Adna M · Houston, TXRegistration revokedBuilt 1948 · S/N 18311 N3993VCushman Nicholas R · Mesa, AZBuilt 1948 · S/N 18312 N3996VShiver Gary C · Zolfo Springs, FLBuilt 1948 · S/N 18315 N3998VDoornbos Keith · Bloomington, ILS/N 18317 N4001VKittelman Tom L · Buckley, WAS/N 18320 N4002VLofstrom David S · Chugiak, AKS/N 18321 N4003VPa Services Gulfsouth LLC · Minden, LAS/N 18322 N4004VDitges Nathanael · Creston, IABuilt 1948 · S/N 18323 N4005VScarberry Dennis L · Goddard, KSBuilt 1948 · S/N 18324 N4010VSale Reported · Saint Joseph, MOSale reportedBuilt 1948 · S/N 18329 N4011VDeal Michael R · Elko, NVBuilt 1948 · S/N 18330 N4012VBaker Air Service Inc · Baker, MTBuilt 1948 · S/N 18331 N4013VBaldwin John D · Sisters, ORBuilt 1948 · S/N 18332 N4017VSimpson James H · Craig, COBuilt 1948 · S/N 18336 N4019VEastman Gregory L · Pueblo, COBuilt 1948 · S/N 18338 N4021VBeishline Daniel · Bath, MES/N 18340 N4026VLandry Timothy G · Lodi, CABuilt 1948 · S/N 18345 N4032VHart Travis R · Ontario, ORBuilt 1948 · S/N 18351 N4033VJepsen James Scott · Kirkwood, MOBuilt 1948 · S/N 18380 N4035VBeckner Russell R · Rutland, MAS/N 18382 N4039VHowe Shawn E · Lewistown, PABuilt 1948 · S/N 18358 N4042VFreedom Aviation · Salina, KSBuilt 1948 · S/N 18361 N4043VThompson Frank · Weiser, IDBuilt 1948 · S/N 18362 N4044VStrnad William J · Taylors Falls, MNBuilt 1948 · S/N 18369 N4046VHowell Alvin M · Needville, TXS/N 18373

Back to Cessna 170