OpenAirDocs.org
AD 87-21-02 R1

Registered aircraft · 3,961

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-21-02-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-21-02-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.

N5874CVola Acosta LLC · Lake Forest, CAS/N 421C0882N5877MBrook Ash Inc · Waxahachie, TXS/N 310P0177N5878MKodiak Helo LLC · Kodiak, AKBuilt 1972 · S/N 340-0059N587GFReher David P · Arlington, TXBuilt 1975 · S/N 310R0246N587MWHammonds Mark · N Richlnd Hls, TXBuilt 1974 · S/N 421B0587N5882TDe Smet Vicki M · La Verne, CAS/N 421B0424N5885MButler Richard A · Portland, TXBuilt 1969 · S/N 310P0185N5889MKinney James R · Vermillion, SDBuilt 1969 · S/N 310P0189N588DMColeman Russell Ll · Saint Charles, ILBuilt 1973 · S/N 310Q0624N588RRGay Don F · Terrell, TXBuilt 1966 · S/N 310K0091N588TBVlot Cole T · Wellington, NVBuilt 1976 · S/N 421C0064N589DMGeorgescu Radu A · Louisville, KYS/N 310Q1048N589STCurtis & Son Vacuum Service Inc · Liberty, TXS/N 421C0644N58AWAmplatz Left Aviation LLC · Rapid City, SDS/N 414A0276N58BJJmp Aviation Corp · Dover, DES/N 340A0723N58HBjk Aviation LLC · Morgantown, WVBuilt 1979 · S/N 414A0314N58JASunergy Solutions LLC · Londonderry, NHBuilt 1975 · S/N 3400521N58ZPCk Investor Inc · Lubbock, TXS/N 421C0705N590FMTrrek Enterprises LLC · Sunriver, ORBuilt 1966 · S/N 320D0095N5910MCross Country Well Service LLC · Farmington, NMS/N 340-0067N5911MYataco Enrique · Dothan, ALS/N 310P0211N5913MWallace Larry Wayne · Millsap, TXBuilt 1969 · S/N 310P0213N5914MBogie Aviation LLC · Newton, NJBuilt 1969 · S/N 310P0214N5916MQuest Aviation Inc · Lake City, FLBuilt 1973 · S/N 402B0365N5925MDickerson Stephen R · Frisco, TXBuilt 1969 · S/N 310P0225N592GCFogelson Robert A · Tillamook, ORBuilt 1972 · S/N 340-0152N5931MSteven F Danz LLC · Encino, CABuilt 1972 · S/N 340-0071N5933MMonahan Robert J · Bulverde, TXBuilt 1969 · S/N 310P0233N5934M34m LLC · Young Harris, GABuilt 1969 · S/N 310P0234N5938MKarlen John R · Boring, ORS/N 340-0074N593DMLister John · Pipe Creek, TXS/N 402B1228N5949MSnflk Leasing LLC · Andrews, TXBuilt 1972 · S/N 421B0319N594BVJmak Corp · Seymour, TNBuilt 1978 · S/N 340A0440N594WBUintacor Inc · Mesa, AZS/N 310Q0077N5951MMcdonnell Enterprises Inc · Wilmington, DEBuilt 1973 · S/N 310Q0737N5962MKitov Resources Corp · Shorewood, WIS/N 421B0205N5967MN5967m LLC · Chantilly, VAS/N 421B0210N596DMAirswiss Inc · Wilmington, DES/N 402C0255N5975JFreeland Christopher G · Brownwood, TXS/N 414-0028N5988MSaltzer Eric · Somerton, AZBuilt 1972 · S/N 421B0231N598ASAssociated Auction & Liquidation Co · Clarksburg, TNBuilt 1984 · S/N 414A1003N598DMAirswiss Inc · Wilmington, DEBuilt 1979 · S/N 402C0114N5996MMedcare Emergency Medical Services Inc · Mcallen, TXBuilt 1972 · S/N 421B0334N59NMGf Air LLC · Las Vegas, NVBuilt 1975 · S/N 421B0870N5AMTexas La Flyers LLC · West Monroe, LAFirst renewal noticeBuilt 1979 · S/N 414A0441N5CGSamair LLC · Blackshear, GABuilt 1979 · S/N 340A0751N5CHHartshorn William T · Tucson, AZBuilt 1968 · S/N 421-0113N5CNLewis Gentry Holdings LLC · Orlando, FLBuilt 1978 · S/N 414A0073N5CXGumar Sherko A · Scottsdale, AZBuilt 1975 · S/N 310R0224N5ERMill Direct Textiles LLC · Rollinsford, NHBuilt 1982 · S/N T30300137
Back to AD 87-21-02 R1