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 P5CA2020101800361Warning Message · illuminatedBTB. DURING INITIAL TAKEOFF ROLL (25 KTS). EICAS WARNING CONFIG GEAR CENTER ACTIVATED. ABORTED T/O AND WARNING CEASED IMMEDIATELY. WE ATTEMPTED TAKEOFF AGAIN. WARNING REPEATED PLACED ON DMI, MEL REF 32-53-01, MDDR NR 135599.SDR P5CA2020100200327None · noneLIGHTNING STRIKE-SKIN, UPPER FUSELAGE EXTERNAL SURFACE STA 496, S-22R. ACCOMPLISHED THE REPAIR, IAW EI NO T2020A53M-2409 REV 1 AND REPAIR DATA ATTACHING WITH WO 4988234. CONDITION CHECK NORMAL AND JOB COMPLETED.SDR P5CA2020100200326None · noneLIGHTNING STRIKE-SKIN, UPPER FUSELAGE EXTERNAL SURFACE STA 500 S-21R TO S-22R. ACCOMPLISHED THE REPAIR, IAW EI NO T2020A53M-2409 REV 1. CONDITION CHECK NORMAL AND JOB COMPLETED.SDR P5CA2020100500340Stringer · crackedREPAIR, CRACK DAMAGE ON THE STRINGER S-19R AT AFT SIDE OF STA 1741. ACCOMPLISHED THE REPAIR, IAW EI NO T2020A53M-2513 REV 1. CONDITION CHECK NORMAL AND JOB COMPLETED.SDR P5CA2020100500341Rib · wornWORN RIB, RT WING INBOARD LEADING EDGE CAVITY UPPER RIB LOWER SIDE IFSS 492.22. REPAIRED DAMAGED AREA, IAW EI NO T2020A57M-2393 REV 2. JOB COMPLETED AND CONDITION CHECK NORMAL.SDR P5CA2020100500342Stringer · crackedREPAIR, CRACK DAMAGE ON THE STRINGER S-15L AT AFT SIDE OF STA 2180. REPAIRED, IAW EI NO T2020A53M-2520 REV 1. JOB COMPLETED AND CONDITION CHECK NORMAL.SDR P5CA2020100500343Stringer · crackedREPAIR, CRACK DAMAGE ON THE STRINGER S-10R AT AFT SIDE OF STA 2180. REPAIRED, IAW EI NO T2020A53M-2519 REV 1. JOB COMPLETED AND CONDITION CHECK NORMAL.SDR P5CA2020100500344Stringer · crackedREPAIR, CRACK DAMAGE ON THE STRINGER S-12R AT AFT SIDE OF STA 2180. REPAIRED, IAW EI NO T2020A53M-2537 REV 1. JOB COMPLETED AND CONDITION CHECK NORMAL.SDR P5CA2020100500345Stringer · crackedREPAIR, CRACK DAMAGE ON THE STRINGER S-10L AT FWD SIDE OF STA 1960. ACCOMPLISHED THE REPAIR, IAW EI NO T2020A53M-2518 REV 1. CONDITION CHECK NORMAL AND JOB COMPLETED.SDR P5CA2020100500346Stringer · crackedREPAIR, CRACK DAMAGE ON THE STRINGER S-20R AT AFT SIDE OF STA 2180. REPAIRED, IAW EI NO T2020A53M-2521 REV 1. JOB COMPLETED AND CONDITION CHECK NORMAL.SDR P5CA2020100500347Stringer · crackedREPAIR, CRACK DAMAGE ON STRINGER S-11L AT FWD SIDE OF STA 1960. ACCOMPLISHED THE REPAIR, IAW EI NO T2020A53M-2536 REV 1. CONDITION CHECK NORMAL AND JOB COMPLETED.SDR P5CA2020100500348Fitting · wornFOUND L1 DOOR FWD UPPER LATCH FITTING WORN. REPLACED L1 DOOR FWD UPPER LATCH FITTING, IAW AMM 52-11-01-700-801 REV 33. JOB COMPLETED AND CONDITION CHECK NORMAL.SDR P5CA2020100500349Wire · arcedARCING-FOUND P6-1 PANEL WIRE ARCING WHEN OPEN THE P6-1 POWER PANEL WIRE NR W4084-142, -2, -58, -33, -3, -T6, -133 AND P6-5 PANEL, C/B (C3138) AC 1 DIST-P7 PANEL 1 AND 2 TERMINAL. REFERENCE W/O NO 4988757 FOR WIRE REPLACEMENT AND TEST ITEMS, IAW SWPM 20-61-11,SDR P5CA2020100500350Bearing · brokenFOUND L1 DOOR EXTERNAL HANDLE BEARING BROKEN, IAW AMM TASK 52-11-13-000-801 REV 33 AND AMM TASK 52-11-13-400-801 REV 33. REPLACE L1 DOOR EXTERNAL HANDLE BEARING 2EA. CONDITION CHECK NORMAL.SDR P5CA2020100200328Rib · crackedCRACK ON RIB OF LT WING FIXED TRAILING EDGE AT WBL 448.7. REPAIR DAMAGED AREA, IAW EI NO T2020A57M-2402 REV 1. JOB COMPLETED AND CONDITION CHECK NORMAL.SDR P5CA2020100200329Stringer · crackedCRACK ON THE STRINGER S-11R BETWEEN STA 870 AND STA 890. ACCOMPLISHED THE JOB, IAW EI NO T2020A53M-2472 REV 2. JOB COMPLETED AND CONDITION CHECK NORMAL.SDR P5CA2020100200330Stringer · crackedCRACK ON THE STRINGER S-10R BETWEEN STA 860 AND STA 890. ACCOMPLISHED THE JOB, IAW EI NO T2020A53M-2470 REV 2. JOB COMPLETED AND CONDITION CHECK NORMAL.SDR P5CA2020100200331Stringer · crackedCRACK DAMAGES ON THE STRINGER S-9R BETWEEN STA 860 AND STA 880. ACCOMPLISHED THE JOB, IAW EI NO T2020A53M-2469 REV 1. JOB COMPLETED AND CONDITION CHECK NORMAL.SDR P5CA2020100200332Stringer · crackedCRACK DAMAGE ON THE STRINGER S-7R BETWEEN STA 870 AND STA 890 AND BETWEEN STA 940 AND STA 970. ACCOMPLISHED THE JOB, IAW EI NO T2020A53M-2465, REV 1. JOB COMPLETED AND CONDITION CHECK NORMAL.SDR P5CA2020100200333Stringer · crackedCRACK DAMAGES ON THE STRINGER S-8R AT FWD OF STA 88110 AND AFT OF STA 940. ACCOMPLISHED THE JOB, IAW EI NO T2020A53M-2467 REV 2. JOB COMPLETED AND CONDITION CHECK NORMAL.SDR P5CA2020100200334Stringer · crackedCRACK ON THE STRINGER S-11L BETWEEN STA 880 AND STA 900. REPAIRED, IAW EI NO T2020A53M-2471 REV 1. JOB COMPLETED AND CONDITION CHECK NORMAL.SDR P5CA2020100200335Stringer · crackedCRACK ON THE STRINGER S-7L BETWEEN STA 940 AND STA 970. REPAIRED, IAW EI NO T2020A53M-2464 REV 1. JOB COMPLETED AND CONDITION CHECK NORMAL.SDR P5CA2020100200336Stringer · crackedCRACK ON THE STRINGER S-9L BETWEEN STA 860 AND 980. REPAIRED, IAW EI NO T2020A53M-2468 REV 1. JOB COMPLETED AND CONDITION CHECK NORMAL.SDR P5CA2020100200337Stringer · crackedCRACK ON THE STRINGER S-8L AFT OF STA 940. REPAIRED, IAW EI NO T2020A53M-2466 REV 2. JOB COMPLETED AND CONDITION CHECK NORMAL.SDR P5CA2020100128323Status Message · false activationBODY GEAR STEERING STATUS MESSAGE. PERFORMED GROUND TEST, PER AMM 32-53-11. PASSED MESSAGE CLEARED. A/C OK FOR SERVICE.SDR P5CA2020093070322Warning Message · illuminatedLOW SPEED REJECTED TAKE OFF DUE TO WARNING ALERT CONFIG GEAR CTR EICAS MESSAGE. DEFERRED BODY GEAR STEERING, PER MEL 32-53-01 DDG. C/W MDDR 135044.SDR P5CA2020091510306Actuator · malfunctionedUPON GEAR RETRACTION ON T/OFF 'GEAR TILT' EICAS MSG, UNABLE TO RETRACT GEAR PER ECL CHECKLIST, AIR TURN BACK. REMOVED AND REPLACED GEAR TILT/ACTUATOR, IAW AMM 32-11-20. FOUND NR 13 BRAKE TORQUE SENSOR DAMAGE, REPLACED NR 13 BRAKE TORQUE SENSOR, IAW AMM 32-42SDR UIEA2020091401971Indicator · no indicationCREW REPORTED LOW SPEED, REJECTED T.O. NO LEFT AIRSPEED INDICATION AFTER BRAKES RELEASED, REF AMM 05-51-10. NO ACTION REQUIRED. BRAKES CHECK GOOD AND PLUGS ARE INTACT, NDN. PERFORMED GROUND TEST OF ADIRU L, TEST PASSED, REF AMM 34-25-00. PERFORMED GVI OF SDR P5CA2020082620288Warning Message · illuminatedCONFIG GEAR CTR WARNING MESSAGE(DEFERRED BODY GEAR STEERING IAW MEL 32-53-01, MDDR;133277, CAT 'C').SDR P5CA2020082200287Flap · inflt separationFLAPS DRIVE DISPLAYED WHEN FLAP 1 SELECTED. STATUS MESSAGE FLAP SYSTEM MONITOR. WALKAROUND FOUND #6 LE VC FLAP PANEL MISSING #1 INBD T/R DAMAGE. INSPECTION OF ADJACENT ARE FOUND DAMAGED AT ILES 1100 LE PANEL.(INSTALLED MISSING #6 LE FLAP PANEL / IAW B747 AMM 2SDR P5CA2020071500265Actuator · damagedBODY GEAR STRG EICAS AND STATUS. FOUND LT BODY GEAR INBOARD STEERING ACTUATOR DAMAGED. REMOVED AND REPLACED L BODY / GEAR INBOARD STEERING ACTUATOR IAW AMM 32-53-11, SYSTEM OPS CHECK / GOOD.SDR P5CA2020070700249Skin · gougedGOUGE DAMAGE ON FUSELAGE SKIN OUTER SURFACE AT STA 481, BETWEEN S-45L AND S-46L. REPAIRED THE DAMAGED AREA IAW EI NR T2020A53M-1666 REV 2. JOB COMPLETED AND CONDITION CHECK NORMAL.SDR P5CA2020070700250Stringer · crackedCRACK DAMAGES ON THE STRINGER S-11R BETWEEN STA 880 AND STA 890. ACCOMPLISHED EI NO T2020A53M-1657 REV 1. JOB COMPLETED AND CONDITION CHECK NORMAL.SDR P5CA2020070700251Stringer · crackedCRACK DAMAGE ON THE STRINGER S-8R BETWEEN STA 940 AND STA 950. ACCOMPLISHED EI NO T2020A53M-1659 REV 1. JOB COMPLETED AND CONDITION CHECK NORMAL.SDR P5CA2020070700252Stringer · crackedCRACK DAMAGES ON THE STRINGER S-7R BETWEEN STA 880 AND STA 890 AND BETWEEN STA 940 AND STA 970. ACCOMPLISHED EI NO T2020A53M-1655 REV 1. JOB COMPLETED AND CONDITION CHECK NORMAL.SDR P5CA2020070700253Stringer · crackedCRACK DAMAGES ON THE STRINGER S-7L BETWEEN STA 910 AND STA 970. ACCOMPLISHED EI NO T2020A53M-1654 REV 1. JOB COMPLETED AND CONDITION CHECK NORMAL.SDR P5CA2020070700254Stringer · crackedCRACK DAMAGES ON THE STRINGER S-8L BETWEEN STA 950 AND STA 960. ACCOMPLISHED EI NO T2020A53M-1658 REV 1. JOB COMPLETED AND CONDITION CHECK NORMAL.SDR P5CA2020070700255Stringer · crackedCRACK DAMAGES ON THE STRINGER S-9L BETWEEN STA 870 AND STA 930. ACCOMPLISHED EI NO T2020A53M-1651 REV 1. JOB COMPLETED AND CONDITION CHECK NORMAL.SDR P5CA2020070700256Stringer · crackedCRACK DAMAGES ON THE STRINGER S-12L BETWEEN STA 880 AND STA 890. ACCOMPLISHED EI NO T2020A53M-1653 REV 1. JOB COMPLETED AND CONDITION CHECK NORMAL.SDR P5CA2020070700257Stringer · crackedCRACK DAMAGES ON THE STRINGER S-10L BETWEEN STA 860 AND STA 880. ACCOMPLISHED EI NO T2020A53M-1652 REV 1. JOB COMPLETED AND CONDITION CHECK NORMAL.SDR P5CA2020070700258Stringer · crackedCRACK DAMAGES ON THE STRINGER S-11L BETWEEN STA 840 AND STA 890. ACCOMPLISHED EI NO T2020A53M-1650 REV 1. JOB COMPLETED AND CONDITION CHECK NORMAL.SDR P5CA2020070700259Rib · crackedCRACK DAMAGES ON LT SIDE HST TIP RIB AT HSBL 421.5. REPAIRED DAMAGED AREA IAW EI NO T2020A55M-1660 REV 2. JOB COMPLETED AND CONDITION CHECK NORMAL.SDR P5CA2020070700260Structure · brokenBROKEN DAMAGE ON FRAME UPPER CAP OF FWD CARGO FLOOR STRUCTURE, AT STA 980 RBL 10. REPAIRED THE DAMAGED AREA IAW EI NO T2020A53M-1668 REV 2. JOB COMPLETED AND CONDITION CHECK NORMAL.SDR P5CA2020070700261Fitting · wornFOUND L1 ENTRY DOOR FWD UPPER ROLLER LATCH FITTING WORN. IAW AMM 52-11-01-700-801 REV 32, REPLACED L1 ENTRY DOOR FWD UPPER ROLLER LATCH FITTING. IAW AMM 52-11-01-700-801 REV 32 ADJUST LATCH AND LATCH FITTING AT L1 DOOR FWD UPPER ROLLER LATCH FITTING. CONDITISDR P5CA2020060800176Rib · crackedCRACK ON RIB OF LT WING FIXED TRAILING EDGE AT WBL 448.7. ACCOMPLISHED EI NO T2020A57M-1374 REV 1. JOB COMPLETED AND CONDITION CHECK NORMAL.SDR P5CA2020060800177Stringer · crackedCRACK DAMAGES ON THE STRINGER S-8L BETWEEN STA 870 AND STA 890. REPAIRED DAMAGED AREA IAW EI NO T2020A53M-1373 REV 1. JOB COMPLETED AND CONDITION CHECK NORMAL.SDR P5CA2020060800178Stringer · crackedCRACK DAMAGES ON THE STRINGERS S-11L BETWEEN STA 860 AND STA 900. REPAIRED DAMAGED AREA IAW EI NO T2020A53M-1458 REV 3. JOB COMPLETED AND CONDITION CHECK NORMAL.SDR P5CA2020060800179Stringer · crackedCRACK DAMAGES ON THE STRINGER S-9L BETWEEN STA 860 AND STA 900. REPAIRED DAMAGED AREA IAW EI NO T2020A53M-1449 REV 2. JOB COMPLETED AND CONDITION CHECK NORMAL.SDR P5CA2020060800180Stringer · crackedCRACK DAMAGE ON THE STRINGER S-10L BETWEEN STA 860 AND STA 900. ACCOMPLISHED EI NO T2020A53M-1390 REV 2. JOB COMPLETED AND CONDITION CHECK NORMAL.SDR P5CA2020060800181Stringer · crackedCRACK DAMAGES ON THE STRINGER S-10R BETWEEN STA 860 AND STA 880. REPAIRED THE CRACKED AREA IAW EI NO T2020A53M-1459 REV 1. JOB COMPLETED AND CONDITION CHECK NORMAL.
Back to Boeing 747-87UF