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.

N6160EBurnette Richard A · Hampton, GABuilt 1958 · S/N 46260 N6165EBailey Frank W · White City, ORBuilt 1958 · S/N 46265 N6166EAshabranner Kevin T · Port Saint Joe, FLBuilt 1958 · S/N 46266 N6168EFoster Marcus R · Mesa, AZBuilt 1958 · S/N 46268 N6169EVick Troy · Normangee, TXS/N 46269 N6171EAvequities Inc · Dallas, TXBuilt 1958 · S/N 46271 N6172EKatz Braunschweig Daniel A · Staten Island, NYBuilt 1958 · S/N 46272 N6174ECano Michael J · Vallecito, CABuilt 1958 · S/N 46274 N6175ENeilson Craig H · Vista, CABuilt 1958 · S/N 46275 N6176EBullit Enterprises Ltd · Wshngtn Ct Hs, OHS/N 46276 N6177EByrom Nathanto · Grass Valley, CAS/N 46277 N6178EWaak Harlan L · Lincoln, NEBuilt 1958 · S/N 46278 N6179EHolland Frederic A · Advance, NCBuilt 1958 · S/N 46279 N6180EUtica Township Vol Firefighter Assn Inc · Jeffersonville, INBuilt 1958 · S/N 46280 N6184ERosborough Todd D · Medford, ORBuilt 1958 · S/N 46284 N6186EHadley Ralph James Jr · Saint Clairsville, OHBuilt 1958 · S/N 46286 N6187EBasham James L · Livingston, TXS/N 46287 N6188ECs Aircraft Services LLC · Jefferson, ORS/N 46288 N6189ETrato Sharon M · Millington, MIFirst renewal noticeBuilt 1958 · S/N 46289 N6192ECook Christopher M · Burnet, TXS/N 46292 N6193EHot Wingz LLC · Neeses, SCBuilt 1958 · S/N 46293 N6195EHedrick Harold F · New Port Richey, FLBuilt 1958 · S/N 46295 N6196EHiggins Brian D · Flower Mound, TXBuilt 1958 · S/N 46296 N6197EAl-Bert Consulting Inc · Lakeland, FLBuilt 1958 · S/N 46297 N6200EKirkpatrick Heather A · Clarkston, MIBuilt 1958 · S/N 46300 N6203EBandy Suzanne M · Newport, ORBuilt 1958 · S/N 46303 N6205EMcwilliams Michael W · Derby, KSBuilt 1958 · S/N 46305 N6207EDick Charles H · Milton, KSBuilt 1958 · S/N 46307 N6208EWharton Melissa P · Wise, VABuilt 1958 · S/N 46308 N6209EReynolds Richard E · Trumansburg, NYBuilt 1959 · S/N 46309 N6210EHodges Darin C · West Jefferson, NCBuilt 1958 · S/N 46310 N6213EBeesley Charles F III · Cole Camp, MOBuilt 1959 · S/N 46313 N6215EReinders Gary J · Orange City, IABuilt 1958 · S/N 46315 N6216EPratt Joseph O · Wasilla, AKBuilt 1958 · S/N 46316 N6217ESchiffel Peter W · Pequannock, NJBuilt 1958 · S/N 46317 N6218EZephyrhills Flying Club Inc · Tampa, FLBuilt 1958 · S/N 46318 N6219EOaks Randall K · Oxnard, CABuilt 1958 · S/N 46319 N6220EStoudt Kristen D · Derby, KSBuilt 1958 · S/N 46320 N6221EAllgeier David G Jr · Taylorsville, KYBuilt 1958 · S/N 46321 N6222EAlexander Tom · Alamogordo, NMBuilt 1959 · S/N 46322 N6230EDean Matthew · Pine Grove, CAS/N 46330 N6235ELee William Lewis · Gilbert, AZS/N 46335 N6237ESale Reported · Brandon, MSSale reportedS/N 46337 N6239EKnutson Wayne R · Thompson, NDFirst renewal noticeBuilt 1958 · S/N 46339 N6240EDgcg Properties LLC · Casa Grande, AZBuilt 1959 · S/N 46340 N6241ERuijne Leo L · Plainview, TXS/N 46341 N6242EDenson Randy A · Meridian, IDBuilt 1958 · S/N 46342 N6244ESpicer Aaron D · Wadena, MNBuilt 1958 · S/N 46344 N6247EBudenbender Heidi B · Weatherford, TXBuilt 1959 · S/N 46347 N6249ERlp Aviation LLC · Missoula, MTBuilt 1959 · S/N 46349

Back to Cessna 172