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.

N9160BS & J Investments LLC · Sardis, MSBuilt 1958 · S/N 36760N9160HTodd Media Inc · Tuscaloosa, ALBuilt 1975 · S/N 17265984N91614Hendrich Matthew G · Paso Robles, CABuilt 1969 · S/N 18259844N9161ACabral Aviation LLC · Milton, WABuilt 1950 · S/N 19355N9161BLee Mark S · Grove, OKBuilt 1958 · S/N 36761N9161CLatta Michael D · Auburn, WABuilt 1954 · S/N 31260N9161GBowling Gary L · Elk City, IDBuilt 1971 · S/N 18260701N9161HAir Athens LLC · Athens, GABuilt 1975 · S/N 17265985N91621Whitney Richard J · Mason City, ILBuilt 1969 · S/N 18259846N91626Tmstar Services LLC · Lewes, DEBuilt 1969 · S/N 18259850N9162BMedic Choppers LLC · Springdale, ARBuilt 1958 · S/N 36762N9162HStratus Aviation LLC DBA · Vacaville, CABuilt 1975 · S/N 17265986N9162UDag Arda Orcun · Mount Dora, FLBuilt 1976 · S/N 15078113N9163BWright Donald E · Greensboro, NCBuilt 1958 · S/N 36763N9163GHayssen Arthur H · Sebastopol, CABuilt 1971 · S/N 18260703N9164CMonmouth Aircraft Services Inc · Toms River, NJBuilt 1978 · S/N R18200433N9164GZirjacks Winston L Jr · Gold River, CABuilt 1971 · S/N 18260704N9164UUnderwood Callum M · Canton, GABuilt 1976 · S/N 15078115N91651Cain Edward A · Pembroke, MABuilt 1969 · S/N 18259856N91657Webster Max S · Dalton, PAS/N 18259858N9165AAdams Harry J · Montgomery, TXBuilt 1952 · S/N 19359N9165ULudwiczak Damian · Medina, OHBuilt 1976 · S/N 15078116N9165XShults Jerry G · Kingsland, TXBuilt 1961 · S/N 18253565N91661James One Seventeen LLC · Fairview, OKBuilt 1969 · S/N 18259861N91667Dennis Robert · Rosamond, CAS/N 18259863N9166BWusterhausen Jerry L · Boynton Beach, FLBuilt 1958 · S/N 36766N9166RSchwend Brian · Forsyth, MTS/N 18802136TN9166UKsnl Aero LLC · Shawnee, OKBuilt 1976 · S/N 15078117N91670Sierrahotellima LLC · Farmingdale, MEBuilt 1969 · S/N 18259864N91672Baldridge Steven J · Edmonds, WAS/N 18259865N91673Martin Charles W · Twain Harte, CABuilt 1973 · S/N 17261506N9167BAshley-Nye Johanna I · Graham, WABuilt 1958 · S/N 36767N9167CNew Garden Township · Landenberg, PABuilt 1972 · S/N 15074232N9167GKgrd Aviators LLC · Greenwood, SCBuilt 1971 · S/N 18260707N9167UTobin Dustin J · Hesperia, CABuilt 1976 · S/N 15078118N9167XRichard I French · Eatonville, WABuilt 1961 · S/N 18253567N91680Kay Scott Aviation Insurance Inc · Reno, NVBuilt 1969 · S/N 18259869N9168AMatthews Jeff M · Conowingo, MDS/N 18929N9168BAverett Joseph B · Denham Springs, LABuilt 1958 · S/N 36768N9168GClark Byron · Olympia, WABuilt 1971 · S/N 18260708N9168UC150 LLC · Gilbert, AZBuilt 1976 · S/N 15078119N91690Walker Curtis N · Phoenix, AZBuilt 1969 · S/N 18259872N91691Stumm Robert W · Cadott, WIBuilt 1969 · S/N 18259873N91699Caughlan Cody P · Santa Cruz, CABuilt 1969 · S/N 18259875N9169CVajdos Robert C Jr · Louise, TXBuilt 1955 · S/N 31268N9169GDodson International Parts Inc · Rantoul, KSBuilt 1971 · S/N 18260709N9169UVipperman Richard Madison Jr · Martinsville, VABuilt 1976 · S/N 15078120N9169XAllen Air LLC · Fennville, MIBuilt 1961 · S/N 18253569N916ACYr-Aircraft Leasing LLC · Bethel, AKBuilt 1979 · S/N 20700061N916ATKdrd Holdings LLC · Texas City, TXBuilt 1982 · S/N 17275931
Back to AD 87-20-03 R2