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.

N4297BBass Steven W · Elbert, COBuilt 1955 · S/N D-4245N4298DKumle Kreations LLC · Libby, MTS/N D-4541N4299BBorger Jimmy L · Lafayette, LABuilt 1955 · S/N D-4261N4299DOverseas Aviation Inc · Wilmington, DEBuilt 1956 · S/N D-4521N429GLHamilton Verlon D · Roanoke, TXBuilt 1965 · S/N TC-868N429JKRegistered aircraftBuilt 2005 · S/N E-3604N429PDupuy William C · Waco, TXBuilt 2000 · S/N E-3356N42ABGallaway Michael T · Dallas, TXBuilt 1965 · S/N D-7935N42ADLopez Michael · Leesville, LAS/N P-283N42AMGruhlkey William H · Wildorado, TXBuilt 1979 · S/N EA-29N42AUBite Wing Aviation LLC · Wichita, KSBuilt 1982 · S/N CE-1010N42BAGroom Randall T · Vero Beach, FLBuilt 1984 · S/N E-2139N42CStage One Associates LLC · Oxford, CTS/N A-468N42DMajerle Michael A · Big Lake, AKS/N BA-117N42HFKlochko Oleg Alexander · Furlong, PABuilt 1974 · S/N TC-1730N42JVCheshire Vincent Eugene Jr · Slidell, LABuilt 1980 · S/N CE-913N42JWBusiness Aircraft Leasing Inc · Petersburg, ILBuilt 1965 · S/N TC-884N42LBRigney Timothy D · Troy, VABuilt 1970 · S/N D-9140N42LHFly Hangar 13 LLC · Mico, TXBuilt 1981 · S/N EA-163N42MMPiper Capital LLC · Elkhorn, NEBuilt 1988 · S/N CE-1278N42RRWalla Walla University · College Place, WAS/N ME-84N42SMBaron South LLC · Dexter, MOBuilt 1977 · S/N TJ-109N42WKMariash Cary Norman · Indianapolis, INBuilt 1964 · S/N D-7390N42XRegistration Pending · Grandfield, OKRegistration pendingBuilt 1951 · S/N D-2825N4300WPrivate Enterprises LLC · Peoria, AZBuilt 1973 · S/N E-487N4301SCoburn Thomas R Trustee · Upperco, MDBuilt 1975 · S/N CE-578N4301WNash Matthew · Edmonds, WABuilt 1974 · S/N D-9578N4302WDagenhart Ronald Jason · Westerville, OHBuilt 1974 · S/N D-9582N4305UMarshall Paul A Trustee · Gilroy, CABuilt 2000 · S/N E-3305N4305WBennett Hugh · Gillette, WYBuilt 1974 · S/N TE-967N4306AOdyssey Aviation LLC · Raleigh, NCBuilt 1970 · S/N TE-802N4306DNightingale Matthew M · Rancho Cucamonga, CABuilt 1956 · S/N DH-65N4306WBlaylock Christopher W · Lubbock, TXBuilt 2000 · S/N E-3352N4307SHuddleston Edward · Oaktown, INS/N E-675N4308SBurroughs Steven R · Murphysboro, ILBuilt 1975 · S/N E-678N4309SGsi · Temple, TXBuilt 1975 · S/N E-682N430FMCygnus Inc · Sioux Falls, SDBuilt 2000 · S/N E-3319N4310SVelk Vincent F · Havre, MTBuilt 1975 · S/N D-9773N4310WSt Clair Joseph M · Wills Point, TXBuilt 1974 · S/N TC-1651N4312WBreitbarth Brian · Canby, ORBuilt 1974 · S/N D-9585N4314BJab Aviation LLC · Houston, TXBuilt 1982 · S/N CE-1002N4316DPaulsen James · Lafayette, INBuilt 1956 · S/N D-4712N4316WHolt Bartlett · Binghamton, NYBuilt 1974 · S/N CE-485N4317WMurray Patrick G · Moraga, CABuilt 1974 · S/N D-9587N4319SMac Air Inc · Farmington, MOBuilt 1975 · S/N TC-1869N431BKnisley David J · Jacksonville, FLBuilt 1948 · S/N D-1648N431SPMoreno Jose J · Irvine, CABuilt 1961 · S/N D-6799N432Lazy J Aeroplanes LLC · Beverly, WVBuilt 1974 · S/N TC-1649N4321EHarper Henry Jr · Mesquite, NVS/N D-8868N4321SBeech Peak Aviation LLC · Boulder, COBuilt 1964 · S/N D-7512
Back to AD 99-05-13 R1 WD