Skip to content

Registered aircraft · 717

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.

N100KN18t Ltd · Wilmington, DEBuilt 1965 · S/N 17252599 N100YSLally Lawrence L · Mooresville, NCBuilt 1965 · S/N 17252400 N101Bene Mary D · Ketchum, OKBuilt 1964 · S/N 17252056 N103CTSocolosky Stephen Gerard · East Hartford, CTBuilt 1973 · S/N 17253365 N1117THimes Austin M · Wentworth, MOBuilt 1965 · S/N 17252759 N1129MTechair LLC · Playa Vista, CAS/N 17252240 N124PJNortheast Florida Aero Club Inc · Fleming Island, FLBuilt 1964 · S/N 17252491 N1701Rolston Charles W · Shoreview, MNBuilt 1964 · S/N 17252418 N172CDHnh Enterprises Inc · Lander, WYBuilt 1964 · S/N 17252386 N172EGMondloch Jesse R · Freedom, WIBuilt 1964 · S/N 17252003 N172GFDel Martin Lp · Spring, TXBuilt 1965 · S/N 17252903 N172GXSingleton Randy V · Shippensburg, PABuilt 1965 · S/N 17252756 N172KCWellner Thomas B · Bremerton, WABuilt 1965 · S/N 17252649 N172KRRose Kim M · Mount Vernon, OHBuilt 1965 · S/N 17252960 N172VLEnce Daniel G · Saint George, UTBuilt 1964 · S/N 17251968 N173VFCorlee Douglas K · Palm Coast, FLBuilt 1964 · S/N 17252157 N17BSSell William T · Orofino, IDBuilt 1965 · S/N 17252856 N181TTWilson James · Bagwell, TXBuilt 1964 · S/N 17252385 N1XSaitto Jeffrey M · Media, PABuilt 1965 · S/N 17252958 N21RPJ-Dawgs Aviation LLC · Greenville, NCS/N 17252591 N234RMWilliams Walt A · Mena, ARBuilt 1964 · S/N 17252230 N2502YSkinner Norman D · Osceola, IABuilt 1965 · S/N 17253227 N2545YCalifornia Aviation Services Inc · Riverside, CABuilt 1965 · S/N 17252552 N2586SCasey Aviation Inc · Mansfield, MAS/N 17252809 N269RDHumphries Aviation LLC · Maysville, KYS/N 17252737 N2JHReign Air Charter Corp · New Port Richey, FLBuilt 1964 · S/N 17252443 N30DBBouchard Dean · Glendive, MTBuilt 1965 · S/N 17252702 N336RSAirspeed Marketing LLC · Phoenix, AZS/N 17252228 N3507SBengen Dietrick K · Pasco, WABuilt 1965 · S/N 17253090 N370LATurning Point @ Sonrise Inc · Hartsville, TNBuilt 1964 · S/N 17251995 N375LARegistered aircraftBuilt 1965 · S/N 17252722 N378LARials Tommy G · Crystal Springs, MSBuilt 1965 · S/N 17252795 N411RFFoothill Aircraft Sales & Service Inc · Upland, CAS/N 17252216 N41AFAmerican Airpower Heritage Flying Museum Inc · Dallas, TXBuilt 1965 · S/N 17253102 N424BCPikeside Flying Club Inc · Martinsburg, WVBuilt 1964 · S/N 17252171 N439CEMuller Jenny DBA · Cody, NEBuilt 1965 · S/N 17253171 N444YZBlue Aero Group LLC · Blairstown, NJBuilt 1965 · S/N 17253119 N4991BStapleton Kenneth E · Nocona, TXBuilt 1965 · S/N 17252588 N505FNovotny Paul A · Elk River, MNBuilt 1964 · S/N 17251911 N5100FAir & Space Education Instittute Inc · Pine Knot, KYBuilt 1964 · S/N 17251947 N5108FCooper Gerald W · Kennewick, WABuilt 1965 · S/N 17252727 N5113FVtf LLC · Winter Haven, FLBuilt 1965 · S/N 17252762 N5115FSunrise Equipment Co · Canton, OHBuilt 1965 · S/N 17252776 N5116FMancuso Donald R · Weatherford, TXBuilt 1965 · S/N 17252783 N5120FUnited States Air Force · Jacksonville, FLBuilt 1965 · S/N 17252811 N5122FRay Richard H · Franklin, GABuilt 1965 · S/N 17252825 N5125FEckles Aircraft LLC · Holdenville, OKBuilt 1965 · S/N 17252846 N5126FEkblad Carl A · New Port Richey, FLBuilt 1965 · S/N 17252853 N5127FDolan Ross R · Portland, MEBuilt 1965 · S/N 17252860 N5131FWoerle Edward R · Rossville, TNBuilt 1965 · S/N 17252888

Back to Cessna 172F