OpenAirDocs.org
AD 2003-13-15 R1

Registered aircraft · 330

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

N366GCHavens Aviation LLC · Blacklick, OHBuilt 2000 · S/N S1809N367RWSpies Robert Charles Sr · Kingman, AZS/N 870627N37750Bacon Gregory · Prairie Home, MOBuilt 1968 · S/N 680883(6716776)N380MCVeturis David L · Lake Forest, CAS/N 128-1054N38ABJerry Lay Aviation LLC · Minonk, ILS/N 46-0503N396CPAir 1 LLC · Newark, DEBuilt 1994 · S/N S1683N3TFHelicopter Accessory Service East · Pensacola, FLS/N 34-0042N411JCFlying Z Ranch LLC · Douglas, WYBuilt 1986 · S/N S1201N413LHRatcliff Dustin Matthew · Saltville, VABuilt 2008 · S/N S1925N41THLammers Ross L · Cumming, GABuilt 1997 · S/N S1747N4276REchols Mark R · Diana, TXBuilt 1967 · S/N 1181032N444EDunker Quinn E · Morse Bluff, NEBuilt 1963 · S/N 0217N451JRFathom Aviation LLC · Burley, WAS/N 65-0212N451MCAero-Tech Helicopters LLC · Kingstree, SCS/N 340287N47SDWampler William C · Canton, TXS/N 108-0989N48155Classic Rotors Museum · Ramona, CABuilt 1964 · S/N 160433N4853STurley Gregory D · Pell City, ALBuilt 1977 · S/N 870625N49WGGarlock Walter G · Oconomowoc, WIS/N 760616N5001FReynolds Darryl G · Wills Point, TXBuilt 1965 · S/N 95-0385N50045Drive A Tank Inc · Kasota, MNBuilt 1966 · S/N 76-0610N500HSDaniels Richard L · Bow, WAS/N 170554N5015VFoos LLC · Vancouver, WAS/N 611058N503QDSchroth Charles D · Gustavus, AKBuilt 1977 · S/N 1170643N511RJCarman Scott C · Port Orange, FLBuilt 2010 · S/N S1946N515PHGulf Coast Helicopters Inc · Pearland, TXBuilt 1998 · S/N S1771N5160NFox Judy S · Ridgefield, WAS/N 1076N521RSJj Airlift Inc · Broomfield, COBuilt 2006 · S/N S1891N522TTHarris Kenneth L · Greeley, COBuilt 1990 · S/N S1471N525GHLauff Samuel Jr · Ocala, FLBuilt 1964 · S/N 87N526LWN526lw LLC · Salem, ORBuilt 1981 · S/N 511051N528WTRegistration Pending · New Smyrna Beach, FLRegistration pendingBuilt 2001 · S/N S1822N536XDel Rio Aviation Inc · Paso Robles, CABuilt 1977 · S/N 170574N53KFHaynes Robert Kent · Pilot Point, TXBuilt 1996 · S/N S1738N556BKd Helicopters Inc · Shingleton, MIBuilt 1986 · S/N S1235N557DCJoslyn Larry J · Las Vegas, NVBuilt 1993 · S/N S1630N5594YWdw Aviation Leasing Inc · Knoxville, TNBuilt 1964 · S/N 1140329N55PHElectrical Design Consultants Group LLC · Pepper Pike, OHBuilt 2002 · S/N 0145N58160Brb Flight Services LLC · Laguna Beach, CABuilt 1974 · S/N 740324N58174Castle Farms Inc · Sunnyside, WAS/N 480685N58206Kiwi Choppers LLC · Hillsboro, ORBuilt 1978 · S/N 190768N58208Smith Helicopter Inc · Cotulla, TXBuilt 1979 · S/N 390780N58281Lueck Thomas J · Cedar Rapids, IABuilt 1978 · S/N 1180734N58319Schweizer Rsg LLC · Fort Worth, TXBuilt 1979 · S/N 390761N58344Wolff Scott A · Missoula, MTS/N 1090836N58359Warner Robert G Jr · Broomall, PABuilt 1979 · S/N 1290861N58363Hartle Aaron Duane · Vicksburg, MIBuilt 1979 · S/N 690796N58371Bilton Aircraft Management Inc · Umatilla, FLBuilt 1979 · S/N 690794N58384Sonnichsen Landen D · Delta Junction, AKS/N 990829N58397Frost Darrell G · Atlanta, TXBuilt 1979 · S/N 1090833N6120ABrabeck Mark F · Glasgow, MTBuilt 1991 · S/N S1520
Back to AD 2003-13-15 R1