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.

N9723HFlying Tigers Flight School LLC · Houston, TXBuilt 1975 · S/N 17266336N9723TLuinstra Lee Vernon · Benton, KSBuilt 1960 · S/N 47523N9723XThornton James P · Amesbury, MABuilt 1962 · S/N 21058023N97240N97240 LLC · Amherst, MABuilt 1979 · S/N 18267030N97246Duggins Robert W · Van Nuys, CAS/N 18267034N97257Moser Keith W · Huntington, INBuilt 1979 · S/N 18267037N9725GMathis Isaac Thomas · Fletcher, NCBuilt 1971 · S/N 18052225N9725QWings Over Texas Holdings LLC · Denton, TXBuilt 1975 · S/N 17265787N9725RLongitude 150 LLC · Anchorage, AKBuilt 1986 · S/N U20606950N9725TAnderas Per R · Green Bay, WIS/N 47525N9725VAnderson Aerial Spraying Service Inc · Canby, MNBuilt 1966 · S/N 188-0175N9725XNewling Galen J · Bremerton, WABuilt 1962 · S/N 21058025N97266East Hill Flying Club · Ithaca, NYBuilt 1984 · S/N 17276169N97269J&L Aviation LLC · Malta, NYBuilt 1984 · S/N 17276170N9726GIrc Holdings Ltd · Allentown, PABuilt 1971 · S/N 18052226N9726TBuettner Casey R · Kearney, NES/N 47526N9727ACaughlin David Drew · Boise, IDBuilt 1950 · S/N 19404N9727GInternational Air Services Inc Trustee · Carson City, NVBuilt 1971 · S/N 18052227N9727TRogers Bob · Mountain Green, UTBuilt 1960 · S/N 47527N9727VDills John H · Ione, WABuilt 1974 · S/N 17264492N97281Wackerli Steve B · Idaho Falls, IDFirst renewal noticeBuilt 1979 · S/N 18267041N97282Jav Air Services LLC · Anchorage, AKBuilt 1979 · S/N 18267042N97288Bolle Aviation LLC · Clare, MIBuilt 1979 · S/N 18267044N9728ADailey Brian A · Strongsville, OHBuilt 1950 · S/N 19405N9728BLowery Janell D · Anchorage, AKBuilt 1957 · S/N 50026N9728MGrant Aviation Inc · Anchorage, AKBuilt 1981 · S/N 20700721N9728TBanks Trevor A · Thomaston, GABuilt 1960 · S/N 47528N97295J-Air LLC · Guthrie, OKBuilt 1979 · S/N 18267047N97298Roberts And Connell Llp · San Luis Obispo, CABuilt 1979 · S/N 18267048N9729ABaker Benjamin D · Catasauqua, PABuilt 1949 · S/N 19190N9729BAnderson Benjamin T · Havre De Grace, MDBuilt 1957 · S/N 50027N9729GBurch Gerald T · Lake Charles, LABuilt 1971 · S/N 18052229N9729TGibbs David F · Greenville, NCBuilt 1960 · S/N 47529N972DPCrosswind Aviation Of Oklahoma LLC · Stillwater, OKBuilt 1969 · S/N 17258652N972FCBlackhawk Holding Corp · Wilmington, DEBuilt 1979 · S/N 17272682N972LLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1967 · S/N U2060705N972MAAir Repair Inc · Easton, MDBuilt 1967 · S/N 15067551N972NCIal Corp · Lewes, DEBuilt 1971 · S/N 17259818N972PMNp Aviation Inc · Naguabo, PRS/N 17264940N97300Jaeger Kurt · Bermuda Dunes, CABuilt 1979 · S/N 18267050N97309Afana Lawrence L Jr · Phoenix, AZS/N 18267054N9730GMcginty Flying Service LLC · Jones, LAS/N 18052230N9730VWings Over Texas Holdings LLC · Denton, TXBuilt 1974 · S/N 17264494N9730XHaase Herman · Stockton, CABuilt 1962 · S/N 21058030N97311Christiansen Aviation LLC · Wilmington, DEBuilt 1984 · S/N 17276176N97313Civil Air Patrol Inc · Maxwell Afb, ALBuilt 1984 · S/N 17276177N9731ANorbury Frank R · Scottsdale, AZBuilt 1949 · S/N 19192N9731HCreative Strategies Inc · Proctorville, OHS/N 17266339N9731TKarren Robert E · Mountain Home, IDS/N 47531N9731XPoe David A · Big Sandy, TXBuilt 1962 · S/N 21058031
Back to AD 87-20-03 R2