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.

N8YQHartlieb Gordon Wesley · Anchorage, AKBuilt 1972 · S/N 17701718N9000UWhitaker Robbie L · Brooklet, GABuilt 1976 · S/N 15078050N9000XAbidance Inc · Winthrop, WAS/N 18253400N9001MWetzel Tarek C · Chugiak, AKBuilt 1969 · S/N 18052101N9002CDutcher Arthur B · Redwood City, CABuilt 1954 · S/N 31050N9002EWisconsin Aviation Inc · Watertown, WIBuilt 1979 · S/N 17272214N9002HAngel Aviation Inc · Peoria, AZBuilt 1975 · S/N 17265892N9002RSmith Terry L · Atoka, TNS/N 28597N9003EBermuda Dunes Flight Training LLC · Palm Desert, CABuilt 1979 · S/N 17272215N9003XPaselk Stuart · Winchester, ORS/N 18253403N90045Kuzma Steven L · Eugene, ORS/N 56603N9004AStuckert Robert D · Scottdale, PABuilt 1949 · S/N 18759N9004RHarper Edward A · Pleasant Plain, OHS/N 15076428N9004XMay James P · Huntington, WVBuilt 1961 · S/N 18253404N90052Laz Stanley R · Snohomish, WABuilt 1977 · S/N 177RG1140N9005AFerraro Donald M · Bangor, PABuilt 1949 · S/N 18894N9005CAirxl Inc · Billings, MTBuilt 1954 · S/N 31053N9005HBuffalo Aviation LLC · Royal, NEBuilt 1975 · S/N 17265894N9005MBuford David C · Bonaparte, IABuilt 1976 · S/N 18264639N9005UPea Patch Flying Club Inc · Girard, OHBuilt 1976 · S/N 15078051N9006CMillionista Investment Hub LLC · Boca Raton, FLS/N 31054N9006GAltomari Richard J · Pittsburgh, PABuilt 1970 · S/N 18260546N9006MHolliday Dean Trustee Et Al · Klamath Falls, ORBuilt 1976 · S/N 18264640N9007AWeiszmann Erik · Bedford, NHBuilt 1949 · S/N 18762N9007GKem Air Enterprises LLC · Kalispell, MTBuilt 1970 · S/N 18260547N9007JMalcolm Douglas B · Shell Beach, CABuilt 1967 · S/N 337-0729N9007MKirkman Robert Nolan · Pilot Mountain, NCBuilt 1969 · S/N 18052107N9007RWill Michael · Mukilteo, WABuilt 1978 · S/N R18200656N9007XGustafson Stephen M · Tallulah, LABuilt 1961 · S/N 18253407N9008CFogleman Brian L · Stonewall, LABuilt 1954 · S/N 31056N9008MWhaley Steven Todd · De Leon Springs, FLBuilt 1969 · S/N 18052108N9009CKyer Barry Patrick · Honey Grove, TXBuilt 1954 · S/N 31057N9009HConnell Flying Service Inc · Decorah, IABuilt 1975 · S/N 17265897N9009TNelson Landon E · Monument, COBuilt 1960 · S/N 52909N9009XChick Theodore D DBA · Beulah, NDS/N 18253409N900AGFriedman & Friedman Ltd · Chicago, ILBuilt 1981 · S/N P21000607N900DFWaters Aero-Marine Inc · South Thomaston, MEBuilt 1973 · S/N 20700234N900EDSpradling James · Fremont, OHBuilt 1969 · S/N 18259731N900JBPumpkin Eater LLC · Tavares, FLBuilt 1980 · S/N 18504188N900MPSweet Fred A · Loves Park, ILBuilt 1981 · S/N 18268093N900RPCobra Aviation Services LLC · San Angelo, TXBuilt 1978 · S/N 18266414N900RSInmon Leon C · Williston, FLS/N 17248585N900RTTakle Raymond L · Hudson, WIBuilt 1979 · S/N R1723160N900SCCordle Christopher T · Howard, OHBuilt 1964 · S/N 17251349N9010MCrotts Aircraft Service Inc · Dodge City, KSBuilt 1976 · S/N 18264641N9011Kro Bros LLC · Lebanon, OHBuilt 1973 · S/N 18261966N9011AWilmsen Paul R · Millington, ILBuilt 1949 · S/N 18766N9011XCowan James H · New Springfield, OHS/N 18253411N9012CClark Gloria L Trustee · Gillette, WYBuilt 1954 · S/N 31060N9012GCockrell Carroll G · Mount Sterling, KYBuilt 1970 · S/N 18260552
Back to AD 87-20-03 R2