OpenAirDocs.org
AD 2002-10-13

Registered aircraft · 562

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-10-13')
    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-10-13')
  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.

N66HWStender Aviation D LLC · Huntsville, ALBuilt 1980 · S/N P-559N66PLValiair Lc Trustee · Casper, WYBuilt 1980 · S/N P-532N66WZBowing Vending Co Inc · Louisville, TNBuilt 1980 · S/N TJ-321N6731ZJerry Slough Aviation LLC · Bakersfield, CAFirst renewal noticeBuilt 1980 · S/N TJ-255N6739CPearce William · Grants Pass, ORBuilt 1980 · S/N TJ-262N6743CRocket Ems Inc · Santa Clara, CABuilt 1980 · S/N TJ-269N6752XIyer Vijay · Mammoth Lakes, CABuilt 1980 · S/N TJ-276N678AJAj Air LLC · Brookfield, WIBuilt 1975 · S/N P363N67ERWhitfield Michael L · Leander, TXBuilt 1976 · S/N TJ-43N68BBKorney Eugene A Trustee · Los Angeles, CABuilt 1981 · S/N TJ-317N68CRAeronation Aircrft & Exotics LLC · Lewes, DEBuilt 1972 · S/N P-211N68EBGayler Larry G · Thermal, CABuilt 1972 · S/N P-207N691JHSb Airlines Inc · Wilmington, DEBuilt 1985 · S/N TJ-480N693BHRed River Cellular Telephone Corp · Texarkana, ARBuilt 1980 · S/N TJ-294N699BBProfi-Vision Inc · Fogelsville, PABuilt 1981 · S/N TJ-334N69LCConsol Air Inc · Youngsville, NCS/N TJ-438N6ED3 Rivers Inc · St George, UTS/N TJ-9N6LWN195sd LLC · Senatobia, MSBuilt 1975 · S/N P-323N700VRMountain & Vine LLC · Park City, UTBuilt 1979 · S/N TJ-194N7029DLang Ronald J · Middleburg, VABuilt 1968 · S/N P-11N7071DGottschall Kenneth Lee III · Santa Paula, CABuilt 1969 · S/N P-115N7079DYang Chin-Yuh · West Covina, CAS/N P-39N707MPEmmet Street Holdings LLC · Saint Petersburg, FLBuilt 1978 · S/N TJ-166N707TSShortt Aircraft Leasing LLC · South Lyon, MIBuilt 1981 · S/N P-564N710PAMartin Frank S · Overton, NVS/N P-152N711AAPro-Star Aeronautical Inc · Morrison, COBuilt 1977 · S/N P-417N712J4j Aviation LLC · Perryton, TXBuilt 1975 · S/N P-327N712LSDwyer Stephen C · The Woodlands, TXBuilt 1979 · S/N TJ-192N713VUhlik Daniel · Delano, CABuilt 1968 · S/N P-16N717VSJacobs John D · Chicago, ILBuilt 1977 · S/N P-433N7197DJ And J Farming LLC · Halsey, ORBuilt 1969 · S/N P-70N71WWLarson Christopher L · Sheboygan, WIBuilt 1981 · S/N P-567N72006Detmer Darren D · Chappell Hill, TXBuilt 1984 · S/N TJ-460N7202MG&M Baron Aviation LLC · Bradenton, FLS/N TJ-456N7204EOverit Air LLC · Las Vegas, NVBuilt 1984 · S/N TJ-457N7205EAl Force 1 LLC · North Salt Lake, UTBuilt 1984 · S/N TJ-458N720PMPeter J Messina & Associates Ltd · West Chicago, ILBuilt 1977 · S/N P-449N721TRDe Anza Building & Maintenance Inc · Los Altos, CABuilt 1981 · S/N P-571N7222LAllmon William C · Las Vegas, NVFirst renewal noticeS/N TJ-484N7225HCosmo Plastics Company · Pepper Pike, OHBuilt 1985 · S/N TJ-485N7243ABc Express LLC · Santa Barbara, CAS/N TJ-494N724BDEdelson David · New York, NYBuilt 1980 · S/N TJ-266N724RKChasing Ace LLC · Cresson, TXBuilt 1981 · S/N P-583N726BADangerstik Corp · Olympic Valley, CABuilt 1979 · S/N TJ-214N726TJJohnstone Thomas T · Panama City, FLBuilt 1976 · S/N TJ-80N727LTFoster Jeffrey · Baton Rouge, LABuilt 1980 · S/N TJ-313N729BCNeedy LLC · Maud, OKBuilt 1973 · S/N P-254N72CGGarvin Carroll E · Scottsdale, AZBuilt 1980 · S/N TJ-264N72SCLsa Aircraft Holdings LLC · Houston, TXBuilt 1984 · S/N TJ-477N737EDDuke Group LLC · Port Clinton, OHFirst renewal noticeS/N P-185
Back to AD 2002-10-13