Skip to content

Registered aircraft · 718

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

N5352RProam Flyers Of Union County · Matthews, NCBuilt 1965 · S/N 17252882 N5355RFeauto Aviation LLC · Saint Cloud, FLBuilt 1965 · S/N 17252885 N5358RVandenbosch Joseph P · Bergen, NYBuilt 1965 · S/N 17252889 N5360RSommer Wayne · Wellsville, MOBuilt 1965 · S/N 17252891 N5362RWeinhold Dale J Trustee · Ellsworth, KSBuilt 1965 · S/N 17252893 N5363RCrawford James A · Coshocton, OHBuilt 1965 · S/N 17252894 N5367RBrooks Gordon B Sr · Hot Springs, SDBuilt 1965 · S/N 17252899 N5368RBiggs Aircraft Inc · Wellston, OKBuilt 1965 · S/N 17252900 N5371RAirglas Inc · Anchorage, AKBuilt 1965 · S/N 17252904 N5378RGittlein Paul A · Wasilla, AKBuilt 1965 · S/N 17252912 N5384RKidd Frank E Jr · Wilson, NCBuilt 1965 · S/N 17252919 N5386RVargo Michael D · Fremont, OHBuilt 1965 · S/N 17252921 N5387ROancea Traian · Oakdale, CAS/N 17252922 N5389RTetrault David E · Largo, FLBuilt 1965 · S/N 17252925 N5390RSmith James H · Fordyce, ARBuilt 1965 · S/N 17252926 N5396RPrecocity Academy LLC · Gibsonia, PABuilt 1965 · S/N 17252933 N5403RPeterson Matthew · Overland Park, KSBuilt 1965 · S/N 17252941 N5404RKoller Rex E · Athens, ALS/N 17252942 N5405RPolson Taylor M · Killeen, TXBuilt 1965 · S/N 17252943 N5406RMmm Enterprises LLC · Aurora, INBuilt 1965 · S/N 17252945 N5407RLake Area Technical College · Watertown, SDS/N 17252946 N5410RIsbell Thomas · Mountain View, ARBuilt 1965 · S/N 17252950 N5412RYoungstown Warren Development Partners · Youngstown, OHS/N 17252953 N5413RMckee Thomas E · Terra Alta, WVBuilt 1965 · S/N 17252954 N5417RBuenting John E · Sylva, NCBuilt 1965 · S/N 17252959 N5420RBarrientos Sebastian · Tamarac, FLBuilt 1965 · S/N 17252963 N5421RAviation Design LLC · Kalamazoo, MIBuilt 1965 · S/N 17252965 N5422RRice Robert M · Huntsville, ALBuilt 1965 · S/N 17252966 N5425RWalker Lyle P · Katy, TXBuilt 1965 · S/N 17252970 N5429RRose Ronald R · Richland, NYBuilt 1966 · S/N 17252975 N5432RMishmash Christopher L · Valdez, AKBuilt 1965 · S/N 17252979 N5433RJones Kenneth Jr · Lufkin, TXBuilt 1965 · S/N 17252981 N5434RFlorida Keys Flight Academy LLC · Marathon, FLBuilt 1965 · S/N 17252982 N5439RIndian Hills Community College · Ottumwa, IABuilt 1965 · S/N 17252989 N5441RGraham Norman J · West Ossipee, NHBuilt 1965 · S/N 17252991 N5442RBarnes Terry A · Austin, TXBuilt 1965 · S/N 17252993 N5444RAlpha Romeo Aviation LLC · Phoenix, AZBuilt 1965 · S/N 17252995 N5445RWimpy Gregory S · Griffin, GABuilt 1965 · S/N 17252997 N5447RToth Roger J · Willoughby, OHFirst renewal noticeBuilt 1965 · S/N 17252999 N5448RBuby Lloyd F · Mannington, WVBuilt 1965 · S/N 17253001 N5449RMartin David · Waterport, NYBuilt 1965 · S/N 17253002 N5450RMayer Ag Service · Chamberlain, SDBuilt 1965 · S/N 17253003 N5451RYoungstown Warren Development Partners · Vienna, OHBuilt 1965 · S/N 17253005 N5452RWilliams Matthew W · Auburn, WABuilt 1965 · S/N 17253006 N5453RVaughn Mark R · Fort Payne, ALBuilt 1965 · S/N 17253007 N5455REpstein Paul · Pensacola, FLBuilt 1965 · S/N 17253010 N5457RFarrand David V · London, OHBuilt 1965 · S/N 17253013 N5458RLafranchise Louis C · Aurora, ORS/N 17253014 N5459RAllsup Rachel B · Anchorage, AKBuilt 1965 · S/N 17253015 N5460RTake Angels Aviation LLC · Watertown, NYBuilt 1965 · S/N 17253017

Back to Cessna 172F