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.

N3848LHarrod Group Inc · Ellaville, GABuilt 1966 · S/N 17254017N3848QWestwind Flyers LLC · Friday Harbor, WABuilt 1971 · S/N 17259948N3848RGunter Jeffrey W · Demorest, GAS/N 17255348N3849DMellor Bradford A · Spanish Fork, UTS/N 34549N3849JGamble Marty · Crofton, KYBuilt 1966 · S/N 15065149N3849QSmetana Louis V III · Blair, NEBuilt 1971 · S/N 17259949N3849RSims Charles H · Soldotna, AKBuilt 1966 · S/N 17255349N3849UKashi Joseph L · Soldotna, AKBuilt 1963 · S/N 336-0149N3849VPaulas Daniel · Petaluma, CAS/N 18736N384MGMissionary Air Group Inc · Burlington, NCBuilt 1979 · S/N U20605272N3850RKelley Patrick W · Charlo, MTBuilt 1966 · S/N 17255350N3850SFoss Sterling D · Basin, WYBuilt 1963 · S/N 17251050N3850VFlorida Air Tours Inc · Merritt Island, FLBuilt 1949 · S/N 18737N3850YPoole Vernon N · Melstone, MTBuilt 1964 · S/N 21058350N3851DSale Reported · Darby, MTSale reported, pending cancellationBuilt 1957 · S/N 34551N3851UMcintyre Lester Blake · Fountain Run, KYS/N 336-0151N3851VTexas Air Corps · Bullard, TXBuilt 1949 · S/N 18738N3851YMckie-Voerste Travis K · Chatsworth, GABuilt 1964 · S/N 21058351N3852CWilson Kirk B · Glennallen, AKBuilt 1954 · S/N 31000N3852LMountain Wings LLC · Salem, WVBuilt 1965 · S/N 17254021N3852QOwens Wilbur · Rch Palos Vrd, CAS/N 17259952N3852RChristman Mike G · Wasilla, AKBuilt 1966 · S/N 17255352N3853DMccabe Ryan · Las Vegas, NVS/N 34553N3853G3853g LLC · Umatilla, FLBuilt 1967 · S/N U206-0853N3853YRafter Bar B LLC · Ashland City, TNBuilt 1964 · S/N 21058353N3854CAnderson Clint T · Corsicana, TXBuilt 1954 · S/N 31002N3854DTjp@Jax Inc · Zephyrhills, FLBuilt 1957 · S/N 34554N3854QHafford Jay T · Stevenson, WAS/N 17259954N3854USkymaster Stc LLC · Mena, ARBuilt 1963 · S/N 336-0154N3854YJames Wilson Smith Enterprises LLC · Athens, GABuilt 1964 · S/N 21058354N3855GMoore David · Lexington, TXBuilt 1967 · S/N U206-0855N3855JWiley Phillip W · New Martinsville, WVBuilt 1966 · S/N 15065155N3855RAircraft Investment Group LLC · Cookeville, TNBuilt 1966 · S/N 17255355N3855VKeiths Aviation Training LLC · Altus, OKS/N 18742N3856JClifton Chad R · Asheboro, NCBuilt 1966 · S/N 15065156N3856LSimmons Brandon M · Sylacauga, ALS/N 17254025N3856RSmith Joseph M · Juneau, AKBuilt 1966 · S/N 17255356N3856SSobie David M · Nome, AKS/N 17251056N3857RLorring Eric Henry · Kodiak, AKBuilt 1966 · S/N 17255357N3857VSrv Air Service LLC · Stockton, NJBuilt 1949 · S/N 18744N3857YLutz Matthew B · Jackson, TNBuilt 1964 · S/N 21058357N3858QPylant Eric Jon · Arnold, CABuilt 1971 · S/N 17259958N3858RBaugh David · Kirkland, WABuilt 1983 · S/N U20606496N3858SDearman Daniel R Sr · Cottonwood, CABuilt 1963 · S/N 17251058N3858VMission Aviation LLC · Orange Park, FLBuilt 1975 · S/N 15076637N3859CSweet Phillips R · Laguna Beach, CABuilt 1954 · S/N 31007N3859JOnefiftyjuliet LLC · Saint Petersburg, FLBuilt 1966 · S/N 15065159N3859LBourke Michael T · Adams, WIBuilt 1965 · S/N 17254028N3859RLeja Dennis A · Watertown, WIBuilt 1966 · S/N 17255359N3859SFlorance Robert L · Fort Worth, TXBuilt 1963 · S/N 17251059
Back to AD 87-20-03 R2