Skip to content

Registered aircraft · 857

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

N2896QWings Over Texas Holdings LLC · Denton, TXBuilt 1971 · S/N 17259896 N291KFTotal Flight Aircraft Leasing LLC · Apex, NCBuilt 1972 · S/N 17260482 N321PAFosston Flying Club Inc · Fosston, MNBuilt 1971 · S/N 17260202 N323SMAmerican Patrols Inc · Midland, TXBuilt 1972 · S/N 17260679 N32LACircle S Aviation LLC · Starkville, MSBuilt 1972 · S/N 17260454 N333AFChickasha Wings Inc · Chickasha, OKBuilt 1972 · S/N 17260403 N336AFLaine Carey E · Nevada City, CABuilt 1972 · S/N 17260404 N3591FWolfe Robert G · West Columbia, SCBuilt 1970 · S/N 17259225 N3593FEakin Robert C · Franklin, PABuilt 1970 · S/N 17259400 N364CKSchneider William J Jr · Cedar Key, FLS/N 17260354 N369RAShaffer Patricia G · Texarkana, TXBuilt 1971 · S/N 17259719 N3803QAmerican Patrols Inc · Midland, TXBuilt 1971 · S/N 17259903 N3804QWings Over Texas Holdings LLC · Denton, TXBuilt 1971 · S/N 17259904 N3816QGoli Aviation LLC · Raleigh, NCBuilt 1971 · S/N 17259916 N3817QMoses Aviation Services LLC · Uvalde, TXS/N 17259917 N3818QRanch Hand Flying Club Inc · Gardiner, NYBuilt 1972 · S/N 17259918 N3819QGulf Coast Aero Club Inc · Sarasota, FLBuilt 1971 · S/N 17259919 N3822QMatanane Roke C · Barrigada, GUBuilt 1971 · S/N 17259922 N3825QFischer Roger G · Torrance, CABuilt 1971 · S/N 17259925 N3829QMiller Randall J · Arlington, WABuilt 1971 · S/N 17259929 N3830QAero Place Flyers Inc · Urbana, ILBuilt 1971 · S/N 17259930 N3833QDowning Robert · Talent, ORBuilt 1971 · S/N 17259933 N3837QBaja Guided Tripps LLC · Grand Lake Stream, MEBuilt 1971 · S/N 17259937 N3844QSmtm Holdings Inc · Wilmington, DEBuilt 1971 · S/N 17259944 N3845QMacon Flying Club Inc · Macon, MOBuilt 1971 · S/N 17259945 N3848QWestwind Flyers LLC · Friday Harbor, WABuilt 1971 · S/N 17259948 N3849QSmetana Louis V III · Blair, NEBuilt 1971 · S/N 17259949 N3852QOwens Wilbur · Rch Palos Vrd, CAS/N 17259952 N3854QHafford Jay T · Stevenson, WAS/N 17259954 N3858QPylant Eric Jon · Arnold, CABuilt 1971 · S/N 17259958 N3861QLopez Mario J · Torrance, CABuilt 1971 · S/N 17259961 N3862QQ Flyers LLC · Anaheim, CABuilt 1971 · S/N 17259962 N3863QCondor Air LLC · Pleasant Valley, NYBuilt 1971 · S/N 17259963 N3864QEvans James · Tuolumne, CAS/N 17259964 N3865QAmerican Patrols Inc · Midland, TXBuilt 1971 · S/N 17259965 N3866QOcala Aviation Services Inc · Ocala, FLBuilt 1971 · S/N 17259966 N3867QLangner Dale R · Louisburg, KSBuilt 1971 · S/N 17259967 N3869QNew Garden Township · Landenberg, PABuilt 1971 · S/N 17259969 N3870QLake Waccamaw Aviation LLC · Lake Waccamaw, NCBuilt 1971 · S/N 17259970 N3872QGibbs Elizabeth A · Bellingham, WABuilt 1971 · S/N 17259972 N3873QSkywalker Flight School LLC · Adrian, MIBuilt 1971 · S/N 17259973 N3875QAerial Scouting Solutions LLC · Sioux Center, IABuilt 1971 · S/N 17259975 N3876QKracke Spraying Service Inc · Fargo, NDBuilt 1971 · S/N 17259976 N3880QJ&J Hangars LLC · Newnan, GABuilt 1971 · S/N 17259980 N3882QRiddle Kenneth G · Cherryville, NCBuilt 1971 · S/N 17259982 N3883QAir Williams LLC · Arlington, TXBuilt 1971 · S/N 17259983 N3884QWrangell Mountain Air Inc · Palmer, AKBuilt 1971 · S/N 17259984 N3889QRegistration Pending · White, GARegistration pendingBuilt 1971 · S/N 17259989 N388PGAviator Air Flight School LLC · Grand Prairie, TXBuilt 1972 · S/N 17260525 N3891QRiley George L III · Washington, INBuilt 1971 · S/N 17259991

Back to Cessna 172L