OpenAirDocs.org
AD 2002-13-05 R1

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-R1')
    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-R1')
  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.

N593CK & S Helicopters Inc · Kailua Kona, HIS/N 201EN594DBDeland Air And Sea Brokerage Inc · Deland, FLBuilt 1982 · S/N 1169DN59CPAtomic Eft LLC · Scottsdale, AZBuilt 2008 · S/N 0591EN59SDInternational Air Services Inc Trustee · Carson City, NVBuilt 1983 · S/N 0019EN600FHFatv LLC · Henderson, NVS/N 0600EN60556Usda Aphis Ws Atoc · Cedar City, UTS/N 0256FFN6062MUsda Aphis Ws Atoc · Cedar City, UTS/N 0262FFN6063PUsda Aphis Ws Atoc · Cedar City, UTS/N 0263FFN6065NUsda Aphis Ws Atoc · Cedar City, UTS/N 0223FFN6068TUsda Aphis Ws Atoc · Cedar City, UTS/N 0215FFN6084UUsda Aphis Ws · Cedar City, UTBuilt 2023 · S/N 0341FFN6100NUsda Aphis Ws Atoc · Cedar City, UTS/N 0216FFN622PBPope James · Lewiston, IDBuilt 1978 · S/N 880318DN62UCCbft LLC · Mobile, ALBuilt 1979 · S/N 1090594DN630NBank Of Utah Trustee · Salt Lake City, UTBuilt 1984 · S/N 0004FN633JHJack Harter Helicopters Inc · Lihue, HIBuilt 1987 · S/N 0230EN64RSRainbow Air Inc · Niagara Falls, NYBuilt 1989 · S/N 0320EN651RPPeasant Air LLC · Parkersburg, WVBuilt 2008 · S/N 0583EN65CRWinco Inc · Aurora, ORBuilt 1976 · S/N 1160011DN66SDEnforcement Aviation Services Inc · Midway City, CABuilt 1985 · S/N 0147EN67FFSummit Helicopter Inc · Pacoima, CABuilt 1989 · S/N 0067FFN67HFPadgett Ag Rotors LLC · Missoula, MTBuilt 1978 · S/N 1280403DN681HBCity Of Huntington Beach · Huntington Beach, CABuilt 2022 · S/N 0335FFN682HBCity Of Huntington Beach · Huntington Beach, CABuilt 2022 · S/N 0336FFN683HBCity Of Huntington Beach · Huntington Beach, CABuilt 2022 · S/N 0337FFN690PDBoard Of Police Commissioners · Kansas City, MOBuilt 2012 · S/N 0613EN690WAWindward Aviation Inc · Puunene, HIBuilt 1978 · S/N 1170237DN691PDBoard Of Police Commissioners · Kansas City, MOBuilt 2012 · S/N 0611EN692PDBoard Of Police Commissioners · Kansas City, MOBuilt 2012 · S/N 0612EN69DVTripwire South LLC · Gettysburg, PABuilt 1981 · S/N 410950DN69GECbft LLC · Mobile, ALBuilt 1990 · S/N 0394EN69NWNorthwest Helicopters LLC · Olympia, WABuilt 1990 · S/N 0435EN69PFSanders Associates LLC · Bluefield, VAS/N 1060012DN700CBChesapeake Bay Helicopters Inc · Chesapeake, VABuilt 1977 · S/N 170074DN701KPKp Properties LLC · Auburn, WAS/N 1280417DN702SH702sh LLC · Kalispell, MTBuilt 1978 · S/N 1280404DN7032CBoeing Co · Mesa, AZBuilt 2000 · S/N 0141FFN705KPOceans Alaska LLC · Dover, DEBuilt 1996 · S/N 0530EN705MPSmith Mark K DBA · Hubertus, WIBuilt 1990 · S/N 0405EN7079KDah Aircraft LLC · Georgetown, SCBuilt 1981 · S/N 610988DN711KVAa Leasing Lp · Kilauea, HIBuilt 1977 · S/N 1070212DN715KVAa Leasing Lp · Kilauea, HIBuilt 1979 · S/N 490487DN7168FHelicopter Minit Men Inc · Columbus, OHBuilt 1977 · S/N 570131DN716CBCbhelos LLC · Chesapeake, VABuilt 1980 · S/N 500701DN716KVAa Leasing Lp · Lihue, HIBuilt 1990 · S/N 0407EN719KVAa Leasing Lp · Kilauea, HIBuilt 1979 · S/N 890579DN721RPRatcliff Dustin · Saltville, VABuilt 1981 · S/N 310918DN724HKHawkeye Helicopter LLC · Lyndon, KSBuilt 2000 · S/N 0553EN725MAviation Advantage Inc · Tabor City, NCBuilt 1980 · S/N 500726DN734HHHlh Leasing LLC · Wilmington, DEBuilt 1980 · S/N 200677D
Back to AD 2002-13-05 R1