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.

N9539BThree Rivers Limousine Service Inc · Pittsburgh, PABuilt 1981 · S/N 172RG0865N9539HNorthwest Flyers Inc · Marianna, FLBuilt 1981 · S/N 18267961N953ASA2g International LLC · San Juan Capo, CABuilt 1978 · S/N 33701872N953CCScruggs Ken · Plain City, OHBuilt 1975 · S/N 18264109N953HAEkstrom Benjamin G · Anchorage, AKBuilt 1950 · S/N 19444N953SASunrise Aviation Inc · Ormond Beach, FLBuilt 1980 · S/N 15283908N953SMBogen Alfred T · Brandon, MSBuilt 1980 · S/N 172RG0772N953STBoone Keith · Cabot, ARBuilt 1976 · S/N 21061155N95404Delta State University · Cleveland, MSBuilt 1984 · S/N 15285887N9540AAlder George A · Palmer, AKBuilt 1949 · S/N 19101N9540BFly8ma LLC · Big Lake, AKBuilt 1981 · S/N 172RG0866N9540GSchwend Brian · Forsyth, MTBuilt 1974 · S/N 18801520N9540LCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1986 · S/N 17276574N9540TChino Aviation Inc · Chino, CABuilt 1960 · S/N 57340N9540XWhitetop Air LLC · Wilmington, DEBuilt 1985 · S/N 18268550N9541BBodick John K · Anchorage, AKBuilt 1957 · S/N 32838N9541GAllen Charles Mark · Puryear, TNBuilt 1974 · S/N 18801521N9541TNevill John D · Tahoka, TXS/N 57341N95429Suburban Air Corp · Castro Valley, CABuilt 1984 · S/N 15285892N9542BSoileau Kenneth B · Lancaster, SCBuilt 1981 · S/N 172RG0867N9542HAbusham Hamed M · Upland, CABuilt 1975 · S/N 17266215N9542TLarsen Richard A · Wannaska, MNBuilt 1960 · S/N 57342N95431Kent State University · Stow, OHBuilt 1984 · S/N 15285893N95435Bird Acquisition LLC · Phoenix, AZFirst renewal noticeS/N 15285895N9543ABest Alvin A · Anchorage, AKRegistration revokedBuilt 1949 · S/N 19104N9543HGonzalez-Rio Jesus A · Big Pine Key, FLBuilt 1975 · S/N 17266216N9543XBarth Samuel · Fonda, NYS/N 21057843N95444Kent State University · Stow, OHBuilt 1984 · S/N 15285897N95445Kent State University · Stow, OHBuilt 1984 · S/N 15285898N9544ADaugherty Lee H · Charleston, WVRegistration revokedBuilt 1949 · S/N 19105N9544HSouthern Aero LLC · Homestead, FLBuilt 1975 · S/N 17266217N9544XB&B Aviation LLC · Arlington, WABuilt 1961 · S/N 21057844N9545AJetl Aviation LLC · Southern Pines, NCBuilt 1950 · S/N 19388N9545BSunrise Aero Inc · Ocala, FLBuilt 1981 · S/N 172RG0870N9545XRichardson Dana C · Okeechobee, FLBuilt 1961 · S/N 21057845N95469Kent State University · Stow, OHBuilt 1984 · S/N 15285899N9546AStevens Scott D · Corsicana, TXS/N 19107N9546GSale Reported · Emerson, IASale reported, canceledBuilt 1974 · S/N 18263402N9546HMiller Dale L · Bozeman, MTBuilt 1975 · S/N 17266219N9546TAerographics Inc · St Cloud, MNBuilt 1960 · S/N 57346N9546XN9546x LLC · Lakeville, MNBuilt 1986 · S/N 18268551N95474Kent State University · Stow, OHBuilt 1984 · S/N 15285901N95475Kent State University · Stow, OHBuilt 1984 · S/N 15285902N9547AChristiansen Brent D · Mabton, WABuilt 1949 · S/N 19108N9547LCivil Air Patrol · Maxwell Afb, ALBuilt 1986 · S/N 17276575N9547XCundiff Zackery A · Klamath Falls, ORBuilt 1962 · S/N 21057847N9548GMeyer Bros Ag LLC · Algona, IABuilt 1974 · S/N 18801526TN9548XMclenaghan Alvin · Phoenix, AZBuilt 1962 · S/N 21057848N95494Valiair Limited Co Trustee · Casper, WYS/N 18266558N9549GMacica Stephen J DBA · Truckee, CABuilt 1972 · S/N U20601749
Back to AD 87-20-03 R2