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.

N6641RWightman William Adams Jr · Yukon, OKBuilt 1979 · S/N D-10230N6641TAx3 LLC · Decatur, TXBuilt 1980 · S/N EA-68N6641WLandlund Flying LLC · Oroville, CABuilt 1982 · S/N EA-274N6641ZVineyard Andrew L · Laguna Hills, CABuilt 1979 · S/N P-509N66421Gleim Garrett William · Gainesville, FLBuilt 1979 · S/N D-10267N6642DShelk John Brian · Bend, ORBuilt 1979 · S/N TE-1162N66433Mc Namara Donald · Sunriver, ORBuilt 1983 · S/N MC-791N6643EReynolds Ronnie · White Hall, ARBuilt 1979 · S/N TJ-215N6643PRobert Yost Enterprises Inc DBA · Saint Francis, KSBuilt 1979 · S/N EA-45N6643QSky High Solutions Inc · Miami, FLBuilt 1979 · S/N D-10265N66444Transcontinental Air LLC · Orange, CAS/N EA-12N6645BS&D Productions · Lake Havasu City, AZBuilt 1984 · S/N E-2159N6645YDietl Manfred · Naples, FLBuilt 1979 · S/N TC-2258N6646SHolub James T · Wellington, FLS/N D-10252N6646ZN1437a LLC · Delray Beach, FLBuilt 1981 · S/N TJ-203N6647RBradamike LLC · Fostoria, OHBuilt 1979 · S/N E-1561N66489Fog City Flying LLC · Dublin, OHBuilt 1983 · S/N E-2073N6648DPedrizetti Raymond D · Sammamish, WABuilt 1979 · S/N CE-864N6648JWindward Passage Corporation · Englewood, NJBuilt 1979 · S/N E-1514N6648KWest Star Lands LLC · Seminole, TXBuilt 1979 · S/N TJ-204N6648NMark & David LLC · Coldwater, MSBuilt 1979 · S/N D-10250N6648WN6648w LLC · Wilmington, DES/N TC-2242N6649LChauza Edward J · Mesa, AZBuilt 1979 · S/N E-1516N6649SRay James William · Albert, NMBuilt 1976 · S/N D-9847N664DMStar Air Group LLC · Anchorage, AKBuilt 1968 · S/N D-8721N664EDrury Herbert R Jr · Maynard, MABuilt 1951 · S/N D-2934N664GBTcc Air Services Inc · Greenwich, CTS/N TC-2093N664HWWilliamson Kemal · O Fallon, ILBuilt 1979 · S/N D-10260N664JGSpecialty Contractors Inc · Lake In The Hills, ILBuilt 1990 · S/N CE-1481N664TBechtol Andrew M · Long Beach, CABuilt 1972 · S/N D-9374N6650HN6650h LLC · Edmond, OKBuilt 1982 · S/N EA-318N6650LHoward Barron S · Henderson, NVS/N CE-866N66514Vintage Aviation Medical Associates LLC · Wilmington, DEBuilt 1979 · S/N E-1522N66519George Jon L · Gulf Shores, ALBuilt 1982 · S/N E-2054N6651RZucha Joseph P · Rio Vista, CABuilt 1975 · S/N MB-742N6651TMichalina Patrick J · Liberty Hill, TXBuilt 1982 · S/N MC-784N66529King Warren D · Bend, ORBuilt 1979 · S/N EA-8N6652DRafter B Cattle Company LLC · Gordonville, TXBuilt 1979 · S/N D-10254N6652GHenehan Brendan A · Geneva, NYBuilt 1983 · S/N M-2385N6652JAir Chairs LLC · Austin, TXBuilt 1979 · S/N EA-11N6652RDrummond Williams D · Bloomington, INBuilt 1979 · S/N E-1524N6652YSeiger Thomas W · Medford, ORS/N E-1525N66532Accu Spray LLC · Olton, TXBuilt 1983 · S/N EA-351N6653DWilliams Lee V · Dallas, TXS/N D-10256N6653RRegistered aircraftBuilt 1979 · S/N D-10259N6653VWalker Ray A · Sanger, TXBuilt 1979 · S/N D-10253N6654LRomeo Air LLC · Missoula, MTS/N EA-50N6654RLow Mach Aero LLC · Hays, KSBuilt 1979 · S/N D-10273N6655QDurham Aviation LLC · Henrietta, TXS/N E-1740N6655YBretts Spray Service Inc · Onida, SDBuilt 1979 · S/N E-1559
Back to AD 99-05-13 R1 WD