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 P5CA2025080600055Stringer · crackedFOUND STRINGER CRACKED AT BS 970, S7R. REPAIRED THE STRINGER IAW WORK SHEET 50515, AND SRM 53-20-03-2R-1, REV 46. JOB COMPLETED AND CONDITION CHECK NORMAL.SDR P5CA2025080600056Stringer · crackedFOUND STRINGER CRACKED AT BS 918, S10R. ACCOMPLISHED EI T2025A53M-1577, SEQUENCE A, REV 0 IAW SRM 53-20-03, REPAIR 1, REV 46. ACCOMPLISHED EI T2025A53M-1392, REV 0. ACCOMPLISHED EI #T2025A53M-1577 REV 1. JOB COMPLETED AND CONDITION CHECK NORMAL.SDR P5CA2025080600057Stringer · crackedFOUND STRINGER CRACK AT BS 958, S7L. ACCOMPLISHED EI #T2025A53M-1566, SEQUENCE A, REV 0. ACCOMPLISHED EI T2025A53M-1566 REV 1. JOB COMPLETED AND CONDITION CHECK NORMAL.SDR P5CA2025080600058Stringer · crackedFOUND STRINGER CRACKED AT BS 963, S7L. ACCOMPLISHED EI T2025A53M-1566, SEQUENCE A, REV 1, AND EI ATTACHED TO W/O 11234472. JOB COMPLETED AND CONDITION CHECK NORMAL.SDR P5CA2025080600059Stringer · crackedFOUND STRINGER CRACK AT STA 957, S-7R. ACCOMPLISHED EI T2025A53M-1569, SEQUENCE A, REV 0, IAW SRM 53-20-03 REPAIR 1, REV 46. ACCOMPLISHED EI #T2025A53M-1569, REV 1. JOB COMPLETED AND CONDITION CHECK NORMAL.SDR P5CA2025080600060Stringer · crackedFOUND STRINGER CRACK AT BS 944, S7R. ACCOMPLISHED EI T2025A53M-1569, SEQUENCE A, REV 1, AND EI ATTACHED TO W/O #11244350. 2. JOB COMPLETED AND CONDITION CHECK NORMALSDR P5CA2025080600061Stringer · crackedFOUND STRINGER CRACKED AT BS 763, S8L. REPAIR THE DAMAGE AREA IAW EI T2025A53M-1575, REV 0, AND SRM 53-20-03, REPAIR 1, REV 46. ACCOMPLISHED EI T2025A53M-1575, REV 1. JOB COMPLETED AND CONDITION CHECK NORMAL.SDR P5CA2025080600062Skin · dentedPERMANENT REPAIR OF SCRATCH AND DENT ON FUSELAGE SECTION 46 SKIN COMMON TO LAP AND BUTT SPLICE AT STA 1740 AND S-46L REQUIRED PER PART 3 OF EO 4853A132 BEFORE 10000 FC. ACCOMPLISHED EI #T2025A53M-1615, REV 1 FOR UPGRADE FUSELAGE SKIN TIME-LIMITED REPAIR. ASDR P5CA2025080600063Battery · no testFOUND M5168 EMERGENCY POWER COULD NOT STAY MORE THAN 15 MINS IAW AMM 33-51-04-900-803, REV 47. REPLACED POWER SUPPLY BATTERY (M5168) AT UPPER DECK, THE CONDITION CHECK NORMAL IAW AMM 33-51-04-900-803 REV 47. PERFORMED INSTALLATION TEST OF (M5168) POWER SUPSDR P5CA2025080600064Battery Pack · no testFOUND M5170 EMERGENCY POWER FUNCTION. IAW AMM 33-51-04-000-803 & 33-51-04-900-803 & 33-51-04-400-803 REV 48. REPLACED BATTERY ASSY (M5170) AT UPPER DECK AREA, THE CONDITION CHECK NORMAL IAW AMM 33-51-04-900-803 & 33-51-04-400-803 REV 48. PERFORMED INSTALLATSDR UIEA2025070600841Rib · crackedRHW T/E I/B AILERON L/H I/B ATTACH HINGE RIB UPPER T/E FLANGE FOUND CRACKED AS MARKED.(<P>RHW T/E I/B AILERON L/H I/B ATTACH HINGE RIB UPPER T/E FLANGE REPAIRED IAW RI-57-20-17700 REV.A. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2025070600842Rib · crackedLHW T/E I/B AILERON R/H HINGE ATTACH R/H RIB UPPER FLANGE FOUND CRACKED.(<P>HW T/E I/B AILERON R/H HINGE ATTACH R/H RIB UPPER FLANGE REPAIRED I.A.W RI-57-20-17699 REV.A. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2025071000897Flap · damaged#7 V/C FLAP LSA DAMAGED.(<P>PERFORMED REPAIR AT LSA DAMAGE AREA IAW CMM 57-55-42 REPAIR 17-1. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2025071000898Flap · damaged#8 V/C FLAP LSA DAMAGED.(<P>PERFORMED REPAIR AT LSA DAMAGE AREA IAW CMM 57-55-42 REPAIR 17-1. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2025071000899Flap · damaged#19 V/C FLAP LSA DAMAGED.(<P>PERFORMED REPAIR AT LSA DAMAGE AREA IAW CMM 57-55-42 REPAIR 17-1. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2025071000900Flap · damaged#20 V/C FLAP LSA DAMAGED. PERFORMED REPAIR AT LSA DAMAGE AREA IAW CMM 57-55-42 REPAIR 17-1. NO FURTHER DEFECTS NOTED.SDR UIEA2025071400948Rib · crackedRHW R/H O/B AILERON ATTACH HINGE L/H AFT SPAR RIB (691JB) FLANGE FOUND CRACKED AS MARKED.(<P>RHW R/H O/B AILERON ATTACH HINGE L/H AFT SPAR RIB (691JB) FLANGE FOUND CRACKED AREA REPAIRED IAW RI-57-51-17702 REV.A. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2025071400950Stringer · crackedM/D STA 879 AND STA 882 S7L STRINGER AREA FOUND CRACK AS PER EO 4853A131 1 & 2.(<P>M/D STA 879 AND STA 882 S7L STRINGER AREA CRACK REPAIRED IAW 747-8F SRM 53-20-03 REPAIR 1 REV.46. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2025071400951Stringer · crackedM/D STA 880-890 S8L STRINGER AREA FOUND CRACK AS PER EO 4853A131 1 & 2.(<P>M/D STA 880-890 S8L STRINGER CRACKED AREA REPAIRED AS PER EO 4853A131 1 & 2 B747-8F SRM 53-20-03 REPAIR 1 REV.46. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2025071500952Stringer · crackedM/D - STA 2180 FWD AND AFT, S-10L STRINGER FOUND CRACKED.(<P>M/D - STA 2180 FWD AND AFT, S-10L STRINGER CRACKED AREA REPAIRED IAW SRM 53-60-03-2R-3 ALTERNATIVE 4 FIG 205 REV.46. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2025071600959Rib · crackedRHW T/E I/B AILERON L/H O/B ATTACH HINGE RIB UPPER T/E FLANGE FOUND CRACKED AS MARKED.(<P>RHW T/E I/B AILERON L/H O/B ATTACH HINGE RIB UPPER T/E FLANGE CRACKED AREA REPAIRED IAW RI-57-20-17701 REV.A. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2025071700965Stringer · crackedM/D - STA 2180 AFT AND FWD, S-12L STRINGER FOUND CRACKED.(<P>M/D - STA 2180 AFT AND FWD, S-12L STRINGER CRACKED AREA REPAIRED IAW SRM 53-60-03-2R-3 ALTERNATIVE 4 FIG 205 REV.46. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2025071700967Stringer · crackedM/D - STA 2180 FWD AND AFT, S-10R STRINGER FOUND CRACKED.(<P>M/D - STA 2180 FWD AND AFT, S-10R STRINGER CRACKED AREA REPAIRED IAW SRM 53-60-03-2R-3 ALTERNATIVE 4 FIG 205 REV.46. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2025071700968Stringer · crackedM/D - STA 2180 AFT AND FWD, S-11R STRINGER FOUND CRACKED.(<P>M/D - STA 2180 AFT AND FWD, S-11R STRINGER CRACKED AREA REPAIRED IAW SRM 53-60-03-2R-3 AL 4 FIG 205 REV.46. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2025071700969Stringer · crackedM/D - STA 2180 AFT AND FWD, S-12R STRINGER FOUND CRACKED.(<P>M/D - STA 2180 AFT AND FWD, S-12R STRINGER CRACKED AREA REPAIRED IAW SRM 53-60-03-2R-3 ALTERNATIVE 4 FIG 205 REV.46. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2025071700970Stringer · crackedM/D STA 919 S8L STRINGER AREA FOUND CRACK AS PER EO 4853A131 1 & 2.(<P>M/D STA 919 S8L STRINGER AREA CRACKED AREA REPAIRED IAW B747-8F SRM 53-20-03-2R-1 REPAIR 1 REV.46. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2025071800973Stringer · crackedM/D STA 850-862 S10L STRINGER AREA FOUND SEVERAL CRACKS AS PER EO 4853A131 1 & 2.(<P>M/D STA 850-862 S10L STRINGER CRACKED AREAS REPAIRED IAW B747-8F SRM 53-20-03-2R-1 REPAIR 1 REV.46. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2025071800974Stringer · crackedEMP - STA 2598 FWD FACE STRINGER 7R SUSPECT CRACKED.(<P>EMP - STA 2598 FWD FACE STRINGER 7R CRACKED AREA REPAIRED I.A.W RI-53-81-17714 REV.A. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2025071800975Stringer · crackedEMP - STA 2598 FWD FACE STRINGER 1R SUSPECT CRACKED.(<P>EMP - STA 2598 FWD FACE STRINGER 1R CRACKED AREA REPAIRED IAW RI-53-81-17713 REV.A. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2025072000981Stringer · crackedEMP - STA 2598 FWD FACE STRINGER 7L SUSPECT CRACKED.(<P>EMP - STA 2598 FWD FACE STRINGER 7L CRACKED AREA REPAIRED IAW RI-53-81-17707 REV.A. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2025072000982Stringer · crackedM/D - STA 1960 AFT, S-8R STRINGER FOUND CRACKED.(<P>M/D - STA 1960 AFT, S-8R STRINGER CRACKED AREA REPAIRED IAW SRM 53-60-03-2R-4 ALTERNATIVE 3 FIG 204 REV.46. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2025072100984Fairing · crackedLONGERON BOX FAIRING FOUND CRACK.(<P>PERFORMED REPAIR AT CRACKED AREA AS PER RI-53-40-17743 REV.A. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2025072100985Channel · crackedHORIZONTAL STAB. T/E AFT SUPPORT WEDGE U CHANNEL FOUND CRACK.(<P>REPLACED U CHANNEL AS PER RI-55-10-17723 REV.A. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2025072100986Stringer · cracked2 EA CRACKS WERE FOUND ON STRINGER I/B SIDE AT FWD OF BS2360 STR 1R AREA.(<P>CRACKS ON STRINGER I/B SIDE AT FWD OF BS2360 STR 1R AREA REPAIRED IAW RI-53-61-17705 REV.A. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2025072100987Stringer · cracked2 EA CRACKS WERE FOUND ON STRINGER UPPER SIDE AT FWD OF BS 2360 STR 7R AREA.(<P>2 EA CRACKS ON STRINGER UPPER SIDE AT FWD OF BS 2360 STR 7R AREA REPAIRED IAW B747-8F SRM 53-60-03-2R-8 REPAIR 8 TR53-149. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2025072100988Stringer · crackedCRACKS WERE FOUND ON STRINGER I/B AND O/B SIDE AT FWD OF BS 2360 STR 2R AREA.(<P>CRACKS ON STRINGER I/B AND O/B SIDE AT FWD OF BS 2360 STR 2R AREA WERE REPAIRED IAW RI-53-61-17706 REV.A. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2025072100990Stringer · cracked2 EA CRACK WERE FOUND ON STRINGER O/B SIDE AT FWD OF BS 2360 STR 2L AREA.(<P>2 EA CRACKS ON STRINGER O/B SIDE AT FWD OF BS 2360 STR 2L AREA WERE REPAIRED IAW RI-53-61-17703 REV.A. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2025072100991Stringer · crackedEMP - STA 2598 AFT FACE STRINGER 26R SUSPECT CRACKED.(<P>EMP - STA 2598 AFT FACE STRINGER 26R CRACKED AREA REPAIRED IAW RI-53-81-17744 REV.A. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2025072200992Stringer · crackedEMP - STA 2598 AFT FACE STRINGER 25L SUSPECT CRACKED.(<P>EMP - STA 2598 AFT FACE STRINGER 25L CRACKED AREA REPAIRED IAW SRM 53-80-03-2R-1 REPAIR 1 TR 53-151. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2025072200993Stringer · crackedM/D STA 798 S9L STRINGER AREA FOUND CRACK AS PER EO 4853A 131 1 & 2.(<P>M/D STA 798 S9L STRINGER AREA CRACKS WERE REPAIRED IAW B747-8F SRM 53-20-03 REPAIR 1 REV.46. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2025072200994Stringer · crackedEMP - STA 2598 AFT FACE STRINGER 42R SUSPECT CRACKED.(<P>EMP - STA 2598 AFT FACE STRINGER 42R CRACKED AREA REPAIRED IAW RI-53-81-17716 REV 46. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2025072200995Stringer · crackedEMP - STA 2598 AFT FACE STRINGER 7L SUSPECT CRACKED.(<P>EMP - STA 2598 AFT FACE STRINGER 7L CRACKED AREA REPAIRED IAW SRM 53-80-03-2R-2 TR 53-152. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2025072200996Stringer · crackedEMP - STA 2598 AFT FACE STRINGER 6L SUSPECT CRACKED.(<P>EMP - STA 2598 AFT FACE STRINGER 6L CRACKED AREA REPAIRED IAW SRM 53-80-03-2R-2 TR 53-152. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2025072200999Stringer · crackedEMP - STA 2598 AFT FACE STRINGER 5L SUSPECT CRACKED. - STA 2598 AFT FACE STRINGER 5L CRACKED AREA REPAIRED IAW SRM 53-80-03-2R-2 TR 53-152. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2025072301000Stringer · crackedEMP - STA 2598 AFT FACE STRINGER 25R SUSPECT CRACKED. - STA 2598 AFT FACE STRINGER 25R CRACKED AREA REPAIRED IAW RI-53-81-17753 REV.A. NO FUTHER DEFECTS NOTED.</P>)SDR UIEA2025072301001Stringer · crackedEMP - STA 2598 FWD FACE STRINGER 51L SUSPECT CRACKED. - STA 2598 FWD FACE STRINGER 51L CRACKED AREA REPAIRED I.A.W RI-53-81-17739 REV.A. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2025072301002Stringer · crackedEMP - STA 2598 FWD FACE STRINGER 8L SUSPECT CRACKED. - STA 2598 FWD FACE STRINGER 8L CRACKED AREA REPAIRED IAW SRM 53-80-03-2R-2 TR 53-152. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2025072301003Skin · crackedFOUND CRACK ON RUDDER.(<P>PERFORMED REPAIR AT CRACK AREA AS PER SRM 51-70-04 REPAIR 5. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2025072301004Stringer · crackedEMP - STA 2598 FWD FACE STRINGER 5R SUSPECT CRACKED.- STA 2598 FWD FACE STRINGER 5R CRACKED AREA REPAIRED IAW RI-53-81-17715 REV.A. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2025072301005Stringer · crackedEMP - STA 2598 AFT FACE STRINGER 4L SUSPECT CRACKED.- STA 2598 AFT FACE STRINGER 4L CRACKED AREA REPAIRED IAW SRM 53-80-03-2R-2 TR 53-152. NO FURTHER DEFECTS NOTED.</P>)
Back to Boeing 747-87UF