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.

N124QKepes Bruce R · So Charleston, OHBuilt 1948 · S/N 18509 N170EEDowd Darin R · Gainesville, TXBuilt 1948 · S/N 18063 N170ERBowles Brent J · Iraan, TXBuilt 1948 · S/N 18328 N170JGivens Steve W · Pendleton, INBuilt 1948 · S/N 18471 N170LEArends Brian H · Mahomet, ILS/N 18271 N170LMGlastonbury Michael C · Sioux Falls, SDS/N 18457 N170RHBas Part Sales LLC · Greeley, COBuilt 1947 · S/N 18030 N170RWSchroth Ian C · Gustavus, AKS/N 18406 N170SLSimmons Kenton L · Van Alstyne, TXBuilt 1948 · S/N 18138 N170STDow Jeff W · Port Hadlock, WABuilt 1948 · S/N 18666 N170UWBlocher Kristyn A · Tumwater, WABuilt 1948 · S/N 18403 N1744DJones William H Trustee · Wenden, AZBuilt 1951 · S/N 20187 N175BAPlane Fun Inc Tr Trustee · Snellville, GABuilt 1948 · S/N 18516 N18108Larsen Kevin L · Firth, IDBuilt 1948 · S/N 18108 N1827CFrazier Tammy L · Cutler, INBuilt 1953 · S/N 25971 N2284EHarris Jeremy B · Sandy, ORBuilt 1948 · S/N 18389 N2500YSutton Aircraft Salvage LLC · Palmer, AKBuilt 1948 · S/N 18562 N2501VWherry Patrick J · Goodyear, AZBuilt 1948 · S/N 18004 N2505VNelson Brian D · Hobbs, NMBuilt 1948 · S/N 18008 N2509VBrown James · Georgetown, MEBuilt 1948 · S/N 18012 N2511VSutton Aircraft Salvage LLC · Palmer, AKBuilt 1948 · S/N 18014 N2512VNichol Nathan P · Anchorage, AKS/N 18020 N2513VMcrobie Roger L · Maryville, TNBuilt 1948 · S/N 18016 N2515VBoyd Robert T · Quakertown, PABuilt 1948 · S/N 18018 N2518VFile Thomas A · Shoreline, WABuilt 1948 · S/N 18022 N2520VSmith Gregory A · Lewistown, MTBuilt 1948 · S/N 18024 N2524VJohnson Randon · Snowflake, AZBuilt 1948 · S/N 18028 N2527VWright James C · Sulphur Springs, TXBuilt 1948 · S/N 18031 N2536VZimmer Joseph J · Marion Center, PABuilt 1948 · S/N 18105 N2537VWeatherly Richard A · Spokane Valley, WABuilt 1948 · S/N 18041 N2540VMathis Jimmie L · Port Orchard, WABuilt 1948 · S/N 18044 N2545VFun Flyers LLC · Comstock, MIBuilt 1948 · S/N 18049 N2552VBurril Matthew C · Asheville, NCBuilt 1948 · S/N 18057 N2553VJj&M LLC · Red Lodge, MTBuilt 1948 · S/N 18058 N2556VLester Paul W · Hurricane, UTBuilt 1948 · S/N 18061 N2560VCrowley John Arthur · Visalia, CABuilt 1948 · S/N 18065 N2563VSchneider Gregory M · Bridger, MTS/N 18068 N2568VFarringer Steven R · Columbia City, INBuilt 1948 · S/N 18073 N2581CClepper Catherine M · Saegertown, PABuilt 1954 · S/N 26225 N2582VThul Nathan Michael Trustee · Centralia, IABuilt 1948 · S/N 18087 N2589VGraveson John W · Uxbridge, MABuilt 1948 · S/N 18094 N2593VKenyon Chad J · Sterling, AKBuilt 1948 · S/N 18098 N2595VJm Aviation LLC · Howe, INS/N 18100 N2597VIson Joshua A · Dry Ridge, KYBuilt 1948 · S/N 18102 N2599VLyon Joshua D · Palmer, AKBuilt 1948 · S/N 18104 N2600VErickson Rodney L · Rutland, NDBuilt 1948 · S/N 18238 N2607VHamlin Ryan C · Naples, MES/N 18117 N2608VWohl Mitch A · Deer Park, ILBuilt 1948 · S/N 18118 N2609VPallotto Victor N · Passaic, NJBuilt 1948 · S/N 18119 N2616VStage One Associates LLC · Oxford, CTBuilt 1948 · S/N 18126

Back to Cessna 170