AD 2002-13-05

Registered aircraft · 484

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

N369TAHva Inc · Summersville, WVBuilt 1996 · S/N 0529EN369TRChehalem Helicopters LLC · Newberg, ORBuilt 1977 · S/N 570141DN369TVTennessee Valley Authority · Muscle Shoals, ALBuilt 2017 · S/N 0269FFN369WYReece Construction Company · Marysville, WABuilt 1981 · S/N 510976DN36FGCalifornia Department Of Fish & Wildlife · Sacramento, CABuilt 2020 · S/N 0322FFN36KRDragonfly Aviation LLC · Mirando City, TXBuilt 1978 · S/N 580315DN371PDCity Of Atlanta · Atlanta, GABuilt 2023 · S/N 0345FFN377LWPremier Helicopters LLC · Kalispell, MTS/N 0523EN383FJ&J Holdings And Investments LLC · Phoenix, AZBuilt 1990 · S/N 0440EN40090Bank Of Utah Trustee · Salt Lake City, UTS/N 0627EN400MBPrecision Heli-Support LLC · Mesa, AZBuilt 1990 · S/N 0420EN4010RBank Of Utah Trustee · Salt Lake City, UTS/N 0628EN40125N525gm LLC · Bozeman, MTBuilt 2020 · S/N 0625EN4037LSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 0589EN405ATRotor Blade LLC · Georgetown, SCBuilt 1980 · S/N 500717DN411JHHeidrick Joe · Woodland, CAS/N 0193EN411WJNorthwest 60 LLC · Kalispell, MTBuilt 2014 · S/N 0620EN415WCWilson Construction Co · Canby, ORBuilt 1981 · S/N 0005EN41AJEnglish Air Service LLC · Georgetown, TXBuilt 1978 · S/N 480299DN420KTRegistered aircraftBuilt 2008 · S/N 0582EN420WCWilson Construction Company · Canby, ORS/N 0579EN421KY250 Logistics LLC · Mount Pleasant, TXBuilt 2009 · S/N 0594EN421SPKentucky State Police · Frankfort, KYBuilt 2008 · S/N 0714FFN421VSVertol Systems Company Inc · Destin, FLS/N 1090592DN424WCWilson Construction Co · Canby, ORBuilt 1988 · S/N 0606FFN425WCWilson Construction Co Inc · Canby, ORS/N 0268EN4265JRatcliff Dustin · Saltville, VABuilt 1979 · S/N 790542DN4292DUrocopters Inc · Lancaster, CAS/N 0364EN42FFBeef Aviation LLC · Bradenton, FLBuilt 1984 · S/N 0141EN43BATerrell Bill · Port Orange, FLS/N 770160DN451HAIron Horse Aviation LLC · Marshalltown, IABuilt 1979 · S/N 490484DN454JHJack Harter Helicopters Inc · Lihue, HIBuilt 1991 · S/N 0454EN457GMCentury Aviation Inc Trustee · Wilmington, DEBuilt 2010 · S/N 0603EN458HWHeliwild Investments LLC · Austin, TXBuilt 1979 · S/N 390483DN458PBBarbaro Paul G · Argyle, TXBuilt 1985 · S/N 0123EN46662Brown Helicopter Inc · Pensacola, FLBuilt 1979 · S/N 590510DN469FCFerguson And Sons Construction LLC · Emmett, IDBuilt 1980 · S/N 1100854DN46EEUnited States Department Of Agriculture · Cedar City, UTBuilt 1990 · S/N 0406EN473EOchoco Wood Products LLC · Prineville, ORBuilt 1991 · S/N 0473EN484Bhh 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 611006DN4RRBlue Sky Air Services LLC · Wilmington, DEBuilt 2013 · S/N 0203FFN500ARHelicopter Roundup Service LLC · Nephi, UTS/N 0149EN500BHAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1998 · S/N 0537EN500DCHva Holdings LLC · Gettysburg, PABuilt 1978 · S/N 290456DN500EKKar Aviation LLC · Saltville, VABuilt 1979 · S/N 1190610DN500EVSnohomish County Sheriff · Snohomish, WABuilt 1989 · S/N 0340EN500FCFerguson And Sons Construction LLC · Emmett, IDBuilt 1983 · S/N 0442E
Back to AD 2002-13-05