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.

N2999CCarnine Daniel L · Seeley Lake, MTBuilt 1954 · S/N 30899N2999DRegistered aircraftBuilt 1955 · S/N 26942N2999SZheng Zheng · Walnut, CABuilt 1967 · S/N 15066899N2999URichmor Aviation Inc · Hudson, NYBuilt 1963 · S/N 17250599N2999XPoore Zack W · Mcdonald, KSBuilt 1967 · S/N 17700399N299MPayne Michael Allen · Montgomery, TXBuilt 1974 · S/N 17702216N299MWAbramovich Michael Pavel · Scottsdale, AZBuilt 1960 · S/N 15059071N299PTWright W Gregory III · Kinsale, VABuilt 1969 · S/N 18259631N299RQRds Aviation LLC · Powder Springs, GABuilt 1977 · S/N 177RG1167N29BCD' Jm Holdings LLC · Sugar Land, TXBuilt 1974 · S/N P3370172N29CMChenango 11 LLC · Wilmington, DEBuilt 1976 · S/N 18264793N29ERCosta Air Service LLC · Painted Post, NYBuilt 1977 · S/N 17269532N29FCUsda Forest Service Fepp · Raleigh, NCBuilt 1968 · S/N U206-1191N29FLTorres Chris · Princeton, CABuilt 1968 · S/N 18258813N29HLSchreiber Christopher · Foley, ALBuilt 1975 · S/N 17266262N29JFJkg LLC · Murfreesboro, TNBuilt 1968 · S/N 18259450N29KMDebonair Consulting Inc · Wilmington, DEBuilt 1955 · S/N 31579N29LKGibbons David · Holmen, WIS/N 177RG0736N29MXPeterson Jim · Bedford, WYBuilt 1975 · S/N 17266309N29NDDamstetter Katherine M · Hudson, FLS/N 15066888N29PCFisher Douglas C · Mountain View, CABuilt 1979 · S/N 18266929N29PMAlly Mohamed Yacoob · Fort Lauderdale, FLS/N U20605769N29SRAviation USA LLC · Anchorage, AKBuilt 1978 · S/N 18503582N2AJBlair Aviation LLC · Swamp Branch, KYFirst renewal noticeBuilt 1981 · S/N R18201789N2AWSpacecrafters Inc · Silver Springs, FLBuilt 1971 · S/N 17701692N2BFMs Aero Inc · Lakeville, OHBuilt 1968 · S/N 15068499N2BPMiami Clipper Aviation LLC · Cutler Bay, FLBuilt 1972 · S/N 17701783N2CNCassel Paul E · Hernando, MSS/N 18052848N2CWMiller Steven D · Mccall, IDS/N 18502486N2DMWiley Post LLC · Lewes, DEBuilt 1970 · S/N 21059305N2EBCampbell Bernard D · Morehouse, MOBuilt 1971 · S/N 18260609N2FNFlying Neutrons LLC · Lebanon, OHBuilt 1977 · S/N 17269910N2GAWilson Frank C · Irondale, OHBuilt 1974 · S/N 18502376N2GHAbel Robert G · Williamstown, MABuilt 1963 · S/N 2050369N2HABrunner Robert L · Jefferson, ORBuilt 1975 · S/N 17265382N2HUN2hu LLC · Parker, COS/N R18200447N2JHReign Air Charter Corp · New Port Richey, FLBuilt 1964 · S/N 17252443N2JKGoldberg Leonard J · Westbrook, CTBuilt 1977 · S/N 18265546N2KDElliott Frank F · Mojave, CAFirst renewal noticeBuilt 1969 · S/N T210-0436N2KFLivingston H Clark · Akron, ALBuilt 1968 · S/N 17700997N2KGLowe Samuel S III · Mary Esther, FLBuilt 1974 · S/N 17702073N2MSLemmon William Michael · N Richland Hills, TXBuilt 1978 · S/N 152-82011N2NMMayberry Harold M · Bryant, ILBuilt 1949 · S/N 18831N2PJMorgan Bryan K · Sacramento, CABuilt 1969 · S/N 337-1161N2QDSpectraq · Las Vegas, NVS/N P3370277N2QFAbel Elliot A · Terre Haute, INBuilt 1977 · S/N P3370280N2QKPax Air LLC · Minden, NVS/N P3370283N2QMNorth Casade Air Transport LLC · Manson, WABuilt 1977 · S/N P3370290N2QPNoess Michael A · Shakopee, MNBuilt 1977 · S/N P3370291N2RXJbs Enterprises LLC · Hamilton, MTS/N P21000030
Back to AD 87-20-03 R2