Skip to content

Registered aircraft · 722

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

N3870LStraub Brian L · Queensbury, NYBuilt 1965 · S/N 17254039 N3872LMaletich Steven J · Las Vegas, NVBuilt 1965 · S/N 17254041 N3875LBazemore Robert J · Butler, GAS/N 17254044 N3876LWoerle Edward R · Rossville, TNS/N 17254045 N3878LLatshaw Sonja · Vero Beach, FLBuilt 1965 · S/N 17254047 N3879LThielemann Kate Ann · Inverness, FLBuilt 1966 · S/N 17254048 N3881LDarnell David M · Bon Aqua, TNS/N 17254050 N3883LBragg Gary W · Rainelle, WVBuilt 1966 · S/N 17254052 N3884LCosta Jason L · Spring Hill, FLBuilt 1966 · S/N 17254053 N3886LRench Eugene G · Owosso, MIS/N 17254055 N3887LHigley Ryan · Arlee, MTBuilt 1965 · S/N 17254056 N3889LBaker Duane · Shepherd, TXS/N 17254058 N3890LTexas Yellow Rose Planes LLC · Fort Worth, TXBuilt 1965 · S/N 17254059 N3892LHuettl Austin · Liberty Hill, TXBuilt 1965 · S/N 17254061 N3895LGoodyear Aviation Business Services LLC · Buckeye, AZBuilt 1965 · S/N 17254064 N3896LMcphillips Flying Service Inc · Beaver Island, MIBuilt 1965 · S/N 17254065 N3900LShaw Flying Club LLC · Cleveland, MSS/N 17254069 N3901LSan Fernando Aviation LLC · Van Nuys, CAS/N 17254070 N3907L33 Global LLC · Potomac Falls, VABuilt 1965 · S/N 17254076 N3909LBlakeley David · Lancaster, NYBuilt 1965 · S/N 17254078 N3910LHickerson Sherman · Broken Bow, OKS/N 17254079 N3917LShipley Kelly R · Warrenton, ORS/N 17254086 N3918LBrown Tony A Jr · Calhoun City, MSBuilt 1965 · S/N 17254087 N3921LClark Michael L · Waco, TXBuilt 1965 · S/N 17254090 N3922LVan Tin C · Ellicott, MDS/N 17254091 N3926LWerner Christopher R · Anderson, CABuilt 1966 · S/N 17254095 N3927LCatlett Robert B · Wasilla, AKBuilt 1966 · S/N 17254096 N3928LLumpkins Lonnie D · Longview, TXBuilt 1966 · S/N 17254097 N3931LMollentze Robert A H · Marietta, GABuilt 1965 · S/N 17254100 N3932LHughes Gerald R · Huntsville, ALBuilt 1965 · S/N 17254101 N3934LMiller Rick J · Amherst, OHBuilt 1965 · S/N 17254103 N3936LHeldman John M · Rawson, OHBuilt 1966 · S/N 17254105 N3940LLeblanc Charles A · Jacksonville, FLS/N 17254109 N3942LOriginal Design Ministries · Eatonville, WABuilt 1966 · S/N 17254111 N3945LBlakesley Barrett · Spokane, WABuilt 1966 · S/N 17254114 N3955LLukasik Jason D · Eagle River, AKBuilt 1966 · S/N 17254124 N3958LN3958l LLC · Honolulu, HIBuilt 1965 · S/N 17254127 N3959LV1vr LLC · Wilmington, DEBuilt 1966 · S/N 17254128 N3961LRaya Thomas S · Porterville, CABuilt 1966 · S/N 17254130 N3963LN3963l LLC · Bishop, GABuilt 1966 · S/N 17254132 N3964LAirhorse Aviation LLC · Youngstown, OHS/N 17254133 N3966LJohnston Traci L · Denver, NCBuilt 1966 · S/N 17254135 N3967LJalukar Vishram · Mason City, IABuilt 1966 · S/N 17254136 N3968LSaddler Susan J · Dayton, OHBuilt 1966 · S/N 17254137 N3970LHughes William L II · Ft Worth, TXBuilt 1966 · S/N 17254139 N3971LKenworthy Christian R · Missoula, MTS/N 17254140 N3972LBerg Brian R · Mechanicsville, VABuilt 1966 · S/N 17254141 N3974LLake Area Technical College · Watertown, SDBuilt 1966 · S/N 17254143 N3976LMccrimmon Edward W · Suwanee, GABuilt 1966 · S/N 17254145 N3979LLine Steven J · Jonesboro, ARBuilt 1966 · S/N 17254148

Back to Cessna 172G