AD 2002-15-08

Registered aircraft · 1,064

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-15-08')
    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-15-08')
  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.

N155RBAerospace Trust Management LLC Trustee · Wilmington, DES/N 6583N155RDCastro Be LLC · Miami, FLBuilt 2000 · S/N 6580N157AEBoeing Company · Mesa, AZBuilt 2011 · S/N 7171N1603MCity Of San Antonio Texas · San Antonio, TXBuilt 2018 · S/N 8563N162GRReach Air Medical Services LLC · Lewisville, TXBuilt 2026 · S/N 9926N162TMSaberair LLC · Englewood, COBuilt 2019 · S/N 8654N167MTAnalar Corp · Princeton, NJS/N 5604N168BHBhi Holdings #1 LLC · Ontario, ORBuilt 2018 · S/N 8613N16NSNs Air Leasing LLC · Wilmington, DES/N 7383N172AEUS Department Of Homeland Security · Washington, DCBuilt 2004 · S/N 3839N173BHBhh Leasing #4 LLC · Pensacola, FLBuilt 2009 · S/N 4614N174AHAres Air LLC · Phoenix, AZBuilt 2022 · S/N 9121N175AEMainstream Investment LLC · Tavernier, FLBuilt 2004 · S/N 1389N175SCSeminole County Sheriffs Office · Sanford, FLBuilt 2017 · S/N 8430N176MTDr Heli Acquistion LLC · Princeton, NJBuilt 2004 · S/N 6677N176SCSeminole County Sheriffs Office · Sanford, FLBuilt 2024 · S/N 9495N178MTTribeca Heli LLC · Princeton, NJBuilt 1998 · S/N 6527N179AAirbus Helicopters Inc · Grand Prairie, TXS/N 9996N179MTAnalar Corp · Princeton, NJS/N 5183N17KBTrevor Corp · Grayslake, ILS/N 6526N180QDepartment Of Homeland Security · Washington, DCBuilt 2020 · S/N 8815N1811FMaster Link Corp · Barceloneta, PRS/N 3430N181PLAlpine Air Alaska LLC · Girdwood, AKBuilt 2014 · S/N 7812N183AEU S Dept Of Homeland Security · Washington, DCS/N 3852N183EHBristow LLC · Lake Charles, LABuilt 1993 · S/N 2752N183SDOrange County Sheriff'S Department · Costa Mesa, CABuilt 2017 · S/N 8376N184RDepartment Of Homeland Security · Washington, DCBuilt 2022 · S/N 9158N184SDCounty Of Orange - Air Support · Costa Mesa, CAS/N 4009N185SDOrange County Sheriff'S Department · Costa Mesa, CABuilt 2016 · S/N 8125N186AEUS Department Of Homeland Security · Washington, DCBuilt 2004 · S/N 3872N187AEUS Department Of Homeland Security · Washington, DCBuilt 2004 · S/N 3846N188EULashinski Robert D Trustee · Sebastopol, CABuilt 2011 · S/N 7188N191NRMaryland Natural Resources Police · Stevensville, MDBuilt 2023 · S/N 9382N191TXTexas Dept Of Public Safety · Austin, TXBuilt 2010 · S/N 4841N192ADepartment Of Homeland Security · Washington, DCBuilt 2011 · S/N 7184N193BHBlack Mountain Aviation LLC · Boulder City, NVBuilt 1995 · S/N 2894N194AETemsco Helicopters Inc · Ketchikan, AKBuilt 2001 · S/N 3338N1964LDepartment Of Homeland Security · Washington, DCBuilt 2022 · S/N 9179N1977GDepartment Of Homeland Security · Washington, DCBuilt 2022 · S/N 9192N197BHNevada Helicopter Leasing LLC · Greenwood Village, COBuilt 1992 · S/N 2666N198AETemsco Helicopters Inc · Ketchikan, AKBuilt 2001 · S/N 3371N1997GAirbus Helicopters Inc · Grand Prairie, TXS/N 9970N1CRComanche Maverick Air LLC · Houston, TXBuilt 2016 · S/N 8165N1MZA Star 350 LLC · Henderson, NVS/N 7300N1SDPinellas County Sheriffs Office · Clearwater, FLBuilt 2015 · S/N 8024N202PBCalpass Corp · Del Mar, CABuilt 2000 · S/N 1084N202SCNs Air Leasing LLC · Wilmington, DEBuilt 1982 · S/N 5204N203CHCoastal Helicopters Inc · Juneau, AKBuilt 1981 · S/N 1430N203ZDepartment Of Homeland Security · Washington, DCBuilt 2020 · S/N 8811N204CHCoastal Helicopters · Juneau, AKBuilt 1981 · S/N 2054
Back to AD 2002-15-08