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.

N97540Popeye And Olives Adventures LLC · Helena, MTBuilt 1979 · S/N 18267127N97543Carter Michael E · Dallas, GAS/N 18267128N97549Brandt Jeremy · Torrance, CAS/N 17276206N9754GWings Aircraft Leasing And Services LLC · Wasilla, AKBuilt 1972 · S/N 18052254N97553Gregor Anthony J · Bethesda, OHBuilt 1979 · S/N 18267129N9755BRs Specialties LLC · Anchorage, AKBuilt 1957 · S/N 50053N9755DSkyline Solutions Inc · Deland, FLBuilt 1984 · S/N 17276227N9755HQualitair LLC Trustee · MichelstadtBuilt 1981 · S/N 18267997N97563Fenell Jeffrey A · Stahlstown, PAS/N 18267133N9756VLarson Lynn R · Casselton, NDS/N 188-0206N97578Utecht Thomas A · Friant, CABuilt 1979 · S/N 18267135N97580Wardall Wesley David · Ione, CABuilt 1979 · S/N 18267137N9758BSherwood Aviation LLC · Lewes, DES/N 172RG1015N9758HBlue Sky Aviation Association Inc · Readington, NJBuilt 1981 · S/N 18268000N9758XHernandez Luis Ignacio · Naples, FLBuilt 1962 · S/N 21058058N97596Aero-Sphere Inc · Longmont, COBuilt 1979 · S/N 18267143N9759ALove John W Jr · Los Lunas, NMBuilt 1950 · S/N 19220N9759BHernandez Raymond · Burleson, TXBuilt 1957 · S/N 50057N9759GMcneill Dudley · Happy, TXBuilt 1974 · S/N 18801592N9759HHavelka Glen C · Boerne, TXBuilt 1981 · S/N 18268001N9759XFlorida Alarm & Security Technologies LLC · Merritt Island, FLBuilt 1962 · S/N 21058059N975BWWeidendorf Investments LLC · Hinckley, MNS/N 17270718N975PCBeck Steven · San Clemente, CABuilt 1975 · S/N 18263546N975SRBrown Tyrone · Fontana, CABuilt 1968 · S/N 18258964N97601Zapata Michael III · Cary, NCBuilt 1979 · S/N 18267145N9760AK & S Aviation Adventures LLC · Toms River, NJS/N 19221N9760XGubler Joseph A · Fairhaven, MABuilt 1962 · S/N 21058060N97611Bravo Aviation Co · San Antonio, TXBuilt 1979 · S/N 18267147N9761HBrentco Aerial Patrol Inc · Canton, OHBuilt 1981 · S/N 18268003N97622Paul A Leep Md P C · Chassell, MIBuilt 1979 · S/N 18267148N97627Speer Paul B · Vancouver, WABuilt 1979 · S/N 18267150N9762EBuermann Hank · Brookfield, VTBuilt 1954 · S/N 30799N9762XMcdonald Daniel P · Canon City, COBuilt 1962 · S/N 21058062N97633Graham Brown Aircraft Rentals LLC · Wilmington, DEBuilt 1979 · S/N 18267152N9763ARoman Financial Inc · Monroe, WABuilt 1950 · S/N 19224N9763BS-3 Aero Ent LLC · Denton, TXBuilt 1957 · S/N 50061N9763HReed Grain & Bean Inc · Buhl, IDBuilt 1981 · S/N 18268004N97640Foutz William R · Farmington, NMBuilt 1979 · S/N 18267154N9764BPowder Hound LLC · Girdwood, AKBuilt 1957 · S/N 50062N9764GSicheneder Scott · Wasilla, AKS/N 18052264N97650Updraft LLC · Kissimmee, FLS/N 17276218N9765HAspen Helicopters Inc · Oxnard, CAS/N 18268006N9765XBaer Monte Wayne · Ronan, MTS/N 21058065N97661Gravity Productions Inc · Redondo Beach, CABuilt 1979 · S/N 18267162N97662Northwest Alabama Holdings LLC · Spruce Pine, ALBuilt 1984 · S/N 17276219N97672You Are My Sunshine Aviation LLC · Orange, TXBuilt 1979 · S/N 18267165N97674Oc Flight Lessons LLC · Costa Mesa, CABuilt 1984 · S/N 17276220N97678Walkinshaw Marcus D · Ridgeland, MSBuilt 1979 · S/N 18267166N9767GCottingham Dwain R · Attica, INBuilt 1972 · S/N 18052267N9767HSwanson Joseph C · Blairsville, GABuilt 1981 · S/N 18268008
Back to AD 87-20-03 R2