OpenAirDocs.org
AD 87-21-02 R1

Registered aircraft · 3,960

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-21-02-R1')
    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-21-02-R1')
  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.

N3041TSouthern Oregon Skyways Inc · Medford, ORBuilt 1964 · S/N 320C0041N3042LMsl Holdings · Newbury Park, CABuilt 1965 · S/N 310J0042N3042TKls Enterprises Inc · Cave Creek, AZBuilt 1964 · S/N 320C0042N3043TJwt Aviation LLC · Yancey, TXBuilt 1964 · S/N 320C0043N3048LLuster Maurice A Jr · Miami Beach, FLS/N 310J0048N304JWVega Air LLC · Pigeon Forge, TNS/N 340A-1250N304MCValiair Lc Trustee · Casper, WYS/N 421B0130N3050LMadison Mitchell · Guthrie, OKBuilt 1965 · S/N 310J0050N3050TLand T Chat · Tulsa, OKBuilt 1964 · S/N 320C0050N3051TPacific Arts Collection LLC · Oakland, CAS/N 320C0051N3055TTechnical Education Services · Virginia Beach, VABuilt 1965 · S/N 320C0055N3056LFowler Larry K · Harrison, ARBuilt 1965 · S/N 310J0056N3068LMirage Air Ltd · Wilmington, DENon-citizen corporation, flight hours not reportedS/N 310J0068N306PMBc 414 LLC · Vineyard Haven, MABuilt 1979 · S/N 414A0419N306TBApex Aviation Holding LLC · Kalispell, MTBuilt 1982 · S/N 340A1537N3070LClark Kenneth N · Tempe, AZBuilt 1965 · S/N 310J0070N3071LDishburger Samuel T · Westfield, INBuilt 1965 · S/N 310J0071N3073LSheakley John W DBA · Meadville, PABuilt 1965 · S/N 310J0073N3075LAlvis Michael E · Parkton, NCS/N 310J0075N3079LTff Inc · Parma, MIBuilt 1965 · S/N 310J0079N307FMNorris Aviation LLC · Mansfield, TXBuilt 1977 · S/N 421C-0323N3083LPrice Randy L · Pahrump, NVS/N 310J0083N3088LRice James M · Austin, TXS/N 310J0088N308CFBaba Kenneth D · Sierra Vista, AZBuilt 1973 · S/N 310Q0804N3091LAbbasi Babak · Murrieta, CABuilt 1965 · S/N 310J0091N30DTShelton Sharon Shay · Abilene, TXS/N 414-0910N30EEEnterprises Aviation Inc · Piedmont, SDBuilt 1979 · S/N 414A0443N30ETZaldivar Carlos · Miami, FLBuilt 1971 · S/N 310Q0266N30FBBmg Aviation Leasing LLC · Bloomington, INBuilt 1978 · S/N 414A0067N30HBN30hb LLC · North Miami, FLS/N 340-0786N30HCKinetic Concepts LLC · Pensacola, FLS/N 310Q1079N30LPDialysis Clinic Inc · Nashville, TNBuilt 1977 · S/N 310R0995N30LTJuans Adios LLC · Newark, DES/N 421C0290N30PTGas Aviation LLC · Decatur, TNBuilt 1976 · S/N 421C0157N30RWSaltzy Seas LLC · Loxahatchee, FLBuilt 1976 · S/N 310R0667N30SSN30ss LLC · Dover, DEBuilt 1973 · S/N 414-0451N30TAero Quest LLC · Olive Branch, MSBuilt 1962 · S/N 310G-0031N3101TMission Air LLC · Charlotte, NCS/N 310R1877N310ACJulie Dorst LLC · Kalispell, MTBuilt 1975 · S/N 310R0290N310ADChang Stephen · Santa Barbara, CABuilt 1976 · S/N 310R0538N310AFSelwa Michael A · Oconomowoc, WIBuilt 1974 · S/N 310Q1121N310AHGraydon Bilal R · Melbourne, FLBuilt 1979 · S/N 310R1660N310AJPj Aviation Holding LLC Trustee · Eden Prairie, MNBuilt 1980 · S/N 310R1606N310AMCwr Enterprises Inc · Henderson, NCBuilt 1979 · S/N 310R1672N310ARHales Gutter Guys LLC · Cottonwood, AZS/N 310R1387N310ATBelknap Scott M · Temecula, CABuilt 1965 · S/N 310J0097N310AWBetty Eric · Old Hickory, TNBuilt 1969 · S/N 310P0231N310BARampey Alvin H Jr · Atlanta, GABuilt 1975 · S/N 310R0065N310BBF & F Aviation LLC · Memphis, TNS/N 310R1858N310BDSale Reported · Fort Wayne, INSale reportedBuilt 1965 · S/N 310J0013
Back to AD 87-21-02 R1