Skip to content

Registered aircraft · 1,025

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

N46721Bristol Robert W · Sandpoint, IDBuilt 1968 · S/N 17257452 N46722Tingey Brent J · Juneau, AKBuilt 1968 · S/N 17257453 N46726Taylor David W · Hot Springs, ARBuilt 1968 · S/N 17257455 N46729Thomas Mark R · Clintondale, NYBuilt 1968 · S/N 17257457 N46730Zahn Christopher W · Edwardsville, ILBuilt 1968 · S/N 17257458 N46731Laurel Highlands Aeronautical Academy LLC · Latrobe, PABuilt 1968 · S/N 17257459 N46736Krantz Gwendolyn A · Advance, NCBuilt 1968 · S/N 17257460 N46737Berney John E · Morgan Hill, CABuilt 1968 · S/N 17257461 N46742Barlet Richard D · Carthage, MOBuilt 1968 · S/N 17257463 N46743Longino Thomas G · Celeste, TXBuilt 1968 · S/N 17257464 N46744Harrison Airplane LLC · Cynthiana, KYBuilt 1968 · S/N 17257465 N46746Dunlap Gary P · Seattle, WABuilt 1968 · S/N 17257466 N46JWWerner John D · Pownal, VTBuilt 1969 · S/N 17257942 N5133GPioneer Aviation LLC · Crossett, ARBuilt 1969 · S/N 17258447 N5134GRegistration Pending · Cannon Falls, MNRegistration pending, pending cancellationBuilt 1969 · S/N 17258448 N5135GChinrock Adam · Spanish Fort, ALBuilt 1969 · S/N 17258449 N5136GYork Aviators LLC · York, PAS/N 17258450 N517SMMcelvain Pete R · Iowa Park, TXBuilt 1968 · S/N 17257318 N51MSDekervor Marc Phillippe II · La Mesa, CABuilt 1970 · S/N 17259085 N51WT51 Whiskey Tango LLC · Henrico, VABuilt 1969 · S/N 17258240 N521TDRaiders-Tigers Flying Club · Houston, TXBuilt 1969 · S/N 17258636 N522FN522f LLC · Titusville, FLBuilt 1970 · S/N 17258510 N524MESmith Lester C Jr · Colleyville, TXS/N 17258149 N54VAFisheer Eric E · Memphis, TNBuilt 1968 · S/N 17257295 N55PGGonzalez Pota H · Seguin, TXBuilt 1968 · S/N 17257793 N599CMMscm Partners LLC · Fairfield, TXS/N 17257970 N60SSDhone Shridhar · Livermore, CABuilt 1968 · S/N 17257479 N6152VClayton Stephen C · Conyers, GABuilt 1970 · S/N 17258999 N615WTOwensby Paul T · Fayetteville, NCBuilt 1968 · S/N 17257421 N647MTArbo Elijah B · Mount Chase, MEBuilt 1970 · S/N 17259158 N650VVMindy Limited LLC · Muscatine, IABuilt 1969 · S/N 17258561 N65DPPilawski Darren · Spring Hill, FLS/N 17257299 N67022Mccormack James · Mount Jewett, PABuilt 1970 · S/N 17259032 N679DLBlink Squirrel Aviation LLC · Cherokee, IABuilt 1970 · S/N 17259138 N67CNPrichard Brian E · Caledonia, MIBuilt 1968 · S/N 17257566 N6ABCenterline Holdings Inc · Camden, DEBuilt 1969 · S/N 17258164 N6MBSierra Whiskey Aircraft LLC · Oakland, CABuilt 1968 · S/N 17257279 N7004GMcgreen John R · Albany, NYBuilt 1969 · S/N 17258704 N7005GHamilton Peter D · Bear, DEBuilt 1969 · S/N 17258705 N7010GStavair LLC · Gulf Breeze, FLBuilt 1969 · S/N 17258710 N7011GChase Development Aviation LLC · Oakland Park, FLBuilt 1969 · S/N 17258711 N7013GSaeid Abdelmasih · Euless, TXBuilt 1969 · S/N 17258713 N7015GDaugherty William A · Horseheads, NYBuilt 1969 · S/N 17258715 N7018GCape Aerial Tours Inc · Chatham, MABuilt 1969 · S/N 17258718 N7028GKathol Donavin J · Hartington, NEBuilt 1969 · S/N 17258728 N7034GFat Tyre Flyers LLC · Moses Lake, WABuilt 1969 · S/N 17258734 N7037GN7037g Inc · Newark, DEBuilt 1969 · S/N 17258737 N7041GJohnson Justin Eric · Grand Forks, NDBuilt 1969 · S/N 17258741 N7042G7042g LLC · Shingle Springs, CAS/N 17258742 N7044GSpitzbart David G · Woodstock, ILBuilt 1969 · S/N 17258744

Back to Cessna 172K