OpenAirDocs.org
AD 87-20-03 R2

Registered aircraft · 54,019

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.

N22276Ramsey Lenny J · Greeneville, TNBuilt 1968 · S/N 15068185N22277Gage Rodney L · Oak Grove, ARS/N 15068186N2227YAdam Lewis W · Chiefland, FLBuilt 1967 · S/N 17700027N22284Fenton Ted P · Rushville, MOS/N 15068191N22285Barlow Richard B · Stockbridge, GABuilt 1968 · S/N 15068192N2228GHalo Halo LLC · Milwaukie, ORS/N 51528N2228SHannaford Edward M · Roseville, MIBuilt 1976 · S/N 21061173N22297Trissell Flying Service Inc. · Clarksville, TXBuilt 1968 · S/N 15068199N2229CYleski LLC · Bozeman, MTBuilt 1953 · S/N 30529N2229DN2229d LLC · Wilmington, OHBuilt 1952 · S/N 20381N2229ESix Pack Aviation LLC · Pocono Pines, PABuilt 1978 · S/N 17271193N2229SKey Lime Consultants LLC · Wilmington, DEBuilt 1976 · S/N 21061174N2229XByers Gary F · Wasilla, AKBuilt 1969 · S/N 185-1509N222AKChambers Samuel S · Salmon, IDBuilt 1953 · S/N 30097N222ATSierra 1 Tech Inc · Blue Jay, CABuilt 1968 · S/N 21059098N222BKDeralex Airways LLC · Miami, FLS/N 17272887N222BVBb Air LLC · Chesapeake, VABuilt 1975 · S/N 17264997N222CTMorency Richard · Houston, TXBuilt 1974 · S/N 18263068N222ERGjg Air LLC · Amarillo, TXBuilt 1975 · S/N 18263978N222ETValiair Lc Trustee · Casper, WYBuilt 1981 · S/N P21000626N222FDKent State University · Stow, OHBuilt 1968 · S/N 15068498N222FFReagan John · Knippa, TXS/N 18253725N222HERound Engine Aero · Nashville, MIBuilt 1978 · S/N 17271191N222HPHarrison Walter E · Taylor, TXBuilt 1982 · S/N R18201881N222JHRegistered aircraftBuilt 1974 · S/N 18263066N222LJDodson International Parts Inc · Rantoul, KSBuilt 1977 · S/N 33701764N222LSLj Bickford Companies LLC · Wasilla, AKBuilt 1972 · S/N U206-01751N222MHJones Jimmy N · Bremond, TXBuilt 1972 · S/N U20601931N222NYCivil Air Patrol · Maxwell Afb, ALBuilt 1985 · S/N 17276473N222PAFrank Eric A · East Troy, WIBuilt 1976 · S/N 15078669N222PFStokes Brian L · Boulder City, NVBuilt 1979 · S/N R18201308N222PXRegistered aircraftBuilt 1976 · S/N 18265157N222QLindeen Karen D · Anchorage, AKS/N 18257622N222QAKlopotek Jerome P · Orangevale, CABuilt 1969 · S/N 15070543N222SADenny Robert C · Fort Myers, FLS/N 15078576N222SBFuglestad Jon T · Anchorage, AKBuilt 1953 · S/N 30360N222SGPacific Aviation Aircraft Management Inc · Fresno, CAS/N 210-64410N222SJTriple Deuce LLC · Harrisonville, MOBuilt 1972 · S/N 21059732N222TADeschene Michael R · Westminster, CABuilt 1968 · S/N 15069729N222TKMachowicz Mark M · Eastpointe, MIBuilt 1967 · S/N 18257973N222TXJ M Williams LLC · Stockton, CABuilt 1957 · S/N 29976N222USTicoair LLC · Wilmington, DEBuilt 1979 · S/N 17273491N222WAWiseman Aviation Inc · Flagstaff, AZS/N R18201443N222WFBailey Steve · Chehalis, WABuilt 1963 · S/N 205-0220N222WKSchellhorn Friedrick · Harxheim/MainzS/N 337-0696N222WTLopes Jeremy B · Peoria, AZBuilt 1952 · S/N 20372N222XLFox Jeffery R · Spooner, WIBuilt 1981 · S/N 18504278N22304Berry Dewey R · Lexington, SCBuilt 1968 · S/N 15068204N22305Arend James E · Mesa, AZS/N 15068205N22307Martin David O · West Mifflin, PABuilt 1968 · S/N 15068207
Back to AD 87-20-03 R2