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.

N777RPParis Air Conditioning Co · Paris, TXBuilt 1974 · S/N 414-0636N777TSEmery Edward F DBA · Bloomsburg, PAFirst renewal noticeS/N 421B0352N777VMiso Enteprises LLC · Wilmington, DES/N 310R0267N777VFZammit Flight Resources LLC · Sheridan, WYBuilt 1977 · S/N 414-0946N777ZTSee David M · Shady Shores, TXBuilt 1966 · S/N 320E0033N7782QFanning Fred W · Fairlawn, OHBuilt 1971 · S/N 310Q0282N7792QSchultz Todd · Bakersfield, CAS/N 310Q0402N7793QJupiter Flight Service And Investing LLC · Lithonia, GABuilt 1971 · S/N 310Q0403N7794QRg Aviation Inc · Wilmington, DEBuilt 1971 · S/N 310Q0404N77BRInternational Air Services Inc Trustee · Carson City, NVBuilt 1975 · S/N 340A-0053N77CDN-J Aviation LLC · Forest, VABuilt 1975 · S/N 414-0646N77EPCba Air LLC · Tuscaloosa, ALBuilt 1973 · S/N 421B0478N77FAJeff Air Pilot Services LLC · Shelbyville, INBuilt 1974 · S/N 310R0044N77JSSol Aerial Surveys LLC · Las Vegas, NVBuilt 1979 · S/N 310R1621N77MBCosgrove D DBA · Crestview, FLBuilt 1964 · S/N 310I0068N77MJN77mj LLC · Phoenix, AZS/N 310R-0707N77QBDeauxboys LLC · Menomonee Falls, WIBuilt 1976 · S/N 340A0120N77RGN77rg LLC · Amarillo, TXBuilt 1976 · S/N 310R0636N780JCN780jc Inc · Orlando, FLBuilt 1974 · S/N 421B0582N780MBSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1972 · S/N 402B-0249N780SHPro Aire Cargo & Consulting Inc · Oshkosh, WIBuilt 1978 · S/N 310R1367N7829QCavok Aviation LLC · West Fargo, NDBuilt 1972 · S/N 310Q0545N7835QChannell Robert Douglass · Moreland, GABuilt 1972 · S/N 310Q0617N7841QExigo Capital LLC · Miami Beach, FLBuilt 1973 · S/N 340-0222N7845QReading Jared · Uvalde, TXBuilt 1973 · S/N 340-0225N7864FKeller Russell L · Runaway Bay, TXBuilt 1968 · S/N 4010207N7872QSinkovich Peter I · Phoenix, AZBuilt 1972 · S/N 310Q0653N7873QWallis Aircraft Inc · Clifford Township, PABuilt 1972 · S/N 310Q0654N7875EUniversity Research Foundation · Greenbelt, MDBuilt 1973 · S/N 402B0432N787DRBad Aire LLC · Aledo, TXS/N 414A0503N787GSwirsding David J · Chalfont, PABuilt 1979 · S/N 340A0961N7887QBeiser Ned E · De Soto, TXBuilt 1972 · S/N 310Q0659N788DMSts Aviation LLC · Daytona Beach, FLBuilt 1978 · S/N 340A0461N788JJGreenlee Joseph A III · Fort Wayne, INBuilt 1975 · S/N 421B0851N7893QDatchcorr LLC · Chattanooga, TNBuilt 1972 · S/N 310Q0661N7899QCounty Farms LLC · Mars Hill, MEBuilt 1972 · S/N 310Q0619N789BDTroy Farms Lp · Delano, CAFirst renewal noticeBuilt 1973 · S/N 310Q0922N789MD340a1021 Inc Trustee · Wilmington, DEBuilt 1980 · S/N 340A1021N789PTValiair Limited Company · Casper, WYBuilt 1985 · S/N 414A1209N789RPBrindle Concepts LLC · Hanover, PABuilt 1975 · S/N 421C0009N789SCTransport Drive Man LLC · Encino, CAS/N 340-0175N78BBRadwanski D · Westmont, ILBuilt 1977 · S/N 310R1246N78DGUsac N78dg LLC · Wall Township, NJBuilt 1981 · S/N 414A-0641N78KC5634 Aviation LLC · Flowery Branch, GABuilt 1978 · S/N 414A-0045N78KJMuzquiz Alberto · San Antonio, TXBuilt 1976 · S/N 310R0669N78NGRam Aero Development Inc · Waco, TXS/N 414A0617N78SBas Part Sales LLC · Greeley, COBuilt 1972 · S/N 340-0151N7901QKentucky Airmotive Inc · Mount Sterling, KYBuilt 1969 · S/N 401B0001N7909QSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1972 · S/N 310Q0620N790DMNostalgair/Sky Adventures Inc · Vero Beach, FLBuilt 1973 · S/N 310Q0828
Back to AD 87-21-02 R1