OpenAirDocs.org
AD 2003-09-13

Registered aircraft · 1,267

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-09-13')
    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-09-13')
  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.

N3353PHeffron Jacob L · Little Falls, MNBuilt 1958 · S/N 23-1308N3363PDubois Aviation Inc · Chino, CABuilt 1958 · S/N 23-1320N3366Sutton Aircraft Salvage LLC · Palmer, AKS/N 23-1919N3367PJackson Lee Roy Jr · Needville, TXBuilt 1958 · S/N 23-1324N3377PFlying High LLC · Gore, VABuilt 1958 · S/N 23-1337N3388PMorrison Maria · Port Townsend, WABuilt 1958 · S/N 23-1351N3389PLapeyrouse Charles L · Raceland, LABuilt 1958 · S/N 23-1352N338SSSieli Paul III · Griffin, GAS/N 27-224N339CTPatel Niral G · Atlanta, GABuilt 1974 · S/N 27-7405350N33RWSpencer Joseph C · Asheboro, NCBuilt 1960 · S/N 23-1948N33SAMcwherter Holdings Inc · Asheboro, NCS/N 27-3370N3403PCarper Ryan W · Marietta, OHBuilt 1958 · S/N 23-1367N341CHAce Flight Center Inc · St Thomas, VIBuilt 1980 · S/N 27-8154006N3420PKeyuravong Pisonth · Anchorage, AKBuilt 1958 · S/N 23-1384N3430PChamberlain Paul E · Troup, TXBuilt 1958 · S/N 23-1396N3434PNasair LLC · Flower Mound, TXBuilt 1958 · S/N 23-1401N3442POttmann Robert · Indialantic, FLBuilt 1958 · S/N 23-1410N3447PSimonovich Sheldon K · Fredericksburg, VABuilt 1958 · S/N 23-1418N3448PDabney Richard W · Tanner, ALBuilt 1958 · S/N 23-1419N3456PBels Holdings LLC · Albert Lea, MNBuilt 1958 · S/N 23-1428N3457PSewade Dawn M · New River, AZBuilt 1958 · S/N 23-1429N345JGGo Fly Inc · Spring Hill, FLBuilt 1959 · S/N 23-1825N3468PHilligoss Forrest R · Brownsburg, INBuilt 1958 · S/N 23-1442N3475PEdixon James Richard II · Cameron Park, CABuilt 1958 · S/N 23-1449N3494AWheeler Michael R · Peculiar, MOBuilt 1962 · S/N 27-2197N3494BLiguori Fred C · Granby, CTBuilt 1955 · S/N 23-282N3497PKitchens Craig N · Salt Lake City, UTBuilt 1958 · S/N 23-1473N3499PTinny Twister Aviation LLC · Fort Myers, FLBuilt 1958 · S/N 23-1475N349CHAce Flight Center Inc · St Thomas, VIBuilt 1968 · S/N 27-3949N34DAGlover William S · Mount Pleasant, TXBuilt 1958 · S/N 231469N34KKLe Ferrand Colette · Kalispell, MTBuilt 1972 · S/N 27-7304946N355MDelaware Trust Company Owner Trustee · Wilmington, DES/N 273972N3611BRestorations & Rentals LLC · Tulsa, OKBuilt 1970 · S/N 27-4579N362BMAmerican Valet Air Inc · Wilmington, DEBuilt 1973 · S/N 27-7305171N362BPLight & Variable LLC · Arlington, VABuilt 1979 · S/N 27-7954048N367PBuzzard Air Service LLC · Carleton, MIS/N 23-367N370Bas Part Sales LLC · Greeley, COBuilt 1965 · S/N 27-3084N370MDAlmost There Air LLC · Daytona Beach, FLBuilt 1972 · S/N 27-4814N370SASharp Spears LLC · Vero Beach, FLBuilt 1979 · S/N 278054005N370TBellas Business LLC · Kalispell, MTBuilt 1958 · S/N 23-1506N371AMPreuss Andrew J · North Charleston, SCBuilt 1968 · S/N 27-4005N371DSCl Finney Aviation LLC · Benton, KSBuilt 1955 · S/N 23-153N374PDavhen Aero LLC · Anderson, SCBuilt 1974 · S/N 27-7405410N375AZSale Reported · Guatemala CitySale reportedS/N 27-7854038N377DWSoutheastern Aircraft Inc · Birmingham, ALBuilt 1965 · S/N 27-3063N385WKTriva Solutions LLC · El Paso, TXS/N 27-4130N388METrinity Aviation Group LLC · Hudson Oaks, TXBuilt 1955 · S/N 23-322N390ASOcala Aviation Services Inc · Ocala, FLS/N 27-3117N391MGHagedorn Aviation Inc · Columbus, OHBuilt 1975 · S/N 27-7554131N3929CWest Candace F · Helena, MTBuilt 1969 · S/N 27-4049
Back to AD 2003-09-13