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.

N9153HSambriski Michael Daniel III · Long Beach, NYBuilt 1975 · S/N 17265978N91541Engelen Patrick J · Rosamond, CABuilt 1969 · S/N 18259811N91546Delta Charlie LLC · Meridian, IDBuilt 1969 · S/N 18259812N9154MUpupnaway LLC · Concord, NCBuilt 1976 · S/N 18264705N9154TLethal Aviation LLC · Kalispell, MTS/N 50654N91552Reese Ken W · Pewaukee, WIBuilt 1969 · S/N 18259813N91553Simpson Josiah J L Trustee · Shelburne, MABuilt 1973 · S/N 17261500N91557Aero Safe Corporation · Mineral Wells, TXBuilt 1969 · S/N 18259817N91558Cole Christopher W · Bothell, WABuilt 1969 · S/N 18259818N9155AMaki Kevin L · Saginaw, MNBuilt 1950 · S/N 19354N9155CN9155c LLC · Palm Harbor, FLBuilt 1978 · S/N R18200427N9155MMain Line Flying Association Inc · Blue Bell, PABuilt 1976 · S/N 18264706N91564Siudzinski David · Tuolumne, CABuilt 1969 · S/N 18259819N91568Rasmussen Air LLC · Washington, UTBuilt 1969 · S/N 18259821N9156AStokes Jay M · Kingsland, TXBuilt 1949 · S/N 18917N9156BRegistration Pending · Cheyenne, WYRegistration pendingBuilt 1958 · S/N 36756N9156HSolar Flying Club · Grimes, IABuilt 1975 · S/N 17265981N9156MJolliff Richard · Brady, TXBuilt 1976 · S/N 18264707N9156NBurdick Kenneth M · Swansea, MABuilt 1956 · S/N 28648N9156UHangar6 Aviation LLC · Apex, NCBuilt 1976 · S/N 15078107N91574Capps Edward F · Chaparral, NMBuilt 1969 · S/N 18259823N91576Reeves James Matthew · Corpus Christi, TXBuilt 1969 · S/N 18259825N91579Valentine Jimmie Lloyd Sr · Gulfport, MSBuilt 1969 · S/N 18259826N9157BMighells Conrad E · Randolph, NYFirst renewal noticeBuilt 1958 · S/N 36757N9157CAims Community College · Greeley, COBuilt 1978 · S/N R18200429N9157RHolmes Ronald W · Kent, ORBuilt 1975 · S/N 18802135TN9157URoss Stephen D · Greenfield, OHS/N 15078108N91589Whittles John L · Higganum, CTFirst renewal noticeBuilt 1969 · S/N 18259829N9158CSmith Robert A · Stillwater, OKBuilt 1978 · S/N R18200430N9158HParrish Aviation Flight Academy LLC · Southlake, TXBuilt 1975 · S/N 17265982N9158MScott Richard A · Liberty Lake, WABuilt 1970 · S/N U20601558N9158XSutton Randall D · Rexburg, IDBuilt 1961 · S/N 18253558N91592Sawatzky John E · Oakley, CAS/N 18259832N91596West Michigan Flying Club Inc · Norton Shores, MIBuilt 1973 · S/N 17261505N9159HHess Garrett · Fullerton, CAS/N 17265983N9159UHac Plane LLC · Sugar Land, TXBuilt 1976 · S/N 15078110N915AAHoecher Robert T · Anchorage, AKFirst renewal noticeBuilt 1977 · S/N 15280359N915CHLegacy Aire LLC · Kennesaw, GABuilt 1977 · S/N 18266153N915CMVaayu Aviation LLC · Newark, CABuilt 1972 · S/N 17261229N915LCardinal Flying Corp · San Jose, CABuilt 1976 · S/N 17267355N915NGWillard Theron K · Anchorage, AKBuilt 1975 · S/N U20602946N915SCI P M Ministries · Dufur, ORBuilt 1954 · S/N 26131N915SPThin Air LLC · Hillsboro, WIBuilt 1969 · S/N 18259816N915WBBordelon Warren P · Breaux Bridge, LABuilt 1972 · S/N 17261221N915XKSk Aircraft LLC · Anchorage, AKBuilt 1958 · S/N 51506N91602Kreikemeier Michael L · Belgrade, MTBuilt 1969 · S/N 18259838N91604Veeref LLC · Temecula, CAS/N 18259840N91606Zoltak Aviation LLC · Perry, GABuilt 1969 · S/N 18259841N91607Parreira Paul Jr · Dos Palos, CABuilt 1969 · S/N 18259842N9160AAttitude Toys LLC · Wilmington, DEBuilt 1949 · S/N 18921
Back to AD 87-20-03 R2