OpenAirDocs.org
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.

N125CLHillsboro Aviation Inc · Hillsboro, ORBuilt 2015 · S/N 7987N125DAPayne David L Trustee · Saint Louis, MOBuilt 2022 · S/N 9154N125EPEnbridge Energy Co Inc · Houston, TXBuilt 2019 · S/N 8650N125HDUS Helicopters Inc · Marshville, NCBuilt 2014 · S/N 7899N125NBCisco Aero LLC · Grass Range, MTBuilt 2022 · S/N 9318N125NYOffice Of Vector Surveillance And Control · New York, NYBuilt 2019 · S/N 8745N125PDCity Of Albuquerque · Albuquerque, NMBuilt 2019 · S/N 8667N125SCStandard Aero (Alliance) Inc · Maryville, TNBuilt 2005 · S/N 3904N126BHBhi Holdings #2 LLC · Ontario, ORBuilt 2012 · S/N 7403N126PJHelibro LLC · Red Bluff, CABuilt 2010 · S/N 7039N127ABApexheli Oregon Inc · Florence, ORBuilt 2000 · S/N 3331N127BHBhi Holdings #3 LLC · Ontario, ORBuilt 2013 · S/N 7675N127PJHelibro LLC · Red Bluff, CABuilt 2011 · S/N 7180N129NBPathfinder Leasing LLC · Anchorage, AKBuilt 2017 · S/N 8397N129TVUS 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 4579N12NYNew York Aircam Corp · Woodbury, NYBuilt 2018 · S/N 8594N12TVImportant Matters LLC · Leesburg, VABuilt 2008 · S/N 1569N12YJTiny Bubbles Aviation Inc · Pacoima, CABuilt 2008 · S/N 4443N132BHBrainerd Helicopters Inc · Leesburg, FLBuilt 2007 · S/N 4374N132TVU S Helicopters Inc · Marshville, NCBuilt 1982 · S/N 1636N134TVNexstar Broadcasting Inc · Albuquerque, NMBuilt 2007 · S/N 4291N135MBSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2007 · S/N 1521N135MCWings Up IV LLC · Allen Park, MIBuilt 2004 · S/N 3826N137AHCity Of Dallas · Dallas, TXBuilt 2025 · S/N 9672N140PJHelibro LLC · Red Bluff, CAS/N 8646N141PJHelibro LLC · Red Bluff, CABuilt 2023 · S/N 9368N141THTemsco Helicopters Inc · Ketchikan, AKBuilt 1979 · S/N 1167N142SHNbs Equipment Leasing LLC · Bixby, OKBuilt 2005 · S/N 1392N143GKN143gk 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 9070N14806Pinellas County · Clearwater, FLBuilt 2023 · S/N 9341N148SCHeli Inc · Miami, FLBuilt 2006 · S/N 1469N148THTemsco Helicopters Inc · Ketchikan, AKBuilt 2008 · S/N 4623N149AETemsco Helicopters Inc · Ketchikan, AKBuilt 2001 · S/N 3370N149THTemsco Helicopters Inc · Ketchikan, AKBuilt 2005 · S/N 9071N151ADAtlantic Coast Maintenance · Palm Coast, FLS/N 1173N151AEPhi Health LLC · Tempe, AZBuilt 2004 · S/N 3814N151HHangar One Avionics Inc · Carlsbad, CABuilt 2024 · S/N 9647N151RGRegistered aircraftBuilt 2010 · S/N 7049N151RMBank Of Utah Trustee · Salt Lake City, UTBuilt 1999 · S/N 3234N152RMBank Of Utah Trustee · Salt Lake City, UTBuilt 2001 · S/N 3422N153AEPhi Health LLC · Tempe, AZBuilt 2004 · S/N 3829N153AHNorton Basin Services · Nome, AKBuilt 2022 · S/N 9272N153RMSls Aviation Capital 1 LLC · Newark, DEBuilt 2012 · S/N 7495N154RPA S K Equipment Leasing LLC · Cumming, GABuilt 2021 · S/N 8954N155JECjb Equipment Leasing LLC · Naples, FLBuilt 2003 · S/N 6633
Back to AD 2002-15-08