OpenAirDocs.org
AD 88-03-01

Registered aircraft · 49

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-03-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:88-03-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.

N1079UTurbines Ltd · West Point, NEBuilt 1980 · S/N 31122N119WGHigh Performance Helicopters Corp · Crestline, CABuilt 2005 · S/N 14502N121CMSpace Coast Aircraft Co · Merritt Island, FLBuilt 1993 · S/N 208B0336N141MHCinema Aircraft Executive Transportation LLC · Las Vegas, NVBuilt 1997 · S/N 760465N159CMMomentum Foundation Inc · Tullahoma, TNBuilt 1987 · S/N 760333N176BAIslander Holdings Ltd · Fort Lauderdale, FLBuilt 1985 · S/N 760317N208SSugar Pine Aviation LLC · Merlin, ORBuilt 1992 · S/N 760399N212HBBritt Christopher Charles · Bryan, TXBuilt 1982 · S/N 31214N212HPCorpat Inc · Missoula, MTBuilt 1979 · S/N 30951N212YS76b LLC · New York, NYBuilt 1989 · S/N 760357N249HVertol Systems Co Inc · Destin, FLBuilt 1993 · S/N 35061N280TRAircraft Guaranty Corporation Trustee · Oklahoma City, OKBuilt 1988 · S/N 760344N307SBSan Bernardino County Sheriffs Aviation Division · San Bernardino, CABuilt 1975 · S/N 30781N316PDLonghorn Air LLC · Wilmington, DEBuilt 2003 · S/N 14038N319PDAerotrust Services Corp Trustee · Wilmington, DEBuilt 2004 · S/N 14040N386AFBank Of Utah Trustee · Portsmouth, NHBuilt 2024 · S/N 2386N397ALVertol Systems Co LLC · Wilmington, DEBuilt 1990 · S/N 36012N413AFBerry Genetics Inc · Portsmouth, NHBuilt 2024 · S/N 2413N432WAWoodley Aerial Leasing LLC · Walnut, ILS/N 400-0435N468ZBBrown Helicopter Inc · Pensacola, FLBuilt 1988 · S/N 760345N473QHBrown Helicopter Inc · Pensacola, FLBuilt 1986 · S/N 760331N58CMCrystal Motorsports LLC · Crystal River, FLS/N 14030N58SAircrane Inc · Winder, GABuilt 1962 · S/N 58-1539N61DJBlack Badge Aviation LLC · Carson City, NVBuilt 1991 · S/N 760380N622FCRegistered aircraftN-number assigned, not yet registeredS/N 35048N626FCFlorida Department Of Agriculture And Consumer · Tallahassee, FLBuilt 1995 · S/N 35088N666JMBank Of Utah Owner Trustee · Salt Lake City, UTBuilt 2025 · S/N 2468N6925YPleasant Aviation LLC · Mount Pleasant, TXBuilt 1978 · S/N GM-94N7125NKsnl Aero LLC · Shawnee, OKBuilt 2015 · S/N 208B5235N760JEIslander Holdings Ltd · Fort Lauderdale, FLBuilt 1997 · S/N 760462N761CGCoulson 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 760367N7TPDt Connect II LLC · New York, NYBuilt 1989 · S/N 760353N813DGBristow LLC · Lake Charles, LABuilt 2006 · S/N 31032N822MMBristow LLC · Lake Charles, LABuilt 2005 · S/N 14055N860AR412 Jw Aviation LLC · Dover, DEBuilt 1990 · S/N 36019N8817QRuhe Sales LLC · Leipsic, OHBuilt 1970 · S/N 1517RN911HWRogers Helicopters Inc · Fresno, CABuilt 1980 · S/N 31101N911KWRogers Helicopters Inc · Fresno, CABuilt 1973 · S/N 30592N911VRRogers Helicopters Inc · Fresno, CABuilt 1980 · S/N 30998N9122ZIntermountain Helicopter Inc · Sonora, CABuilt 1975 · S/N 30716N969JVGgm Transport LLC · Bakersfield, CABuilt 2022 · S/N 1440
Back to AD 88-03-01