OpenAirDocs.org
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.

N8287QAdventist World Aviation · Wilson, NCBuilt 1976 · S/N U20603148N8287XMckeever Jesse M · Indio, CABuilt 1961 · S/N 17248787N8287ZMillion John B · Westminster, MDBuilt 1963 · S/N 205-0287N8288EGomez Cierra D · Jasper, ALS/N 17272174N8288GFord Flying Service Inc · Doerun, GABuilt 1973 · S/N 18801287N8288MAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1970 · S/N 21059288N8288SWatters Reid W · Tilleda, WIBuilt 1965 · S/N 15061888N8288TDooley Kenneth J · Charleston, TNBuilt 1961 · S/N 17556988N8288XLantana Beach Flying Club · West Palm Beach, FLBuilt 1961 · S/N 17248788N8289BGodfrey Brian T · Waupaca, WIBuilt 1957 · S/N 36089N8289FDe Cristo Andre G · Flushing, NYBuilt 1966 · S/N 15064389N8289GDutcher Kenneth J · Kingsland, TXS/N 177RG0189N8289LFaust Stanley J · Nashua, NHBuilt 1967 · S/N 17256489N8289UPrice William B · Lamar, SCBuilt 1964 · S/N 17252189N828BCFitzdam Justin D · Franklin, TNBuilt 1979 · S/N R18200975N828JTAtems Elisabeth · Northfield, VTBuilt 1976 · S/N 177RG0945N828LFFinseth Loren V Trustee · Fountain, MNBuilt 1977 · S/N 18265438N828PBAero Missions LLC · Zeeland, MIBuilt 1977 · S/N 18265926N828RHMad Kav Properties LLC · Corona, CABuilt 1979 · S/N 18267467N828RJNielsen Ron E · Lindon, UTS/N 21063836N828TATravelaire Service Inc · Wilmington, DEBuilt 1973 · S/N 18502245N828YLong Island Aviators LLC · Seaford, NYBuilt 1976 · S/N 17268168N8290BSchooman Clarence G · Marion, TXBuilt 1957 · S/N 36090N8290LPretty Plane LLC · Nixa, MOBuilt 1967 · S/N 17256490N8290SNewsome Jeff · Blackwell, OKBuilt 1965 · S/N 15061890N8291AScott William M · Spring Hill, FLBuilt 1952 · S/N 25143N8291ERangers Flying Club Inc · Eden Prairie, MNBuilt 1979 · S/N 17272177N8291GBullock Brooks M II · Cartersville, GABuilt 1971 · S/N 177RG0191N8291LUsglap LLC · Fort Morgan, COBuilt 1967 · S/N 17256491N8291MElbs Aviation LLC · Pell City, ALBuilt 1976 · S/N 18264581N8291SSipes Jacob L · Sunbury, OHBuilt 1965 · S/N 15061891N8291TKnight James M · Wilton, CABuilt 1961 · S/N 17556991N8291UBarnett William M · Rolla, MOBuilt 1964 · S/N 17252191N8291XChandler Christopher G · Cooperstown, NYS/N 17248791N8292ADeforest Dennis L · Hamilton, INBuilt 1952 · S/N 25144N8292BEagle Eye Aerial Imaging LLC · Chagrin Falls, OHS/N 36092N8292EP&N Corp · Marion, IAS/N 17272178N8292LBrown Troy M · Austin, TXBuilt 1967 · S/N 17256492N8292MAircraft Guaranty Corp Trustee · Oklahoma City, OKS/N 21059292N8292QFitzgerald John A Jr · Ester, AKS/N 18503643N8292SStephens Ralph W · Reno, NVBuilt 1964 · S/N 18255792N8292URettkowski Brady A · Hermiston, ORBuilt 1964 · S/N 17252192N8292XHeadings Daniel E · Salem, ORBuilt 1961 · S/N 17248792N8292ZBenedick Yachal O · Wilsey, KSBuilt 1963 · S/N 205-0292N8293AMcgreevy Stephen P · Poplar Grove, ILBuilt 1952 · S/N 25145N8293EFiorini Anthony Wayne · Tuttle, OKBuilt 1979 · S/N 17272179N8293QBaker Marianne J · Raeford, NCBuilt 1976 · S/N U20603154N8293RPanterra Aviation LLC · Mountain Green, UTBuilt 1979 · S/N R18200933N8293TNational Refining Co · Owosso, MIBuilt 1962 · S/N 17556993N8293ZAv8r Aviation LLC · Yakima, WABuilt 1963 · S/N 205-0293
Back to AD 87-20-03 R2