Skip to content

Registered aircraft · 353

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

N128CGMontaez Torrez Raul · Guaynabo, PRBuilt 1968 · S/N 17256621 N128RVande Hei Joshua G · Kaukauna, WIBuilt 1968 · S/N 17256984 N13YPBlock Scott M · Chandler, AZBuilt 1968 · S/N 17257055 N14NFStiles Terry D · King Salmon, AKBuilt 1968 · S/N 17256844 N15SWNi Oliver Xingyuan · Norfolk, VABuilt 1968 · S/N 17256875 N16WLLivingston Patricia R · Wasilla, AKS/N 17256545 N172BMBarrett Jacob D · Paris, ILBuilt 1968 · S/N 17256780 N172DVLima Tango Aviation LLC · Mount Dora, FLBuilt 1968 · S/N 17256625 N172HTAuto Outlet Of Irvington LLC · Irvington, NJS/N 17257091 N172VKKatula Gerard · Pawleys Island, SCBuilt 1968 · S/N 17257009 N2074AN2074a Aviation LLC · Sheridan, WYBuilt 1968 · S/N 17257138 N20AAGrand River Aviation LLC · Kremmling, COBuilt 1968 · S/N 17256596 N216TSS&S Aircraft Inc · Bennington, VTBuilt 1968 · S/N 17256570 N3086SAmo Air & Claims LLC · Grove, OKS/N 17256700 N3198FDepinet Rodney J · Glen Saint Mary, FLBuilt 1968 · S/N 17256588 N347WGMt Aircraft LLC · Port Orange, FLBuilt 1968 · S/N 17256883 N351GPSelby Chris A · Monticello, ARBuilt 1968 · S/N 17256918 N35302William Benjamin LLC · Orono, MNS/N 17256701 N35308Kress Gregory A · Sharpsburg, GABuilt 1968 · S/N 17256704 N35313Lyon W Bruce · Carterville, ILBuilt 1968 · S/N 17256706 N35315Hubert Thomas D · Greenville, TXBuilt 1968 · S/N 17256708 N35318Wings LLC · Scottsdale, AZBuilt 1968 · S/N 17256709 N35322Vincent Zachary T · Saint George, UTBuilt 1968 · S/N 17256710 N35323Bourdon Greg · Henniker, NHBuilt 1968 · S/N 17256711 N35324Schuster Darin D · New Castle, DEBuilt 1968 · S/N 17256712 N35326Harrison Keith D · La Grange, NCBuilt 1968 · S/N 17256714 N35330Wilkerson Jeffrey D · Morning Sun, IABuilt 1968 · S/N 17256715 N35332Katchmar Michael L · Canon City, COBuilt 1968 · S/N 17256717 N35337Myer Martin John Trustee · Juneau, AKBuilt 1968 · S/N 17256718 N35340Jones Donald E · Hollandale, MNBuilt 1968 · S/N 17256720 N35344Sawyer James E · Urbana, OHBuilt 1968 · S/N 17256721 N35345Flight One Holdings LLC · Devils Lake, NDBuilt 1968 · S/N 17256722 N35348Jet & Rotor Aviation LLC · Sacramento, CABuilt 1968 · S/N 17256724 N35349Stammich Thomas R · South Bend, INBuilt 1968 · S/N 17256725 N35358N44344 LLC · Wasilla, AKBuilt 1968 · S/N 17256732 N35362Hicks James P · Franklin, OHBuilt 1968 · S/N 17256734 N35371Honrud Joseph C · Cal Nev Ari, NVS/N 17256738 N35377Laurel Highlands Aeronautical Academy · Latrobe, PABuilt 1968 · S/N 17256740 N35382Steele Aviation Inc · Walnut Cove, NCBuilt 1968 · S/N 17256742 N35383Scott Mark · North Andover, MABuilt 1968 · S/N 17256743 N35386Ehmann Stephen L · Holland, MIBuilt 1968 · S/N 17256745 N35392Meinema Mathew · Fort Wayne, INS/N 17256747 N353JLMartinez Jose L · Kansas City, MOBuilt 1968 · S/N 17256727 N35401American Aviation Training LLC · Fort Scott, KSBuilt 1968 · S/N 17256748 N35402Kautzsch Randy D · Pocatello, IDBuilt 1968 · S/N 17256749 N35406Dennis Robert W Jr · Heath, OHBuilt 1968 · S/N 17256752 N35411Cherry Hill Aviation Inc · Freetown, INBuilt 1968 · S/N 17256755 N35420Edwards David S · Colbert, WABuilt 1968 · S/N 17256759 N35421Gleason Franklin R · Darlington, SCBuilt 1968 · S/N 17256760 N35422Hamilton Pamela P · Norman Park, GABuilt 1968 · S/N 17256761

Back to Cessna 172I