OpenAirDocs.org
AD 2002-04-07

Registered aircraft · 249

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-04-07')
    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-04-07')
  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.

N108TABristow LLC · Lake Charles, LABuilt 1998 · S/N 3080N109TALima Whiskey Alpha LLC · Missoula, MTBuilt 1998 · S/N 3103N111LNC Lou Leasing LLC · Mankato, MNBuilt 1984 · S/N 1602N113PHCherokee Helicopter Service LLC · Ford City, PABuilt 1980 · S/N 1298N114MXAir Resources Helicopters Inc · Salt Lake City, UTBuilt 1984 · S/N 1747N117HDUS Helicopters Inc · Marshville, NCS/N 3318N117TVU S Helicopters Inc · Marshville, NCBuilt 2012 · S/N 7464N119TVU S Helicopters Inc · Marshville, NCBuilt 1988 · S/N 2122N1231ATiny Bubbles Aviation Inc · Pacoima, CABuilt 2003 · S/N 3682N124LNAir Methods LLC · Greenwood Village, COBuilt 2006 · S/N 4130N124TXTexas Department Of Public Safety · Austin, TXBuilt 2008 · S/N 4405N125HDUS Helicopters Inc · Marshville, NCBuilt 2014 · S/N 7899N125SCStandard Aero (Alliance) Inc · Maryville, TNBuilt 2005 · S/N 3904N129TVUS Helicopters Inc · Marshville, NCBuilt 1996 · S/N 2897N12FQN12fq LLC · Helena, MTBuilt 2003 · S/N 3726N12NNAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 2008 · S/N 4579N12YJTiny Bubbles Aviation Inc · Pacoima, CABuilt 2008 · S/N 4443N134TVNexstar Broadcasting Inc · Albuquerque, NMBuilt 2007 · S/N 4291N135MCWings Up IV LLC · Allen Park, MIBuilt 2004 · S/N 3826N141THTemsco Helicopters Inc · Ketchikan, AKBuilt 1979 · S/N 1167N143GKN143gk LLC · Sheridan, WYBuilt 2002 · S/N 3606N145KKato Aviation LLC · Henderson, MNBuilt 1979 · S/N 1157N145THTemsco Helicopters Inc · Ketchikan, AKBuilt 2003 · S/N 9060N147THTemsco Helicopters Inc · Ketchikan, AKBuilt 2005 · S/N 9070N148THTemsco Helicopters Inc · Ketchikan, AKBuilt 2008 · S/N 4623N149THTemsco Helicopters Inc · Ketchikan, AKBuilt 2005 · S/N 9071N152RMBank Of Utah Trustee · Salt Lake City, UTBuilt 2001 · S/N 3422N1811FMaster Link Corp · Barceloneta, PRS/N 3430N183EHBristow LLC · Lake Charles, LABuilt 1993 · S/N 2752N184SDCounty Of Orange - Air Support · Costa Mesa, CAS/N 4009N193BHBlack Mountain Aviation LLC · Boulder City, NVBuilt 1995 · S/N 2894N197BHNevada Helicopter Leasing LLC · Greenwood Village, COBuilt 1992 · S/N 2666N1SDPinellas County Sheriffs Office · Clearwater, FLBuilt 2015 · S/N 8024N203CHCoastal Helicopters Inc · Juneau, AKBuilt 1981 · S/N 1430N204CHCoastal Helicopters · Juneau, AKBuilt 1981 · S/N 2054N2127SEurotec Vertical Flight Solutions LLC · Eudora, KSBuilt 1989 · S/N 2213N214EHBristow LLC · Lake Charles, LABuilt 1998 · S/N 3163N214GHCobalt Holdings Inc · Pacoima, CABuilt 1991 · S/N 2537N215EHBristow LLC · Lake Charles, LABuilt 1998 · S/N 3172N216CHCoastal Helicopters Inc · Juneau, AKBuilt 2002 · S/N 3619N216EHBristow LLC · Lake Charles, LABuilt 1999 · S/N 3184N217EHBristow LLC · Lake Charles, LABuilt 1999 · S/N 3197N217FDBristow LLC · Lake Charles, LABuilt 2007 · S/N 4221N220CFMercy Air Helicopter Inc · Fort Lauderdale, FLBuilt 2001 · S/N 3411N226PDAnaheim Police Dept · Fullerton, CABuilt 2004 · S/N 3879N228LACity Of Los Angeles · Los Angeles, CABuilt 2000 · S/N 3316N229LACity Of Los Angeles · Los Angeles, CABuilt 2000 · S/N 3317N234BUHeli-USA Corp · Houston, TXS/N 1210N244TXBrenthel Industries LLC · Helena, MTBuilt 2008 · S/N 4408N251HIsland Helicopters Kauai Inc · Lihue, HIBuilt 2005 · S/N 3975
Back to AD 2002-04-07