OpenAirDocs.org
AD 87-23-07 R1

Registered aircraft · 53

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:87-23-07-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:87-23-07-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.

N11110Arrow Aviation Co LLC · Broussard, LAS/N 760429N120DTIflyajet Inc · Lawrenceville, GABuilt 1990 · S/N 760362N141MHCinema Aircraft Executive Transportation LLC · Las Vegas, NVBuilt 1997 · S/N 760465N159CMMomentum Foundation Inc · Tullahoma, TNBuilt 1987 · S/N 760333N164AMIslander Holdings Ltd · Fort Lauderdale, FLBuilt 1994 · S/N 760427N176BAIslander Holdings Ltd · Fort Lauderdale, FLBuilt 1985 · S/N 760317N176DPDodson International Parts Inc · Rantoul, KSS/N 760356N208SSugar Pine Aviation LLC · Merlin, ORBuilt 1992 · S/N 760399N212YS76b LLC · New York, NYBuilt 1989 · S/N 760357N269FLBlackbird Aero LLC · Boca Raton, FLBuilt 1987 · S/N 760335N276TCN276tc LLC · Chino, CABuilt 1980 · S/N 760061N280TRAircraft Guaranty Corporation Trustee · Oklahoma City, OKBuilt 1988 · S/N 760344N282SArrow Aviation Company LLC · Broussard, LABuilt 1985 · S/N 760282N468ZBBrown Helicopter Inc · Pensacola, FLBuilt 1988 · S/N 760345N473QHBrown Helicopter Inc · Pensacola, FLBuilt 1986 · S/N 760331N473WBSale Reported · Orlando, FLSale reportedBuilt 1992 · S/N 760409N509HHCoulson Aviation (USA) Inc · Portland, ORS/N 760312N5294AArrow Aviation Co LLC · Broussard, LAS/N 760364N5415XConnecticut Air And Space Center · Stratford, CTBuilt 1981 · S/N 760199N576VPN576vp LLC · Chino, CABuilt 1980 · S/N 760040N60609Turbines Ltd · West Point, NES/N 760077N6061CTurbines Ltd · West Point, NES/N 760229N61DJBlack Badge Aviation LLC · Carson City, NVBuilt 1991 · S/N 760380N644LHBank Of Utah Trustee · Salt Lake City, UTS/N 760170N7266KGulf Helicopters LLC · Santa Fe, TXBuilt 1985 · S/N 760283N751LLState Of Illinois · Springfield, ILS/N 760318N760GPIndustrial Integrity Solutions LLC · Ontario, CABuilt 1996 · S/N 760448N760JEIslander Holdings Ltd · Fort Lauderdale, FLBuilt 1997 · S/N 760462N760PVSikorsky Aircraft Corp · Stratford, CTBuilt 1994 · S/N 760425N761CGCoulson Aviation (USA) Inc · Portland, ORBuilt 1994 · S/N 760410N761MHMansfield Heliflight Inc · Milton, VTBuilt 1981 · S/N 760232N762MHGm Leasing Co LLC · Broussard, LAS/N 760233N763MHGm Leasing Co LLC · Broussard, LAS/N 760230N7644SIslander Holdings Ltd · Ft Lauderdale, FLS/N 760314N765MHGm Leasing Co LLC · Broussard, LABuilt 1983 · S/N 760236N768ALSikorsky Aircraft Corp · Stratford, CTS/N 760031N768MHGm Leasing Co LLC · Broussard, LABuilt 1981 · S/N 760189N768SXRentco LLC · Deer Park, TXBuilt 1991 · S/N 760372N769MHGm Leasing Co LLC · Broussard, LAS/N 760278N76CGCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1989 · S/N 760355N76DNFastboy Equipment LLC · Beasley, TXS/N 760351N76EXIsland Express Helicopters Inc · Henderson, NVBuilt 1988 · S/N 760342N76FLHelinet Aviation Services LLC · Van Nuys, CABuilt 1988 · S/N 760347N76VRArrow Aviation Co LLC · Broussard, LABuilt 1989 · S/N 760360N776DPDelaware Park LLC · Wilmington, DEBuilt 1991 · S/N 760367N780JCoulson Aviation (USA) Inc · Portland, ORS/N 760352N7TPDt Connect II LLC · New York, NYBuilt 1989 · S/N 760353N8063RTurbines Ltd · West Point, NES/N 760064N80EXIsland Express Holding Corp · Fillmore, CAS/N 760258N844LCWarbirds-3 LLC · Kalispell, MTBuilt 1987 · S/N 760332
Back to AD 87-23-07 R1