OpenAirDocs.org
AD 99-05-13 R1 WD

Registered aircraft · 13,518

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:99-05-13-R1-WD')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:99-05-13-R1-WD')
  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.

N6675LMcelhannon Fayette M Jr · Athens, GABuilt 1979 · S/N CE-882N6675YField Inspection LLC · Brawley, CABuilt 1980 · S/N TJ-254N6677LAeropacific Consulting LLC · Reno, NVBuilt 1979 · S/N TJ-209N6677YBrown Hunter L · Sulphur Rock, ARBuilt 1979 · S/N E-1594N66784Grimm Phillip H · Draper, UTBuilt 1979 · S/N EA-34N6678C678c LLC · Pensacola Beach, FLBuilt 1979 · S/N TJ-235N6678SHawkeye Aero Sales LLC · West Des Moines, IABuilt 1976 · S/N CE-628N6678YNewhouse Eric · Corrales, NMBuilt 1983 · S/N EA-360N6679APegasus Specialty Leasing Inc · Paris, TXBuilt 1983 · S/N E-2082N6679XElite Aviation Group LLC · Pasco, WABuilt 1982 · S/N E-2041N6679YRanchlands LLC · Hyattville, WYBuilt 1988 · S/N E-2445N667DWombles Earnest · Knoxville, TNBuilt 1952 · S/N D-2938N667DBGutierrez Jess R · Portland, ORBuilt 1977 · S/N CE-737N66801Cirrus Management LLC · Suwanee, GABuilt 1979 · S/N E-1603N6680GHorst Commercial Ventures LLC · Sanger, TXBuilt 1979 · S/N TJ-236N66812Dehaan Aviation LLC · Bethel, AKBuilt 1979 · S/N E-1604N66815Circle S Aviation LLC · Missoula, MTS/N E-2083N66818Schultz Gregory L · Greenbush, MNS/N D-10310N6681XSky Harbor Aviation LLC · Powder Springs, GABuilt 1983 · S/N M-2388N6682THanger 32 LLC · Largo, FLBuilt 1983 · S/N MC-786N6682ZDavis Brad L Trustee · Canton, MOBuilt 1979 · S/N E-1607N6683DRegional Consultants LLC · Wilmington, DEBuilt 1979 · S/N D-10311N6683NLn Skies LLC · Streetman, TXBuilt 1979 · S/N TJ-239N6683YGate Post Aviation LLC · Woodbury, CTBuilt 1979 · S/N TK-111N6683ZMckinney John C · Heath, TXBuilt 1979 · S/N TC-2285N66840Lowery Aviation LLC · Burwell, NEBuilt 1983 · S/N E-2085N66844Munden Paul M · Amarillo, TXS/N EA-364N66845Madsen James · Markle, INBuilt 1979 · S/N TC-2287N6684DDowney Leasing LLC · Lexington, NEBuilt 1979 · S/N E-1610N6685RGlobal Distillation Services LLC · Reno, NVBuilt 1979 · S/N D-10314N66863Taylor John Arthur · Mission Hills, KSBuilt 1983 · S/N E-2086N6686GDarco Hotels Inc · Bentonville, ARBuilt 1981 · S/N EA189N6686XCoughlin James G · Naples, FLBuilt 1979 · S/N E-1616N66876Mcmarlin Richard C · Santa Fe, NMBuilt 1979 · S/N D-10316N6687DVolare Flight Service LLC · Pine Village, INBuilt 1983 · S/N EA-365N66882Mrd Aero LLC · Manheim, PAS/N TC-2291N66885Turn Key Construction Services Inc · Lincoln, CAS/N EA-48N6688EHill Daniel DBA · Grove, OKBuilt 1979 · S/N D-10319N6688JQuesnel Robert Todd · Tomball, TXBuilt 1979 · S/N D-10299N6688UHotel Lima LLC · Oro Valley, AZBuilt 1980 · S/N D-10320N6688YHolt Kyle · Cottontown, TNBuilt 1979 · S/N EA-47N66896Diesbach Benjamin · Cincinnati, OHBuilt 1979 · S/N E-1623N6689JAce Technical Services LLC · Hernando, MSBuilt 1979 · S/N D-10321N6689NMoore Christopher J · Mebane, NCBuilt 1979 · S/N E-1622N668BJordan Thomas G · Saint Helena, CAFirst renewal noticeBuilt 1948 · S/N D-1669N668DESteele Kevin · Phoenix, AZBuilt 1983 · S/N EA363N668JGCapps Steven M · Mount Pleasant, TXBuilt 1999 · S/N E3266N668QUnruly Passengers LLC · Piedmont, SCS/N TD-326N668ZSDrumwright Gerald L · Ormond Beach, FLBuilt 1979 · S/N D-10258N66907Flynn Curtis J · Granbury, TXBuilt 1979 · S/N D-10322
Back to AD 99-05-13 R1 WD