AD 82-17-01

Registered aircraft · 211

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

N230MDAir2 LLC · Blountville, TNBuilt 1981 · S/N 510978DN240FLAir2 LLC · Blountville, TNBuilt 1978 · S/N 480298DN262WAWindward Aviation Inc · Puunene, HIBuilt 1979 · S/N 790554DN28MLTre Aviation Corp · Wilmington, DEBuilt 1978 · S/N 1080362DN305JEDah Aircraft LLC · Georgetown, SCBuilt 1982 · S/N 1194DN315SHJc Aircraft Leasing LLC · Wasilla, AKS/N 1120DN316HKHawkeye Holdings LLC · Lyndon, KSBuilt 1979 · S/N 390479DN31HMDah Aircraft LLC · Georgetown, SCBuilt 1977 · S/N 1160027DN333TABallard 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 870167DN369EHApplebee Aviation Inc · Banks, ORBuilt 1980 · S/N 1200861DN369FCFerguson And Sons Construction LLC · Emmett, IDBuilt 1981 · S/N 610983DN369KVAgricultural Air Services LLC · Jupiter, FLBuilt 1980 · S/N 300659DN369LRCenterline Holdings Inc · Camden, DES/N 610991DN369MHAa Leasing Lp · Kilauea, HIBuilt 1978 · S/N 380287DN369MPAviation Advantage Inc · Tabor City, NCBuilt 1977 · S/N 670150DN369PBHelicopter Aviation Services & Leasing Inc · Miami, FLBuilt 1978 · S/N 480305DN369SCVertical Flight Path LLC · Wilmington, DES/N 380273DN369TRChehalem Helicopters LLC · Newberg, ORBuilt 1977 · S/N 570141DN369WYReece Construction Company · Marysville, WABuilt 1981 · S/N 510976DN36KRDragonfly Aviation LLC · Mirando City, TXBuilt 1978 · S/N 580315DN405ATRotor Blade LLC · Georgetown, SCBuilt 1980 · S/N 500717DN41AJEnglish Air Service LLC · Georgetown, TXBuilt 1978 · S/N 480299DN421VSVertol Systems Company Inc · Destin, FLS/N 1090592DN4265JRatcliff Dustin · Saltville, VABuilt 1979 · S/N 790542DN43BATerrell Bill · Port Orange, FLS/N 770160DN451HAIron Horse Aviation LLC · Marshalltown, IABuilt 1979 · S/N 490484DN458HWHeliwild Investments LLC · Austin, TXBuilt 1979 · S/N 390483DN46662Brown Helicopter Inc · Pensacola, FLBuilt 1979 · S/N 590510DN469FCFerguson And Sons Construction LLC · Emmett, IDBuilt 1980 · S/N 1100854DN484Bhh Leasing #2 LLC · Pensacola, FLS/N 870177DN48MPPope James D · Lewiston, IDBuilt 1982 · S/N 1137DN499SLHlh Leasing LLC · Wilmington, DEBuilt 1979 · S/N 190448DN49WKRail N LLC · Oracle, AZBuilt 1981 · S/N 611006DN500DCHva Holdings LLC · Gettysburg, PABuilt 1978 · S/N 290456DN500EKKar Aviation LLC · Saltville, VABuilt 1979 · S/N 1190610DN500FFRegistered aircraftN-number assigned (import), not yet registeredS/N 1270251DN500GKN969md Inc · Middletown, DES/N 911074-DN500HWHeliwild Investments LLC · Austin, TXBuilt 1978 · S/N 480294DN500MVTreeline Helicopters Inc · Bristol, TNBuilt 1977 · S/N 770156DN500NCSanders Associates LLC · Bluefield, VABuilt 1977 · S/N 1260052DN500TNOnespan Powerline Services LLC · Peachtree City, GABuilt 1979 · S/N 590521D
Back to AD 82-17-01