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 UIEA2021071601569Skin · puncturedRH BLG W/W O/B DOOR INTERIOR SURFACE FWD AREA FOUND PUNCTURE.(<P>THE SUBJECT DOOR INTERIOR SKIN REPAIR CARRIED OUT AS PER RI-52-80-14763 REV A</P>)SDR UIEA2021071601570Seat Track · corrodedM/D - SEAT TRACK STA 2110 LBL 11 FOUND CORROSION.(<P>THE SUBJECT SEAT TRACK REPAIR CARRIED OUT AS PER RI-53-00-14764 REV A</P>)SDR UIEA2021071601571Seat Track · corrodedM/D - SEAT TRACK STA 2090 LBL 11 FOUND CORROSION.(<P>THE SUBJECT SEAT TRACK REPAIR CARRIED OUT AS PER RI-53-00-14762 REV A</P>)SDR P5CA2021063000251Fitting · crackedRH CANTED PRESSURE DECK, A FASTENER HOLE OF OUTERMOST FITTING WAS FOUND 2EA CRACKS AT APPROX. STA 1241 RBL 125.(<P>RH CANTED PRESSURE DECK. STA 1241 RBL 125 FASTENER HOLE REPAIRED AS PER RI-53-45-14705 REV A.</P>)SDR P5CA2021062900250Partition · damagedBULK CARGO - STA 2160 PARTITION LOWER EDGE TORN AND L/R ATT FABRIC LINER.(<P>BULK CARGO - STA 2160 PARTITION LOWER FABRIC LINER REPAIRED AS PER RI NO. RI-25-54-14673 REV A 24 JUN 2021.</P>)SDR P5CA2021062800248Spar · damagedRH ELEVATOR FRONT SPAR STA 186.80 STIFFENER HAS HOLES ELONGATE AT I/B AND O/B SIDE.(<P>RH ELEVATOR FRONT SPAR STA 186.80 STIFFENER ELONGATED HOLES REPAIRED AS PER RI-55-33-14694 REV A. </P>)SDR P5CA2021062000245Switch · faultedEO. 4852A037 PART 1, SB 747-52-2307 FWD CARGO DOOR CONTROL SWITCH PAN CLIPS FOUND DISCREPANCIES.(<P>EO. 4852A037 PART 1, SB 747-52-2307 FWD CARGO DOOR CONTROL SWITCH PAN CLIPS INSTALLED IAW RI-52-00-14681 REV A. </P>)SDR UIEA2021062701424Controller · faultedBLEED 1 ADVISORY AND BLEED # 3 ADVISORY MSG. REMOVED AND REPLACED #1 IASC AND #3 IASC IAW B747-8 AMM 36-10-01/401</SPAN></P>)SDR P5CA2021042200152Intercostal · crackedMAIN DECK SIDE CARGO DOOR LATCH FRAME SPLICE INTERCOSTAL WEB (146U6145-1), DOUBLER (65B17613-30), AND INNER CHORD (146U6157-10) - CRACK DAMAGE AT STA 1707 WL210 TO WL200 - CAT C REPAIR(<P ><SPAN>PERFORMED TIME LIMITED / REPAIR OF MAIN DECK SIDE CARGO DOOR IAW SDR P5CA2021041900097Skin · dentedDENT - PNL, V-STAB, LH SURFACE, FS 130, BSTA 2130(<P>CUT OUT THE DAMAGED AREA AND CLEAN. MEASURE THE DAMAGED AREA (DIA = 2", D = 0.01", 28.5" FROM FWD EDGE, 10" FRO UPR EDGE AT V-STAB, L/H SURFACE. FS130 BSTA 2130) BOND FILLER AND REPAIR DOUBLER (DIA = 5", ASSDR P5CA2021041900098Skin · not reportedDEVIATION FOUND DURING PERFORM 747-8F SRM 53-00-01 REPAIR 1 ON FUSELAGE SKIN NEAR STA 680 BETWEEN S-31R AND S-33R.(<P>ACCOMPLISHED EI NO T2021A53M-1021 REV. 1. JOB COMPLETED AND CONDITION CHECK NORMAL.</P>)SDR P5CA2021041900099Rib · crackedCRACK ON RIB OF RH WING OF FIXED TRAILING EDGE AT WBL 448.7(<P>ACCOMPLISHED EI NO T2021A57M-861 REV 1. JOB COMPLETED AND CONDITION CHECK NORMAL</P>)SDR P5CA2021041900100Stringer · crackedCRACK DAMAGE ON THE STRINGER S-6R BETWEEN STA 770 AND STA 790(<P>ACCOMPLISHED EI NO: T2021A53M-866 REV. 1. CONDITION CHECK NORMAL AND JOB COMPLETED,</P>)SDR P5CA2021041900101Stringer · crackedCRACK DAMAGE ON THE STRINGER S-7R BETWEEN STA 850 AND 890(<P>ACCOMPLISHED EI NO T2021A53M-869, REV 1. CONDITION CHECK NORMAL AND JOB COMPLETED.</P>)SDR P5CA2021041900102Stringer · crackedCRACK DAMAGE ON THE STRINGER S-7R BETWEEN STA 930 AND STA 970(<P>ACCOMPLISHED EI NO T2021A53M-869 REV 1 AND ITS ATTACHING WITH WO NO 5672759. CONDITION CHECK NORMAL AND JOB COMPLETED.</P>)SDR P5CA2021041900103Stringer · crackedCRACK DAMAGE ON THE STRINGER S-11R BETWEEN STA 810 AND STA 890(<P>ACCOMPLISHED EI NO T2021A53M-877 REV 1. CONDITION CHECK NORMAL AND JOB COMPLETED.</P>)SDR P5CA2021041900104Stringer · crackedCRACK DAMAGE ON THE STRINGER S-9R BETWEEN STA 870 AND STA 910.(<P>ACCOMPLISHED EI NO T2021A53M-873 REV 1 AND ITS ATTACHING WITH WO 5671454 (372). CONDITION CHECK NORMAL AND JOB COMPLETED.</P>)SDR P5CA2021041900105Stringer · crackedCRACK DAMAGE ON THE STRINGER S-9R BETWEEN STA 930 AND 950(<P>ACCOMPLISHED EI NO T2021A53M-873 REV 1. CONDITION CHECK NORMAL AND JOB COMPLETED.</P>)SDR P5CA2021041900106Stringer · crackedCRACK DAMAGE ON THE STRINGER S-10R BETWEEN STA 870 AND STA 890(<P>ACCOMPLISHED EI NO T2021A53M-875 REV 1. CONDITION CHECK NORMAL AND JOB COMPLETED.</P>)SDR P5CA2021041900107Stringer · crackedCRACK DAMAGE ON THE STRINGER S-8R BETWEEN STA 790 AND STA 810(<P>ACCOMPLISHED EI NO T2021A53M-871 REV 1. CONDITION CHECK NORMAL AND JOB COMPLETED.</P>)SDR P5CA2021041900108Stringer · crackedCRACK DAMAGE ON THE STRINGER S-8R BETWEEN STA 930 AND STA 980+30(<P>ACCOMPLISHED EI NO T2021A53M-871 REV 1 AND ITS ATTACHING WITH WO 5672202. CONDITION CHECK NORMAL AND JOB COMPLETED.</P>)SDR P5CA2021041900109Stringer · crackedCRACK DAMAGE ON THE STRINGER S-8R BETWEEN STA 830 AND STA 910.(<P>ACCOMPLISHED EI NO T2021A53M-871 REV 1 AND ITS ATTACHING WITH WO 5672202. CONDITION CHECK NORMAL AND JOB COMPLETED.</P>)SDR P5CA2021041900110Stringer · crackedCRACK DAMAGE ON THE STRINGER S-18R, AT FWD SIDE OF STA 1740(<P>REPAIRED DAMAGED AREA IAW EI NO T2021A53M-914 REV 1. REINSTALL FASTENERS IAW SRM 51-40-02 REV 33 AND DWG NO 146U1741 SHEET 325, REV - AND DWG NO 146U11620, SH80 REV B. CONDITION CHECK NORMAL AND JOSDR P5CA2021041900111Stringer · crackedCRACK DAMAGE ON THE STRINGER S-12L, AT AFT SIDE OF STA 2180.(<P>REMOVED AFFECTED FASTENER TO GET ACCESS IAW SRM 51-40-02 REV 33. ACCOMPLISHED EI NO T2021A53M-936 REV 1. REINSTALLED FASTENER IAW SRM 51-40-02 REV 33 AND DWG NO 146U1312 SHEET 113 REV - . JOB COMPSDR P5CA2021042000112Stringer · crackedCRACK - STRINGER, FWD UPPER FUSELAGE INTERNAL STRUCTURE STA 870 - STA 890, S-8L(<P>REPAIR DAMAGE AREA IAW EI NO T2021A53M-870 REV 1. JOB COMPLETED AND CONDITION CHECK NORMAL.</P>)SDR P5CA2021042000113Stringer · crackedCRACK - STRINGER, FWD UPPER FUSELAGE INTERNAL STRUCTURE STA 930 - STA 970, S-8L(<P>ACCOMPLISHED EI NO T2021A53M-870, REV 1 AND EI ATTACHING WITH WO NO. 5670088 (365). JOB COMPLETED AND CONDITION CHECK NORMAL.</P>)SDR P5CA2021042000114Stringer · crackedCRACK - STRINGER, FWD UPPER FUSELAGE INTERNAL STRUCTURE STA 870 - STA 910, S-11L(<P>REPAIR DAMAGE AREA IAW EI NO T2021A53M-876, REV 1. JOB COMPLETED AND CONDITION CHK NORMAL.</P>)SDR P5CA2021042000115Stringer · crackedCRACK - STRINGER, FWD UPPER FUSELAGE INTERNAL STRUCTURE STA 850 - STA 890, S-10L(<P>REPAIR DAMAGED AREA IAW EI NO T2021A53M-874, REV 1. JOB COMPLETED AND CONDITION CHECK NORMAL.</P>)SDR P5CA2021042000116Stringer · crackedCRACK - STRINGER, FWD UPPER FUSELAGE INTERNAL STRUCTURE STA 870 - STA 890, S-7L(<P>REPAIR DAMAGED AREA IAW EI NO T2021A53M-867, REV 1. JOB COMPLETED AND CONDITION CHK NORMAL.</P>)SDR P5CA2021042000117Stringer · crackedCRACK DAMAGE ON STRINGER S-17L, AT FWD SIDE OF STA 1960(<P>REMOVED AFFECTED FASTENER TO GET ACCESS IAW SRM 51-40-02 REV 22. ACCOMPLISHED EI NO T2021A53M-928 REV 1. REINSTALLED FASTENERS IAW SRM 51-40-02 REV 33 AND DWG NO 146U1940 SHEET 206 REV -. JOB COMPLETD SDR P5CA2021042000118Stringer · crackedCRACK DAMAGE ON STRINGER, S-22L, AT FWD SIDE OF STA 1960.(<P>REMOVED AFFECTED FASTENER TO GET ACCESS IAW SRM 51-40-02 REV 33. ACCOMPLISHED EI NO T2021A53M-932 REV 1. REINSTALLED FASTENERS IAW SRM 51-40-02 REV 33 AND DWG NO 146U1961 SHEET 470 REV A AND 146U1961SDR P5CA2021042000119Stringer · crackedCRACK DAMAGE ON THE STRINGER S-23L, AT FWD SIDE OF STA 2180.(<P>REMOVED AFFECTED FASTENER TO GET ACCESS IAW SRM 51-40-02 REV 22. ACCOMPLISHED EI NO T2021A53M-940 REV 1. REINSTALLED FASTENERS IAW SRM 51-40-02 REV 33 AND DWG NO 146U2160 SHEET 158 REV C. JOB COMPSDR P5CA2021042000120Stringer · crackedCRACK DAMAGE ON THE STRINGER S-12L, AT FWD SIDE OF STA 1960.(<P>REMOVED AFFECTED FASTENER TO GET ACCESS IAW SRM 51-40-02 REV 33. ACCOMPLISHED EI NO T2021A53M-927 REV 1. REINSTALLED FASTENERS IAW SRM 51-40-02 REV 33 AND DWG NO 146U1940 SHEET 206 REV -. JOB COMPSDR P5CA2021042000121Stringer · crackedCRACK DAMAGE ON THE STRINGER S-10L, AT FWD SIDE OF STA 1960.(<P>REMOVED AFFECTED FASTENER TO GET ACCESS IAW SRM 51-40-02 REV 33. ACCOMPLISHED EI NO T2021A53M-926 REV 1. REINSTALLED FASTENER IAW SRM 51-40-02 REV 33 AND DWG NO 146U1940 SHEET 206 REV -. JOB COMPLSDR P5CA2021042000122Stringer · crackedCRACK DAMAGE ON STRINGER S-21L AT FWD SIDE OF STA 1960.(<P>REMOVED AFFECTED FASTENER TO GET ACCESS IAW SRM 51-40-02 REV 33. ACCOMPLISHED EI NO T2021A53M-931 REV 1. REINSTALL FASTENERS IAW SRM 51-40-02 REV 33 AND DWG NO 146U1365 SHEET 20 REV A AND 146U1365 SHEESDR P5CA2021042000123Stringer · crackedCRACK DAMAGE ON THE STRINGER AT S-46L, STA 2604(<P>REPAIR DAMAGE AREA IAW EI NO T2021A53M-1014 REV 1. JOB COMPLETED AND CONDITION CHK NORMAL.</P>)SDR P5CA2021042000124Stringer · crackedCRACK DAMAGES ON THE STRINGER S-42R NEAR STA 2605.(<P>REPAIR DAMAGE AREA IAW EI NO T2021A53M-1015, REV 1. JOB COMPLETED AND CONDITION CHK NORMAL.</P>)SDR P5CA2021042000125Stringer · crackedCRACK DAMAGES ON THE STRINGER S-42L NEAR STA 2606.(<P>REPAIR DAMAGE AREA IAW EI NO 52021A53M-1013 REV 1. JOB COMPLETED AND CONDITION CHK NORMAL.</P>)SDR P5CA2021042000126Stringer · crackedCRACK DAMAGES ON THE STRINGER AT S-46R STA 2604(<P>REPAIR DAMAGE AREA IAW EI NO T2021A53M-1016 REV 1. JOB COMPLETED AND CONDITION CHK NORMAL.</P>)SDR P5CA2021042000127Stringer · crackedCRACK - STRINGER, FWD UPPER FUSELAGE INTERNAL STRUCTURE STA 950 - STA 980+30, S-9L(<P>ACCOMPLISHED EI NO T2021A53M-872, REV 1 AND EI ATTACH TO WO NO 5670098 (367). JOB COMPLETED AND CONDITION CHK NORMAL.</P>)SDR P5CA2021042000128Stringer · crackedCRACK - STRINGER, FWD UPPER FUSELAGE INTERNAL STRUCTURE STA 930 - STA 950, S-9L(<P>REPAIR DAMAGE AREA IAW EI NO T2021A53M-872, REV 1. JOB COMPLETED AND CONDITION CHK NORMAL.</P>)SDR P5CA2021042000129Stringer · crackedCRACK DAMAGE ON THE STRINGER S-11R, AT FWD SIDE OF STA 1960(<P>REPAIRED DAMAGE AREA IAW EI NO T2021A53M-921 REV 1. REINSTALL FASTENERS IAW SRM 51-40-02 REV 33 AND DWG NO 146U1961 SH511, 513, REV B AND 146U1961 SH465 REV B. CONDITION CHK NORMAL AND JOB COMPLETESDR P5CA2021042000130Stringer · crackedCRACK DAMGE ON THE STRINGER S-21L, AT AFT SIDE OF STA 2180(<P>REMOVED AFFECTED FASTENER TO GET ACCESS IAW SRM 51-40-02 REV 33. ACCOMPLISHED EI NO T2021A53M-939 REV 1. REINSTALLED FASTENERS IAW SRM 51-40-02 REV 33 AND DWG NO 146U2200 SHEET 153 REV -. JOB COMPLESDR P5CA2021042000131Stringer · crackedCRACK DAMAGE ON STRINGER S-20L, AT FWD SIDE OF STA 1960.(<P>REMOVED AFFECTED FASTENER TO GET ACCESS IAW SRM 51-40-02 REV 33. ACCOMPLISHED EI NO T2021A53M-930 REV 1. REINSTALLED FASTENER IAW SRM 51-40-02 REV 33 AND DWG NO 146U1940 SHEET 206 REV -. JOB COMPLETEDSDR P5CA2021042000132Stringer · crackedCRACK DAMAGE ON THE STRINGER S-23L, AT FWD SIDE OF STA 1960.(<P>REMOVED AFFECTED FASTENER TO GET ACCESS IAW SRM 51-40-02 REV 33. ACCOMPLISHED EI NO T2021A53M-933 REV 1. REINSTALLED FASTENERS IAW SRM 51-40-02 REV 33 AND DWG NO 146U1365 SHEET 20 REV A AND 146U13SDR P5CA2021042000133Stringer · crackedCRACK DAMAGE ON THE STRINGER S-17L, AT AFT SIDE OF STA 2180.(<P>REMOVED AFFECTED FASTENER TO GET ACCESS IAW SRM 51-40-02 REV 33. ACCOMPLISHED EI NO T2021A53M-938, REV 1. REINSTALLED FASTENERS IAW SRM 51-40-02 REV 33 AND DWG NO 146U2200 SHEET 154 REV -. JOB COMSDR P5CA2021042000134Stringer · crackedCRACK DAMAGE ON THE STRINGER S-13L, AT AFT SIDE OF STA 2180(<P>REMOVED AFFECTED FASTENER TO GET ACCESS IAW SRM 51-40-02 REV 33. ACCOMPLISHED EI NO T2021A53M-937 REV 1. REINSTALLED FASTENERS IAW SRM 51-40-02 REV 33 AND DWG NO 146U2181 SHEET 368 REV C. JOB COMPLSDR P5CA2021042000135Stringer · crackedCRACK DAMAGE ON THE STRINGER S-19L, AT AFT SIDE OF STA 1960.(<P>REMOVED AFFECTED FASTENER TO GET ACCESS IAW SRM 51-40-02 REV 33, ACCOMPLISHED EI NO T2021A53M-929 REV 1. REINSTALLED FASTENERS IAW SRM 51-40-02 REV 33 AND DWG NO 146U1980, SHEET 86 REV B. JOB COMPSDR P5CA2021042100137Stringer · crackedCRACK DAMAGE ON THE STRINGER 2-9R, AT FWD SIDE OF STA 1960(<P>REPAIRED DAMAGED AREA IAW EI NO T2021A53M-920 REV 1. INSTALLED FASTENERS IAW SRM 51-40-02 REV 33 AND DWG NO 146U1961 SHEET 511 513 REV B, 146U1940 SHEET 173 REV -. CONDITION CHECK NORMAL AND JOB COMSDR P5CA2021042100138Stringer · crackedCRACK DAMAGE ON THE STRINGER S-23R, AT FWD SIDE OF STA 1740.(<P>REPAIRED DAMAGED AREA IAW EI NO T2021A53M-918 REV 1. INSTALLED FASTENERS IAW SRM 51-40-02, REV 33 AND DWG NO 146U1741 SH 324, 325 REV - AND DWG NO 146U1720 SH 79 REV B. CONDITION CHK NORMAL AND JO
Back to Boeing 747-87UF