Skip to content

Registered aircraft · 857

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

N9806GDonohue Denis J · Montvale, NJBuilt 1971 · S/N 17259706 N9807GPoshak Jay M · Ely, MNS/N 17259707 N9809GMcclendon Jon L · Kilgore, TXBuilt 1971 · S/N 17259709 N9810GAir America Flight Center LLC · Daytona Beach, FLBuilt 1971 · S/N 17259710 N9815GKenmore Air Harbor LLC · Kenmore, WABuilt 1971 · S/N 17259715 N9816GRicker Harry K · Turner, MEBuilt 1971 · S/N 17259716 N9817GLester Matthew J · Gouldsboro, MEBuilt 1971 · S/N 17259717 N9818GGough Gregory · Emmett, IDBuilt 1971 · S/N 17259718 N9821GGrubelich Mark C · Edgewood, NMBuilt 1971 · S/N 17259721 N9825GKanawha Aviators LLC · Bancroft, WVBuilt 1971 · S/N 17259725 N9827GSpencer Jeffrey · Capistrano Beach, CABuilt 1971 · S/N 17259727 N9830GGonzalez Nicolas · Naples, FLBuilt 1971 · S/N 17259730 N9834GNielson Douglas W · East Troy, WIBuilt 1971 · S/N 17259734 N9835GPiedmont Flight Inc · Winston Salem, NCBuilt 1971 · S/N 17259735 N9836GSchafhausen Mark G · Spokane, WABuilt 1971 · S/N 17259736 N9838GMcdonald James E · Harleyville, SCS/N 17259738 N9841GYoxall Jennifer S · Guilford, CTBuilt 1971 · S/N 17259741 N9842GNighthawk N8231g LLC · Pompano Beach, FLBuilt 1971 · S/N 17259742 N9846GFord Eagles Inc · Plymouth, MIFirst renewal noticeBuilt 1971 · S/N 17259746 N9847GPilot In Command Academy · Miami, FLBuilt 1971 · S/N 17259747 N9848GRicci Mark P · Waterford, MIBuilt 1971 · S/N 17259748 N9849GPray Aviation Inc · Augusta, KSFirst renewal noticeBuilt 1971 · S/N 17259749 N984FAFreedom Aviation Inc · Lynchburg, VABuilt 1971 · S/N 17259928 N9853GParker Steve E · Palmer, AKBuilt 1971 · S/N 17259753 N9855GChoctaw Nation Of Oklahoma · Durant, OKBuilt 1971 · S/N 17259755 N9857GLeaseair LLC · Wilmington, DEBuilt 1971 · S/N 17259757 N9858GRegistration Pending · Dublin, VARegistration pendingBuilt 1971 · S/N 17259758 N9859GLandrum Craig L · Vinita, OKBuilt 1971 · S/N 17259759 N9860GCitabria Inc · Auburn, CABuilt 1971 · S/N 17259760 N9861GLaurel Highlands Aeronautical Academy · Latrobe, PAS/N 17259761 N9863GHurricane Airshows Inc · La Porte, TXBuilt 1971 · S/N 17259763 N9864GHoppers James W Jr · Milan, TNBuilt 1971 · S/N 17259764 N9865GWheeler John W · River Ranch, FLBuilt 1971 · S/N 17259765 N9866G198 Main Street Aviation LLC · Sullivan, WIBuilt 1971 · S/N 17259766 N9867GRegistration Pending · Miami, FLRegistration pendingBuilt 1971 · S/N 17259767 N9868GHoff Brian A · Hackettstown, NJBuilt 1971 · S/N 17259768 N9869GWilliams Richard H · Lockport, NYBuilt 1971 · S/N 17259769 N9870GThacker William E · Chenoa, ILS/N 17259770 N9874GKorn Jeffrey J · Marietta, GABuilt 1971 · S/N 17259774 N9875G1 Aircraft LLC · Kissimmee, FLBuilt 1971 · S/N 17259775 N9875MKaelin Robert A · Fayetteville, ARBuilt 1972 · S/N 17260575 N9876GKentucky Lake Aviation LLC · Huntingdon, TNBuilt 1971 · S/N 17259776 N9877GRowse Larry G · Plain City, OHBuilt 1971 · S/N 17259777 N9878GRoyal Aviation Academy LLC · Sarasota, FLBuilt 1971 · S/N 17259778 N9880GHewlett John · Columbus, OHBuilt 1971 · S/N 17259780 N9881GFortenberry Robert N · Pascagoula, MSBuilt 1971 · S/N 17259781 N9883GLagor Mark D · Parshall, NDBuilt 1971 · S/N 17259783 N9884GBarbour John P · Dexter, MOBuilt 1971 · S/N 17259784 N9888GRegistration Pending · Atlanta, TXRegistration pending, pending cancellationBuilt 1971 · S/N 17259788 N9889GWright Flight Inc · Tucson, AZBuilt 1971 · S/N 17259789

Back to Cessna 172L