OpenAirDocs.org
AD 87-20-03 R2

Registered aircraft · 54,017

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.

N3740JHersom Jeffrey T · Helena, MTBuilt 1966 · S/N 15065040N3740RRhodes Samuel R · Bonne Terre, MOBuilt 1967 · S/N 17255540N3740SGarnsey Zene P · Schuylerville, NYBuilt 1963 · S/N 17250940N3740UFlight Club 502 Inc · Louisville, KYBuilt 1963 · S/N 18255140N3740YOmg Air LLC · Okeechobee, FLBuilt 1964 · S/N 21058240N3741DTrouwborst Keith J · Lander, WYBuilt 1957 · S/N 34441N3741FMclanahan John P · Culpeper, VAS/N 17255236N3741JSharp Ruth · Clarksville, TNBuilt 1966 · S/N 15065041N3741RAbecca Corp · Jackson, MIBuilt 1966 · S/N 17255541N3742JLow Cost Flying LLC · Chandler, AZBuilt 1966 · S/N 15065042N3742SHand Jerry A · Nacogdoches, TXBuilt 1963 · S/N 17250942N3743DLanzisera Francesco · Questa, NMBuilt 1957 · S/N 34443N3743FRohde William B · Homer, NEFirst renewal noticeBuilt 1966 · S/N 17255238N3743GMahler Richard Keith · Haines, AKS/N 26301N3743LAero Flight Two LLC · Peoria, AZS/N 17253912N3743UHughes Kathryn G · Council, IDBuilt 1963 · S/N 18255143N3743YCooper Jess D · Spanaway, WAS/N 21058243N3744CVand Flyve Klub Inc · Thief River Falls, MNBuilt 1957 · S/N 32792N3744DMorcom Ronald W Jr · Stanwood, WABuilt 1957 · S/N 34444N3744LAir Jeffery LLC · Aledo, TXBuilt 1965 · S/N 17253913N3745LMaxey Lonnie C · Powell, TNBuilt 1965 · S/N 17253914N3745PRiviera Aircraft Inc · Lewes, DEBuilt 1978 · S/N P21000052N3745RDodds Timothy E · Salmon, IDBuilt 1966 · S/N 17255545N3745SKondel Eugene F · Owosso, MIBuilt 1963 · S/N 17250945N3745UAnglemyer Mark · Piketon, OHBuilt 1963 · S/N 18255145N3746Nickravesh Niknam J · Saratoga, CABuilt 1975 · S/N U20602818N3746JCrandall Lloyd G · Lake City, MIBuilt 1966 · S/N 15065046N3746LBygd Sherman O · New Richmond, WIBuilt 1965 · S/N 17253915N3746RPearson Eric · Wills Point, TXS/N 17255546N3746UUltimate Internet Access Inc · Wrightwood, CABuilt 1963 · S/N 18255146N3746YWeed James A · Suwanee, GABuilt 1963 · S/N 21058246N3747BAviation Specialists Inc · Gonzales, LABuilt 1979 · S/N R18201305N3747JRegistration Pending · Bay Harbor Islands, FLRegistration pendingS/N 15065047N3747LN3747l LLC · Sonora, CABuilt 1965 · S/N 17253916N3747SToland Wesley H · Warrenton, ORBuilt 1963 · S/N 17250947N3747YCenturion Aviation Nevada LLC · Sparks, NVBuilt 1963 · S/N 21058247N3748DPetersen Jacob R · Wasilla, AKBuilt 1957 · S/N 34448N3748FMcdonald David R · Duluth, MNS/N 17255243N3748HVoth Michael K · Lynchburg, VABuilt 1963 · S/N 21058248N3748RRotormate LLC · Royse City, TXBuilt 1966 · S/N 17255548N3748SGeminiair Inc · Davis, CABuilt 1963 · S/N 17250948N3748UChristy Allen C · Farmington, NMBuilt 1963 · S/N 18255148N3749FLeduc Kramer LLC · Live Oak, FLBuilt 1966 · S/N 17255244N3749JLove Duane Anthony · San Rafael, CAFirst renewal noticeBuilt 1966 · S/N 15065049N3749LWilcox James F · Garrison, NDBuilt 1965 · S/N 17253918N3749YWestwind Homes Inc · Twin Falls, IDBuilt 1963 · S/N 21058249N374DNChadbourne Daniel I Jr · Anchorage, AKBuilt 1978 · S/N P3370326N3750FGrubbs Richard T · Spring, TXBuilt 1966 · S/N 17255245N3750JEagle East Aviation Inc · North Andover, MABuilt 1966 · S/N 15065050N3750RN3750r LLC · Guthrie, OKBuilt 1966 · S/N 17255550
Back to AD 87-20-03 R2