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.

N9925HScientific Aerial Imaging Inc · Saint Helena, CABuilt 1981 · S/N 18268117N9925NHarrod James · Birchwood, MNBuilt 1975 · S/N 18052580N9925QRoeder Cara R · Lake Charles, LABuilt 1975 · S/N 17265869N9925VGoodin Joshua W · Jacksonville, FLBuilt 1974 · S/N 17264559N99263Wings Over Texas Holdings LLC · Denton, TXBuilt 1985 · S/N 17276424N99265St Pete Aviation Services LLC · Saint Petersburg, FLBuilt 1985 · S/N 17276425N9926AOlmsted Ronald A · Barnstead, NHFirst renewal noticeBuilt 1950 · S/N 19286N9926EPaul Michael Trustee · San Antonio, TXBuilt 1985 · S/N 18268472N9926NBelchak Timothy A · Albuquerque, NMS/N 21063252N9926VRanheim Richard J · Blaine, MNBuilt 1966 · S/N 18051778N9926XMuth Franklin R · Missoula, MTBuilt 1961 · S/N 1850126N99273United States Air Force · Dover Afb, DEBuilt 1985 · S/N 17276427N9927ABrian Jake K · Sumner, ILBuilt 1950 · S/N 19287N9927HAnderson Mfg Inc · Camilla, GABuilt 1981 · S/N 18268118N9927QAndrus Shane · Pullman, WABuilt 1975 · S/N 17265871N9927THauser Thomas R · Johnson, KSBuilt 1960 · S/N 18253027N9927VBunin David K · Rockwall, TXBuilt 1977 · S/N R1722354N9928BHayton James B · Sedro Woolley, WAS/N 34328N9928EAir-Lark Inc · Fort Walton Beach, FLBuilt 1975 · S/N 18263988N9928NScott J Steve Jr · Itta Bena, MSBuilt 1977 · S/N U20603730N9928QDavis John · Jackson, WYBuilt 1975 · S/N 17265872N9928VRyan Wilfred P · Anchorage, AKFirst renewal noticeBuilt 1966 · S/N 18051780N9928YEckelkamp L B Jr · Washington, MOBuilt 1982 · S/N 21064643N99295Sky Warrior Flight Training Inc · Pensacola, FLBuilt 1985 · S/N 17276429N9929ACavner Hudson · Palmer, AKBuilt 1950 · S/N 19289N9929EJesse Briggs Inc · Stuttgart, ARS/N 18263989N9929NBarnes Stewart A Trustee · Wasilla, AKBuilt 1975 · S/N 18052584N992CDPineland Properties LLC · Volga, SDS/N 56299N992EZLarge Jon D · Wasilla, AKBuilt 1953 · S/N 25905N992LBBravo Initiative LLC · Highlands Ranch, COBuilt 1975 · S/N 18263982N992PSProctor Gary · Wichita, KSBuilt 1978 · S/N 21063074N992WTAngle Of Attack Inc · Santa Fe, NMBuilt 1972 · S/N 18261200N9930ASmith David J · Duluth, MNBuilt 1950 · S/N 19290N9930EBell A A Flying Club · Mechanicsburg, PABuilt 1985 · S/N 18268473N9930HTorres Daniel Yorro · Carolina, PRBuilt 1981 · S/N 18268121N9930QBrawdy James · Clarence Center, NYBuilt 1979 · S/N 18503798N9930TWateractive43 LLC · Auburn, CAS/N 18253030N9930VHovland Keith C · Wadsworth, OHBuilt 1966 · S/N 18051782N9930XPeterson Tony · Humboldt, IABuilt 1961 · S/N 1850130N9931ARowland Brett D · Wichita, KSBuilt 1950 · S/N 19291N9931BLevin Lawrence W · Glencoe, ILFirst renewal noticeBuilt 1982 · S/N 172RG1084N9931EN9931e LLC · Phoenix, AZBuilt 1979 · S/N 17272291N9931HEnergy Transfer Aviation LLC · Spring, TXBuilt 1981 · S/N 18268122N9931QDexter Aero Club Inc · Stetson, MEBuilt 1975 · S/N 17265875N9931THanft Douglas N · Raymond, CABuilt 1960 · S/N 18253031N99329Tactical Integrated Training Soluctions LLC · San Antonio, TXBuilt 1985 · S/N 17276432N9932EMiller Mike R · Redmond, WABuilt 1975 · S/N 18263992N9932GT & M Aircraft LLC · Monticello, ILBuilt 1971 · S/N 18800732N9932HFlathead Flight Operations LLC · Kalispell, MTBuilt 1981 · S/N 18268123N9932NGetz Keith · Murfreesboro, TNBuilt 1975 · S/N 18052587
Back to AD 87-20-03 R2