Skip to content

Registered aircraft · 781

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

N2831LJkj Flying LLC · Chittenango, NYBuilt 1967 · S/N 17256031 N2833LWade Kenneth L · Huron, TNBuilt 1967 · S/N 17256033 N2834LRomano Kenneth J · Shirley, NYBuilt 1967 · S/N 17256034 N2835LBrinkmac LLC · Cadillac, MIS/N 17256035 N2836LRyan Patrick J · Quinton, VABuilt 1967 · S/N 17256036 N2837LGehrke Halle · Elk Mound, WIBuilt 1967 · S/N 17256037 N2838LA-R-M Aircraft Leasing LLC · Williamsburg, VABuilt 1967 · S/N 17256038 N2841LJustison David · Hillsboro, ILS/N 17256041 N2842LBravo Aviation LLC · Rexburg, IDBuilt 1967 · S/N 17256042 N2845LShenk Ronald W · Palmetto, GABuilt 1967 · S/N 17256045 N2847LGervase Russell · Farmington, NMBuilt 1967 · S/N 17256047 N2850LBergmann Robert A · Lake Placid, FLBuilt 1967 · S/N 17256050 N2851LMorristown Flying Service Inc · Talbott, TNBuilt 1967 · S/N 17256051 N2852LHardin County Aviation LLC · Kountze, TXBuilt 1967 · S/N 17256052 N2855LParis Flight Training LLC · Powderly, TXBuilt 1967 · S/N 17256055 N2857LKeller Thomas Joe · Chattanooga, OKBuilt 1967 · S/N 17256057 N2858LAgile Systems LLC · Simpsonville, SCS/N 17256058 N2859LWheadon William J · Napa, CABuilt 1967 · S/N 17256059 N2864LTakle Management LLC · Bethany, OKS/N 17256064 N2865LIfr LLC · Springfield, MOBuilt 1967 · S/N 17256065 N2866LRegistration Pending · Spring Branch, TXRegistration pendingBuilt 1967 · S/N 17256066 N2869LHelmstetler John D · Mt Vernon, TXBuilt 1967 · S/N 17256069 N2874LSchirack John · Decatur, INBuilt 1967 · S/N 17256074 N2875LDavenport Ross K · Raleigh, NCBuilt 1967 · S/N 17256075 N2878LHolbrook David A · Toccoa, GABuilt 1967 · S/N 17256078 N2881LCore Alan L · Indianola, IABuilt 1967 · S/N 17256081 N2885LBlevens George A Jr · Franklin, KYS/N 17256085 N2887LMello Stephen F · Ludlow, MABuilt 1967 · S/N 17256087 N2889LSouthern Star Aviation LLC · Missoula, MTBuilt 1967 · S/N 17256089 N2892LSellers Michael E · Clam Gulch, AKBuilt 1967 · S/N 17256092 N2894LJohnson Nancy B · Vestavia Hills, ALBuilt 1967 · S/N 17256094 N2897LBork Joseph L · Mosier, ORS/N 17256097 N292DAIndependence Youth Flying Club Inc · Independence, ORBuilt 1966 · S/N 17255066 N2984UJuris Ronald D · Bickleton, WABuilt 1966 · S/N 17255040 N3147XSuperior Golf Course Maintenance LLC · Plantation, FLBuilt 1966 · S/N 17255297 N3148XJennings Dewey S · Springfield, MOBuilt 1966 · S/N 17255298 N3202LMatta Figueroa Eduardo · Chapman, KSBuilt 1967 · S/N 17256102 N3212LBlackstone Rotorcraft Inc · Hartselle, ALBuilt 1967 · S/N 17256112 N3219LBlock Taylor I · Sibley, IAS/N 17256119 N3222LLanier James A · Phillipsburg, KSBuilt 1967 · S/N 17256122 N3223LBerube Leo Reginald · Easley, SCBuilt 1967 · S/N 17256123 N3225LWing Nuts Inc · Maryville, MOBuilt 1967 · S/N 17256125 N3226LStammen Dakota J · Stanley, NDBuilt 1967 · S/N 17256126 N3227LLown Robin F · Douglas, AKBuilt 1967 · S/N 17256127 N3228LWoodson Marcus L · Detroit, MIBuilt 1967 · S/N 17256128 N3229LTate Samuel Paul Baylon · Tacoma, WABuilt 1967 · S/N 17256129 N3231LColumbia Asset Trust Corp Trustee · Wichita, KSBuilt 1967 · S/N 17256131 N3236LMartin Alan K · Tenaha, TXBuilt 1967 · S/N 17256136 N3237LKeith Investments LLC · Verona, MSBuilt 1967 · S/N 17256137 N3239LGame Composites Flying Club · Bentonville, ARBuilt 1967 · S/N 17256139

Back to Cessna 172H