OpenAirDocs.org
AD 87-20-03 R2

Registered aircraft · 54,017

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.

N3439SProtsman Bryan D · Anchorage, AKBuilt 1964 · S/N 18255839N3439UFlycatcher Aviation LLC · Purcell, OKBuilt 1963 · S/N 18254839N343CEDeriso Jordan L · Arcadia, FLBuilt 1979 · S/N R18201144N34405Jj&R Aero LLC · Winchester, INBuilt 1972 · S/N 17701787N34407Registered aircraftS/N 17701788N3440DSimpson Don DBA · Bryan, TXBuilt 1955 · S/N 26983N3440JNoguess Michele R · Deming, NMBuilt 1967 · S/N 15066140N3440SLynch Chris A · Sedro Woolley, WABuilt 1964 · S/N 18255840N3440UPlane Joy LLC · Payson, AZBuilt 1963 · S/N 18254840N3440VBarrientos Jeri D · Collinsville, OKBuilt 1948 · S/N 7144N34411Jlh Aviation LLC · La Grange, TXBuilt 1972 · S/N 17701790N34413Mms Flight LLC · Shawnee, KSBuilt 1972 · S/N 17701791N3441FLawrence Kam M · Big Bear City, CABuilt 1966 · S/N 18257441N3441LBarlow Dwight D · Monte Vista, COBuilt 1966 · S/N U206-0741N3441RQualtieri John E · Fallon, NVS/N 18258741N3441SSun Technology LLC · Cheyenne, WYBuilt 1964 · S/N 18255841N3441UDemeyer Scott M · Olympia, WABuilt 1963 · S/N 18254841N3441YBird Avery L · Wasilla, AKBuilt 1968 · S/N 18051941N34420Berman John L · Corvallis, ORS/N 17701794N34426Cardinal 426 LLC · Jacksonville, FLBuilt 1976 · S/N 177RG0996N34427Cessna 177b Cardinal LLC · Prescott, AZBuilt 1972 · S/N 17701797N3442CClaire Aviation Inc · Wilmington, DEBuilt 1954 · S/N 26485N3442DLowery Chad Lewis · Palmer, AKBuilt 1955 · S/N 26985N3442EOwens John W Sr · Myrtle Beach, SCBuilt 1978 · S/N 17271548N3442SRail Birds · Clearfield, UTBuilt 1964 · S/N 18255842N3442VAdams Richard J · Mesa, AZBuilt 1948 · S/N 7146N34430Travland Christopher L · Austin, TXBuilt 1972 · S/N 17701798N34432Wallace James K · Rio Rancho, NMBuilt 1972 · S/N 17701799N34433Sowlemann Inc · Rockton, ILBuilt 1972 · S/N 17701800N3443CSale Reported · Mesa, AZSale reportedBuilt 1954 · S/N 26486N3443DMiller Charles T · Bynum, TXBuilt 1951 · S/N 20102N3443RBertrand John E · Trion, GABuilt 1967 · S/N 18258743N3443SWilliams Forest Chem LLC · Columbus, GABuilt 1964 · S/N 18255843N3443UHall George K · Cathedral City, CABuilt 1963 · S/N 18254843N3443VMenard Charles H · Burton, MIBuilt 1948 · S/N 7133N3443YTurner Nathan D · Nenana, AKBuilt 1968 · S/N 18051943N34442Valenti Alan · Bend, ORBuilt 1972 · S/N 17701805N34443Schwitters Jerry · Clara City, MNS/N 17701806N34444Lil Red Cardinal LLC · Phoenix, AZBuilt 1972 · S/N 17701807N34445East Carolina Aviation LLC · Camden, NCBuilt 1972 · S/N 17701808N34448Schleicher Conan A · Salem, ORBuilt 1972 · S/N 17701809N3444CRichards Chad M · North Pole, AKS/N 26487N3444DBaker Adam J · Eaton Rapids, MIS/N 26987N3444FAtwood David E Trustee · Nampa, IDBuilt 1966 · S/N 18257444N3444LDierick Greg E · Yakutat, AKS/N U206-0744N3444SBraha Thomas I · Mansfield, PABuilt 1964 · S/N 18255844N3444THunter David Frederick · Peachtree City, GABuilt 1968 · S/N 17700744N3444ULepton Films LLC · Tarzana, CABuilt 1963 · S/N 18254844N3444YParish John L Jr · Saint Louis, MOBuilt 1975 · S/N 18502879N34453Porcaro James · Latham, NYS/N 17701814
Back to AD 87-20-03 R2