OpenAirDocs.org
AD 85-07-03 R1

Registered aircraft · 35

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:85-07-03-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:85-07-03-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.

N176MTDr Heli Acquistion LLC · Princeton, NJBuilt 2004 · S/N 6677N178MTTribeca Heli LLC · Princeton, NJBuilt 1998 · S/N 6527N17KBTrevor Corp · Grayslake, ILS/N 6526N234VMIntegrity Aircraft Title Holdings LLC · Portland, ORS/N 6548N247HHIntegrity Aircraft Title Holdings LLC · Portland, ORS/N 6529N276TCN276tc LLC · Chino, CABuilt 1980 · S/N 760061N282SArrow Aviation Company LLC · Broussard, LABuilt 1985 · S/N 760282N365JABank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 6585N365RTIntegrity Aircraft Title Holdings LLC · Portland, ORBuilt 2002 · S/N 6624N38MDBank Of Utah Trustee · Salt Lake City, UTBuilt 1989 · S/N 6335N403HHIntegrity Aircraft Title Holdings LLC · Portland, ORBuilt 1999 · S/N 6570N444KLIntegrity Aircraft Title Holdings LLC · Portland, ORBuilt 2008 · S/N 9010N444YUnion Airspeed LLC · Cincinnati, OHBuilt 2008 · S/N 6827N5294AArrow Aviation Co LLC · Broussard, LAS/N 760364N5415XConnecticut Air And Space Center · Stratford, CTBuilt 1981 · S/N 760199N576VPN576vp LLC · Chino, CABuilt 1980 · S/N 760040N600LLIntegrity Aircraft Title Holdings LLC · Portland, ORBuilt 1987 · S/N 6262N60609Turbines Ltd · West Point, NES/N 760077N6061CTurbines Ltd · West Point, NES/N 760229N644LHBank Of Utah Trustee · Salt Lake City, UTS/N 760170N666HHIntegrity Aircraft Title Holdings LLC · Portland, ORBuilt 1995 · S/N 6494N7266KGulf Helicopters LLC · Santa Fe, TXBuilt 1985 · S/N 760283N761MHMansfield Heliflight Inc · Milton, VTBuilt 1981 · S/N 760232N762MHGm Leasing Co LLC · Broussard, LAS/N 760233N763MHGm Leasing Co LLC · Broussard, LAS/N 760230N765MHGm Leasing Co LLC · Broussard, LABuilt 1983 · S/N 760236N768ALSikorsky Aircraft Corp · Stratford, CTS/N 760031N768MHGm Leasing Co LLC · Broussard, LABuilt 1981 · S/N 760189N769MHGm Leasing Co LLC · Broussard, LAS/N 760278N8063RTurbines Ltd · West Point, NES/N 760064N80EXIsland Express Holding Corp · Fillmore, CAS/N 760258N82MDBank Of Utah Trustee · Salt Lake City, UTBuilt 1998 · S/N 6550N896LLAnalar Corp · Princeton, NJBuilt 1988 · S/N 6294N90EVTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1984 · S/N 760264N97MDBank Of Utah Trustee · Salt Lake City, UTS/N 6330
Back to AD 85-07-03 R1