OpenAirDocs.org
AD 87-20-03 R2

Registered aircraft · 54,019

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.

N2600VErickson Rodney L · Rutland, NDBuilt 1948 · S/N 18238N2600YCurrin Thomas E · Pendleton, ORBuilt 1962 · S/N 18051100N2601DHerrmann Mark D · Dillingham, AKS/N 20753N2601FFly3h4 LLC · Hillsboro, NDBuilt 1965 · S/N 18256701N2601LCobb William J · Cincinnatus, NYBuilt 1967 · S/N 17255801N2601UK D Helicopters Inc · Shingleton, MIBuilt 1963 · S/N 17250201N2602DAllen Matt · Bullhead City, AZS/N 20754N2602GConran Joshua · Belmont, MIBuilt 1959 · S/N 51902N2602RSiegel Jeffrey P · Snowmass Village, COS/N 18258302N2602UVan Zee Charles C · Rancho Cucamonga, CABuilt 1963 · S/N 17250202N2603Intentus Aviation LLC · Sunset, TXS/N 32957N2603FHolloway Graham · Orcutt, CABuilt 1965 · S/N 18256703N2603KPadilla Management Inc · Burlington, WABuilt 1978 · S/N 18053013N2603LMagel David J · Lakemoor, ILBuilt 1967 · S/N 17255803N2603RHopper Jeremy G · Amity, ORS/N 18258303N2604DO4dflys LLC · Enterprise, ORBuilt 1952 · S/N 20756N2604GBlessing Christopher B · Houston, DEBuilt 1959 · S/N 51904N2604SGillespie Dan L · Discovery Bay, CABuilt 1968 · S/N 337-0904N2604UTalboy Theodore Neal · Lathrop, CABuilt 1963 · S/N 17250204N2604YLawson Charles A · Arlington, WABuilt 1962 · S/N 18051104N2605FRose Walter W · Arena, WIBuilt 1965 · S/N 18256705N2605GInnes Stephen L · Bentonville, ARBuilt 1959 · S/N 51905N2606DMoran Craig L · Krotz Springs, LABuilt 1952 · S/N 20758N2606QElsayed Von Bayreuth Alaaeldeen Mohamed · Fairfield, CABuilt 1966 · S/N 18257806N2606XSmith And Cherry Aviation LLC · Knoxville, TNBuilt 1965 · S/N P206-0106N2607DMachen Matthew W · Lander, WYBuilt 1952 · S/N 20759N2607GJensen Rodney · Aptos, CABuilt 1959 · S/N 51907N2607SHunter Gary A · Fort Wayne, INBuilt 1976 · S/N 21061338N2607VHamlin Ryan C · Naples, MES/N 18117N2607ZSidney Aviation LLC · Sidney, NEBuilt 1963 · S/N 185-0607N2608JDriftless Aero LLC · Montfort, WIBuilt 1966 · S/N 15065608N2608QMiller David C · Burlington, CTBuilt 1966 · S/N 18257808N2608RRegistered aircraftBuilt 1967 · S/N 18258308N2608VWohl Mitch A · Deer Park, ILBuilt 1948 · S/N 18118N2608XOdonnell James E · Northport, NYBuilt 1965 · S/N P2060103N2609GRegistration Pending · Grove City, PARegistration pendingS/N 15077218N2609LHavertown Flyers LLC · Havertown, PABuilt 1967 · S/N 17255809N2609QDawson Arden H III · Eagle Nest, NMBuilt 1966 · S/N 18257809N2609VPallotto Victor N · Passaic, NJBuilt 1948 · S/N 18119N2609YHelvey Michael H · Sheridan, WYBuilt 1962 · S/N 18051109N260DFMatchbox Holdings LLC · Harrisonburg, VABuilt 1975 · S/N 18264479N260PTPeterson Todd · El Dorado, KSBuilt 1977 · S/N 18265612N260TGPickerel Enterprises LLC · Bennet, NES/N 18267521N2610DKomer Thomas B Jr · Moorpark, CABuilt 1952 · S/N 20762N2610JTrotzke Samuel P · North Pole, AKBuilt 1966 · S/N 15065610N2610SGordon Daryl B · Bellevue, WABuilt 1968 · S/N 337-0910N2611DAmsdell David A · Morgantown, WVS/N 20763N2611FMccall Aviation LLC · Union Springs, ALBuilt 1965 · S/N 18256711N2612QLabarre Ben A · Hayward, WIS/N 18257812N2612SNixon Edward J · Collierville, TNS/N 337-0912
Back to AD 87-20-03 R2