OpenAirDocs.org
AD 83-03-02 R1

Registered aircraft · 1,083

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:83-03-02-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:83-03-02-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.

N969RLRanger Aviation Leasing LLC · Wilmington, DES/N 3969N969VSVertol Systems Co Inc · Destin, FLBuilt 1980 · S/N 1100833DN96NWNorthwest Helicopters Inc · Olympia, WABuilt 1995 · S/N 4389N970YGCbk LLC · Eagle, COBuilt 1979 · S/N P21000219N971RHTurbines Ltd · West Point, NEBuilt 1972 · S/N 797N973RHTurbines Ltd · West Point, NEBuilt 1994 · S/N 4318N975RHTurbines Ltd · West Point, NEBuilt 1996 · S/N 4415N9762CFort Wolters Helicopters · Mineral Wells, TXBuilt 1962 · S/N 2159N979RHTurbines Ltd · West Point, NEBuilt 1989 · S/N 4080N97PHProvine Helicopter Service Inc · Greenwood, MSBuilt 1979 · S/N 2632N97RRCounty Of Ocean · Barnegat, NJBuilt 1993 · S/N 4287N981RDSunrise Adventures LLC · Stillwater, MNBuilt 1981 · S/N U20605872N9833FKlump Aviation LLC · Bowie, AZBuilt 1992 · S/N 4205N985MVKar Aviation LLC · Saltville, VAS/N 610985DN987CBChangstrom Co · Pasadena, CABuilt 1999 · S/N 0543EN988DFCounty Council Of Beaufort County South Carolina · Beaufort, SCBuilt 1980 · S/N 700737DN988LBUpshaw Roy L · Ft Worth, TXBuilt 1993 · S/N 4217N98AZBig Tree Aviation LLC · Salem, ORBuilt 1977 · S/N 2296N98CMSk Hoff Enterprises LLC · Wilsonville, ORBuilt 1989 · S/N 4056N9902KSouthmark Aviation Inc · Hattiesburg, MSBuilt 1976 · S/N 1923N991MCCharleston County Mosquito Control · North Charleston, SCBuilt 1978 · S/N 780314DN992ACLarge Michael M · Angeles CityNon-citizen corporation, flight hours not reportedBuilt 1982 · S/N C-3007N992MRPlatinum Rigging & Hvac Consulting LLC · Covington, GABuilt 1981 · S/N 3265N995KPBank Of Utah Trustee · Salt Lake City, UTBuilt 1978 · S/N 2572N996TVTopside Aviation Inc · Brasstown, NCBuilt 1988 · S/N 4019N9984KJl Aviation Inc · Boring, ORBuilt 1976 · S/N 45054N998SHConstruction Equipment Rentals Inc · Fallbrook, CABuilt 1980 · S/N 1100847DN99ZASouthmark Aviation Inc · Hattiesburg, MSFirst renewal noticeBuilt 1979 · S/N 2794N9QDChemair Helicopters Inc · Jefferson, WIBuilt 1994 · S/N 4306N9TVGriffin Television Okc LLC · Oklahoma City, OKBuilt 1995 · S/N 52129N9VFAtxaviation LLC · Creedmoor, TXBuilt 1986 · S/N 3945N9YJHelicopters Inc · Linden, NJBuilt 1982 · S/N 3672N9ZVL& R Investment Partners LLC · Wilmington, DES/N 3793
Back to AD 83-03-02 R1