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.

N2481CPippert Jim · Dysart, IABuilt 1954 · S/N 30781N2481DMandiola Alexander S · Key Biscayne, FLBuilt 1952 · S/N 20633N2481GEaster Brett D · Enumclaw, WABuilt 1959 · S/N 51781N2481LGhaemmaghami Ommid · Mckinney, TXBuilt 1966 · S/N 17255681N2481REngh Robert G · Laurel, MTBuilt 1964 · S/N 18255581N2481UWilliams Jeremy · Searsport, MES/N U20602380N2481YFellers Farms LLC · Burlington, OKBuilt 1962 · S/N 17249781N2482CMiller Richard W · Bellingham, WABuilt 1954 · S/N 30782N2482DRiegel Frederick E · Houston, OHBuilt 1952 · S/N 20634N2482LTrubowicz Maciej Piotr · Cornelius, NCBuilt 1966 · S/N 17255682N2482QFox John E · Boonville, CABuilt 1966 · S/N 18257682N24831Bishop Darin R · Livermore, CABuilt 1977 · S/N 15280403N2483DBrogden Aviation LLC · Olathe, KSBuilt 1952 · S/N 20635N2483FMiller Clinton J · Traverse City, MIBuilt 1966 · S/N 18051685N2483GLenox Mark W · Idaho Falls, IDS/N 51783N2483JWestern Pilot Service Inc · Phoenix, AZBuilt 1979 · S/N 18803467TN2483QMarch Kenrick D · Kingwood, TXBuilt 1966 · S/N 18257683N2483RSkydive Twin Cities LLC · Baldwin, WIS/N 18255583N2484CLejeune Aerial Applications LLC · Basile, LABuilt 1954 · S/N 30784N2484FJones William Ransom · Anchorage, AKBuilt 1966 · S/N 18051686N2484JTundra Aviation Inc · Casselton, NDBuilt 1966 · S/N 15065584N2484LLuv2fly LLC · San Antonio, TXS/N 17255684N2484UFiske James K · North Andover, MABuilt 1963 · S/N 17250084N24856Mccreary Aviation LLC · Green Valley, AZBuilt 1977 · S/N 15280414N24857Pea-Wayman Flight LLC · Daytona Beach, FLBuilt 1977 · S/N 15280415N2485DDraggin Tail Pilots LLC · Prospect, PABuilt 1952 · S/N 20637N2485GBack Country Guys LLC · Prescott, AZBuilt 1959 · S/N 51785N2485JPercival Sheila · Watson, ILS/N 15065585N2485QPayne Scott M · Twin Bridges, MTBuilt 1966 · S/N 18257685N2485SBrewer Lester A · Magna, UTS/N 337-0785N2485YMcdonald Gregory S · Mena, ARBuilt 1962 · S/N 17249785N2486CArmstrong Patrick Trustee · Bishop, CABuilt 1954 · S/N 30786N2486GDenton Bob · Nampa, IDBuilt 1959 · S/N 51786N2486RCain James W · Big Rapids, MIBuilt 1964 · S/N 18255586N2486SDarvek LLC · Las Vegas, NVBuilt 1967 · S/N 337-0786N2486XGreat Escape Aviation LLC · Marquette, MIBuilt 1965 · S/N 18256386N2486YCarfinder LLC · Huntington Station, NYBuilt 1962 · S/N 17249786N24874Sunrise Aviation Inc · Ormond Beach, FLBuilt 1978 · S/N 15280427N2487DBlue Four Aviation LLC · North Pole, AKBuilt 1952 · S/N 20639N2487GRegistration Pending · Aledo, TXRegistration pendingBuilt 1959 · S/N 51787N2487RCummings Sean · Lombard, ILBuilt 1964 · S/N 18255587N2487SMoody Bible Institute Of Chicago · Spokane Valley, WAS/N R18201344N2487UBaske Scott E · Hanna, INBuilt 1963 · S/N 17250087N2487YBradley Jeff C · Schertz, TXS/N 17249787N24884Bravo Victor LLC · Afton, WYFirst renewal noticeBuilt 1977 · S/N 15280431N24886Warrior II Ltd · Des Plaines, ILBuilt 1977 · S/N 15280432N24887Sunrise Aviation Inc · Ormond Beach, FLS/N 15280433N2488DStokes David R · Sleepy Hollow, ILBuilt 1952 · S/N 20640N2488GRumley Orville C · Minco, OKBuilt 1959 · S/N 51788N2488JMcdonald Nicholas W · Phoenix, AZBuilt 1966 · S/N 15065588
Back to AD 87-20-03 R2