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.

N797DJN797dj LLC · Fayetteville, GABuilt 1964 · S/N 17251971 N7981USkyhawk Aviation LLC · Midland, MIBuilt 1964 · S/N 17251981 N7982ULastowski Jeffrey A · Mooresville, INBuilt 1964 · S/N 17251982 N7984UButter Kendall L · Gatesville, TXBuilt 1964 · S/N 17251984 N7987UFrick Gary A Trustee · Marion, INBuilt 1964 · S/N 17251987 N7989UA-Cent Aviation Inc · Jacksonville, FLBuilt 1964 · S/N 17251989 N7993UKrecek Jason · Hiram, OHS/N 17251993 N7994UScott Geoffrey H · Jacksonville, FLBuilt 1964 · S/N 17251994 N7996UVolare Of Sc LLC · Myrtle Beach, SCBuilt 1964 · S/N 17251996 N7998USparks Fly LLC · Mount Gilead, OHBuilt 1964 · S/N 17251998 N79DLWilsco Robert L · Arlington, WAS/N 17251930 N8101UWeirick Kelly M · Morganton, NCBuilt 1964 · S/N 17252001 N8104UMellen Dennis L · Peoria, ILBuilt 1964 · S/N 17252004 N8110UHeigle Randall K · Fouke, ARBuilt 1964 · S/N 17252010 N8111UTarkki Jarmo O · Solvang, CABuilt 1964 · S/N 17252011 N8112UHaleco LLC · Pensacola, FLBuilt 1964 · S/N 17252012 N8118URegistration Pending · Heath, OHRegistration pendingBuilt 1964 · S/N 17252018 N8121UFishburn Tol M · Eagle River, AKBuilt 1964 · S/N 17252021 N8124UGardoski Mark · Twin Falls, IDBuilt 1964 · S/N 17252024 N8125UAgati Stephen B · Tucker, GABuilt 1964 · S/N 17252025 N8128UWalters Stephen B · Madison, ALBuilt 1964 · S/N 17252028 N8130UWade Air LLC · Clanton, ALBuilt 1964 · S/N 17252030 N8131UTodd James M · Angleton, TXBuilt 1964 · S/N 17252031 N8134UColey Lee · Fayetteville, GABuilt 1964 · S/N 17252034 N8136UMoors Thomas G · Wentzville, MOBuilt 1964 · S/N 17252036 N813HYOcala Aviation Services Inc · Ocala, FLBuilt 1964 · S/N 17252033 N8140UAnderson Milton M · Twin Bridges, MTS/N 17252040 N8142UMartin Ralph Edward · Jonesboro, ARBuilt 1964 · S/N 17252042 N8143UJon Boyd Beard · Houston, TXBuilt 1964 · S/N 17252043 N8146UBearce Todd A · Phoenix, AZS/N 17252046 N8151UYork George T · Harvard, ILBuilt 1964 · S/N 17252051 N8152UGentry James L · Englewood, TNBuilt 1964 · S/N 17252052 N8153UGorman Shawn Michael · Van Wert, OHBuilt 1964 · S/N 17252053 N8154UPodgorski James E · Walworth, WIBuilt 1964 · S/N 17252054 N8155UShearer Ronald L · Quincy, INBuilt 1964 · S/N 17252055 N8157UQuarter To Two Flying Club Inc · Williamsport, PABuilt 1964 · S/N 17252057 N8161UKaiser James · Fond Du Lac, WIBuilt 1964 · S/N 17252061 N8162ULunger Eric K · Mifflintown, PABuilt 1964 · S/N 17252062 N8163UCave Mark A · Snyder, TXBuilt 1964 · S/N 17252063 N8165UFena Daniel J · Side Lake, MNS/N 17252065 N8169UThorn Mark · Vashon, WABuilt 1964 · S/N 17252069 N8170UFields William B · Climax, NCBuilt 1964 · S/N 17252070 N8172UPrice Paul S · Camano Island, WABuilt 1964 · S/N 17252072 N8174UJenson James H · Downers Grove, ILBuilt 1964 · S/N 17252074 N8175UN8175u LLC · Rosemount, MNS/N 17252075 N817PSSutton Aircraft Salvage LLC · Palmer, AKBuilt 1965 · S/N 17252705 N8181UMillman Chris · Auburn, WABuilt 1964 · S/N 17252081 N8182UMorristown Flying Service Inc · Talbott, TNBuilt 1964 · S/N 17252082 N8183UMacauley Richard D · Shingle Springs, CABuilt 1964 · S/N 17252083 N8186ULake Area Technical College · Watertown, SDBuilt 1964 · S/N 17252086

Back to Cessna 172F