AD 75-06-01

Registered aircraft · 2,832

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:75-06-01')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:75-06-01')
  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.

N262AGMcneely Charter Service Inc · West Memphis, ARBuilt 1985 · S/N SH3120N263CWAir Pard LLC · Baton Rouge, LABuilt 2003 · S/N 263N263JCAllen Chorman & Son Inc · Milton, DEBuilt 2004 · S/N T34HG-105N263RSNorthern Sky Leasing LLC · Middletown, DEBuilt 1995 · S/N 112N264B264b LLC · Wilmington, DEBuilt 2001 · S/N 46-97028N264BRKeller James B · Palo Alto, CABuilt 2023 · S/N K038N264DKStonewall Aviation LLC · Murfreesboro, TNBuilt 2019 · S/N 100-0264N265KQRyffel Aviation LLC · Fort Worth, TXBuilt 2019 · S/N 100-0265N266RDGuardian Flight LLC · Lewisville, TXBuilt 2001 · S/N LJ-1633N267KQFp Winters LLC · Newark, DEBuilt 2019 · S/N 100-0267N269MVMavi8 LLC · Sedona, AZFirst renewal noticeBuilt 2015 · S/N 100-0148N26EDynamic Avlease Inc · Bridgewater, VAS/N LW-62N26TGKenmore Crew Leasing Inc Trustee · Bellingham, WABuilt 1999 · S/N 4636193N270CLRegistration Pending · Chesterfield, MORegistration pendingBuilt 1990 · S/N 208B0232N271SMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2005 · S/N 622N271ZRegistration Pending · Helena, MTRegistration pendingBuilt 2023 · S/N 4698271N272GXFreedom Aviation LLC · Anaconda, MTBuilt 2024 · S/N K072N272ZZBig Flats LLC · Durham, NCBuilt 1943 · S/N 25509(43-48248)N274PMPlanemasters Ltd · West Chicago, ILFirst renewal noticeBuilt 1998 · S/N 208B0705N275LARts Ventures LLC · San Antonio, TXBuilt 1992 · S/N LJ1275N275LHProject Tango Inc Trustee · Wilmington, DEBuilt 2001 · S/N 200N276JBChris Allen Aviation LLC · Naples, FLBuilt 1998 · S/N FL-219N276MABank Of Utah Trustee · Salt Lake City, UTBuilt 1998 · S/N 20800276N277GERltwf LLC · Fiddletown, CABuilt 1990 · S/N BB-1389N277GLDiamondback Equipment Leasing LLC · Avondale, AZBuilt 1991 · S/N BB-1406N278JLarkin Matthew W · Lafayette, CABuilt 2002 · S/N 4697127N278SWTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1982 · S/N LJ-1011N279KQLmg-Rba LLC · Georgetown, TXBuilt 2019 · S/N 100-0279N27BFJab Air LLC · Ponte Vedra Beach, FLBuilt 1981 · S/N 31T-8104038N27BNTravelaire Service Inc · Wilmington, DES/N BB-1268N27MGAvion Capital Corp · Anchorage, AKBuilt 1997 · S/N 208B0650N280SPSan Pablito Ranch Aviation LLC · Hebbronville, TXBuilt 2000 · S/N BB-1740N280TRAircraft Guaranty Corporation Trustee · Oklahoma City, OKBuilt 1988 · S/N 760344N282PMPlanemasters Ltd · West Chicago, ILBuilt 2002 · S/N 208B0981N283JDDurham Aircraft LLC · Port Aransas, TXBuilt 1991 · S/N FL-69N283PMPlanemasters Ltd · West Chicago, ILBuilt 1999 · S/N 208B0774N284PMArtic Legacy Aviation LLC · Anchorage, AKBuilt 1977 · S/N LJ734N285KCCourt Reporter Assignments Inc · Bullhead City, AZBuilt 2023 · S/N 4698285N285PBBank Of Utah Trustee · Salt Lake City, UTBuilt 2004 · S/N 585N285RBButler National Inc · New Century, KSBuilt 1999 · S/N FL-264N286PMPlanemasters Ltd · West Chicago, ILBuilt 1997 · S/N 208B0631N287JJA L S A P Enterprises LLC · Missoula, MTBuilt 2020 · S/N 100-0287N288AFMod-Pac Corp · Portsmouth, NHBuilt 2023 · S/N 2288N288ATN38ry LLC · California, MDBuilt 1987 · S/N FA134N289ATN999mg LLC · California, MDBuilt 1991 · S/N FL-65N289PCTuca 27 LLC · Lewes, DEBuilt 1991 · S/N 546N28ANPa1 208b-0751 LLC · Fort Lauderdale, FLBuilt 1999 · S/N 208B0751N28NRJaars Inc · Waxhaw, NCBuilt 2009 · S/N 100-0024N28VRPajaro 195 LLC · Fort Worth, TXBuilt 1996 · S/N BB-1540N2904GMec Aviation Kodiak LLC · Gainesville, GABuilt 2020 · S/N 100-0290
Back to AD 75-06-01