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.

N42NCCapair Inc · Plantation, FLBuilt 1973 · S/N 402B0387N42SGPolar Star Co · Wilmington, DES/N 4140927N42SSBas Part Sales LLC · Greeley, COBuilt 1972 · S/N 310Q0682N42YZPharaoh Aviation LLC · Velma, OKBuilt 1973 · S/N 421B0385N4304CN4304c LLC · Pawhuskah, OKBuilt 1980 · S/N 340A1011N4308ZMike Victor Yankee LLC · Andover, MABuilt 1983 · S/N T30300183N4315COld Salt Aviation LLC · Virginia Beach, VABuilt 1978 · S/N 340A0532N431BRLockyer Roch Jr · Austin, TXBuilt 1970 · S/N 310Q0221N431CELegacy Aviation LLC · Ann Arbor, MIBuilt 1973 · S/N 414-0431N4326CSeven Echo Whiskey Corp · Wilmington, DEBuilt 1976 · S/N 340A0075N432BEvans Ferguson · Washington, DCBuilt 1965 · S/N 310J0041N432RADirect Entry Holdings LLC · Port Richey, FLBuilt 1979 · S/N 340A0925N433YHRegistration Pending · Stuart, FLRegistration pendingS/N 310Q0998N438APWhiskey 340 LLC · Tucson, AZBuilt 1977 · S/N 340A0438N438EL1 Stop Sod & Landscaping Inc · Orlando, FLBuilt 1977 · S/N 421C0274N43BMDodson International Parts Inc · Rantoul, KSBuilt 1981 · S/N 421C1224N43DAAero Management Holdings LLC · Hot Springs, ARBuilt 1976 · S/N 340A0112N43DW10-4 Aviation LLC · Waco, TXBuilt 1974 · S/N 310R0135N43MRFlight Contract Services Inc · Las Vegas, NVS/N 414A-0016N4403ABank Of Utah Trustee · Salt Lake City, UTBuilt 1980 · S/N 340A1014N440DL421 Partners LLC · Crown Point, INBuilt 1983 · S/N 421C1401N440JBAg Tech Farm Services · Gamaliel, KYBuilt 1975 · S/N 421B0858N440LJByington William · Minden, NVS/N 421C0299N441TPUnited Contractors Inc · Costa Mesa, CABuilt 1978 · S/N 414A0057N441TTSunbird Airlines Inc · San Juan, PRBuilt 1981 · S/N 402C0441N4420MJohnson Capital LLC · Colleyville, TXBuilt 1973 · S/N 310Q0808N442AKKelly Aviation Inc · Tampa, FLBuilt 1977 · S/N 310R0984N442CCRaymond Andrew A · Crescent, IAS/N 414A0483N442FMHogan Quinn H Trustee · Milwaukee, WIBuilt 1979 · S/N 414A0303N443LTValiair Ltd Co Trustee · Casper, WYBuilt 1976 · S/N 310R-0627N443RSalinas Construction Technologies Ltd · Pleasanton, TXS/N 414-0361N4440KKate & Jennifer Airlines LLC · Tampa, FLBuilt 1974 · S/N 421B0567N444ATCore Aviation LLC · Dayton, OHS/N 421B0897N444BGMitchell Aviation LLC · Mitchell, SDBuilt 1980 · S/N 421C0893N444BRNational Aviation Academy Of Mississippi Inc · Clearwater, FLS/N 310H0062N444BZWilliams Allen G Jr · Fort Worth, TXBuilt 1974 · S/N 414-0490N444DMGosnell Josh W · Richards, TXBuilt 1974 · S/N 414-0522N444FABank Of Utah Trustee · Salt Lake City, UTS/N 414-0549N444HDChado Richard P II · Rancho Cucamonga, CAS/N 421C0480N444HTTaktos Ltd · Corvallis, ORBuilt 1973 · S/N 310Q0739N444JMPeck Joseph A · Pound Ridge, NYBuilt 1976 · S/N 340A0280N444KTHangar G-1 Aviation Partners LLC · Los Olivos, CABuilt 1981 · S/N 340A1235N444KWRaw Racing Inc · Puyallup, WAS/N 340A0241N444LJDsl Aviation LLC · Ronkonkoma, NYBuilt 1978 · S/N 310R-1294N444LSTaa Property LLC · Lake Wales, FLBuilt 1973 · S/N 414-0460N444SMPosada Law Pllc · Boca Raton, FLBuilt 1974 · S/N 421B0814N444STPeterson Ocean Tours LLC · Pace, FLS/N 310Q0605N444TAMiller Conner · Lake Havasu City, AZBuilt 1973 · S/N 421B0390N4492UAircraft & Aviation Professionals LLC · Coldwater, MIS/N 421C0020N44DPD L S Aviation Inc · Wilmington, DEFirst renewal noticeBuilt 1968 · S/N 310P0039
Back to AD 87-21-02 R1