OpenAirDocs.org
AD 87-03-06 R1

Registered aircraft · 181

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-03-06-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-03-06-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.

N8226ZUas Transervices Inc · Boca Raton, FLBuilt 1982 · S/N U-190N8227PUas Transervices Inc · Boca Raton, FLBuilt 1982 · S/N U-194N847DBank Of Utah Trustee · Salt Lake City, UTBuilt 1980 · S/N BE-91N86NBClairmont Holdings Vi LLC · St Thomas, VIS/N B166N87NWAlbatross Air Inc · Beaver, WVBuilt 1978 · S/N BE-42N88FARegistration Pending · Helena, MTRegistration pendingBuilt 1979 · S/N BE-74N899CAAlpine Aviation Inc · Provo, UTBuilt 1969 · S/N U-104N899CZN899cz LLC · Milwaukee, WIS/N U-96N902VDDavis Aviation Inc · Brandon, MSS/N B-201N91RKAir Flight Inc · Fort Lauderdale, FLBuilt 1976 · S/N B-226N93GTDodson International Parts Inc · Rantoul, KSBuilt 1974 · S/N B-179N93SFArctic Legacy Aviation LLC · Anchorage, AKBuilt 1976 · S/N BE-13N93VDAbsl Construction · Hayward, CABuilt 1972 · S/N B-118N93WTWes Tex Drilling Company · Abilene, TXBuilt 1979 · S/N BE-80N948HBNew Mountain Aviation LLC · Englewood, COBuilt 1980 · S/N BE-98N950AAAlpine Aviation Inc · Provo, UTBuilt 1974 · S/N U-159N953RCRmc Aviation LLC · Trumann, ARBuilt 1980 · S/N BE-94N95WAAlpine Aviation Inc · Provo, UTBuilt 1968 · S/N U-6N96AVUas Transervices Inc · Boca Raton, FLBuilt 1983 · S/N U-201N980VCN980vc Corp · Wilmington, DEBuilt 1977 · S/N BE19N98TACentral Virginia Aviation Inc · Petersburg, VABuilt 1978 · S/N BE-56N990AFUas Transervices Inc · Boca Raton, FLBuilt 1983 · S/N U-211N991AFUas Transervices Inc · Boca Raton, FLS/N U-214N991AKLake Clark Air Inc · Port Alsworth, AKBuilt 1982 · S/N U-189N992AFUas Transervices Inc · Boca Raton, FLBuilt 1983 · S/N U-203N992AKLake Clark Air Inc · Port Alsworth, AKBuilt 1981 · S/N U-167N993AKLake Clark Air Inc · Ports Alsworth, AKBuilt 1982 · S/N U-180N997SBUas Transervices Inc · Boca Raton, FLBuilt 1982 · S/N U-192N999CZN999cz LLC · Milwaukee, WIBuilt 1969 · S/N U116N999DZAlpine Aviation Inc · Provo, UTBuilt 1968 · S/N U70N99GHAlpine Aviation Inc · Provo, UTS/N U-112
Back to AD 87-03-06 R1