OpenAirDocs.org
AD 88-05-01 R1

Registered aircraft · 34

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:88-05-01-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:88-05-01-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 760335N280TRAircraft Guaranty Corporation Trustee · Oklahoma City, OKBuilt 1988 · S/N 760344N468ZBBrown 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 760312N61DJBlack Badge Aviation LLC · Carson City, NVBuilt 1991 · S/N 760380N751LLState 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 760410N7644SIslander Holdings Ltd · Ft Lauderdale, FLS/N 760314N768SXRentco LLC · Deer Park, TXBuilt 1991 · S/N 760372N76CGCsc 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 760353N844LCWarbirds-3 LLC · Kalispell, MTBuilt 1987 · S/N 760332N9082AArrow Aviation Co LLC · Broussard, LAS/N 760428N976ALBallard Aviation Inc · Newton, KSS/N 760439
Back to AD 88-05-01 R1