AD 87-20-03 R2

Registered aircraft · 54,015

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-20-03-R2')
    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-20-03-R2')
  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.

N9732AMoremen Joshua · Sagle, IDBuilt 1949 · S/N 19193N9732GFulcher David B · Glendale, AZBuilt 1971 · S/N 18052232N9732HLand & Leave LLC · Helena, MTBuilt 1975 · S/N 17266340N9732VSiguaw Robert E · Deming, WABuilt 1974 · S/N 17264496N9733ACloud Dancer Aviation Inc · Deland, FLBuilt 1978 · S/N 15281329N9733GZimmitti Andrew · Mclean, VAS/N 18052233N9733HStephens Jack J · Kingwood, TXBuilt 1981 · S/N 18267980N9733LStock Craig A · Devon, PABuilt 1986 · S/N 17276604N9733VTyler Ronald J · Martville, NYBuilt 1974 · S/N 17264497N97345Postupack Peter Jr · New Cumberland, PABuilt 1979 · S/N 18267063N9734AGreen Theodore G II · Burlington, WIBuilt 1949 · S/N 19195N9734BPreston Aviation LLC · Henderson, KYBuilt 1981 · S/N 172RG0999N97358Rick Aviation Inc · Newport News, VABuilt 1984 · S/N 17276180N9735XPascal LLC · Des Moines, WAS/N 21058035N97361Sky 4 Me LLC · Greendale, WIS/N 18267067N97365Sugg Robert Michael · Covington, GABuilt 1979 · S/N 18267069N9736BWrigley David C · Anchorage, AKBuilt 1964 · S/N 50034N9736GBrakey Richard F · Amarillo, TXBuilt 1972 · S/N 18052236N9736HBrentco Aerial Patrol Inc · Canton, OHBuilt 1981 · S/N 18267983N9736MRyan Air Inc · Anchorage, AKBuilt 1981 · S/N 20700722N9737GZamoruev Alexander Vladimirovich Trustee · Anchorage, AKBuilt 1972 · S/N 18052237N9737HXyz Aviation LLC · Rineyville, KYBuilt 1981 · S/N 18267984N9737VAero Equities LLC · Ventura, CABuilt 1975 · S/N 17264499N97380Rsf Services LLC · Salem, ORBuilt 1979 · S/N 18267073N97385182q LLC · Tyler, TXS/N 18267076N97386Ratcliffe & Sons Inc · Madill, OKS/N 18267077N9738ADemio Douglas · Westbrook, CTBuilt 1949 · S/N 19199N9738HBallard Bradley J · Youngsville, NCBuilt 1981 · S/N 18267985N9738XAdelman Timothy B · Stevensville, MDBuilt 1961 · S/N 21058038N97396Sds Aviation Inc · Buford, GABuilt 1979 · S/N 18267079N97398Dbat Flying Club LLC · Reno, NVBuilt 1979 · S/N 18267080N9739GBjork Richard J · Brackettville, TXBuilt 1972 · S/N 18052239N973JMMarc Inc · Bolton, MSBuilt 1978 · S/N 18266734N973KGRichard Mervin J Jr · Washington, DCBuilt 1961 · S/N 17248989N973SRRegistration Pending · Kuna, IDRegistration pendingBuilt 1968 · S/N 18258865N973WDBaggenstoss William J · Weiser, IDBuilt 1960 · S/N 56519N9740GKestrel Kat LLC · Wilmington, DEBuilt 1972 · S/N 18052240N97410Skynuke LLC · Bechtelsville, PABuilt 1979 · S/N 18267082N97413Northwoods Air LLC · Orono, MEBuilt 1979 · S/N 18267083N9741AHelzer Michelle A · Canby, ORBuilt 1950 · S/N 19406N9741XHalbert Larry E · Jacksonville, FLBuilt 1961 · S/N 21058041N97428Right Wing Aviation LLC · Fort Wayne, INBuilt 1984 · S/N 17276188N9742BHarp Aviation LLC · Flemington, NJBuilt 1981 · S/N 172RG1005N9742HSingularity - Intelligence Amplified LLC · Conesus, NYBuilt 1981 · S/N 18267989N9742VN9742v LLC · Ord, NEBuilt 1966 · S/N 188-0192N97433Menyhay William Csaba · Clovis, CABuilt 1979 · S/N 18267090N97435Wipaire Inc · South Saint Paul, MNBuilt 1979 · S/N 18267091N97437Carr Jeffrey A · Worthington, KYS/N 18267093N9743AYokom James C · Wichita, KSBuilt 1950 · S/N 19204N9743BVinson Paul E DBA · Gainesville, GABuilt 1981 · S/N 172RG1006
Back to AD 87-20-03 R2