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.

N3194DMatthews James B · Wills Point, TXBuilt 1955 · S/N 31992N3194YSchexnayder Jennifer · New Roads, LABuilt 1962 · S/N 18254194N3195AHoward Neil B · Gorin, MOBuilt 1953 · S/N 25839N3195DRegistration Pending · Fort Mohave, AZRegistration pendingBuilt 1955 · S/N 31993N3195ECatlett John W · Briggsville, ARBuilt 1982 · S/N 18268238N3195RPalmer Matthew B · Riverside, CABuilt 1967 · S/N 18258595N3195UHinton Jake B · Mcdonough, GABuilt 1963 · S/N 18254595N3195YFlyers Above The Payette LLC · Mccall, IDBuilt 1962 · S/N 18254195N3196CWeir Ryan L · Buckley, WABuilt 1954 · S/N 30995N3196RS & S Aviation Co · Ball Ground, GAS/N 18258596N3196SHistoricair Transport LLC · Midlothian, TXS/N 18255696N3196TNicholson Perry R · Merlin, ORBuilt 1968 · S/N 17700496N3196XFroes Carlos Da Lapa · Avondale, AZS/N 15064596N3196YRickles Richard J · Chamblee, GABuilt 1962 · S/N 18254196N3197BLavell Michael J · Blue Mounds, WIS/N 25440N3197CScott James D · Mesa, AZBuilt 1954 · S/N 30996N3197FWhite River Land And Timber Co LLC · Greenbrier, ARBuilt 1966 · S/N 18257297N3197SJarvis Jason O · Cresson, TXBuilt 1964 · S/N 18255697N3197TMundle Jeffrey A · Ashland, ORBuilt 1967 · S/N 17700497N3197XLynn Christopher M · Hood River, ORBuilt 1966 · S/N 15064597N3197YMonahan Robert J · Bulverde, TXBuilt 1962 · S/N 18254197N3198AAdams Peter B · Anchorage, AKBuilt 1953 · S/N 25842N3198BHerman Timothy R · Presho, SDBuilt 1953 · S/N 25441N3198FDepinet Rodney J · Glen Saint Mary, FLBuilt 1968 · S/N 17256588N3198JAlternate Air Inc · Seattle, WABuilt 1966 · S/N 15065898N3198YKembel Cary A · Snyder, COBuilt 1962 · S/N 18254198N3199CGreenleaf Michael G · Tacoma, WAFirst renewal noticeBuilt 1954 · S/N 30998N3199RUmina Michael P · Hopkinton, MABuilt 1967 · S/N 18258599N3199TMortgage Experts LLC · Homestead, FLBuilt 1967 · S/N 17700499N3199UNiner Niner Uniform LLC · Elk Mound, WIBuilt 1963 · S/N 18254599N3199VDs Victor LLC · Elburn, ILBuilt 1977 · S/N R1722242N3199XClark Terry E · Dixon, MOBuilt 1966 · S/N 15064599N3199YClearwater Valley Aero Club Inc · Kamiah, IDBuilt 1962 · S/N 18254199N319DDenimarck Vincent · Wildwood, FLBuilt 1969 · S/N 15070159N319JFRegistration Pending · Johns Island, SCRegistration pendingS/N 21063507N319JPElon Aviation LLC · Burlington, NCBuilt 1973 · S/N 17262752N319MTSimply Living LLC · Fort Myers, FLS/N 31438N31ACTango Thirty Aero Clube Inc · Mckinney, TXS/N 17261643N31AJ1 Alpha Jadzia LLC · Fort Worth, TXBuilt 1975 · S/N 18264449N31AZDelgado Tony · Denair, CAS/N 18267911N31BBohon Todd R · Palmer, AKS/N 18052431N31BJAvco Patrol LLC · Lyndon, KSBuilt 1976 · S/N 17702489N31CNSkyland Aviation LLC · Alpine, CABuilt 1976 · S/N 17267936N31DDDavis David C · Queen Creek, AZBuilt 1960 · S/N 52836N31EREmbry Riddle Aeronautical Univ Inc · Prescott, AZBuilt 1964 · S/N 15061072N31FCInternational Air Services Inc Trustee · Carson City, NVS/N 46140N31FR31fr LLC · Bigfork, MTBuilt 1985 · S/N R18202008N31JBLucian Aviation LLC · Modesto, CAS/N 17273002N31KDChinook Fibre LLC · Wilmington, DEBuilt 1984 · S/N T30300310N31KEWilcox John B · South Charleston, WVBuilt 1965 · S/N 18256600
Back to AD 87-20-03 R2