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.

N9476TRegistered aircraftSale reportedBuilt 1960 · S/N 57276N9476USantos Enderson Rafael Teixeira Dos · Aledo, TXBuilt 1976 · S/N 15078424N9476XMcdonald Air LLC · Indianapolis, INBuilt 1985 · S/N 18268536N94772Kamal Rafi · Mountain View, CABuilt 1978 · S/N 18266507N9477BMilson Stuart A · Midlothian, TXBuilt 1958 · S/N 55277N9477LSlipstream Aviation LLC · Carrollton, GABuilt 1986 · S/N 17276562N9477URegistration Pending · Delta Junction, AKRegistration pendingBuilt 1976 · S/N 15078425N9478EColeman Richard · Menominee, MIS/N 17272276N9478GExecutive Security Solutions LLC · Moody, ALBuilt 1974 · S/N 18263397N9478T4cl Inc · Wilmington, DEBuilt 1960 · S/N 57278N94790Kingsky Flight Academy LLC · Lakeland, FLS/N 15285788N9479GCox Ramona T · Manhattan Beach, CABuilt 1971 · S/N U20601679N947ETGranite State Aerial Topography LLC · Wolfeboro, NHBuilt 1973 · S/N U20602271N947SFSnohomish Flying Service Inc · Snohomish, WABuilt 1983 · S/N 15285770N94800Trick Aviation LLC · Kalispell, MTBuilt 1978 · S/N 18266512N9480BAlexis Aviation LLC · Greenwell Springs, LABuilt 1958 · S/N 55280N9480DKent State University · Stow, OHBuilt 1985 · S/N 172RG1180N9480EMoyer Aviation Inc · Tobyhanna, PABuilt 1979 · S/N 17272277N9480HMoynihan Patrick J · Lakeville, MNBuilt 1975 · S/N 17266173N9480RWestern Montana Orthopaedic LLC · Missoula, MTS/N R18200708N9480UColeman Stephen A · Wakefield, RIBuilt 1976 · S/N 15078428N94810Kaski Brian · Battle Ground, WABuilt 1978 · S/N 18266515N94812James Hamilton Construction Co · Silver City, NMS/N 18266517N9481BPueppke Clinton · Ayr, NDBuilt 1958 · S/N 55281N9481CWhitby Christopher W · Prescott, AZBuilt 1955 · S/N 31879N9481DBoemig Madison K · Dalton, NHBuilt 1985 · S/N 172RG1181N9481UParnell Jr Jerry · Panama City, FLBuilt 1976 · S/N 15078429N9481X2310 Woodcrest LLC · Freeland, PABuilt 1961 · S/N 21057781N94822Elon Aviation LLC · Burlington, NCBuilt 1983 · S/N 15285795N9482MWestwind Aviation Inc · Phoenix, AZBuilt 1981 · S/N 20700698N9482RWindy Lane Farms Transport LLC · Mulberry, INBuilt 1975 · S/N 18802292TN9482UClark Josh D · Morehead, KYBuilt 1976 · S/N 15078430N94837Leyser Joshua F C · Tega Cay, SCS/N 18266521N9483HDelbrocco Christopher A · Waitsfield, VTBuilt 1981 · S/N 18267955N9483YSioux Falls Technology LLC · Sioux Falls, SDBuilt 1981 · S/N 21064520N9484CKnowles Jayson C · Winter Harbor, MEBuilt 1955 · S/N 31882N9484HN9484h LLC · Wheeling, ILBuilt 1975 · S/N 17266175N9484XD&J Air Adventures Inc · Koloa, HIBuilt 1985 · S/N 18268537N94853Middle Georgia Aviation Services LLC · Warner Robins, GABuilt 1978 · S/N 18266523N94854Sutliff John K · Walla Walla, WAS/N 18266524N9485BLuggar Michael D · Leonard, MNFirst renewal noticeBuilt 1958 · S/N 55285N9485RStevenson Flying Service LLC · Selden, KSBuilt 1975 · S/N 18802294TN9485XBruckman Monty D · Edgewood, NMBuilt 1961 · S/N 21057785N9486BMccoy Robert P · Fairbanks, AKBuilt 1981 · S/N 172RG0837N9486GAndrew Odean T · Willow, AKBuilt 1971 · S/N U20601686N9486HStegehuis Richard L · Helenville, WIBuilt 1981 · S/N 18267957N9486RAnderson Aerial Spraying Serv Inc · Canby, MNBuilt 1975 · S/N 18802295TN9486XSchilling Aviation Services LLC · Salina, KSBuilt 1961 · S/N 21057786N94872Weber Brian T · Hastings, MNBuilt 1978 · S/N 18266527N9487BFord Christian G · Pasco, WAS/N 55287
Back to AD 87-20-03 R2