OpenAirDocs.org
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.

N8671TSchafer Timothy R · Soldotna, AKS/N 52571N8672BVolker Bradley B · Rice Lake, WIBuilt 1957 · S/N 36372N8672JHunt Daniel · Hayward, CABuilt 1967 · S/N 15066572N8672SAres Aviation LLC · Holly Ridge, NCBuilt 1965 · S/N 15061972N8672UEcho Tango LLC · Milledgeville, GABuilt 1965 · S/N 17252575N8673JAdams Dirk L · Pleasant Hill, OHBuilt 1967 · S/N 15066573N8673TJensen Dennis H · Askov, MNBuilt 1960 · S/N 52573N8673UCarpenter Alan B · Wasilla, AKBuilt 1965 · S/N 17252576N8674UAngle Kevin D · Rocky Mount, VAS/N 17252577N8674ZHoch Lance M · Weiser, IDBuilt 1968 · S/N P206-0474N8675BMountain Express LLC · Haines City, FLBuilt 1957 · S/N 36375N8675TWakefield Bradley E · Rogersville, MOBuilt 1960 · S/N 52575N8676TCasciola Diana M · East Branch, NYBuilt 1960 · S/N 52576N8676XEdwards Flying Service Inc · Leland, MSBuilt 1961 · S/N 18051076N8677SClay Robert W · Hancock, MNBuilt 1965 · S/N 15061977N8677TKowachek Edwin J · Missoula, MTBuilt 1960 · S/N 52577N8677UHunter Richard Louis · Wilton, CABuilt 1965 · S/N 17252580N8678JIvanchenkov Alexandr N · Arden, NCBuilt 1967 · S/N 15066578N8678URoane Aaron J · Ogden, UTBuilt 1965 · S/N 17252581N8678XDorman Richard E · Mesa, WABuilt 1961 · S/N 18051078N8679TOnshore Aviation LLC · Taylors, SCBuilt 1960 · S/N 52579N8679ULake Aera Technical College · Watertown, SDBuilt 1965 · S/N 17252582N8679XHigh Mountain Air LLC · Missoula, MTBuilt 1961 · S/N 18051079N867AAWings Over Texas Holdings LLC · Denton, TXBuilt 1974 · S/N 17264498N8680BGabelli Alfred R · Grand Junction, COBuilt 1957 · S/N 36380N8680SMaestro Aviation LLC · Anson, TXBuilt 1965 · S/N 15061980N8680TD2w Enterprise LLC · Miami Lakes, FLS/N 52580N8680URoberts Robert V · Sebastian, FLBuilt 1965 · S/N 17252583N8680XStevens William C · Ashland, MTBuilt 1961 · S/N 18051080N8681GGrammer Samuel C · Vernal, UTBuilt 1966 · S/N 15062781N8681JSaitto Jeffrey M · Media, PABuilt 1967 · S/N 15066581N8681UFly Around Alaska LLC · Palmer, AKS/N 17252584N8682TBushong Charles L Jr · Jackson, WYBuilt 1960 · S/N 52582N8682UAircraft N8682u Inc · Half Moon Bay, CABuilt 1965 · S/N 17252585N8683UConrad Richard M · Chinook, MTBuilt 1965 · S/N 17252586N8684GTorres Andres · Plano, TXBuilt 1966 · S/N 15062784N8684TMacnealy Bradly S · Isola, MSBuilt 1960 · S/N 52584N8684UOlsovsky Jesse C · Bonita Springs, FLBuilt 1965 · S/N 17252587N8685UBrennan Curtis Callaway · Atlanta, MIS/N 15077970N8686BMcknight Thomas N · Fredericksburg, TXBuilt 1957 · S/N 36386N8686QWaters & Associates Inc · Bellaire, TXS/N U20603468N8686SKaines John L · Ludington, MIBuilt 1965 · S/N 15061986N8687BSelf Aviation LLC · Hayden, IDBuilt 1957 · S/N 36387N8687GLindsey John Monroe · Dover, ARBuilt 1966 · S/N 15062787N8687JManthey Daniel T · Marine St Crx, MNBuilt 1967 · S/N 15066587N8687TKinney Christopher G · Beresford, SDBuilt 1960 · S/N 52587N8688BRegistered aircraftBuilt 1957 · S/N 36388N8688SKubik Darrel J · Boise, IDBuilt 1965 · S/N 15061988N8688USabol Andrew R · Waterville, NYBuilt 1965 · S/N 17252592N8688ZPowell Leo · Villa Park, CAS/N P206-0488
Back to AD 87-20-03 R2