AD 87-20-03 R2

Registered aircraft · 54,015

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:87-20-03-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2')
  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.

N9460BEdwards Ag Service · Primghar, IABuilt 1958 · S/N 55260N9460UMarkham Clint D · Vinita, OKBuilt 1976 · S/N 15078408N94619Fanning Fred W · Fairlawn, OHBuilt 1978 · S/N 18266463N9461DDurghinescu Cris Nicolae · Rancho Mirage, CABuilt 1984 · S/N 172RG1174N9461GMillionair Inc · Ferndale, WAS/N U20601661N9461MMaster Chief Cricket LLC · Morgan City, LABuilt 1970 · S/N 21059361N9461REthnos360 Inc DBA · Mcneal, AZBuilt 1985 · S/N U20606868N9461ZMichigan Aeronautics Commission · Lansing, MIBuilt 1981 · S/N U20606505N94623Watts Mark A · Medicine Lodge, KSBuilt 1978 · S/N 18266464N94626New Horizons Aviation Inc · Goshen, INS/N 15285747N9462BPustell Robert J · West Ossipee, NHBuilt 1958 · S/N 55262N9462CAcp Aviation LLC · Oakdale, LABuilt 1955 · S/N 31860N9463BSanford Scott · Rancho Cucamonga, CABuilt 1958 · S/N 55263N9463COgden Dale · Buckley, WABuilt 1955 · S/N 31861N9463DHarris Aircraft Leasing Co · Oklahoma City, OKBuilt 1984 · S/N 172RG1175N9463TMcbee Kenneth H · Pasadena, TXBuilt 1960 · S/N 57263N9463UMonday Terry A · Greenville, NCBuilt 1976 · S/N 15078411N94643Ashmore Mark D · Naples, IDBuilt 1978 · S/N 18266471N94645Bozic Zeljko · San Pedro, CABuilt 1978 · S/N 18266472N9464CSpencer Page Trustee · Anchorage, AKBuilt 1955 · S/N 31862N9464HAlsworth Leon R · Port Alsworth, AKS/N 18503440N9464M2morrow Aviation LLC · Abilene, TXBuilt 1977 · S/N 21062079N9464THansen Peter J · Collierville, TNBuilt 1960 · S/N 57264N94651Patrick A Testerman · Maple Grove, MNBuilt 1978 · S/N 18266475N94652Maryak Hans F · Somersworth, NHBuilt 1983 · S/N 15285752N94655Iowa Great Lakes Flyers Inc · Cheyenne, WYBuilt 1983 · S/N 15285753N94659Pavco Inc · Gig Harbor, WABuilt 1983 · S/N 15285755N9465BBartlett Robert E · Cleveland, TXBuilt 1958 · S/N 55265N9465CPottenger Matthew J · Richland, MIBuilt 1955 · S/N 31863N9465DMehrer Fritz J · Oceanside, CAS/N 172RG1176N9465GOsprey Air LLC · Anchorage, AKS/N U20601665N9465YWof Investments LLC · Dover, DES/N 21064515N94660Tweed Bradley Steven · Greeneville, TNBuilt 1978 · S/N 18266480N94661Fjiro Aviation N94661 LLC · Vancouver, WAFirst renewal noticeBuilt 1983 · S/N 15285756N94669Harvanek Brian R · Sarver, PABuilt 1978 · S/N 18266484N9466BStoots David A · Fairbanks, AKBuilt 1958 · S/N 55484N9466CTappan Zachariah · Fritz Creek, AKBuilt 1955 · S/N 31864N9466EGood Flight Aviation LLC · Stockton, CABuilt 1979 · S/N 17272272N94671Sky Jaunts LLC · Kalispell, MTBuilt 1978 · S/N 18266485N94672Cls Contracting LLC · Eureka, MTFirst renewal noticeBuilt 1978 · S/N 18266486N94673Glaze Roy J · Smyrna, TNBuilt 1978 · S/N 18266487N9467MSideropoulos Lester G · Knoxville, TNBuilt 1968 · S/N 18258909N9467UPowell Travis R · Clinton, MOS/N 15078415N94684Delta State University · Cleveland, MSBuilt 1983 · S/N 15285763N94688Lyon Aviation Inc · Pittsfield, MABuilt 1983 · S/N 15285765N9468BHayward David E · Middlesboro, KYBuilt 1958 · S/N 55268N9468CClarkson Darren E · Phoenix, AZS/N 31866N9468DKelly Henry Searles · Ossining, NYBuilt 1984 · S/N 172RG1177N9468HShouse Andrew · Flagstaff, AZBuilt 1975 · S/N 17266169N9468TBas Part Sales LLC · Greeley, COS/N 57268
Back to AD 87-20-03 R2