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.

N5092AHansen Aviation LLC · Savannah, GABuilt 1955 · S/N 28092 N5100APlane Sense Inc · Kindred, NDBuilt 1955 · S/N 28100 N5103AWinkelstein Aaron B · Lehi, UTS/N 28103 N5110ADickens Dennis D · Noble, OKBuilt 1955 · S/N 28110 N5116ABatch Bryan A · Spokane, WABuilt 1955 · S/N 28116 N5117ANorthwest Aircraft Maintenance LLC · Springdale, ARS/N 28117 N5118AQuinn Thomas P · Cherry Hill, NJBuilt 1955 · S/N 28118 N5120ALane Christopher A · Lakeland, GABuilt 1955 · S/N 28120 N5122ADopson Joel A · Ooltewah, TNS/N 28122 N5123AGrabenstein Walter L DBA · Bradenton, FLFirst renewal noticeBuilt 1955 · S/N 28123 N5131AJohnson Basil · Tucson, AZBuilt 1955 · S/N 28131 N5133ALake Area Technical Institute · Watertown, SDBuilt 1955 · S/N 28133 N5137AAlbritton Kerry B · Camas, WABuilt 1955 · S/N 28137 N513SWilliford James Q · Wilson, NCBuilt 1957 · S/N 29220 N5140ALizarralde Lorenzo · Jackson, MIBuilt 1955 · S/N 28140 N5145AMccullough Ronnie W · Golden, COBuilt 1955 · S/N 28145 N5148ATurner Edward J III · Mokena, ILBuilt 1956 · S/N 28148 N5152ASaunders George A Jr · Powhatan, VABuilt 1955 · S/N 28152 N5156AFrantz Douglas M · Mustang, OKS/N 28156 N5160ABowden Aaron C · Yuma, AZBuilt 1955 · S/N 28160 N5161ASchmid Robert E · Red Bluff, CABuilt 1955 · S/N 28161 N5162ASizer Timothy J · Arthur, NES/N 28162 N5163APassero Robert S · Madison, ALBuilt 1955 · S/N 28163 N5165AKulp Robert E Jr · Cartersville, GABuilt 1955 · S/N 28165 N5166ADavis Barry E · Carrollton, GABuilt 1955 · S/N 28166 N5171AInfinity Metalworks Inc · Newton, KSBuilt 1955 · S/N 28171 N5172ABarnes Timothy Edward · Stephenville, TXBuilt 1955 · S/N 28172 N5174AWells Lavar W · Hanksville, UTBuilt 1956 · S/N 28174 N5175ADenkema Richard S · Grand Rapids, MIBuilt 1955 · S/N 28175 N5177AHolden Daniel N · Anacortes, WAS/N 28177 N5180AWarmack Holdings LLC · Englewood, FLBuilt 1956 · S/N 28180 N5185ACardan Aircraft Services Inc · Red Bluff, CAS/N 28185 N5186ATengwall Kevin A · Watford City, NDS/N 28186 N5191ABurdeaux Barry S · Orting, WAS/N 28191 N5192AGenitempo Serge · Studio City, CABuilt 1955 · S/N 28192 N5193AGustaf John A · Lowell, MIBuilt 1956 · S/N 28193 N5196AParker Todd S · Kaysville, UTBuilt 1956 · S/N 28196 N5442EUnterseher Pat L · Kearney, NEBuilt 1957 · S/N 36330 N54GCWilson Karlton M · Craigmont, IDBuilt 1959 · S/N 46454 N5600AJessup Modeana M · Wilbur, WABuilt 1956 · S/N 28200 N5601AOsceola Aerosport LLC · Osceola, WIBuilt 1956 · S/N 28201 N5602ALooney Hubert · Florissant, MOBuilt 1956 · S/N 28202 N5605AKlase Robert · Greenville, TXS/N 28205 N5607AGilbirds William M · Kansas City, MOBuilt 1956 · S/N 28207 N5610ANielson Douglas W · East Troy, WIBuilt 1956 · S/N 28210 N5611ALewis Christopher Michael · Troy, OHBuilt 1956 · S/N 28211 N5616ABingham Boyce James · Juneau, AKBuilt 1956 · S/N 28216 N5620ASmith Steven R · Nome, AKBuilt 1956 · S/N 28220 N5621AMedic Choppers LLC · Springdale, ARS/N 28221 N5622ANissley Stanley · Cottage Grove, TNBuilt 1956 · S/N 28222

Back to Cessna 172