OpenAirDocs.org
AD 71-13-01 R1

Registered aircraft · 6,916

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.

N8243LFieri Doug · La Verne, CABuilt 1980 · S/N 32-8024035N82470Tfto LLC · Franklin, TNBuilt 1984 · S/N 32R-8429016N8248QElkhart Flying Club Inc · Nappanee, INBuilt 1982 · S/N 32R-8329004N824GTBmi Aviation LLC · Bartlesville, OKBuilt 2000 · S/N 2010N824KLN824kl LLC · Lakewood, CABuilt 1973 · S/N 73-32-123N824PGMount Olive Flight Club LLC · Mount Olive, NCBuilt 1982 · S/N 31-8252055N824RCAquila Consulting Services LLC · Los Angeles, CABuilt 2004 · S/N T18208305N824WBest Start Inc · Kingman, AZBuilt 1982 · S/N 32R8229032N8250PSedberry Jason A · Kokomo, INS/N 24-2563N82532Smithy Grain Inc · Presho, SDBuilt 1980 · S/N 32-8024039N8254RKrejci Ryan J · Sandstone, MNBuilt 1972 · S/N 32-88N8255RTwo River Airspray LLC · Cavalier, NDBuilt 1972 · S/N 32-72N8258PThings That Fly LLC · Phoenix, AZBuilt 1963 · S/N 24-3511N8258RNewo Aviation LLC · Garden City, KSS/N 32-66N825AN7045x LLC · Farmingdale, NYBuilt 2008 · S/N 4692043N825CSMge Underground Inc · Paso Robles, CABuilt 2021 · S/N T20609625N825DHLafferty Steven Michael · Huntley, ILBuilt 2007 · S/N T18208744N825XSktr Ac LLC · Fallbrook, CABuilt 2006 · S/N 3255043N8261TDoss Brothers Inc · Lawrenceburg, TNBuilt 1980 · S/N 32-8024043N8263EN8263e LLC · Jackson, MIS/N 32-8024046N82646Downs Ricky R Trustee · Roundup, MTS/N 36-7760127N82654Horomanski Eugene E · Duncansville, PABuilt 1980 · S/N 32-8024048N82656Souther Field Aviation Inc · Americus, GAFirst renewal noticeBuilt 1977 · S/N 36-7760134N8265RMirrorstriker Aviation LLC · Tomball, TXBuilt 1972 · S/N 32-73N8268VMcs Inc · Loveland, COBuilt 1980 · S/N 32-8024050N82692Piper Aircraft Inc · Vero Beach, FLBuilt 1977 · S/N 36-7960044N826CFHanekamp John W · Glen Carbon, ILBuilt 2001 · S/N T182-08091N826DDRegistered aircraftBuilt 2004 · S/N T18208357N826MABrown Thomas W · San Luis Obispo, CAS/N 3257435N8275RRensberger Scott C · Lake Jackson, TXBuilt 1972 · S/N 32-84N8278RSutton Barry W · Longview, TXBuilt 1972 · S/N 32-82N8279YSaratoga Aviation LLC · Sioux Falls, SDBuilt 1980 · S/N 32-8024052N827HTWings Over Texas Holdings LLC · Denton, TXS/N 31-156N827RJN827rj LLC · Ogden, UTBuilt 2012 · S/N 4636526N827YPGreiner Heating Air Conditioning Inc · Dixon, CABuilt 2009 · S/N T20608938N82813Preside Management Inc · Coachella, CABuilt 1980 · S/N 32-8124001N8282KNoyes Tony · Lewisville, TXS/N 32R-8129002N8282NMercury Aircraft Holdings Inc · West Monroe, LABuilt 1980 · S/N 32R-8129003N8287RHuhnke John · Newburgh, INBuilt 1972 · S/N 32-81N828BDEchols Mill Aviation LLC · Elberton, GABuilt 1982 · S/N 31-8212017N828GPGreene And Phillips Attorneys At Law LLC · Mobile, ALBuilt 2011 · S/N 4636514N828HJPegasus Air Charter LLC · Hartford, CTBuilt 1980 · S/N 31-8052160N828KTJones Larry · Anchorage, AKBuilt 1980 · S/N 318052098N828LBBeraut Olivier Trustee · Scotts Valley, CABuilt 1972 · S/N 32-7240077N828PDSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1991 · S/N 1085N828SRGulfcoast Aviation Inc · Wilmington, DEBuilt 1978 · S/N 32R-7887169N82908Hall Charles R · Leawood, KSBuilt 1982 · S/N 32-8324001N8292TJames Peterson Sons Inc · Medford, WIBuilt 1982 · S/N 32R-8329001N8299PFischer Dale R · Laporte, INBuilt 1963 · S/N 24-3277N829CJetran LLC · Horseshoe Bay, TXBuilt 2005 · S/N 3255039
Back to AD 71-13-01 R1