OpenAirDocs.org
AD 71-13-01 R1

Registered aircraft · 6,915

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:71-13-01-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:71-13-01-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.

N151TMBehel Bobby O · Tuscumbia, ALBuilt 2010 · S/N 4636467N151ZGSale Reported · Hood River, ORSale reportedBuilt 2006 · S/N T20608588N15206Megwetch Aviation LLC · Auburn, MES/N T20609214N15238Shme II LLC · West Lakeland, MNBuilt 1972 · S/N 32-7340024N15240Mitchell Joseph B · Westfield, MABuilt 1972 · S/N 32-7340025N15268Jj Freefall Inc · Wendell, NCBuilt 1972 · S/N 32-7340029N15293Dionisio Phillip · East Moriches, NYBuilt 1972 · S/N 32-7340033N152BFFlorida State Guard · Tallahassee, FLBuilt 2015 · S/N T20609201N152RFHeritage Aviation Management Ltd · Conroe, TXBuilt 2020 · S/N T20609611N152SWDjct LLC · Brown Summit, NCBuilt 1981 · S/N 28-8211017N15316Drmm Aviation LLC · South Beloit, ILBuilt 1972 · S/N 32-7340036N1535XSmith James E · Wilson, NCBuilt 1975 · S/N 32-7540170N153CSSawyer Jonathan · Littleton, COS/N T18209043N153EJQualitair LLC Trustee · MichelstadtBuilt 1983 · S/N 31P-8414011N153HPCalifornia Highway Patrol · Sacramento, CABuilt 2016 · S/N GA8-TC-320-16-232N153LMSkylens LLC · Hammond, LABuilt 1976 · S/N 27-7754019N153WBOster Dale E · Trego, MTBuilt 1966 · S/N 27-3329N153WMPollard Aviation LLC · York, MEBuilt 2018 · S/N T20609558N1541XSheffer Marshall A · Herrin, ILBuilt 1975 · S/N 32-7540171N1543TVan Bortel Aircraft Inc · Arlington, TXBuilt 2007 · S/N T18208781N1548XSouthern Turf Services LLC · West Palm Beach, FLBuilt 1975 · S/N 32-7540172N15494Freisitzer Roland Franz · Charlottesville, VAS/N 32-7340045N15498Universal Management And Mainteneance Co Inc · Enid, OKBuilt 1972 · S/N 32-7340010N154BJDent Air Ltd · Annapolis, MDBuilt 1977 · S/N 32R-7780251N154BZGrund Joseph R Jr · North Cape May, NJBuilt 1995 · S/N 27-0195N154DCRocha Jonathan · Prescott Valley, AZBuilt 1969 · S/N 32-40599N154HROakes Aviation LLC · Racine, WIBuilt 2007 · S/N T20608755N154WWAlpha Whiskey 1 LLC · Brandon, MSS/N 31-7952230N15514Smedsmo Darrin A · Roseau, MNS/N 32-7340046N1552SZimmer Eric Fritz · Temecula, CABuilt 2007 · S/N T18208782N1553XGreat Divide Aircraft LLC · Louisville, COBuilt 1975 · S/N 32R-7680003N15552Crate Inc · Humboldt, NEBuilt 1972 · S/N 32-7340048N15554Hogan James · Winter Garden, FLBuilt 1972 · S/N 32-7340014N1556XMills Donald Lee · Arlington, TNBuilt 1975 · S/N 32-7540124N1558QHostettler Aviation LLC · Nashville, TNBuilt 2017 · S/N T20609516N155AEBissat Rashid H · Visalia, CABuilt 1989 · S/N 27-0014N155EPGogoplex LLC · Wilmington, DEBuilt 1969 · S/N 27-4430N155MAOne Zero Three Six Papa LLC · Florence, SCBuilt 2019 · S/N 4636743N156Koche Gary · Downers Grove, ILBuilt 2012 · S/N T18209064N1568WDfb Holdings LLC · Coeur D Alene, IDS/N T18208394N156HPCalifornia Highway Patrol · Sacramento, CABuilt 2016 · S/N GA8-TC-320-16-234N15708Lanza Thomas N · Las Vegas, NVBuilt 1972 · S/N 32-7340058N1572EKorkmaz Fethi A · Asheville, NCS/N 32-7340059N1575XMaring Thomas J · Westley, CABuilt 1975 · S/N 32-7540178N15776Rc & C Inc · Norwalk, IABuilt 1972 · S/N 32-7340064N157CMChamark LLC · Knoxville, TNBuilt 1975 · S/N 32R-7680023N1583XK&T Lawn & Landscape Inc · Newport News, VABuilt 1975 · S/N 32-7540179N15895Ksgj Aircraft LLC · Saint Augustine, FLBuilt 1972 · S/N 32-7340072N158TZBoney George C Jr Trustee · Chapin, SCBuilt 2000 · S/N 20037N1591XTask Aviation LLC · Vancouver, WABuilt 1975 · S/N 32-7540180
Back to AD 71-13-01 R1