OpenAirDocs.org
AD 2005-10-13

Registered aircraft · 1,224

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:2005-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:2005-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.

N321PERadnor Construction Of Delaware Inc · Allentown, PABuilt 1989 · S/N 0342EN322ECDivesa Aviation Services LLC · Missoula, MTBuilt 1977 · S/N 2218N324CMClarke Environmental Mosquito Management · Roselle, ILBuilt 1977 · S/N 2303N326MHMaritime Helicopters Inc · Homer, AKBuilt 1988 · S/N S-803N327MHMaritime Helicopters Inc · Homer, AKBuilt 1989 · S/N S813N32ENEnstrom Helicopter Corp · Menominee, MIBuilt 2025 · S/N 5260N32KYEnglish Air Service LLC · Santa Maria, CABuilt 1979 · S/N 2875N330THHuff Jon L · Corning, NYBuilt 1992 · S/N 0002N331MHKt Auburndale LLC · Panama City Beach, FLBuilt 1982 · S/N 3564N3324FSummit Sales & Leasing Inc · Salem, VABuilt 1964 · S/N 1735N332JPAeronautical Airmotive Modifications Inc · Biscayne Park, FLS/N 7358N333FCGolden Ranch Aviation Inc · Raceland, LABuilt 1975 · S/N 1763N333TABallard Aviation Inc · Newton, KSBuilt 1979 · S/N 590500DN334KCHawk Hollow Farm LLC · Brighton, MIBuilt 1994 · S/N 4303N335DMSmith Steven Lee · Whitehall, MTBuilt 1981 · S/N 3330N3399Scotts Helicopter Service · Le Sueur, MNBuilt 1968 · S/N 305N345RRChemair Helicopters Inc · Jefferson, WIBuilt 1977 · S/N 2107N346ERCibaoair Aviation Group Inc · Middletown, DEBuilt 1995 · S/N 4337N347MJam Zoom Yayos LLC · Manheim, PABuilt 1981 · S/N EA-253N34CTCorporate Auto Brokers Inc DBA · Cleveland, GABuilt 2001 · S/N 4545N3521TMbm Aviation Consultants Inc · Wilmington, DEBuilt 1979 · S/N 2703N3523TMoreau Robert D · Granbury, TXBuilt 1979 · S/N 2637N3528TR&B Helicopters Inc · Salinas, CABuilt 1981 · S/N 3516N353AHBank Of Utah Trustee · Salt Lake City, UTBuilt 1981 · S/N 811079DN355AGHover-Views Unlimited Inc · Syosset, NYBuilt 1982 · S/N 5109N355ERElite Rotorcraft LLC · Mt Juliet, TNBuilt 1990 · S/N 5436N355FFRichards William · Gardiner, NYBuilt 1982 · S/N 5133N355SFHowe Aviation LLC · Surprise, AZS/N 5054N355THTimberland Helicopters Inc · Ashland, ORBuilt 1981 · S/N 5111N357MCHillsborough County Board Of County Commissioners · Tampa, FLBuilt 1995 · S/N 4355N357MHAa Leasing Lp · Kilauea, HIBuilt 1982 · S/N 1171DN358RLTopside Aviation Inc · Brasstown, NCBuilt 1979 · S/N 2736N360JFCt Grain Systems LLC · Lewisburg, KYS/N 0031AN364KRWright Kris H · Idaho Falls, IDBuilt 1984 · S/N E2184N365JJtjl Leasing LLC · Cortez, COBuilt 2007 · S/N 4632N368CBAero Leasing LLC · Virden, ILBuilt 1975 · S/N 1655N369DRatcliff Dustin · Saltville, VABuilt 1977 · S/N 1070209DN369EDMonroe Helicopters LLC · Vestavia, ALBuilt 1978 · S/N 870167DN369EHApplebee Aviation Inc · Banks, ORBuilt 1980 · S/N 1200861DN369GSHellyer Aviation · Worland, WYBuilt 1973 · S/N 1230548SN369HAAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1976 · S/N 660821SN369HEN369he LLC · Wickenburg, AZBuilt 1969 · S/N 1090205EN369HSPurcell Ian · San Diego, CABuilt 1976 · S/N 850763SN369JHJack Harter Helicopters Inc · Lihue, HIBuilt 1985 · S/N 0145EN369KDDairy Air LLC · Scottsdale, AZBuilt 1983 · S/N 0037EN369KVAgricultural Air Services LLC · Jupiter, FLBuilt 1980 · S/N 300659DN369MHAa Leasing Lp · Kilauea, HIBuilt 1978 · S/N 380287DN369PBHelicopter Aviation Services & Leasing Inc · Miami, FLBuilt 1978 · S/N 480305DN369PDCity Of Atlanta · Atlanta, GABuilt 2001 · S/N 0721FFN369SDPyramid Property Development And Management LLC · Cedar Lake, INBuilt 2000 · S/N 0548E
Back to AD 2005-10-13