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.

N29444Pikula Eric Martin · Brainerd, MNS/N 17700893N29448Central Virginia Aviation Inc · North Dinwiddie, VABuilt 1968 · S/N 17700894N29449Brown D W · Wasilla, AKBuilt 1968 · S/N 17700895N2944AWalker Travis J · Wasilla, AKBuilt 1953 · S/N 30144N2944CHenry Kent · Prescott, AZBuilt 1954 · S/N 30844N2944DWeaver Brian J · Livingston, TXBuilt 1955 · S/N 26887N2944FJ3 Contracting Inc · Milton Freewater, ORBuilt 1966 · S/N 18257044N2944JThomas Edward R · Piney Flats, TNS/N 15065744N2944SChartrand Robert J · Brimley, MIBuilt 1967 · S/N 15066844N2944UMillsaps David C · Tuscumbia, ALBuilt 1963 · S/N 17250544N29455Heir Richard T · Lambert, MTBuilt 1968 · S/N 17700899N29459Frana Cody R · Eagle Rock, MOBuilt 1968 · S/N 17700901N2945UGriffith Ronald W Jr · Douglasville, GABuilt 1963 · S/N 17250545N2945VMcclellan Stephanie · Hebron, ILS/N 15076330N29462Thomas Stanley L · Thermopolis, WYBuilt 1968 · S/N 17700904N29467Teel Kevin E · Fallbrook, CAS/N 17700908N29468Cummings Mark R · Laveen, AZBuilt 1968 · S/N 17700909N29469Gem Property Investments LLC · San Antonio, TXBuilt 1968 · S/N 17700910N2946ARuach Ministry · Dover, DES/N 30146N2946CMannis Arthur · Somers, NYBuilt 1954 · S/N 30846N2946EHigh Wing Air Services LLC · Merritt Island, FLBuilt 1978 · S/N 17271380N2946SFreed Michael · Sylmar, CABuilt 1967 · S/N 15066846N2946UPearson Eugene L · Burns, KSS/N 17250546N29474Leslie Jason · Dayton, OHBuilt 1968 · S/N 17700913N29479Kozminski Michael J · Caledonia, WIBuilt 1968 · S/N 17700914N2947CHess Alexander · Virginia Beach, VABuilt 1954 · S/N 30847N2947DMelin Clinton C Trustee · Big Lake, AKS/N 26890N2947FCopeland Matthew S · Wichita, KSBuilt 1966 · S/N 18257047N2947JMaggio Anthony M · Harbor City, CABuilt 1966 · S/N 15065747N29480Cobra Aviation LLC · Kalispell, MTBuilt 1968 · S/N 17700915N29481Walle Heidi N · Coarsegold, CABuilt 1968 · S/N 17700916N29485Lily Anne Aviation LLC · Bad Axe, MIBuilt 1968 · S/N 17700919N29488Luther Charles A · Walnut Creek, CABuilt 1968 · S/N 17700921N2948CTundra House Tailwheel Club LLC · Willow, AKBuilt 1955 · S/N 31730N2948JSale Reported · Ruston, LASale reportedBuilt 1966 · S/N 15065748N2948YWells David · Twin Falls, IDBuilt 1962 · S/N 18253948N29495Beaudine Robert J · Westlake Village, CABuilt 1968 · S/N 17700926N2949AEllis Sterling M · Scottsdale, AZBuilt 1953 · S/N 30149N2949DJackson Carl · Martin, SDBuilt 1955 · S/N 26892N2949SRegistered aircraftBuilt 1967 · S/N 15066849N2949VKingdom Power And Glory LLC · Colorado Springs, COBuilt 1977 · S/N R1722235N2949YGallinat Theodore R · Milliken, COS/N 18253949N29509Empty Nest Aviation LLC · Mckinney, TXBuilt 1968 · S/N 17700934N2950CHenry'S Dragline Service LLC · Winona, MNBuilt 1954 · S/N 30850N2950DKnight Todd · Grimes, IABuilt 1955 · S/N 26893N2950FSpring Ronald L · London, OHBuilt 1966 · S/N 18257050N2950JRunway Aviation Flight Training USA Corp · Rockwall, TXS/N 15065750N2950SJohnson Aviation LLC · Middleton, IDS/N 15066850N2950UMorris Lawrence P Jr · Aberdeen, NCBuilt 1963 · S/N 17250550N2950VCollins Robert J · Kennett Square, PABuilt 1974 · S/N 15076332
Back to AD 87-20-03 R2