Boeing 747-47UF
Service difficulty reports · 3,116
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 = '74747UF' 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 = '74747UF' 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 UIEA2023061600647Shutoff Valve · unknownITEM 1: AIR TURNBACK DUE TO COCKPIT AND UPPER DECK TEMPERATURES CONTINUALLY DROPPING. FLT DECK SET AT 29C, FWD DECK SET AT 15C, UPPER DECK 8C & CREW REST AT 3C.(<P>REMOVED AND REPLACED FWD TRIM AIR SHUTOFF VALVE PER AMM 21-28-04, TEST PASSED.</P>)SDR UIEA2023052200463Unknown · unknownCRACKON LH UPPER DECK FLOOR BEAM AFTER CHANNEL OF STA 820(<P>1) REMOVE THE DAMAGE AREA IAW SRM 51-40-02-0G-0 & 53-20-30-2R-2 REV 97. 2) REPAIR THE TENSION TIE AFTER CHANNEL IAW SRM 53-20-30-2R-2 REV 97. 3) CONDITION CHECK NORMAL & JOB COMPLETED</P>)SDR UIEA2023052200464Unknown · unknownDEVIATION - DURING PFM 4453A087 PART 2, FOUND 2 EXISTING FASTENERS NO CONNECT WITH FRAME AT STA 500 RH SIDE(<P>1) PFM EI T2023A53M-875 SEQUENCE A REV 0. 2) ACCOMPLISHED EI T2023A53M-875 REV 1 AND CONDITION CHECK NORMAL</P>)SDR UIEA2023052200465Unknown · unknownCORROSION ON THE FUSELAGE SKIN AT 2-42L BETWEEN STA 1720 & STA 1740(<P>1) REMOVED THE AFFECTED FASTENERS IAW SRM 51-40-02-0G-0 REV 97. 2) PERFORMED EI T2023A53M-834 SEQUENCE A REV 0. 3) ACCOMPLISHED EI T2023A53M-834 REV 1 & CONDITION CHECK NORMAL. 4) RECORD THSDR UIEA2023052200466Unknown · unknownDEFORM - FOUND MAIN DECK SEAT TRACK FLOOR COVER DEFORM STA 1730 RBL 75(<P>1) REPAIR DAMAGE AREA IAW SRM 53-00-52-2R-13 REV 97 & BOEING DWG 65B38251 SH 75 REV - & 65B38251 SH 32 REV -. 2) CONDITION CHECK NORMAL AND JOB COMPLETED</P>)SDR UIEA2023052200467Unknown · unknownFOUND M/D FLOOR STRUCTURE SUBSTITUTE TRACK CRACK AT STA 1485 RBL 75.92(<P>1) REPAIR DAMAGE AREA IAW SRM 53-00-52-2R-13 REV 97 & BOEING DWG 144U0882 SH 3 REV B & 65B38251 SH 32 REV -. 2) CONDITION CHECK NORMAL AND JOB COMPLETED</P>)SDR UIEA2023052200468Unknown · unknownFOUND M/D FLOOR STRUCTURE SUBSTITUTE TRACK CRACK AT STA 990 RBL 75.92(<P>1) REPAIR DAMAGE AREA IAW SRM 53-00-52-2R-13 REV 97 REV 97 AND DWG 65B16004 SH 4 REV A. 2) CONDITION CHECK NORMAL AND JOB COMPLETED</P>)SDR UIEA2023052200469Unknown · unknownFOUND M/D FLOOR STRUCTURE SUBSTITUTE TRACK CRACK AT STA 990 LBL 75.92(<P>1) REPAIR DAMAGE IAW SRM 53-00-52-2R-13 REV 97 AND DWG 65B16004 SH 4 REV A. 2) CONDITION CHECK NORMAL AND JOB COMPLETED</P>)SDR UIEA2023052200470Unknown · unknownBROKEN - SKIN AND CAP, RH WING INBD AILERON T/E WEDGE OUTBD END(<P>1) PERFORM REPAIR OF BROKEN SKIN DAMAGE FOUND ON RH WING INBD AILERON T/E OUTBD SIDE. PLEASE REFER TO THE JOB CARD ATTACHING SHEET FOR DETAILED REWORK INFO. 2) CONDITION CHECK IS GOOD.</P>)SDR UIEA2023052200471Unknown · unknownDEVIATION - DURING PERFORM 4453A087 PART 2 FOUND EXISTING STRAP HOLES SEM 5 EACH AT STA 480 RH SIDE(<P>1) PERFORM DEVIATION AND PERFORM REPAIR IAW EI T2023A53M-835 REV 1. 2) ACCOMPLISHED EI T2023A53M-835 REV 2. 3) JOB COMPLETED</P>)SDR UIEA2023052200472Unknown · unknownFOUND M/D CARGO FLOOR STRUCTURE CORROSION AT STA 2240 LBL 88 TO 85(<P>1) REPAIR DAMAGE AREA IAW EI T2023A53M-900 REV 0 AND SRM 53-00-51-02R-3 REPAIR 3 REV 97. 2) INSTALL REPAIR PARTS IAW EI T2023A53M-900 REV 0 AND SRM 53-00-51-2R-3 REPAIR 3 REV 97 & BOEING DWGSDR UIEA2023052200473Unknown · unknownFOUND M/D CGO FLOOR STRUCTURE CORROSION AT STA 2240 RBL 59 TO 80(<P>1) REPAIR DAMAGE AREA IAW EI T2023A53M-902 REV 0 AND SRM 53-00-51-2R-3 REPAIR 3 REV 97. 2) INSTALL REPAIR PARTS IAW EI T2023A53M-902 REV 0 AND SRM 53-00-51-2R-3 REPAIR 3 REV 97 AND BOEING DWG SDR UIEA2023052200474Shear Tie · unknownCRACK ON SHEAR TIE AT STA 1000 RBL 57.50 WL195(<P>1) REMOVED DAMAGE PARTS IAW SRM 51-40-02-0G-0 REV 97. 2) REPAIR DAMAGE AREA IAW EI T2023A53M-1018 SEQUENCE A REV 0. 3) INSTALLED NEW PARTS IAW SRM 51-40-02-0G-0 REV 97 AND EI T2023A53M-1018 SEQUENCE A REV 0. 4)SDR UIEA2023052200475Shear Tie · unknownCRACK ON SHEAR TIE AT STA 1000 RBL 33.99 WL195(<P>1) REMOVED DAMAGE PARTS IAW SRM 51-40-02-0G-0 REV 97. 2) REPAIRED DAMAGE AREA IAW EI T2023A53M-1018 SEQUENCE A REV 0. 3) INSTALLED NEW PARTS IAW SRM 51-40-02-0G-0 REV 97 AND EI T2023A53M-1018 SEQUENCE A REV 0. SDR UIEA2023052200476Unknown · unknownFND M/D BEAM CORROSION AT STA 2100 RBL 100(<P>1) REPAIR DAMAGE AREA IAW SRM 53-00-51-2R-3 REV 97 AND EI T2023A53M-1103 SEQUENCE A REV 0 AND BOEING DWG 65B38105 SH12 REV -, 65B38251 SH 62 REV A, 65B38251 SH 33 REV -, 65B38251 SH 67 REV A, 65B38406 SH 48 REV A. SDR UIEA2023052200477Unknown · unknownRH OUTBD MID FLAP WBL 822 FWD RIB AND CONTROL ASSY(<P>1) REMOVED DAMAGE PARTS IAW SRM 51-40-02-0G-0 REV 97. 2) FABRICATED PARTS IAW EI T2023P57M-823 REV 0 & EI T2023A57M-802 REV 1. 3) INSTALLED FABRICATED PARTS IAW SRM 51-40-02-0G-0 REV 97 DRAWING 65B08527 SH SDR UIEA2023052200478Unknown · unknownDEFORM - FOUND M/D SEAT TRACK FLOOR COVER DEFORM AT STA 1630 LBL 75(<P>1) REPAIR DAMAGE AREA IAW SRM 53-00-52-2R-13 REV 97 AND BOEING DWG 65B38251 SH 62 REV A, 65B38251 SH 75 REV -, 65B38251 SH 32 REV -. 2) JOB COMPLETED</P>)SDR UIEA2023052200479Unknown · unknownFOUND M/D CGO SEAT TRACK CORROSION BETWEEN STA 1770 TO STA 1900 LBL 11.33(<P>1) REMOVED AFFECTED FASTENERS IAW SRM 51-40-02-0G-0 REV 97. 2) PERFORMED EI T2023A53M-1035 REV 0 SEQUENCE A. 3) INSTALLED FASTENERS IAW SRM 51-40-02-0G-0 REV 97 AND DWG 65B38253 SH 49SDR UIEA2023052200480Unknown · unknownEXISTING REPAIR ON AFT CGO FRAME WEB NEAR STA 1880 LBL 45.5(<P>1) REMOVED EXISTING REPAIR IAW SRM 51-40-02-0G-0 REV 97. 2) PERFORMED NDT INSPECTION REFER TO JOB CARD ATTACHING SH 0399168. 3) REPAIRED DAMAGE AREA IAW SRM 51-40-02-0G-0 REV 97, SRM 53-60-07-2R-8 SDR UIEA2023052200481Unknown · unknownEXISTING REPAIR ON AFT CGO FRAME WEB STA 1620 LBL 5.5(<P>1) REMOVED EXISTING REPAIR IAW SRM 51-40-02-0G-0 REV 97. 2) PERFORM NDT INSPECTION REFER TO JOB CARD ATTACHING SH 0399166. 3) REPAIRED DAMAGE AREA IAW SRM 51-40-02-0G-0 REV 97, SRM 53-60-07-2R-8 REV 97 &SDR UIEA2023052200482Unknown · unknownCORROSION DAMAGE ON UPPER CHORD OF MAIN DECK FLOOR BEAM AT STA 1760, BETWEEN RBL 45.50 AND RBL 55(<P>1) REPAIR DAMAGE AREA IAW EI T2023A53M-919 REV 0 AND SRM 53-00-51-2R-3 REPAIR 3 REV 97 AND BOEING DWG 65B38088 SH 27 REV -, 65B38088 SH 28 REV -, 457U4040 SH 1SDR UIEA2023052200483Unknown · unknownFOUND MAIN DECK CARGO FLOOR BEAM STRUCTURE CORROSION AT STA 1640 LBL 33.99 AND LBL 75.92(<P>1) REPAIR DAMAGE AREA IAW EI T2023A53M-918 REV 1 AND SRM 53-00-51-2R-3 REV 97 AND BOEING DWG 65B38082 SH 14 REV -, 65B3082 SH 13 REV A. 2) ACCOMPLISHED EI T2023A53M-918SDR UIEA2023052200484Unknown · unknownEXISTING REPAIR ON AFT CGO FRAME UPPER CHORD STA 1640 RBL 15(<P>1) REMOVED EXISTING REPAIR IAW SRM 51-40-02-0G-0 REV 97. 2) ACCOMPLISHED EI T2023A53M-1056 SEQUENCE A REV 1. 3) JOB COMPLETED AND CONDITION CHECK NORMAL</P>)SDR UIEA2023052200485Unknown · unknownCORROSION ON THE FUSELAGE SKIN AT S-43L BETWEEN STA 1700 - STA 1720(<P>1) REMOVED EXISTING REPAIR PARTS IAW SRM 51-40-02-0G-0 REV 97. 2) PERFORM EI T2023A53M-870 SEQUENCE A REV 0. 3) ACCOMPLISHED EI T2023A53M-870 REV 1 AND CONDITION CHECK NORMAL. 4) RECORD THESDR UIEA2023052200486Unknown · unknownEXISTING REPAIR ON LH V.S.T. CHORD BETWEEN FRONT SPAR AND REAR SPAR AT FIN STA 595.00 FIN WL378.15 LBL 7(<P>1) REMOVED THE EXISTING REPAIR PARTS IAW SRM 51-40-02-0G-0 REV 97. 2) PERFORMED EI T2023A55M-1062 REV 1 SEQUENCE B. 3) ACCOMPLISHED EI T2023A55M-1062 RESDR UIEA2023052200487Unknown · unknownEXISTING REPAIR DOUBLER ON NOSE CGO DOOR SKIN STA 160 BETWEEN S024AR AND S-26R(<P>1) REMOVED EXISTING REPAIR DOUBLER IAW SRM 51-40-02-0G-0 REV 97. 2) PERFORM THE REPAIR IAW EI T2023A52M-1055 REV 1. 3) ACCOMPLISHED EI T2023A52M-1055 REV 2. 4) CONDITION CHECK NOSDR UIEA2023052200488Fitting · unknownCRACK - LONGERON, FUSELAGE EXTERNAL SURFACE NEAR S-331 STA 1480(<P>1) REMOVE THE DAMAGE LONGERON FITTING IAW SRM 51-40-02-0G-0 REV 97 AND EO 4453A818 PART 3 STEP 4 & 6 REV 19. 2) ACCOMPLISHED THE REPAIR AREA IAW EI T2023A53M-935 REV 2, SRM 51-40-02-0G-0 REV 97SDR UIEA2023052200489Unknown · unknownCRACK ON THE WEB OF LH STA 1480 BULKHEAD FRAME WEB(<P>1) REMOVE THE AFFECTED FASTENERS IAW SRM 51-40-02-0G-0 REV 97. 2) REPAIR THE DAMAGE AREA IAW EI T2023A53M-1037 REV 1, SRM 51-40-02-0G-0 REV 97 & SRM 53-40-08-2R-1 REPAIR 1 REV 97. 3) JOB COMPLETED AND CONDISDR UIEA2023052200490Unknown · unknownEXISTING REPAIR ON NOSE CGO DOOR STRINGER STA 180 - STA 200 S-4R(<P>1) REMOVED EXISTING REPAIR IAW SRM 51-40-02-0G-0 REV 97. 2) REPAIR STRINGER IAW EI T2023A52M-1042 REV 0. 3) ACCOMPLISHED EI T2023A52M-1042 REV 1. 4) JOB COMPLETED AND CONDITION CHECK NORMAL</PSDR UIEA2023052200491Unknown · unknownFOUND M/D CGO SIDEWALL FRAME CRACK AT STA 1860 S12R - S13R(<P>1) REMOVED DAMAGED AREA ACCESS IAW SRM 51-40-02-0G-0 & SRM 53-60-07-2R-5 REV 97. 2) PERFORM NDT INSP DAMAGE AREA FREE OF CRACK REFER TO JOB CARD ATTACHING SHEET 0389509. 3) PERFORM EI T2023A53M-985 SDR UIEA2023052200492Unknown · unknownFOUND M/D CGO FLOOR STRUCTURE CORROSION AT STA 480 BETWEEN 55.20 AND LBL 80.00(<P>1) REMOVE SUPPORT ANGLE IAW SRM 51-40-02-0G-0 REV 97. 2) FABRICATE SUPPORT ANGLE IAW EI T2023A53M-1033 REV 20, T2023A53M-1034 REV 0, T2023P53M-1023 & T2023P53M-1024 REV 0. 3) REPSDR UIEA2023052200493Unknown · unknownFOUND M/D CGO FLOOR STRUCTURE CORROSION AT STA 800 BETWEEN RBL 75.92 AND 98.58(<P>1) REPAIR DAMAGE AREA IAW EI T2023A53M-913 REV 0 T2023P53M-1025 REV 0, SRM 53-00-51-2R-3 REV 97, BOEING DWG 65B38040 SH8 REV A, 65B38040 SH9 REV D & 65B38250 SH17 REV A. 2) ACCOMSDR UIEA2023052200495Unknown · unknownCORROSION ON SKIN INNER SURFACE TOTAL 21 EACH, WHEN PERFORM SB 747-53A2878(<P>1) PERFORM EI T2023A53M-854 SEQUENCE A REV 0. 2) PERFORM EI T2023A53M-854 SEQUENCE B REV 1. 3) PERFORM EI T2023A53M-854 SEQUENCE C REV 2. 4) PERFORM EI T2023A53M-854 SEQUENCE D REV 4SDR UIEA2023052200496Angle · unknownCORROSION - BRACKET FWD WING TO BODY FAIRING SUPPORT BRACKET STA 955 TO STA 982 LBL 4(<P>1) REMOVED DAMAGE PART IAW SRM 51-40-02-0G-0 REV 97. 2) INSTALLED NEW PART IAW SRM 51-40-02-0G-0 REV 97 & DWG 65B06976 SH 2 REV G. 3) CONDITION CHECK NORMAL AND JOB COMPLESDR UIEA2023052200497Angle · unknownCORROSION DAMAGE ON ANGLE OF M/D CGO FLOOR STRUCTURE AT STA 2280 RBL 62(<P>1) REMOVE DAMAGE PARTS IAW SRM 51-40-02-0G-0 REV 97. 2) FABRICATE PARTS IAW EI T2023P53M-887 REV 0. 3) INSTALL FABRICATED PARTS IAW SRM 51-40-02-0G-0 REV 97, DWG 457U1061 SH 4 REV C & DSDR UIEA2023052200498Unknown · unknownCORROSION - BRACKET FWD WING TO BODY FAIRING FRAME SUPPORT BRACKET GWD AND AFT SIDE STA 920 S47 - S47R(<P>1) REMOVE DAMAGE PARTS IAW SRM 51-40-02-0G-0 REV 97. 2) INSTALLED NEW PARTS IAW SRM 51-40-02-0G-0 REV 97, DWG 65B06704 SH 2 REV 3 & 142U0130 SH 1 REV A. 3SDR UIEA2023052200499Flap Track · corrodedFOUND #6 FLAP TRACK INBD SIDE CONTACT WITH SIDE LOAD FITTING SURFACE CORROSION(<P>1) REF EI T2023A57M-923 REV 1 SEQUENCE A, PERFORM #6 FLAP TRACK PERMANENT REPAIR. 2) CONDITION CHECK NORMAL</P>)SDR UIEA2023052200500Fitting · corrodedFOUND M/D CGO FLOOR FITTING CORROSION AT STA 290 RBL 61 STA 300 RBL 61 & STA 320 RBL 56 TTL: 3 EACH(<P>1) IAW AMM WUBTASK 53-44-00-212-011 REV 107 & AMM SUBTASK 53-44-00-02-001 REV 107 REPLACED M/D CGO FLOOR FITTING AT STA 290 RBL 61 & STA 300 RBL 61 TTL: 2 EASDR UIEA2023052200501Actuator · failedFOUND FUNCTION FAIL AT RH WLG ALTERNATE EXTENSION ROTARY ACTUATOR(<P>1) IAW AMM 32-36-01-004-001 REV 107 & AMM 32-36-01-404-009 REV 107 STEP 3.A TO F(4) R/R RH ALTERNATE ELEC ACTUATOR. 2) IAW AMM 32-36-01-404-009 REV 107 STEP F(5) PERFORM RH WLG ALTERNATE EXTESDR UIEA2023052200502Battery · no testWHEN PERFORM EMERGENCY LIGHT BATTERY PACKS CAPACITY TEST FOUND M5168, M5169 & M5170 BATTERY FAIL(<P>1) IAW AMM 33-51-04-902-001-001 REV 107 R/R EMERGENCY LIGHT BATTERY ASSY AT M5168, M5169 & M5170. 2) IAW AMM 33-51-04-902-001-001 REV 107 PERFORMED EMERGENCY LISDR UIEA2023051500460Valve · unknownE/E COOLING EXHAUST FAN FAIL & NO FLT DECK COOLING AND ZONE TEMP STATUS MESSAGE(<P>REMOVED AND REPLACED EE COOLING FAN IAW AMM21-58-01 AND FWD TRIM AIR SHUTOFF VALVE.</P>)SDR UIEA2023050600409Structure · unknownRIGHT WING FIXED TRAILING EDGE GROUND SPOILER AT STA 432.65 SUPPORT RIB STRUCTURE END CORRODED AND METAL PEELING(<P>REPLACED CHORD ON R/H WING STA. 432.65 RIB STRUCTURE IAW EO 4457A169. NO FURTHER DEFECTS NOTED. </P>)SDR UIEA2023041800369Transfer Valve · unknownFUEL TANK #4 LEAKS INTO CENTER TANK AT A RATE OF 100 KILOS PER 11 MINUTES APPROX 600 PER HOUR UNCONTROLLABLY(<P>REPLACED BAD #3 MAIN TANK TRANSFER VALVE IAW 747 AMM 28-16-05. C/W LEACK CHECK, NO LEAKS FOUND AT THIS TIME. REF SUN AERO 5,0,2,3 RO25. REF LP 17680SDR UIEA2023042200379Transfer Valve · unknownFUEL TANK #4 LEAKS INTO CENTER TANK AT A RATE OF 100 KILOS PER 11 MINUTES, APPROX 600 PER HOUR UNCONTROLLABLY.(<P>REPLACED BAD #3 MAIN TANK TRANSFER VALVE IAW 747 AMM 28-16-05. LEAK CHECKS C/W NO LEAKS FOUND AT THIS TIME.</P>)SDR UIEA2023042180369Unknown · unknownFUEL TANK #4 LEAKS INTO CENTER TANK AT A RATE OF 100 KILOS PER 11 MINUTES APPROX 600 PER HOUR UNCONTROLLABLY(<P>MX CURRENTLY INSTALLING TRANSFER PUMP & ACTUATOR IAW AP-24097, AMM 28-22-07 & FIM 28-20-00.</P>)SDR UIEA2023041800368Unknown · unknownHYD QTY LOW #1 FOLLOWED BY HYD PRESSURE SYS #1 CAUTION ON FINAL.(<P>NOSE GEAR STEERING PRESSURE LINE AT STA 900 IN FWD PIT LEAKING. REPAIRED AND INSTALLED TEMP LINE IAW AMM 20-11-05 & GMM 3.24.1. OPS & LEAK CHECK GOOD. RE-INSPECT TEMP FLEX LINE EVERY 25 FLIGHTSDR UIEA2023041800371Coalescer Bag · unknownDURING LANDING WITH REVERSE THRUST, EICAS SMOKE CREW REST APPEARED. HAZE NOTICED IN UPPER DECK. DISSIPATING SLOWLY AFTER REVERSERS STOWED. SUSPECT AIR CONDITIONING SYSTEM CONTAMINATION.(<P>REMOVED #3 PACK COALESCER BAG PER AMM 21-51-05-002-018 AND INSTALLED NESDR UIEA2023041400342Unknown · unknownFOUND EXISTING REPAIR DOUBLER ON FWD CGO DOOR FWD LWR CORNER(<P>1. REMOVE EXISTING DOUBLER IAW SRM 51-40-02-0G-0 REV 97. 2. REPAIR DAMAGE AREA IAW SRM 52-30-01-2R-2 DETAIL IV REV 97. 3. INSTALL FASTENERS IAW SRM 51-40-02-0G-0 REV 97. 4. CONDITION CHECK NORMAL SDR UIEA2023041400343Shear Tie · unknownCRACK WAS FOUND ON STA 1000 FRONT SPAR BULKHEAD LBL 57.50 SHEAR TIE(<P>1) REMOVED THE DAMAGE PART IAW SRM 51-40-02-0G-0 REV 97. 2) INSTALL NEW PART IAW SRM 51-40-02-0G-0 REV 97 & EO 4453C24 PART 5 REV 3. 3) PERFORM EI T2023A53M-620 REV 0. 4) ACCOMPLISHED IAW ESDR UIEA2023041400344Unknown · unknownFOUND EXISTING REPAIR DOUBLER ON FUSELAGE SKIN AT STA 1920 TO STA 1940 BETWEEN S-31R TO S-34R(<P>1) REMOVED EXISTING REPAIR DOUBLER IAW SRM 51-40-02-0G-0 REV 97. 2) PERFORM EI T2023A53M-724 SEQUENCE A REV 0. 3) PERFORMED EI T2023A53M-724 REV 1 SEQUENCE B. 4) A
Back to Boeing 747-47UF