Skip to content

Registered aircraft · 3,572

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

N1857VCare Central Inc · Minneapolis, MNS/N 17263772 N1864VFrost Dennis J · Appleton, WIBuilt 1974 · S/N 17263774 N1868VCreative Strategies Inc · Proctorville, OHBuilt 1974 · S/N 17263775 N1870VSanders-Smith Kimberly K · Napa, CABuilt 1974 · S/N 17263776 N1871VMcpherson Philip D · Battle Creek, MIBuilt 1974 · S/N 17263777 N1884VMurphy Edward L · Fairmont, WVBuilt 1974 · S/N 17263781 N1886VAngelone Inc · Elkhart, INBuilt 1974 · S/N 17263782 N1889VCroome James Earl Jr · Sandersville, GABuilt 1974 · S/N 17263783 N1892VSmith Air Inc · Ukiah, CABuilt 1974 · S/N 17263784 N1897VBarxbar Aviation LLC · Mesa, AZBuilt 1974 · S/N 17263785 N18EBAll American Aviation LLC · East Helena, MTBuilt 1974 · S/N 17264188 N18FGShapiro David Ely · Brookhaven, GABuilt 1974 · S/N 17264233 N18STYoung Shawna Hodges · Turlock, CABuilt 1973 · S/N 17261795 N1905VNew Horizons Aviation Inc · Goshen, INBuilt 1974 · S/N 17263788 N1906VN46132 LLC · Kalispell, MTBuilt 1974 · S/N 17263789 N1908FMccloskey Cynthia · Matthews, NCBuilt 1973 · S/N 17256493 N1914VStephens Thomas E · Blacklick, OHBuilt 1974 · S/N 17263792 N1915VBenac Brad James · Swansea, SCS/N 17263793 N1918VCampbell Kevin A · Grayville, ILBuilt 1974 · S/N 17263794 N1919SBurgess Reilly M · Greene, MEBuilt 1974 · S/N 17263899 N191WWLichtscheidl Ted J · Forest Lake, MNBuilt 1972 · S/N 17260840 N1922VRogers Randall J · Newalla, OKBuilt 1974 · S/N 17263796 N192DKLong Drive Holdings LLC · Alpine, UTS/N 17265020 N1930VDodson International Parts Inc · Rantoul, KSFirst renewal noticeBuilt 1974 · S/N 17263798 N1931VRegistered aircraftBuilt 1974 · S/N 17263799 N193JSRyan Moore LLC · Fayetteville, NCBuilt 1975 · S/N 17265118 N1949PEast Bay Trading Co LLC · Fairview, PABuilt 1973 · S/N 17262835 N1954VBray Aviation LLC · Calera, OKBuilt 1974 · S/N 17263803 N1955VJd Kracl Aircraft LLC · Gretna, NEBuilt 1974 · S/N 17263804 N1958BSale Reported · Champaign, ILSale reportedBuilt 1973 · S/N 17261839 N1963VFerguson George W · Vero Beach, FLBuilt 1974 · S/N 17263805 N1973VMurphy Peter · Streamwood, ILBuilt 1974 · S/N 17263809 N1974JTexarkana Flying Club Inc · Texarkana, TXBuilt 1973 · S/N 17262513 N19795Aerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1972 · S/N 17260759 N19797Marple Jon · Mesa, AZBuilt 1972 · S/N 17260760 N19801Salas Elizabeth Robles · Miami Beach, FLBuilt 1972 · S/N 17260764 N19802Westdahl Merrill W · Chugiak, AKBuilt 1972 · S/N 17260765 N19803American Patrols Inc · Midland, TXBuilt 1972 · S/N 17260766 N19804Cm3 LLC · North Las Vegas, NVBuilt 1972 · S/N 17260767 N19805C & R Leasing LLC · Fairbanks, AKS/N 17260768 N19807Lightbourn Ryan R · Lake Mary, FLS/N 17260770 N19811Dow Benjamin L · Fairfax, VTBuilt 1972 · S/N 17260774 N19813Davol Christine · New Hampton, NHS/N 17260776 N19817Maxey John D · Hillsboro, KYBuilt 1972 · S/N 17260780 N19819Northwoods Air LLC · Orono, MEBuilt 1972 · S/N 17260782 N19820Su Zaihao · Auburn, WABuilt 1972 · S/N 17260783 N19830Vainosky Michael A · Fort Johnson, NYBuilt 1972 · S/N 17260789 N19833Tri Star Aviation Inc · Nashua, NHBuilt 1972 · S/N 17260791 N19837Kerrick Wallace Glenn Lee · Miami, FLBuilt 1972 · S/N 17260793 N19838Finegan Charlene · Whitehouse Station, NJBuilt 1972 · S/N 17260794

Back to Cessna 172M