Skip to content

Registered aircraft · 1,805

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

N8998BValles Rick James · Albuquerque, NMS/N 36698 N8999BRacoon Aviation LLC · San Antonio, TXBuilt 1958 · S/N 36699 N9002RSmith Terry L · Atoka, TNS/N 28597 N90951Simard Maurice E · Windham, CTBuilt 1956 · S/N 28984 N90CKHodack Steven J · Burton, MIBuilt 1959 · S/N 46063 N9105BVeretto Michael A · Odessa, TXBuilt 1958 · S/N 36605 N9106BRegistered aircraftBuilt 1958 · S/N 36606 N9107BGrace Community Church · Fremont, OHS/N 36607 N9112BFosgate Helen Hines · Bogart, GABuilt 1958 · S/N 36612 N9113BBrown David L · Spring City, TNBuilt 1958 · S/N 36613 N9115BParker Justin S · Elko, NVBuilt 1958 · S/N 36615 N9116BS Dacy Enterprises Inc · Harvard, ILBuilt 1958 · S/N 36616 N9117BPartridge John R · Manchester, NHS/N 36617 N9118BCulpeper Aviation LLC · Queen Creek, AZBuilt 1958 · S/N 36618 N9123BStockton Clifford A · Anchorage, AKBuilt 1958 · S/N 36723 N9127BBassham Rick D · Bluff Dale, TXBuilt 1958 · S/N 36727 N9129BBoughroum Youssef · Grovetown, GABuilt 1958 · S/N 36729 N9134BJohnson Andrea J · Redlands, CABuilt 1958 · S/N 36734 N9137BMeyer David E · Olathe, KSBuilt 1958 · S/N 36737 N9139BFikes Richard Glen III · Flint, TXS/N 36739 N9140BBunney Jared · Spokane Valley, WAS/N 36740 N9141BBurnham Gary · Helper, UTBuilt 1958 · S/N 36741 N9144BMason Matthew L · Lincoln, ILBuilt 1958 · S/N 36744 N9147BReed Zane · Mountain Home, IDBuilt 1958 · S/N 36747 N9149BFoust Kal E · Lenox, MIBuilt 1958 · S/N 36749 N9150BHarral Blake · Prescott Valley, AZFirst renewal noticeBuilt 1958 · S/N 36750 N9153BMires James · Newnan, GABuilt 1958 · S/N 36753 N9156BRegistration Pending · Cheyenne, WYRegistration pendingBuilt 1958 · S/N 36756 N9156NBurdick Kenneth M · Swansea, MABuilt 1956 · S/N 28648 N9157BMighells Conrad E · Randolph, NYFirst renewal noticeBuilt 1958 · S/N 36757 N9160BS & J Investments LLC · Sardis, MSBuilt 1958 · S/N 36760 N9161BLee Mark S · Grove, OKBuilt 1958 · S/N 36761 N9162BMedic Choppers LLC · Springdale, ARBuilt 1958 · S/N 36762 N9163BWright Donald E · Greensboro, NCBuilt 1958 · S/N 36763 N9166BWusterhausen Jerry L · Boynton Beach, FLBuilt 1958 · S/N 36766 N9167BAshley-Nye Johanna I · Graham, WABuilt 1958 · S/N 36767 N9168BAverett Joseph B · Denham Springs, LABuilt 1958 · S/N 36768 N9170BRegistration Pending · Shohola, PARegistration pendingBuilt 1958 · S/N 36770 N9173BSuperhawk LLC · La Center, WABuilt 1958 · S/N 36773 N9177BBolan Preston A · Phoenix, AZBuilt 1958 · S/N 36777 N9179BHuntley Larry T · Midlothian, TXFirst renewal noticeBuilt 1958 · S/N 36779 N9180BHolcomb Nicholas A · Yakutat, AKS/N 36780 N9180ZKey West Bandit Squadron LLC · Summerland Key, FLS/N 28142 N9187BEbrahim Ahmed E · Onalaska, TXBuilt 1958 · S/N 36787 N9189BSale Reported · Litchfield, MNSale reportedBuilt 1958 · S/N 36789 N9191BE & D Aviation Sales LLC · Sainte Genevieve, MOBuilt 1958 · S/N 36791 N9193BRegistration Pending · Garwood, TXRegistration pendingBuilt 1958 · S/N 36793 N9196BPeterson James G · Keller, TXBuilt 1958 · S/N 36796 N9199BM & H Investment LLC · Montgomery City, MOBuilt 1958 · S/N 36799 N91WAStevens James L · Carrollton, GABuilt 1955 · S/N 28090

Back to Cessna 172