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.

N172DTMilam Six LLC · Milam, TXBuilt 1965 · S/N 17253770 N172JAPalmenteri Louis J · Rhome, TXBuilt 1966 · S/N 17254401 N236DAFalany Curtis E · Tallahassee, FLBuilt 1966 · S/N 17254466 N247DLCentral Florida Flight LLC · Ocoee, FLBuilt 1966 · S/N 17254201 N2975UDehay John M · Bynum, TXBuilt 1966 · S/N 17254180 N2976UReid Brian M · Boise, IDBuilt 1966 · S/N 17254525 N305ACTascosa Trail Inc · Gruver, TXBuilt 1965 · S/N 17253679 N30MUOracle Aviation LLC · Omaha, NEBuilt 1965 · S/N 17253432 N321BMMacintosh William J · Simpsonville, SCBuilt 1966 · S/N 17254361 N333RXJourneys Aviation Inc · Boulder, COBuilt 1966 · S/N 17254308 N3373BManley Steven T · Dallas, TXBuilt 1965 · S/N 17253577 N33KYBurnette Ric A · Sebastian, FLS/N 17253910 N345QASale Reported · Leesburg, FLSale reported, pending cancellationBuilt 1965 · S/N 17253628 N3603LBeardsley David A · Arlington, WABuilt 1967 · S/N 17253772 N3605LUnger Aviation LLC · Saint Clair, MIBuilt 1965 · S/N 17253774 N3608LJ P Aero Holdings Inc · Carson City, NVS/N 17253777 N3611LVick Garland L · Benton, ARBuilt 1965 · S/N 17253780 N3612LClean Waste Solutions LLC · Indianapolis, INBuilt 1965 · S/N 17253781 N3614LHarris Danny R · Winnsboro, TXBuilt 1965 · S/N 17253783 N3615LEynon Thomas Elliott · North Royalton, OHS/N 17253784 N3616LSoflair Aviation Solutions LLC · Miami, FLS/N 17253785 N3620LMullins Lawrence D · Germantown, OHBuilt 1965 · S/N 17253789 N3622LStrelzik Raymond W · Hatfield, PABuilt 1965 · S/N 17253791 N3625LWilliams Michael R · Gig Harbor, WABuilt 1965 · S/N 17253794 N3626LKoshar Robert E · Watervliet, MIBuilt 1965 · S/N 17253795 N3627LGeorge Edward J · Highland Village, TXBuilt 1965 · S/N 17253796 N3628LThrasher Gary Phillip · Galena, OHBuilt 1965 · S/N 17253797 N3631LMcveigh Ian T · Mansfield, TXS/N 17253800 N3632LInternational Life Equity Group LLC · Columbia, KYBuilt 1966 · S/N 17253801 N3634LWahlberg Randy A · Pearland, TXBuilt 1965 · S/N 17253803 N3635LRobinson Edgar M · Cairo, GABuilt 1965 · S/N 17253804 N3636LFllsend Aviation LLC · Kaysville, UTS/N 17253805 N3639LAzimuth Partners II LLC · Sanford, FLBuilt 1965 · S/N 17253808 N3640LHussain Mahmoud T · Miami, FLBuilt 1965 · S/N 17253809 N3641LSeaplanes R Fun Inc · Wilmington, DEBuilt 1965 · S/N 17253810 N3642LMetro Technology Centers · Oklahoma City, OKBuilt 1965 · S/N 17253811 N3644LHobbie Roy Lee · Cynthiana, KYBuilt 1965 · S/N 17253813 N3645LRegistered aircraftBuilt 1965 · S/N 17253814 N3646LRobert Roger J · Gardner, MABuilt 1965 · S/N 17253815 N3646SCummings Larry D · Clarence, NYBuilt 1966 · S/N 17254827 N3647LEmmett Kerry N · Greeneville, TNBuilt 1965 · S/N 17253816 N3648LGlenn William · Marion, NCBuilt 1965 · S/N 17253817 N3649LArmour Walton H · Alliance, OHBuilt 1965 · S/N 17253818 N3650LTom Wrolstad Aircraft LLC · Molalla, ORBuilt 1965 · S/N 17253819 N3652LJbm Aviation LLC · Mc Leansboro, ILBuilt 1965 · S/N 17253821 N3653LRistau Kent T · Eagle Grove, IABuilt 1965 · S/N 17253822 N3654LHeritage In Flight Museum Inc · Lincoln, ILBuilt 1965 · S/N 17253823 N3657LHollabaugh David S · Fulton, MOBuilt 1965 · S/N 17253826 N3658LGraczyk Michael E · Lake Elmo, MNBuilt 1965 · S/N 17253827 N3660LBersig James R · La Palma, CAS/N 17253829

Back to Cessna 172G