Skip to content

Registered aircraft · 1,805

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

N4096FGood John G · Weatherford, TXBuilt 1958 · S/N 36996 N4097FWadsworth Tom R · Roswell, NMBuilt 1958 · S/N 36997 N4101FHanson Kathleen A · Wasilla, AKS/N 46001 N4102FAdams Samuel M · Anna, TXBuilt 1958 · S/N 46002 N4104FMcmahon William F · Westville, INS/N 46004 N4111FRoss Karen F · Marion, TXBuilt 1958 · S/N 46011 N4112FWard Leigh C · Garden Valley, IDBuilt 1958 · S/N 46012 N4118FMountain Air Spray Co Inc · Craig, COS/N 46018 N4119FPlymate Claude L · Tehachapi, CABuilt 1958 · S/N 46019 N4121FHarrold Bruce E · Greybull, WYBuilt 1958 · S/N 46021 N4124FNelson David R Co-Trustee · New Richmond, WIBuilt 1958 · S/N 46024 N4125FSale Reported · Addison, TXSale reportedBuilt 1958 · S/N 46025 N4126FRider Terry · Corinth, MSBuilt 1958 · S/N 46026 N4127FDavolt John E · Independence, KSFirst renewal noticeBuilt 1958 · S/N 46027 N4128FSkidmore Arnold D · Williamsburg, OHBuilt 1958 · S/N 46028 N4132FBaldwin Vivian E · Owasso, OKBuilt 1958 · S/N 46032 N4134FGaffney Mark M · Lincoln, NEBuilt 1958 · S/N 46034 N4143FSteier Tim A · Salome, AZBuilt 1958 · S/N 46043 N4144FKoch Gerald P · Mount Vernon, SDBuilt 1958 · S/N 46044 N4146FGompert Andrew B · Burwell, NEBuilt 1958 · S/N 46046 N4147FSwan Steve · Jackson, WYBuilt 1958 · S/N 46047 N4148FBorders Jimmie L · Tompkinsville, KYBuilt 1958 · S/N 46048 N4149FCarruth Peter J · Benson, MNS/N 46049 N4150FRegistration Pending · Clinton Township, MIRegistration pendingS/N 46050 N4152FGaertner Kim L · Oconto, WIBuilt 1958 · S/N 46052 N4153FChaffee Craig O · Le Raysville, PABuilt 1958 · S/N 46053 N4156FPintar Robert · Spokane, WAS/N 46056 N4157FBeasley John V III · Amarillo, TXS/N 46057 N4158FKraft Dean B · Mapleton, NDBuilt 1958 · S/N 46058 N4161FGilbertson Daniel E · Duluth, MNBuilt 1958 · S/N 46061 N4162FPowell Clinton J · Pleasanton, TXBuilt 1958 · S/N 46062 N4167FHamburg Jeffrey B · Warner Robins, GABuilt 1958 · S/N 46067 N4168FOfarrell Leo S · Lakeport, CABuilt 1958 · S/N 46068 N4172FEdwon Ronnie L · Mesa, AZBuilt 1958 · S/N 46072 N4175FGay Clayton B · Villisca, IAFirst renewal noticeBuilt 1958 · S/N 46075 N4176FKruggel Kurt · Rancho Cucamonga, CABuilt 1958 · S/N 46076 N4177FWinkler Steve · Clarksburg, CABuilt 1958 · S/N 46077 N4182FHong Jason S · Yorba Linda, CABuilt 1958 · S/N 46082 N4183FDurocher David T · Logan, UTFirst renewal noticeBuilt 1958 · S/N 46083 N4184FCastle Jame R · Douglasville, GABuilt 1958 · S/N 46084 N4188FBayliss Warren E · Orlando, FLBuilt 1958 · S/N 46088 N4190FKelly-Hackett Kylie Kristine · Wilkeson, WABuilt 1958 · S/N 46090 N4191FN4191f LLC · Kingsland, TXBuilt 1958 · S/N 46091 N4192FDavidson E Bryant Trustee · Owasso, OKBuilt 1958 · S/N 46092 N4195FDavolt John W · Hobe Sound, FLS/N 46095 N4196FLabrie David L · Deland, FLBuilt 1958 · S/N 46096 N4197FFrizzell Joshua R · Mcdonough, GABuilt 1958 · S/N 46097 N4199FPena Edwin A · Mission Hills, CABuilt 1958 · S/N 46099 N4200FVanhorne John W · Everett, WABuilt 1958 · S/N 46100 N4203FWindham Air LLC · Oxford, FLBuilt 1958 · S/N 46103

Back to Cessna 172