Boeing 747-87UF
Service difficulty reports · 1,102
Newest first. General aviation reporting is voluntary.
Query with SQL
duckdb -csv -c "SELECT sdr_id, difficulty_date, n_number, aircraft_make, aircraft_model, part_name, part_condition, jasc_code, discrepancy FROM 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet' WHERE aircraft_model_key = '74787UF' ORDER BY difficulty_date DESC"
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.
SELECT sdr_id, difficulty_date, n_number, aircraft_make, aircraft_model, part_name, part_condition, jasc_code, discrepancy FROM 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet' WHERE aircraft_model_key = '74787UF' ORDER BY difficulty_date DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
SDR P5CA2021042100139Stringer · crackedCRACK DAMAGE ON THE STRINGER S-22R, AT FWD SIDE OF STA 1740(<P>REPAIRED DAMAGED AREA IAW EI NO T2021A53M-917 REV 1. REINSTALLED FASTENERS IAW SRM 51-40-02 REV 33 AND DWG NO 146U1741 SH 324, 325 REV -, 146U1720 SH 79 REV B. CONDITION CHECK NORMAL AND JOB COMPLESDR P5CA2021042100140Stringer · crackedCRACK DAMAGE ON THE STRINGER S-15R AT AFT SIDE OF STA 740.(<P>ACCOMPLISHED EI NO T2021A53M-879 REV 1. INSTALLED FASTENERS IAW SRM 51-40-02 REV 33 AND BOEING DWG NO 142U3736 SHEET 24 REV -. CONDITION CK NORMAL AND JOB COMPLETED.</P>)SDR P5CA2021042100141Stringer · crackedCRACK DAMAGE ON THE STRINGER S-13R, AT AFT SIDE OF STA 740.(<P>ACCOMPLISHED EI NO T2021A53M-878 REV 1. INSTALL FASTENERS IAW SRM 51-40-02 REV 33 AND BOEING DWG NO 142U0741 SHEET 423 REV - AND BOEING DWG NO 142U1312 SHEET 1 REV A. CONDITION CHK NORMAL AND JOB CSDR P5CA2021042100142Stringer · crackedCRACK DAMAGE ON STRINGER S-25R, AT FWD AND AFT SIDE OF STA 1740(<P>REPAIRED DAMAGE AREA IAW EI NO T2021A53M-919 REV 1. REINSTALL FASTENERS IAW SRM 51-40-02 REV 33 AND DWG NO 146U1741 SHEET 327 REV A. CONDITION CHECK NORMAL AND JOB COMPLETED.</P>)SDR P5CA2021042100143Stringer · crackedCRACK DAMAGE ON THE STRINGER S-21R, AT FWD AND AFT SIDE OF STA 1740(<P>REPAIRED DAMAGED AREA IAW EI NO T2021A53M-916 REV 1. REINSTALLED FASTENERS IAW SRM 51-40-02 REV 33 AND DWG NO 146U1741 SH 324 REV -. CONDITION CHECK NORMAL AND JOB COMPLETED.</P>)SDR P5CA2021042100144Stringer · crackedCRACK DAMAGE ON THE STRINGER S-20R, AT FWD AND AFT SIDE OF THE STA 1740(<P>REPAIRED DAMAGED AREA IAW EI NO T2021A53M-915 REV 1. REINSTALL FASTENER IAW SRM 51-40-02 REV 33 AND DWG NO 146U1741 SH 324, 325, 326 REV -, 146U1720 SH 80 REV B AND 146U1323 SH 96 REV -SDR P5CA2021042100145Stringer · crackedCRACK DAMAGE ON THE STRINGER S-23R, AT FWD SIDE OF STA 1960.(<P>REPAIRED DAMAGED AREA IAW EI NO T2021A53M-925 REV 1. REINSTALL FASTENERS IAW SRM 51-40-02 REV 33 AND DWG NO 146U1323 SH 105 REV - AND 146U1961 SH 484 REV -. CONDITION CHK NORMAL AND JOB COMPLETED.SDR P5CA2021042100146Stringer · crackedCRACK DAMAGE ON THE STRINGER -19R, AT FWD SIDE OF STA 1960.(<P>REPAIR DAMAGE AREA IAW EI NO T2021A53M-923 REV 1. REINSTALL THE FASTENERS IAW SRM 51-40-02 REV 33 AND DWG NO 146U3732 SH 36 REV A, 146U1961 SH 614 REV -, 146U1961 SH 615 REV - 146U1940 SH 179 REV -SDR P5CA2021042100147Stringer · crackedCRACK DAMAGE ON THE STRINGERS S-9R, AT AFT SIDE OF STA 2180(<P>REPAIRED DAMAGED AREA IAW EI NO T2021A53M-934 REV 1. REINSTALLED FASTENERS IAW SRM 51-40-02 REV 33 AND DWG NO 146U3481 SH63 REV -, 146U3922 SH 21 REV - AND 146U2200 SH 120 REV C. CONDITION CHK NORMSDR P5CA2021042100148Stringer · crackedCRACK DAMAGE ON THE STRINGER S-22R, AT FWD SIDE OF STA 1960(<P>REPAIRED DAMAGED AREA IAW EI NO T2021A53M-924 REV 1. REINSTALL FASTENERS IAW SRM 51-40-02 REV 33 AND DWG NO 146U1323 SH 105 REV -, AND 146U1961 SH 615, 614 - . CONDITION CHECK NORMAL AND JOB COMPLESDR P5CA2021042100149Stringer · damagedCRACK ADAMAGE ON THE STRINGER S-12R, AT FWD SIDE OF STA 1960(<P>REPAIRED DAMAGED AREA IAW EI NO T2021A53M-922 REV 1. REINSTALL FASTENERS IAW SRM 51-40-02 REV 33 AND DWG NO 146U1961 SHEET 465 REV B AND 146U1312 SH 123 REV -. CONDITION CHECK NORMAL AND JOB COMPLSDR P5CA2021042100150Stringer · damagedCRACK DAMAGE ON THE STRINGER S-20R, AT AFT SIDE OF STA 2180(<P>REPAIRED DAMAGED AREA IAW EI NO T2021A53M-935 REV 1. REINSTALLED FASTENERS IAW SRM 51-40-02 REV 33 AND DWG NO 146U2181 SH 392 REV A AND 146U2200 SH 164 REV -. CONDITION CHECK NORMAL AND JOB COMPLETSDR P5CA2021042100151Wire · damagedFOUND WIRE WS95-328-20R / W895-329-20B / WS95-330-20Y AND W895-334-20R / W895-335-20B / W895-336-20Y WIRE TOUCH WITH STRUCTURE AND DAMAGE NEAR CONNECTOR DV 744 #2 RAM AIR INLET ACTUATOR(<P>IAW SMM 21-622-03-00-801 / 21-62-03-400-801 REV 35, WDM 21-62-21 REV 23SDR UIEA2021031300538Ecu · malfunctionedUPON ENG SPOOL FOR T/O ACFT VEERED TO RIGHT. EXECUTED LOW SPEED (10 KNOTS APPROX) REJECTED T/O(<P ><SPAN>INSPECTED NOSE STEERING / SYSTEM IAW AMM 32-51-00, INSPECT A/C BRAKES IAW AMM 32-41-00, REPLACED BODY / GEAR STEERING ECU IAW AMM 32-53-03</SPAN></P>)SDR UIEA2021031200527Skin · gougedGOUGE ON THE EXTERNAL SIDE OF SKIN NEAR STA 2575 BETWEEN S-49L AND S-51L(<P>REPAIR DAMAGE AREA IAW SRM 53-00-01-2R-1 FIG 208. REV 32. AND DWG NO 148U3260 SHEET 1 REV 0. JOB COMPLETED AND CONDITION CHK NORMAL.</P>)SDR UIEA2021031200528Stringer · crackedCRACK DAMAGES ON THE STRINGER S-7R BETWEEN STA 960 AND STA 970(<P>ACCOMPLISHED THE STRINGER REPAR IAW EI NO T2021A53M-348 REV 2 AND ATTACHING WITH WO 5541933 (070). CONDITION CHECK NORMAL AND JOB COMPLETED</P>)SDR UIEA2021031200529Actuator · no testFOUND LH BLG ALTERNATE EXTENSION SYSTEM ELECTRICAL ACTUATOR FUNCTION TEST FAIL(<P>IAW AMM 32-35-01-004-001 REV 34 AND AMM 32-35-01-404-007 REV 34. REPLACED AND DO THE POST INSTALLATION TEST. RESULT WAS SATISFACTORY</P>)SDR UIEA2021031200530Stringer · crackedCRACK DAMAGE ON THE STRINGER S-9L BETWEEN STA 950 AND STA 980 + 20(<P>ACCOMPLISHED EI NO T2021A53M-351 REV 1 AND EI ATTACHED TO W/O NO 5541948 (072). JOB COMPLETED AND CONDITION CHECK NORMAL</P>)SDR UIEA2021031200531Actuator · malfunctionedFOUND RH WLG ALTERNATE EXTENSION ACTUATOR FUNCTION ABNORMAL(<P>IAW AMM 32-36-01/401 REV 34 REPLACED AND PERFORM OPERATION TEST. RESULT WAS NORMAL.</P>)SDR UIEA2021031200532Stringer · crackedCRACK DAMAGE ON THE STRINGER S-10R BETWEEN STA 870 AND STA 880(<P>ACCOMPLISHED THE STRINGER REPAIR IAW EI NO T2021A53M-353 REV 1. CONDITION CHECK NORMAL AND JOB COMPLETED</P>)SDR UIEA2021031200533Stringer · crackedCRACK DAMAGES ON THE STRINGER S-7R BETWEEN STA 870 AND STA 890(<P>ACCOMPLISHED THE STRINGER REPAIR IAW EI NO T2021A-53M-348 REV 2. CONDITION CHECK NORMAL AND JOB COMPLETED.</P>)SDR UIEA2021031200534Stringer · crackedCRACK DAMAGES ON THE STRINGER S-11R BETWEEN STA 880 AND 890(<P>ACCOMPLISHED THE STRINGER REPAIR IAW EI NO 52021A53M-354 REV 1. CONDITION CHECK NORMAL AND JOB COMPLETED</P>)SDR UIEA2021031200535Stringer · crackedREPAIR - CRACK DAMAGE ON THE STRINGER S-15R AT AFT SIDE OF STA 740(<P>REPAIR DAMAGE AREA IAW EI NO T2021A53M-380 REV 2. CONDITION CHK NORMAL AND JOB COMPLETED</P>)SDR UIEA2021031200536Stringer · crackedCRACK DAMAGE ON STRINGER S-20R, AT FWD SIDE OF STA 1900(<P>REPAIR STRINGER IAW EI NO T2021A53M-410 REV 1. COND CHK NORMAL AND JOB COMPLETED.</P>)SDR UIEA2021031500558Stringer · crackedCRACK DAMAGE ON STRINGER S-18R, AT FWD SIDE OF STA 1960(<P>REPAIR STRINGER IAW EI NO T2021A53M-409 REV 1. CONDITION CK NORMAL AND JOB COMPLETED.</P>)SDR UIEA2021031500560Stringer · crackedCRACK DAMAGE ON THE STRINGER S-17R OF STA 740 AFT SIDE(<P>ACCOMPLISHED THE JOB IAW EI NO T2021A53M-381 REV 2. JOB COMPLETED AND CONDITION CHK NORMAL</P>)SDR UIEA2021031500561Stringer · crackedCRACK DAMAGES ON THE STRINGER S-9L BETWEEN STA 850 AND STA 950(<P>ACCOMPLISHED EI NO T2021A53M-351 REV 1. JOB COMPLETED AND CONDITION CHK NORMAL</P>)SDR UIEA2021031500564Stringer · crackedCRACK DAMAGE ON THE STRINGER S-19L OF STA 2180 OF AFT SIDE(<P>REMOVE AFFECTED FASTENER TO GET ACCESS IAW SRM 51-40-02 REV 32. ACCOMPLISHED EI NO T2021A53M-413 REV 2. REINSTALLED FASTENER IAW SRM 51-40-02 REV 33 AND DWG NO 146U2200 SHEET 167 REV -. JOB COMPLETESDR UIEA2021031500565Stringer · crackedCRACK DAMAGE ON STRINGER S-15L AT FWD SIDE AND AFT SIDE OF STA 1960(<P>REMOVED AFFECTED FASTENER TO GET ACCESS IAW SRM 51-40-02 REV 32. ACCOMPLISHED EI NO T2021A53M-408 REV 1. REINSTALLED FASTENER IAW SRM 51-40-02 REV 32 AND DWG NO 146U1940 SHEET 206 REV - ANDSDR UIEA2021031500576Stringer · crackedCRACK DAMAGE ON THE STRINGER S-13L OF STA 2180 AFT SIDE(<P>REMOVE AFFECTED FASTENERS TO GET ACCESS IAW SRM 51-40-02 REV 32. ACCOMPLISHED EI NO T2021A53N-412 REV 2. REINSTALLED FASTENERS IAW SRM 51-40-02 REV 32 AND DWG NO 146U3932 SHEET 10 REV -. JOB COMPLETED SDR UIEA2021031500577Stringer · crackedCRACK DAMAGE ON THE STRINGER S-20L OF STA 2180 AFT SIDE(<P>REMOVED AFFECTED FASTENER TO GET ACCESS IAW SRM 51-40-02 REV 32. ACCOMPLISHED EI NO T2021A53M-414 REV 1. REINSTALLED FASTENER IAW SRM 51-40-02 REV 32. AND DWG NO 146U2200 SHEET 166 REV -. JOB COMPLETEDSDR UIEA2021031500578Rib · wornRH WING INBD L/E CAVITY RIB WORN AT IFSS 401.01(<P>ACCOMPLISHED EI NO T2021A57M-407 REV 2. JOB COMPLETED AND CONDITION CHK NORMAL.</P>)SDR UIEA2021031500579Rib · wornLH WING INBD LE CAVITY RIB WORN AT IFSS 439.34.(<P>ACCOMPLISHED EI NO T2021A57M-415 REV 2. JOB COMPLETED AND CONDITION CHK NORMAL</P>)SDR UIEA2021031500580Stringer · crackedCRACK DAMAGE ON STRINGER S-10R OF STA 2180 AFT SIDE(<P>ACCOMPLISH EI NO T2021A53M-411 REV 2 AND DWG NO 146U2181 SHEET 389 REV - AND DWG NO 146U1312 SHEET 113 REV - AND DWG NO 146U3481 SHEET 47 REV -. JOB COMPLETED AND CONDITION CHECK NORMAL.</P>)SDR UIEA2021031500581Stringer · crackedCRACK - STRINGER, FUSELAGE INTERNAL SKIN, STA 882 S-7L.(<P>ACCOMPLISHED THE EI NO T2021A53M-347 REV 1. JOB COMPLETED AND CONDITION CHECK NORMAL.</P>)SDR UIEA2021031500582Stringer · crackedCRACK - STRINGER, FUSELAGE INTERNAL SKIN, STA 880, S-8L(<P>ACCOMPLISHED THE EI NO T2021A53M-349 REV 1. JOB COMPLETED AND CONDITION CHECK NORMAL.</P>)SDR UIEA2021031500583Stringer · crackedCRACK - STRINGER, FUSELAGE INTERNAL SKIN, STA 870 - STA 910.(<P>ACCOMPLISHED THE EI NO T2021A53M-352 REV 1. JOB COMPLETED AND CONDITION CHECK NORMAL.</P>)SDR UIEA2021031500584Stringer · crackedCRACK DAMAGE ON STRINGER S-23L, AT FWD SIDE OF STA 740.(<P>REMOVE AFFECTED FASTENERS TO GET ACCESS IAW SRM 51-40-02 REV 32. ACCOMPLISHED EI NO T2021A53M-382 REV 3. REINSTALLED FASTENERS IAW SRM 51-40-02 REV 33 AND DWG NO 142U0720 SHEET 68 REV -. JOB COMPLETED SDR UIEA2021031500585Stringer · crackedCRACK ON THE STRINGER S-14R OF STA 740 AFT SIDE(<P>REPAIR DAMAGED AREA IAW EI NO T2021A53M-376 REV 2. CONDITION CHECK NORMAL AND JOB COMPLETED.</P>)SDR UIEA2021031500586Stringer · crackedCRACK DAMAGE ON THE STRINGER S-8R BETWEEN STA 940 AND STA 950(<P>ACCOMPLISHED THE STRINGER REPAIR IAW EI NO T2021A53M-350 REV 1. CONDITION CHECK NORMAL AND JOB COMPLETED.</P>)SDR P5CA2021022200048Tube · crackedNUMBER 4 ENGINE OIL SYS STATUS MESSAGE, PRECAUTIONARY SHUTDOWN OF NR 4 ENG PER QRH. M12 - DURING A/C BACK TO GATE W/ REGARDS TO ENG NR 4 OIL SYS STATUS MSG FOUND OIL CAP NOT INSTALLED PROPERLY. (PERFORMED PRECAUTIONARY INSPECTION OF NR 4 ENG FUEL OIL HEAT EXCSDR UIEA2022010200003None · noneMAIN CARGO DECK FLOOR WEB DAMAGED FS228(<P>REPAIRED PER EO 4853A136</P>)SDR P5CA2021010200001None · noneBIRD STRIKE HALFWAY DOWN RW 27 JUST PRIOR TO ROTATE. MCC DIRECTED TO RETURN TO CVG FOR MX INSPECTION. BIRD STRIKE AREA IS NOSE/CARGO DOOR (RT SIDE) STA 200/RWL 250 AND RWL 312. AFFECTED AREA HAS BEEN CLEANED AND INSPECTED, NO DAMAGE FOUND. ENGINES AND AIRCRAFTSDR 3BSY20210104001Fairing · missingON 27 DECEMBER 2020, WHEN POLAR N852GT LANDED AT PVG (PUDONG AIRPORT) SHANGHAI, THE NR 2 FLAP TRACKING FAIRING WAS FOUND MISSING DURING WALK AROUND CHECK. THE OPERATOR WAS NOTIFIED. AFTER THAT, THE AIRCRAFT OPERATION CONTROL CENTER OF THE AIRPORT TOLD OPERATSDR P5CA2020122800410Fairing · missingTHE NR 2 TRAILING EDGE FLAP FAIRING MISSING. A/C DISPATCHED IAW CDL 27-51-02, MDDR 140129.SDR P5CA2020121900407Connector · damagedGEAR CENTER CONFIG EICAS, REJECTED TAKE OFF DUE TO GEAR HORN BODY GEAR STEERING, REF MDDR NR 139776. BODY GEAR STEERING INOPERABLE, MEL CHANGED FROM 32-53-01 TO 32-53-02, CAT C. COMPLETED MAINT PROCEDURES. REMOVED CONNECTOR ON LT BG-RH ACT.SDR P5CA2020120700391Actuator · malfunctionedREJECTED TAKE-OFF AT 40 KTS FOR "CONFIG GEAR CTR" EICAS MESSAGE. BODY GEAR STEERING RESTORATION, IAW 32-00-00-440-815. BODY GEAR STEERING BITE VERIFICATION TEST CARRIED OUT, IAW 32-53-16-744-027. CONFIRMED ALL PRIMARY LOCK SWITCHES LOCK AND UNLOCK ALL BUT SDR P5CA2020111500382Transducer · malfunctionedREJECTED TAKE OFF "CONFIG GEAR CENTER". PERFORMED A/P 18105 NOSE/WHEEL STEERING ADJUSTMENT, PER AMM 21-51-00-835-001 AND BGS ADJUSTMENT, PER AMM/32-53-00-705-001. BITE CHECK FAILED-STEERING TRANSDUCER VALUE ERRATIC. R & R BGS/INPUT TRANSDUCER, PER AMM 32-53SDR P5CA2020110400371Engine · malfunctionedFLIGHT CREW REPORTED TO HKG MX THAT NR 3 ENGINE DID NOT SPOOL UP ON TAKE OFF, BUT SECOND TRY WAS NORMAL. DISCUSSED WITH PPE, AND DOWNLOADED QAR DATA FOR REVIEW.SDR P5CA2020102700365Sensor · false indicationUPON POWER UP CONFIG GEAR CENTER MESSAGE AND GEAR MONITOR STATUS MESSAGE. REMOVED AND REPLACED BODY GEAR TRUCK TILT SENSOR EQUIP 56R, IAW AMM 32-61-21.
Back to Boeing 747-87UF