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.

N2720LBaalman Gary E · San Jose, CABuilt 1967 · S/N 17255920 N2722LSmolik Amanda · Northlake, TXBuilt 1967 · S/N 17255922 N2723LJkr7 LLC · The Dalles, ORBuilt 1967 · S/N 17255923 N2725LFulenchek Raymond D · Sherman, TXS/N 17255925 N2728LPotter Mark H · Santa Rosa, CABuilt 1967 · S/N 17255928 N2732LGlenndale LLC · Jackson, MOBuilt 1967 · S/N 17255932 N2733LHugelman Frank J III · Waynesville, MOBuilt 1967 · S/N 17255933 N2736LWilson Steven W · N Richlnd Hls, TXFirst renewal noticeBuilt 1967 · S/N 17255936 N2737LAviation Trust Co LLC Trustee · Oklahoma City, OKS/N 17255937 N2738LDemkiewicz Daniel · Houston, TXBuilt 1967 · S/N 17255938 N2739LHall Barbara S · Burgettstown, PABuilt 1967 · S/N 17255939 N2740LLightsey Aviation LLC · Jacksonville, FLS/N 17255940 N2742LFisher Corey · Ardmore, OKBuilt 1967 · S/N 17255942 N2743LBarnes Earl E · Live Oak, FLBuilt 1967 · S/N 17255943 N2746LBeavers Timothy · Charlotte, NCBuilt 1967 · S/N 17255946 N2747LGuistwhite Brian K · Etters, PABuilt 1967 · S/N 17255947 N2748LCarter Reagan Tye · Beaumont, TXBuilt 1967 · S/N 17255948 N2749LBeeker Martin J Jr · Plymouth, MIBuilt 1967 · S/N 17255949 N2753LMccartney Matthew T · Lake Tapps, WAS/N 17255953 N2754LThompson John D · Amana, IABuilt 1967 · S/N 17255954 N2761LMiller David L · Mineral City, OHBuilt 1967 · S/N 17255961 N2762LRock Communications · Rock Hill, SCBuilt 1967 · S/N 17255962 N2763LTrent David A · Davin, WVBuilt 1967 · S/N 17255963 N2767LGay David B · Citronelle, ALBuilt 1967 · S/N 17255967 N2768LJoseph Gary L · Ludlow, VTBuilt 1967 · S/N 17255968 N2769LRedditt Brian W · Columbia Station, OHBuilt 1967 · S/N 17255969 N2771LP&N Corp · Marion, IABuilt 1967 · S/N 17255971 N2772LBell William E Jr · Summerville, SCBuilt 1967 · S/N 17255972 N2775LKing Mons A · Paoli, PABuilt 1967 · S/N 17255975 N2776LRd Aire LLC · Opelika, ALBuilt 1967 · S/N 17255976 N2777LHataway Gregory L · Kinston, ALBuilt 1967 · S/N 17255977 N2779LResetar Douglas J · Pittsford, NYBuilt 1967 · S/N 17255979 N2782LSouthern Seaplane Inc · Belle Chasse, LABuilt 1967 · S/N 17255982 N2787LGateway Flying Club Inc · Saint Louis, MOBuilt 1967 · S/N 17255987 N2789LChurch Sammy H · Statesville, NCBuilt 1967 · S/N 17255989 N278BDStubbs J Phillip · Richmond, VABuilt 1967 · S/N 17255945 N2790LWells Mark L · Eads, TNBuilt 1967 · S/N 17255990 N2795LHarkness Paul E · Richmond Hill, GABuilt 1967 · S/N 17255995 N2796LSmyth Michael L · Saint Charles, MOBuilt 1967 · S/N 17255996 N2800LGarcia Fernando · Laredo, TXBuilt 1967 · S/N 17256000 N2807LBerisha James · Porter, TXS/N 17256007 N2809LWarner Walter M Jr · Willow, AKBuilt 1967 · S/N 17256009 N2812LHarris Partnership · Conway, ARBuilt 1967 · S/N 17256012 N2813LFoster Neal W · Nome, AKBuilt 1967 · S/N 17256013 N2814LStewarts Aircraft Service Inc · Waynesville, OHBuilt 1967 · S/N 17256014 N2820LHarrington Thomas W Jr · Cumming, GAS/N 17256020 N2822LRobertson IV Henry B · Owensboro, KYS/N 17256022 N2826LJamtori Investments LLC · Forrest City, ARS/N 17256026 N2829LGeaux Fly LLC · Bossier City, LAS/N 17256029 N2830LPilotpros Training LLC · Longview, TXBuilt 1967 · S/N 17256030

Back to Cessna 172H