Skip to content

Registered aircraft · 722

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

N3662LPrice John C · Bennington, KSBuilt 1965 · S/N 17253831 N3664LNixon Robert W · Mc Alpin, FLBuilt 1965 · S/N 17253833 N3668LMaui Skyhawks Inc · Kula, HIBuilt 1965 · S/N 17253837 N3669LNovacek Jeffrey J · Minneapolis, MNBuilt 1965 · S/N 17253838 N3670LLatch Leo D · Upland, CABuilt 1965 · S/N 17253839 N3671LCalmet Aircraft Leasing LLC · Middletown, DEBuilt 1965 · S/N 17253840 N3672LJanowski Stephen J Jr · Wadsworth, OHBuilt 1965 · S/N 17253841 N3675LSheppard Dale A · Kalispell, MTBuilt 1965 · S/N 17253844 N3677LBell Ellis E · Forrest City, ARBuilt 1965 · S/N 17253846 N3681LBurton Walter E · Statesboro, GABuilt 1965 · S/N 17253850 N3682LRiseaero LLC · Florence, SCBuilt 1965 · S/N 17253851 N3685LBarber Richard S · Baker, NVBuilt 1965 · S/N 17253854 N3688LNamassivaya Nagaraju · Rexford, NYBuilt 1965 · S/N 17253857 N3690LSmith Steve J · Magnolia, TXBuilt 1965 · S/N 17253859 N3697LShearair LLC · Valparaiso, INS/N 17253866 N3701LRice Solutions LLC · Plymouth, NHS/N 17253870 N3702LBailey April O · Papillion, NEFirst renewal noticeS/N 17253871 N3704LN3704l LLC · Jacksonville, FLBuilt 1965 · S/N 17253873 N3705LRed Five Aviation LLC · Wilmington, DEBuilt 1965 · S/N 17253874 N3707LPropwash Aviation LLC · Midland, MIBuilt 1965 · S/N 17253876 N3710LRegistered aircraftS/N 17253879 N3712LNoble Todd D · Hudson, INBuilt 1965 · S/N 17253881 N3714LArizona Aircraft Leasing LLC · Mesa, AZBuilt 1965 · S/N 17253883 N3719LHurst Edward E · Southlake, TXBuilt 1965 · S/N 17253888 N371RSStroberg Roger D · Hutchinson, KSBuilt 1966 · S/N 17254229 N3720LWonsyld Erik · Grants Pass, ORBuilt 1965 · S/N 17253889 N3721LFlightmaster Aviation Services Inc · Centerville, INBuilt 1965 · S/N 17253890 N3724LSnyder Brent I · Columbus, OHBuilt 1965 · S/N 17253893 N3727LMoyer David J · Middletown, DEBuilt 1965 · S/N 17253896 N3728LN3728l LLC · Statesville, NCBuilt 1965 · S/N 17253897 N3729LWells Timothy P · Raynham, MAS/N 17253898 N3731LSturguess James K · Boonville, MOS/N 17253900 N3732LSumma Dawn K · Medina, OHBuilt 1965 · S/N 17253901 N3733LHillstrom Rudolph A · Oakville, WABuilt 1965 · S/N 17253902 N3734LBertrand Todd A · Anchorage, AKBuilt 1965 · S/N 17253903 N3738LTran Tuan M · Canton, MIBuilt 1965 · S/N 17253907 N3739LMattson David G · Lake Park, MNBuilt 1965 · S/N 17253908 N3743LAero Flight Two LLC · Peoria, AZS/N 17253912 N3744LAir Jeffery LLC · Aledo, TXBuilt 1965 · S/N 17253913 N3745LMaxey Lonnie C · Powell, TNBuilt 1965 · S/N 17253914 N3746LBygd Sherman O · New Richmond, WIBuilt 1965 · S/N 17253915 N3747LN3747l LLC · Sonora, CABuilt 1965 · S/N 17253916 N3749LWilcox James F · Garrison, NDBuilt 1965 · S/N 17253918 N3753LKroutil David W · Hilmar, CABuilt 1965 · S/N 17253922 N3754LBuist Gordon G · Southbury, CTBuilt 1965 · S/N 17253923 N3755LNorcal Flight Center LLC · Lincoln, CAS/N 17253924 N3758LN3758l LLC · Titusville, FLBuilt 1965 · S/N 17253927 N3761LBas Part Sales LLC · Greeley, COS/N 17253930 N3766LSygnet Lenard M · Pottstown, PABuilt 1965 · S/N 17253935 N3770LJ&C Aviation LLC · South Boston, VABuilt 1965 · S/N 17253939

Back to Cessna 172G