Skip to content

Registered aircraft · 363

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

N1530YCall Richard T · Wasilla, AKBuilt 1962 · S/N 17249230 N1534YLipsmeyer Jason K · Springdale, ARS/N 17249234 N1535YTheriault John · Harvard, ILBuilt 1962 · S/N 17249235 N1536YCk Aviation LLC · Williamstown, NJBuilt 1962 · S/N 17249236 N1537YAloha Skies Aviation LLC · Pahoa, HIBuilt 1962 · S/N 17249237 N1538YPrice Andre D · Granger, INBuilt 1962 · S/N 17249238 N1547YBurgo Randy P · Alameda, CABuilt 1962 · S/N 17249247 N1549YLotwala Pathik · Woodbine, MDBuilt 1962 · S/N 17249249 N1552YRobinson Charles F · Beach City, TXBuilt 1962 · S/N 17249252 N1561YFire Hound LLC · Springfield, ORBuilt 1962 · S/N 17249261 N1562YWalker Karl L · Las Vegas, NVBuilt 1962 · S/N 17249262 N1563YCraik James E · Trout Creek, MTBuilt 1962 · S/N 17249263 N1564YBurkes Mark E · Denison, TXBuilt 1962 · S/N 17249264 N1569YPropp William D · Azle, TXBuilt 1962 · S/N 17249269 N1570YBoggs Texe T · Sarcoxie, MOBuilt 1962 · S/N 17249270 N1574YBlue Hawk LLC · Rogers, MNS/N 17249274 N1577YConner James D · Elgin, TXBuilt 1962 · S/N 17249277 N1580YG2g Aviation LLC · Wray, COBuilt 1962 · S/N 17249280 N1581YHampton Industrial · Jacksonville Beach, FLS/N 17249281 N1583YR & L Air Service LLC · Yatesville, GABuilt 1962 · S/N 17249283 N1585YKovtun Andriy · Elmwood Park, NJBuilt 1962 · S/N 17249285 N1587YFry William A · Willmar, MNBuilt 1962 · S/N 17249287 N1593YBolsover Douglas J · Cameron Park, CABuilt 1962 · S/N 17249293 N1594YSexson Lance Mason · Ogallala, NES/N 17249294 N1597YHelderman Laban W · Newton, NCBuilt 1962 · S/N 17249297 N1604YOcean Isle Aviation · Ocean Isle Beach, NCBuilt 1962 · S/N 17249304 N1606YFellows James S Jr · Fawnskin, CABuilt 1962 · S/N 17249306 N1608YKohr Daniel E · Bartlett, TNBuilt 1962 · S/N 17249308 N1609YMapes Steven J · Schenectady, NYBuilt 1962 · S/N 17249309 N1613YNelson Bobby E · Lago Vista, TXS/N 17249313 N1624YFallbrook Fly Girl LLC · Lakeside, ORBuilt 1962 · S/N 17249324 N1625YBoyd Jeffrey J · Justin, TXBuilt 1962 · S/N 17249325 N1626YJohnson Dean William · Springvale, MEBuilt 1962 · S/N 17249326 N1627YJohnson Douglas J · O Fallon, ILBuilt 1962 · S/N 17249327 N1630YHart Gregory D · Medford, ORBuilt 1962 · S/N 17249330 N1634YWager Douglas K · Mobridge, SDBuilt 1962 · S/N 17249334 N1636YHokanson Anthony Drake · La Crosse, WIBuilt 1962 · S/N 17249336 N1637YSmartt Kevin M · Springfield, TNBuilt 1962 · S/N 17249337 N1640YHall Justin J · Bellevue, NEBuilt 1962 · S/N 17249340 N1643YLehman Patrick A · Phillips, WIBuilt 1962 · S/N 17249343 N1644YPopple Timothy J · Osseo, WIS/N 17249344 N1646YMinion Air · John Day, ORBuilt 1962 · S/N 17249346 N1647YRudolphi William A · Doylestown, PAS/N 17249347 N1648YSutton Aircraft Salvage LLC · Palmer, AKBuilt 1962 · S/N 17249348 N1650YAirria Holdings LLC · BerlinBuilt 1962 · S/N 17249350 N1652YWallitner Matthew M · Oroville, WABuilt 1962 · S/N 17249352 N1653YBarua Dennis · Midland, TXS/N 17249353 N1657YPegasus Aviation LLC · Rogersville, MOBuilt 1962 · S/N 17249357 N1658YYankee LLC · Casa Grande, AZBuilt 1962 · S/N 17249358 N1659YCrosswhite Noel A · Cabool, MOBuilt 1962 · S/N 17249359

Back to Cessna 172C