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.

N8304BWarzecha Kathy A · Sauk Rapids, MNBuilt 1957 · S/N 36104 N8305BHansen Mark A · Savannah, GABuilt 1957 · S/N 36105 N8306BCoopsair LLC · Saint Petersburg, FLS/N 36106 N8307BRogers Eric M · Cascade, IDBuilt 1957 · S/N 36107 N8308BBerg Timothy J · Neenah, WIS/N 36108 N8311BSills Joseph G · Giddings, TXBuilt 1957 · S/N 36111 N8312BCheatham Harold Joseph · San Diego, CARegistration revokedBuilt 1957 · S/N 36112 N8316BHudspeth Steve A · Wasilla, AKBuilt 1957 · S/N 36116 N8318BRegistration Pending · Redondo Beach, CARegistration pendingBuilt 1957 · S/N 36118 N8319BLobue Andrew N · Gresham, ORBuilt 1957 · S/N 36119 N8321BSkyhawk18 LLC · Opa Locka, FLBuilt 1957 · S/N 36121 N8324BVitt Steven · Lecanto, FLBuilt 1957 · S/N 36124 N8325BDeckard Leroy Jr · Waller, TXS/N 36125 N8328BMontpelier Gary L · W Chazy, NYBuilt 1957 · S/N 36128 N8338BSmitty172 LLC · Rockford, MIBuilt 1957 · S/N 36138 N8339BSmith Daniel B · Boonville, NCBuilt 1957 · S/N 36139 N8341BColeman Patrick D · Naperville, ILBuilt 1957 · S/N 36141 N8342BShelton Harold G · Christiansburg, VABuilt 1957 · S/N 36142 N8348BSogg Steven L · Auburn, WABuilt 1957 · S/N 36148 N8350BTatum Travis · Gatesville, TXBuilt 1957 · S/N 36150 N8352BRoark Larry W · Wheatland, INBuilt 1957 · S/N 36152 N8353BRodriguez Antonio M · Presidio, TXFirst renewal noticeBuilt 1957 · S/N 36153 N8354BTri Flight LLC · Cottonwood, MNBuilt 1957 · S/N 36154 N8355BBowen Jeffrey N · Jacksonville, NCBuilt 1957 · S/N 36155 N8357BHarker James P · Blaine, MNS/N 36157 N8361BBrim Robert H · Bellingham, WABuilt 1957 · S/N 36161 N8362BDelp Ryan K · Southbury, CTS/N 36162 N8364BDigiacomo Ernest R · Hampton Bays, NYBuilt 1957 · S/N 36164 N8365BHallada David M · Lakeview, MIBuilt 1957 · S/N 36165 N8367BPrudek Daniel M · Rathdrum, IDFirst renewal noticeS/N 36167 N8369BO'Keefe Joseph G · Madera, CABuilt 1957 · S/N 36169 N8370BKline Nicholas J · Alliance, OHBuilt 1957 · S/N 36170 N8373BSkyview Aviation LLC · Tracy, CABuilt 1957 · S/N 36173 N8374BGardner Gilbert W · Hartford, KSBuilt 1957 · S/N 36174 N8375BRutan James · Palmer, AKS/N 36175 N8376BBilton Aircraft Management Inc · Umatilla, FLBuilt 1957 · S/N 36176 N8377BLittle Eagle Valley LLC · Dover, DEBuilt 1957 · S/N 36177 N8377HRhodes Kent A · Seattle, WABuilt 1956 · S/N 29426 N8380BShull Thomas A · Copper Center, AKBuilt 1957 · S/N 36180 N8381BRaymond Kyle Inc · Eagle, COS/N 36181 N8382BDevore Plane Affects Lp · Independence, KSS/N 36182 N8383BSpears Franklin L · Lebanon, KYBuilt 1957 · S/N 36183 N8385BTkn Holdings LLC · Pima, AZBuilt 1957 · S/N 36185 N8388BTouch And Go Inc · Center, COBuilt 1957 · S/N 36188 N8392BWeber Thomas P · North Bend, WABuilt 1957 · S/N 36192 N8393BSingh Gurdev · Cathedral City, CABuilt 1957 · S/N 36193 N8395BHughston Chris · Nashville, TNBuilt 1957 · S/N 36195 N8397BDiaz George D · Tucson, AZBuilt 1957 · S/N 36197 N8398BThal James C · Fredericktown, MOBuilt 1957 · S/N 36198 N8399BHumphrey William J · Whiteville, NCBuilt 1957 · S/N 36199

Back to Cessna 172