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.

N4266SFowler Thomas J · Keller, TXBuilt 1977 · S/N TE-1086N4267SJjk Aviation LLC · Wilmington, DEBuilt 1977 · S/N TC-2037N4268BKallhoff Mark · Canby, MNBuilt 1955 · S/N D-4241N4268DDangberg Dennis C · Wayne, NES/N D-4494N426BAnyones Home LLC · Enid, OKBuilt 1957 · S/N D-1647N426KXCoulman Michael A · Highland Village, TXBuilt 1962 · S/N D-7067N426RWolff Phillip R · Highlands Ranch, COBuilt 1952 · S/N D-3188N4270DKliewer Silas M · Ulm, MTBuilt 1956 · S/N D-4490N4271DPc Aviators LLC · Oklahoma City, OKBuilt 1956 · S/N D-4496N4271SVk Aviation LLC · Jennings, LABuilt 1976 · S/N E-944N4272SSchechter Stuart · Great Neck, NYBuilt 1976 · S/N D-9959N4275SEvergreen Aviation LLC · Franktown, COBuilt 1977 · S/N D-9961N4277SDfj Transportation LLC · Ridgedale, MOFirst renewal noticeBuilt 1977 · S/N P-403N4279DAlsaeed Mokhtar · Monroe, WAS/N D-4483N4279SSteinbacher Deane E · Waterford, WIBuilt 1976 · S/N E-948N427BBBolder Travel LLC · Superior, COS/N E-2984N427BDNostra Aeris LLC · Gassville, ARBuilt 1991 · S/N EA528N427CWRural Orthopedic Care LLC · Ardmore, OKBuilt 2001 · S/N E-3400N427DWFlyin Phar LLC · Salt Lake City, UTBuilt 1979 · S/N TK-113N427KMAviation Advantage LLC · Phoenix, AZBuilt 1974 · S/N TC-1818N427LLForrest Jeffrey H · Bloomfield Hills, MIBuilt 1977 · S/N CE-679N427PWLangford Stephen C · York, SCBuilt 1976 · S/N D-9850N427TCag Farms Inc · Angier, NCBuilt 1963 · S/N D-7232N42800Asbury William J · Fresno, CABuilt 1976 · S/N D-9934N4280SYoung Daniel R · Germantown, TNBuilt 1976 · S/N D-9969N4281DConnell Seth · Little Rock, ARBuilt 1956 · S/N D-4499N4281S4b Aviation LLC · Upper Arlington, OHBuilt 1977 · S/N E-949N4282BYaws Larry · Amarillo, TXBuilt 1955 · S/N D-4345N4282PAero Tramp Holdings LLC · Dallas, TXBuilt 1999 · S/N E-3282N4282SGoerzen John P · Goessel, KSBuilt 1976 · S/N E-946N4283BSale Reported · Oklahoma City, OKSale reported, pending cancellationBuilt 1955 · S/N D-4344N4284BPhilcox Kenneth J · Milton, DEBuilt 1955 · S/N D-4258N4285BChisum Robert · Lorenzo, TXS/N D-4262N4285DUrbina Mario A · Pacoima, CAS/N D-4512N4286DRegistration Pending · Kaplan, LARegistration pendingBuilt 1956 · S/N D-4505N4287BDeffner Gerhard Paul Heinrich · Mckinney, TXS/N D-4361N4287SLemanski Joseph S · Fiskdale, MABuilt 1977 · S/N TC-2112N4289SGleason Aviation LLC · High Point, NCBuilt 1977 · S/N CE-682N428BDAirbrn LLC · Stuttgart, ARBuilt 1977 · S/N E-950N428KRLilly James D · Columbia, MDBuilt 1972 · S/N D-9306N428TLJoe Rushing Plumbing Co Inc · Lubbock, TXBuilt 1967 · S/N D-8632N4290BDelyser Dwight G · Upland, CABuilt 1955 · S/N D-4253N4291BElk River Equipment LLC · Elkview, WVS/N D-4249N4292BFreeman Bobby Keith · Grove, OKBuilt 1955 · S/N D-4354N4293BSima Bary J · Salome, AZBuilt 1955 · S/N D-4355N4294BFull Stop Aviation LLC · Union City, TNBuilt 1955 · S/N D-4356N4294DPreisse Gene L · Akron, OHS/N D-4503N4295ANy Fighter Jets · Wilmington, DES/N G-755N4295BHanna Ryan Dale · Berthold, NDBuilt 1955 · S/N D-4362N4295DRutherford Albert II · Baker, LABuilt 1956 · S/N D-4514
Back to AD 99-05-13 R1 WD