OpenAirDocs.org
AD 84-12-01 R1

Registered aircraft · 366

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:84-12-01-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:84-12-01-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.

N1604ZDept Of Fish Wildlife And Parks · Helena, MTBuilt 1989 · S/N 0341EN16050Venturi Aviation LLC · Missoula, MTS/N 0276EN16062Flight Inspection LLC · Springdale, WABuilt 1989 · S/N 0349EN16069Paragon Air Group · Fort Worth, TXBuilt 1990 · S/N 0433EN160THTerrell Bill · Port Orange, FLS/N 770160DN1610BBlackstead Investments Inc · Boise, IDBuilt 1991 · S/N 0480EN161LAAir2 LLC · Blountville, TNBuilt 1981 · S/N 711015DN165HMidvale Air Research LLC · Lewes, DEBuilt 1985 · S/N 0150EN166MBHelicopter Roundup Service LLC · Nephi, UTBuilt 1980 · S/N 1000831DN167ALFerguson And Sons Construction LLC · Emmett, IDBuilt 1977 · S/N 270083DN16EYCarleton Inc Trustee · Wilmington, DEBuilt 1992 · S/N 0501EN173ALFulton Timothy E · Salem, MOBuilt 1976 · S/N 1160020DN175JLRatcliff Dustin · Saltville, VABuilt 1977 · S/N 270076DN18CPPeoples Properties LLC · Tucson, AZBuilt 1990 · S/N 383EN193VSVertol Systems Co Inc · Destin, FLBuilt 1981 · S/N 110882DN195VSVertol Systems Co Inc · Destin, FLBuilt 1981 · S/N 110826DN20FLLocker Fred · Muleshoe, TXBuilt 2008 · S/N 0592EN212ELMark Mondo Building & Excavating Inc · Reno, OHBuilt 1982 · S/N 1097DN212VTLaroche Aviation Services LLC · Bellaire, OHBuilt 1981 · S/N 811039DN220PDCity Of Oakland · Oakland, CABuilt 1993 · S/N 0509EN221TGCollier Mosquito Control District · Naples, FLBuilt 1981 · S/N 410951DN225HRHeliwild Investments LLC · Austin, TXS/N 890559DN228KKKeagy Ken · Central Point, ORBuilt 1987 · S/N 0248EN229HLAviation Advantage Inc · Tabor City, NCBuilt 1995 · S/N 0519EN230MDAir2 LLC · Blountville, TNBuilt 1981 · S/N 510978DN234RFMhoc LLC · Pensacola, FLBuilt 1987 · S/N 0255EN240FLAir2 LLC · Blountville, TNBuilt 1978 · S/N 480298DN241JHChatham County Mosquito Control · Savannah, GAS/N 0233EN262WAWindward Aviation Inc · Puunene, HIBuilt 1979 · S/N 790554DN28MLTre Aviation Corp · Wilmington, DEBuilt 1978 · S/N 1080362DN297ECounty Of Kern · Bakersfield, CAS/N 197EN298PPGillespie Flying Services LLC · Trenton, SCBuilt 1982 · S/N 0006EN299DRKings County Sheriffs Office · Hanford, CABuilt 1986 · S/N 196EN305JEDah Aircraft LLC · Georgetown, SCBuilt 1982 · S/N 1194DN311VTGeco Inc · Wilmington, DEBuilt 1987 · S/N 0229EN315SHJc Aircraft Leasing LLC · Wasilla, AKS/N 1120DN316HKHawkeye Holdings LLC · Lyndon, KSBuilt 1979 · S/N 390479DN31HMDah Aircraft LLC · Georgetown, SCBuilt 1977 · S/N 1160027DN321PERadnor Construction Of Delaware Inc · Allentown, PABuilt 1989 · S/N 0342EN331WHSchreindl Lawrence A · Colton, ORS/N 0207EN333TABallard Aviation Inc · Newton, KSBuilt 1979 · S/N 590500DN33TJRhk Of Kansas Inc · Overland Park, KSS/N 711016DN348Bhh Leasing #2 LLC · Pensacola, FLBuilt 1980 · S/N 1000824DN353AHBank Of Utah Trustee · Salt Lake City, UTBuilt 1981 · S/N 811079DN357MHAa Leasing Lp · Kilauea, HIBuilt 1982 · S/N 1171DN362MNHeli Ag LLC · Plantersville, TXBuilt 1979 · S/N 390462DN363CCBank Of Utah Trustee · Salt Lake City, UTBuilt 1977 · S/N 1070208DN365PRAerotrust Services Corp Trustee · Wilmington, DES/N 1180365DN369DRatcliff Dustin · Saltville, VABuilt 1977 · S/N 1070209DN369EDMonroe Helicopters LLC · Vestavia, ALBuilt 1978 · S/N 870167D
Back to AD 84-12-01 R1