Skip to content

Registered aircraft · 435

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

N7509TMickelson Jason R · Shelton, WABuilt 1959 · S/N 47109 N7511TDonohue Jack L · Imperial, CAS/N 47111 N7512TCaldwell S F Bud · Paradise, CABuilt 1959 · S/N 47112 N7514TRohsner Thomas A · Nacogdoches, TXS/N 47114 N7515TGbl Leasing LLC · Gun Barrel City, TXBuilt 1959 · S/N 47115 N7516TSchehl Darren C · Gahanna, OHBuilt 1959 · S/N 47116 N7518TWilliams Doyle D · Browning, MOS/N 47118 N7519TScud Air 19t LLC · Morgan, UTBuilt 1959 · S/N 47119 N7520THartley Chester E · Holts Summit, MOBuilt 1959 · S/N 47120 N7521TPerry Kenneth C Jr · Tucson, AZBuilt 1959 · S/N 47121 N7522TMoffitt Michael M · Wolcottville, INBuilt 1959 · S/N 47122 N7524TBohn Flying LLC · Tijeras, NMBuilt 1959 · S/N 47124 N7526TJennen David · Erhard, MNBuilt 1960 · S/N 47126 N7527TButcher Isis F · Marietta, OKBuilt 1959 · S/N 47127 N7530TBas Part Sales LLC · Greeley, COBuilt 1959 · S/N 47130 N7531TJanke Gregory A · Lompoc, CABuilt 1959 · S/N 47131 N7532TVan Voast Carla J · Turner, MTBuilt 1959 · S/N 47132 N7533THansman Jon C · Ashland, WIFirst renewal noticeBuilt 1959 · S/N 47133 N7534TFreudenthal Timothy M · Wautoma, WIBuilt 1959 · S/N 47134 N7535TStearman Matthew G · Andale, KSBuilt 1959 · S/N 47135 N7536TD&K Ag Service Inc · Lantry, SDS/N 47136 N7538TClark Walter A Jr · Willcox, AZBuilt 1959 · S/N 47138 N7539TCropper Kenneth B · Orangeville, UTBuilt 1959 · S/N 47139 N7541TSmith Danny R · Sherman, TXBuilt 1959 · S/N 47141 N7543TBlakeney David B · Pocahontas, ARBuilt 1959 · S/N 47143 N7547THall William D · Homeworth, OHBuilt 1959 · S/N 47147 N7548TWatkins Frank E · Montague, CABuilt 1959 · S/N 47148 N7550TShipe Jacqueline M · Louisville, TNBuilt 1959 · S/N 47150 N7552THaycraft James Michael · Magnolia, KYS/N 47152 N7556TOleskiewicz Anna · Palm Beach Shores, FLBuilt 1959 · S/N 47156 N7560TKaplan Paula A · Yorba Linda, CABuilt 1959 · S/N 47160 N7561THendrickson David S · Hamptonville, NCS/N 47161 N7562TDupree Thomas J · Saranac Lake, NYBuilt 1959 · S/N 47162 N7563THaslam Jim M · Twain Harte, CABuilt 1959 · S/N 47163 N7566TMerritt Joseph P · Pryor, OKS/N 47166 N7569THuddleston Garry W · Brownstown, MIBuilt 1959 · S/N 47169 N7572TFlying Colors Airparts Inc · Leesburg, FLBuilt 1959 · S/N 47172 N7573TBogard Aviation LLC · Milan, MOBuilt 1959 · S/N 47173 N7574TWells David M · Weatherford, TXBuilt 1959 · S/N 47174 N7576TInfinity Builders LLC · Parker, COBuilt 1959 · S/N 47176 N7577TRoot Franklin L · Staunton, VABuilt 1959 · S/N 47177 N7582TJones Todd R · Ozona, TXBuilt 1959 · S/N 47182 N7585TBustamante Luis E · Longview, TXBuilt 1959 · S/N 47185 N7587TStreater Stephen · Palm Coast, FLBuilt 1959 · S/N 47187 N7588TSale Reported · Orlando, FLSale reported, pending cancellationBuilt 1960 · S/N 47188 N7591TScamman Glenn O · Topeka, KSBuilt 1960 · S/N 47191 N7592TSouthern Kentucky Aviation LLC · Bowling Green, KYS/N 47192 N7594TGrimes Arthur D · Zeeland, MIBuilt 1959 · S/N 47194 N7598TFieldgrove Matt L · Somerton, AZS/N 47198 N7600TXin Han Aviation LLC · Atwater, CABuilt 1960 · S/N 47200

Back to Cessna 172A