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.

N554JFRhoton Joel S · Borger, TXS/N TC-1286N554JSKilo Kilo Mike LLC · Jacksonville, FLBuilt 1980 · S/N TC-2323N554KCaux Brisebois Vincent · Newcastle, WAS/N TC-1179N554LRCenterline Holdings · Camden, DEBuilt 1969 · S/N TE-738N554SDAeroplanes2 LLC · Indianola, IABuilt 1964 · S/N TC-646N554TBOwen Harold E Jr · Collierville, TNBuilt 1976 · S/N TC-1998N554TMLamar Aviation LLC · Paris, TXBuilt 1992 · S/N E-2688N554USHunter Stephen Earle · Anchorage, AKBuilt 1961 · S/N TC-99N554WFs II Inc · Minden, NVS/N E3554N5551VRegistered aircraftBuilt 1991 · S/N E-2637N5552Rosenlof Dean F · Tempe, AZBuilt 1969 · S/N CJ-15N5552DZahl Oerjan · Maricopa, AZBuilt 1957 · S/N D-5179N5552XJjs Aero LLC · Middletown, DES/N E-2521N5554XDellechiaie Anthony J · Mahwah, NJBuilt 1990 · S/N CE-1457N5556DMedic Choppers LLC · Springdale, ARBuilt 1957 · S/N D-5078N5558DSchoenau Michael W · Tulare, CABuilt 1957 · S/N D-5080N5558PValiair Lc Trustee · Casper, WYS/N TJ-399N555BCHammett Michael James · Hattiesburg, MSBuilt 1966 · S/N D-8341N555CCDavis Donel · Hollis, NYBuilt 1974 · S/N M-1589N555CSGibson Air LLC · Park Hills, MOS/N TJ-385N555DBSira Arashpal Singh · Lakewood, CABuilt 1978 · S/N CE-803N555EVennari Victor · Elbert, COBuilt 1959 · S/N D-5845N555ETFlyboys Nevada LLC · Henderson, NVBuilt 1961 · S/N TC-137N555GGSoutherland Corp · New Port Richey, FLBuilt 1967 · S/N D-8380N555HCWikle Leon · Rapid City, SDBuilt 1979 · S/N E-1586N555JECantr Holdings LLC · Fish Creek, WIBuilt 1970 · S/N TC-1329N555KAKimmel Frank S III · Greenwood, MSBuilt 1967 · S/N TD-707N555KMVerrill Christopher R · Williamstown, NJBuilt 1966 · S/N D-8361N555LFMadden Todd A · Houston, TXBuilt 1979 · S/N D-10270N555LTHogan Daniel · Salina, KSBuilt 1975 · S/N E-737N555MGHampshire Blue Skies LLC · Bedford, NHBuilt 1987 · S/N E-2391N555PManson Howard William · Pinckney, MIBuilt 1966 · S/N TE-164N555PCDawson Clyde W Trustee · Indiantown, FLBuilt 1944 · S/N 23679N555PDSw Plains Aviation LLC · Ford, KSBuilt 1980 · S/N EA-61N555PZLada Aviation LLC · Alpine, UTBuilt 1975 · S/N D-9782N555RSmathers John R · Flowery Branch, GABuilt 1950 · S/N D-2295N555RAMooseknuckle Aviation LLC · Haslet, TXBuilt 1975 · S/N TE-1066N555RDGates Robert H · Santa Barbara, CABuilt 1977 · S/N TC-2025N555RPGreenwood Auto LLC · Itta Bena, MSS/N TC-2009N555RSR&M Aviation LLC · Austell, GABuilt 1963 · S/N M-412N555SNMohave Maverick Aviation LLC · Bullhead City, AZBuilt 1961 · S/N D-6865N555SPJohnston Thomas · Austin, TXBuilt 1969 · S/N TE-676N555TGDodson International Parts Inc · Rantoul, KSBuilt 1975 · S/N TE-1034N555TMPalm Aerobatic Aircraft LLC · Port Saint Lucie, FLBuilt 1969 · S/N TC-1232N555TSBas Part Sales LLC · Greeley, COS/N D-7974N555TXBoujo Yoni · Valley Village, CABuilt 1976 · S/N D-9890N555VRm A36 LLC · Jacksonville, FLBuilt 1978 · S/N E-1221N555WCWilliams Grant A · Port Orange, FLBuilt 1976 · S/N CE-671N555WSDeer Creek Dusters Inc · Rolling Fork, MSBuilt 1956 · S/N BA-168N555WTHigh Speed Low Drag Aviation LLC · Hamilton, MTS/N CE-1536
Back to AD 99-05-13 R1 WD