OpenAirDocs.org
AD 87-20-03 R2

Registered aircraft · 54,017

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.

N4499LKilo Charlie LLC · Lenexa, KSBuilt 1966 · S/N 17254594N4499UMcmahon John P · Huntington Beach, CABuilt 1964 · S/N 15060499N449AGKershner Jordan · Malcolm, NEBuilt 1967 · S/N 17700344N449SFKyle Allyn B · Snohomish, WABuilt 1957 · S/N 50013N449VYKirkham Matthew · Cazenovia, WIBuilt 1973 · S/N 18262199N449WAEuroaviation Inc Trustee · KamatenS/N 18266773N44AGVanderpool Gary W · Alamo, TXBuilt 1966 · S/N 188-0138N44BLBoehr Greg J · Mc Cool Junction, NES/N 17256854N44CCoyne Greg · Hondo, TXBuilt 1979 · S/N P21000311N44CAWiley Commercial Property Consulting Inc · Aitkin, MNBuilt 1980 · S/N R18201556N44CCColumbia Club Aero LLC · East Wenatchee, WABuilt 1971 · S/N 18260646N44CFFly Low Aviation LLC · Smithville, MSS/N 21059764N44CUAirstar Aviation LLC · Manawa, WIBuilt 1976 · S/N 17268037N44DMGorge Winds Aviation Inc · Fairview, ORBuilt 1973 · S/N 17261488N44DRFiretextresponse LLC · Sumner, ILBuilt 1975 · S/N 18263596N44ECN44ec LLC · Caddo Mills, TXBuilt 1980 · S/N 21063972N44EEEchemann Thomas A · Sidney, OHBuilt 1979 · S/N 21063723N44FATemple Craig A · Fort Lauderdale, FLBuilt 1980 · S/N 20700659N44HRCardinal Aviation Services LLC · Castle Rock, COBuilt 1978 · S/N 21062685N44JFEureka E Solutions Inc · Austin, TXBuilt 1973 · S/N 18262579N44JGLiberty Industries LLC · Washington, DCBuilt 1965 · S/N 18256867N44KPHargrave Margarite D · Seattle, WABuilt 1978 · S/N 172-70904N44LBCadet Michel · Locust Grove, GABuilt 1966 · S/N 337-0561N44LKCessna Skyhawk LLC · Parker, COFirst renewal noticeBuilt 1979 · S/N 17273400N44LMDelpenn Flyers Inc · Dover, DEBuilt 1981 · S/N 18268030N44LUGresham Thomas H · Cascade, IDBuilt 1979 · S/N 18267355N44LWWilson Lorraine · Richmond, TXBuilt 1979 · S/N R1723106N44NTTucker Nicholas B · La Canada, CABuilt 1981 · S/N 21064531N44PForester Dwain E · Tonopah, NVBuilt 1961 · S/N 17248620N44RBAmj Air LLC · Holland, MIBuilt 1973 · S/N 18261829N44RCPeterson Matthew W · Ethel, LABuilt 1957 · S/N 29593N44RPCook Aviation Services LLC · Fargo, NDS/N 17250833N44STTakvorian Sevag · West New York, NJBuilt 1979 · S/N 17271609N44TBPacific Horizon LLC · Eagle, IDS/N 18267207N44TUOglesby John B · Graford, TXBuilt 1978 · S/N 18503616N44WBEvans Jerry R · York, PABuilt 1980 · S/N A1520909N44WHKelly Sean R · Bozeman, MTS/N 21061316N44XPFurnace Joel Ray · Golden, COBuilt 1977 · S/N R1722584N44XWMinnehan Land & Cattle · Joplin, MTS/N 18266990N4500BStartin Brandon Lee · Spokane, WABuilt 1955 · S/N 31399N4500CLynch Dana L · Fairbanks, AKBuilt 1953 · S/N 25443N4500KEaston Gregory D · Montrose, COBuilt 1978 · S/N P21000201N4500UButler Dale K · Hillsborough, NCBuilt 1964 · S/N 15060500N4501EOptima Aviation LLC DBA · Lewisville, TXS/N 17271614N4501UPruzek Russell T · New Auburn, WIBuilt 1964 · S/N 15060501N45023New Joel · Waco, TXBuilt 1975 · S/N 15076705N45028Witke Ray · Menomonie, WIBuilt 1975 · S/N 15076706N4502BAshcraft Dustin William · Anchorage, AKBuilt 1955 · S/N 31401N4502CMcfarland Keith A · Oklahoma City, OKBuilt 1952 · S/N 25445N4502NSchoonover Traci L · Weyerhaeuser, WIS/N 26500
Back to AD 87-20-03 R2