OpenAirDocs.org
AD 81-13-10 R1

Registered aircraft · 4,001

Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.

Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:81-13-10-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-13-10-R1')
  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.

N172SPLuke Airlines LLC · Southgate, MIBuilt 1977 · S/N R172-2842N172XPTrapp Thomas A · Salem, CTBuilt 1979 · S/N R1723088N1730ZLoftis Kenneth L · Phoenix, AZBuilt 1963 · S/N 336-0030N1732MCarey International Aviation Services LLC · Long Beach, NYBuilt 1970 · S/N 33701332N1741MWolfehagen Paul B · Phoenix, AZS/N 33701341N1746ZThompson Nathan G · San Antonio, TXS/N 336-0046N174RTThoma Roy E III · Chuckey, TNBuilt 2011 · S/N 73315N1750MChristensen Del A · Mattawa, WABuilt 1970 · S/N 33701350N175CDWilliams Jake Jr · Fayetteville, NCBuilt 2000 · S/N 1065N175TTFarrell Dolliver T · Sterling, AKBuilt 1958 · S/N 55193N17651Basler Turbo Conversions LLC · Oshkosh, WIS/N R172-0137N1765HMcumber James W · Elkin, NCS/N 28R-7703034N1768MWyoming Valley Air LLC · Old Forge, PAS/N 33701368N1768ZMoskowitz Craig B · Sheffield, MABuilt 1963 · S/N 336-0068N176EAHeath Mark R · Radisson, WIS/N R172-3440N1773ZMcclay David H · Lagrande, ORBuilt 1963 · S/N 336-0073N1779ZLewis Lionel · Tacoma, WABuilt 1963 · S/N 336-0079N177KZBolinger Randy S · Roanoke, INBuilt 1976 · S/N 17702580N1781VAmbis Edward J · Ithaca, NYBuilt 1976 · S/N R1722212N1786MClark David A · San Jacinto, CABuilt 1971 · S/N 33701386N178EDSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1977 · S/N P3370285N1791MA & S Helicopters Inc · Cahokia, ILBuilt 1971 · S/N 33701391N1795HJp Kelly Air LLC · Fort Smith, ARBuilt 1977 · S/N 28R-7703035N1797ZReal Fly Air Service LLC · Jackson, WYBuilt 1963 · S/N 336-0097N1799ZWanderlove Alaska LLC · Anchorage, AKBuilt 1963 · S/N 336-0099N179CDBravo Aviation LLC · Newburgh, INBuilt 2000 · S/N 1081N179XPLadonne Frank · Fort Collins, COBuilt 1979 · S/N R1723155N17AXWard Hugh W · Arlington, TXBuilt 1979 · S/N 28R-7931132N17MELouis & Clark LLC · Fort Myers, FLBuilt 1997 · S/N 25-2006N17MLMcleod Bill Alan · Green Cove Springs, FLBuilt 2012 · S/N 154N17QYQuebec Yankee LLC · Tucson, AZBuilt 1981 · S/N 348133117N17SGHelisur USA LLC · Pembroke Pines, FLBuilt 1982 · S/N 28R-8231060N17TBarney Julius C · Lutz, FLBuilt 1968 · S/N 337-0990N17WLFrost Eric M · West Jordan, UTS/N 72N1804VBuskas Blake Rodney · Whitefish, MTS/N R1722214N1809MSkymaster-173 LLC · New Bern, NCBuilt 1971 · S/N 33701409N180GEStuber Thomas J · Marysville, WABuilt 2010 · S/N 81913N1815MReim Rodney D · Enid, OKBuilt 1971 · S/N 33701415N181CDG3 Estates LLC Trustee · Lakeland, FLBuilt 2000 · S/N 1083N181FMLuse Otis · Lago Vista, TXS/N 34-7770400N181RDWoodcock Air LLC · Wilmington, DES/N 33701881N1824MHeinke Nils A · Elkins, WVBuilt 1971 · S/N 33701424N1832VCerniglia Paul J · Monroe Township, NJBuilt 1976 · S/N R1722215N1839HFly 172n LLC · Peoria, AZBuilt 1977 · S/N 34-7770152N184Rocky Mountain Hangars LLC · Longmont, COBuilt 1974 · S/N P3370206N184PDRegistered aircraftS/N 1571N1858MCrowley Michael A · Wake Forest, NCBuilt 1972 · S/N 33701458N185RKMullowney Richard D · Kenai, AKBuilt 1977 · S/N 18503319N1863HSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 34-7770153N186CDJw Aviation LLC · Bemidji, MNBuilt 2000 · S/N 1094
Back to AD 81-13-10 R1