N533US, cancelled Nov 3, 2017
Service difficulty reports · 51
Matched to this aircraft by N-number and event date, checked against the reported serial number, make and model. Newest first.
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 n_number = 'N533US' AND deregistration_id = 'N533US-2017-11-03' 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 n_number = 'N533US' AND deregistration_id = 'N533US-2017-11-03' 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 DALA2015050403049Housing · brokenOVERHEAD EMERGENCY LIGHT IN OVERHEAD BINS AT 18 ABC INOPERATIVE AND BROKEN HOUSING. FOUND BOTH HOUSINGS BROKEN FWD TO MEL IAW MEL 33-51-01. REPLACED FUSE IN BATTERY PACK, LIGHTS CK GOOD. REF AMM 33-51 MEL AND PLAC REMOVED.SDR DALA2015022601676Power Supply · inoperativeDOOR 2L EXTERIOR EMERGENCY LIGHT INOPERTIVE, RELAMPED NO HELP. DOOR 2L, OPS GOOD. DOOR 4L INOPERATIVE. WRITE UP MISLABELLED. FOUND BATTERY BACK AND POWER SUPPLY AT FAULT. R & R POWER SUPPLY IAW AMM 33-51-07. R & R BATTERY PACK IAW AMM 33-51-07-902. OPS SDR DALA2015012900748Line · leakingBURNING ODOR SHORTLY AFTER TAKE OFF. TURNED OFF LT PACK. FOUND LEAK FROM PACK TURBINE TO RE-HEATER. SECURED LINE. R & R LOW LIMIT VALVE IAW AMM 21-51.SDR DALA2014120206376Light · inoperativeR1 DOOR EXTERIOR EMERGENCY LIGHT INOPERATIVE. R & R THE LIGHT. OPS CHECKED GOOD.SDR DALA2014120206372Light · inoperativeEXTERIOR EMERGENCY LIGHTS ARE INOPERATIVE. R & R THE LIGHTS. OPS CHECKED GOOD.SDR DALA2014112106207Skin · damagedFUSELAGE SKIN, BS 399 - 411, S6-7R HAS LIGHTNING STRIKES. REPAIRED IAW PRI 530817-14 REV 0 AND1 AND ERA 530817-14, REV ORIGINAL.SDR DALA2014112106206Skin · damagedFUSELAGE SKIN BS 474, S6R, LIGHTNING STRIKE. REPAIRED IAW PRI 530843-14, REV 0 AND ERA 530843-14, REV ORIGINAL.SDR DALA2014112106205Skin · damagedLIGHTNING STRIKE DAMAGE TOP OF FUSELAGE, BS 440 AFT OF SPLIT LINE, 19 INCHES BELOW LAP SEAM. REMOVED DAMAGED FASTENER IAW SRM 53-00-01, REPAIR 6, SECTION II AND DRILLED DAMAGE IAW SRM 53-00-01, REPAIR 6, SECTION I. PREFORMED HFEC SURFACE SCAN IAW NDTM PART SDR DALA2014112106204Skin · damagedLIGHTNING STRIKE DAMAGE TOP OF FUSELAGE, BS 411, 27 INCHES BELOW UPPER LAP JOINT RT SIDE. REPAIRED IAW E/C ERA 530817-14, REV ORIG.SDR DALA2014112106203Skin · damagedLIGHTNING STRIKE DAMAGE TOP OF FUSELAGE BS 399, 22 INCHES BELOW LAP SEAM RT SIDE. REPAIRED IAW ERA 530817-14, REV ORIGINAL.SDR DALA2014112106202Skin · damagedLIGHTNING STRIKE DAMAGE TOP OF FUSELAGE BETWEEN BS 382 - 399 BETWEEN STRINGERS 6 AND 7, APPROXIMATELY 18 INCHES BELOW LAP SEAM, RT SIDE. REPAIRED IAW ERA 530817-14, REV ORIGINAL.SDR DALA2014112006194Skin · damagedLIGHTNING STRIKE DAMAGE BETWEEN BS 399-411 AND STRINGER 6-7R. DAMAGED AREAS CUT OUT AND DOUBLERS INSTALLED IAW SECTION I OF ER/A 530817-14.SDR DALA2014112006192Skin · damagedLIGHTING STRIKE DAMAGE TOP OF SURFACE BS 474, 18 INCHES BELOW LAP SEAM RT SIDE. REPAIRED IAW ERA 530843-14, REV ORIGINAL.SDR DALA2014112006191Skin · damagedLIGHTNING STRIKE DAMAGE AT BS 474 AND S6R. DAMAGE REPAIRED IAW SECTION I OF ER/A 530843-14.SDR DALA2014112006193Skin · damagedLIGHTNING STRIKE DAMAGE BETWEEN BS 399-411 AND STRINGER 6-7R.SDR DALA2014091805106Warning Light · illuminatedDURING DESCENT PASSING 26000, RECEIVED A CABIN ALTITUDE WARNING ALSO CABIN ALTITUDE AUTO 2 EICAS. QRH FOLLOWED AND DESCENDED TO 10,000. BITE NR 2 CABIN PRESSURE CONTROLLER, FAULT NR 2 AC MOTOR. INSTALLED NEW OUTFLOW VALVE ACTUATOR IAW AMM 21-31. REPLACED SEASDR DALA2014082904858Bottle · no testEMERGENCY POWER RESERVOIR BOTTLE AT R4 DOOR FAILED CHECK IAW R/C 5211-2001. REPLACED RESERVOIR IAW MM 52-11-30.SDR DALA2014071104041Plate · missingFOUND L1 DOOR STOP FITTING BEARING PLATE MISSING. INSTALLED BEARING PLATE.SDR DALA2014070803948Control Rod · disconnectedR1 DOOR WON'T OPEN. FOUND CONTROL ROD DISCONNECTED. REPLACED CONTROL ROD IAW AMM 52-40.SDR DALA14014675533Idg · failedPERFORMED AN AIR TURN BACK APPROXIMATELY FOUR MINUTES AFTER TAKEOFF DUE TO A RT GENERATOR DRIVE ANNUNCIATED ON EICAS FOLLOWED BY A RT GENERATOR FAILURE AND RIGHT BUSS FAILURE WITH ELECTRICAL ODOR OF SMOKE DETECTED IN THE COCKPIT. NO ODORS OR SMOKE DETECTED FRSDR DALA1241245533Threshold · crackedFWD CARGO THRESHOLD CRACKED 12 INCHES FWD OF AFT EDGE CRACKS ARE APPROXIMATELY 3 3/16 AND 1 3/4 LONG. REMOVED EXISTING FWD CARGO COMPARTMENT THRESHOLD BULLNOSE. NEW THRESHOLD LOCATE. NEW THRESHOLD DRILLED AND INSTALLED.SDR DALA1169605533Crease Beam · damagedCREASE BEAM REPAIR. CURRENT ER/A REVISION IS 'A'. SECTION II INSP REQUIREMENT HAS BEEN ADDED. ACCOMPLISH SECTION II NO LATER THAN 36200 TOTAL A/C FLIGHT CYCLES. THE SECTION II INSPECTION IS PENDING A STAGE III DAMAGE TOLERANCE ANALYSIS. CONTACT ENGINEERISDR DALA1036455533Skin · gougedDURING M-CHECK, FOUND ACCESS DOOR 119 BL HANDLE CUTOUT IS GOUGED. REPAIRED IAW ERA 488099-14, REV ORIGINAL.SDR DALA1036065533Skin · crackedDURING M-CHECK, FOUND DAMAGE ON LT ELEVATOR T/E CRACKED DUE TO IMPACT WITH A MANLIFT. REMOVED LT ELEVATOR IAW AMM 27-31-01-024-001 AND PERFORMED REPAIR IAW SRM 51-70-04, GENERAL PARAGRAPH 4D-4G PG 7-18, FIG 14, PG 48 AND REINSTALLED LT ELEVATOR AND PERFORMED SDR DALA1035785533Crease Beam · corrodedDURING MX CORROSION WAS FOUND COMMON TO THE FUSELAGE CREASE BEAM AT STA 1630, WL 208. THE CORRODED AREA OF THE CREASE BEAM WAS CUTOUT AND A REPAIR WAS INSTALLED IAW SECTION OF ER/A 13-487261-14. THE REPAIR IAW SECTION I IS STATICALLY APPROVED FOR 24 MONTHS AFSDR DALA1035835533Skin · damagedDURING M-CHECK, FOUND FUSELAGE SKIN LOWER AFT VHF ANTENNA MOUNT 2 HOLES IN SKIN TRIM OUT STA 1473, S-29R TO S-30R. SECTION I - ACCOMPLISHED DURING MX AT SAT DEC 2010 SECTION II-REPAIR APPROVAL LIMITED TO 75000. TOTAL ACFT CYCLES NOTE TO MON ER/A REVISION REQSDR DALA1035605533Floor Support · corrodedDURING M-CHECK FOUND MAIN CABIN FLOOR SUPPORT BL 0 CORRODED STA 345-378. CORROSION FOUND OUT OF LIMITS IAW SRM 53-00-51, PAGE 03. DETAIL III. R & R SUPPORT BEAM ON MAIN CABIN STA 324 TO 418 BL0 REINSTALLED 7EA CLIPS IAW SRM 51-40-02, PAGE 2-7.SDR DALA1035595533Firewall · chafedDURING M-CHECK FOUND NR1 PYLON NACELLE STA 105 VERTICAL FIRE WALL INBD AFT SIDE SKIN IS CHAFED. BLENDED OUT CHAFED AREA ON NR1 PYLON NACELLE STA 105 VERTICAL FIRE WALL AND FOUND OUT OF LIMITS IAW SRM 54-51-02, PAGE 103. REMOVED FASTENERS AND CUT OUT DAMAGE ASDR DALA1035585533Skin · crackedDURING M-CHECK FOUND NR2 PYLON OTBD AFT OF CTR T/R INSOLATOR ACCESS PANEL CUT OUT CRACKED. REMOVED OTBD T/R HINGE AND 1EA DOUBLER FROM NR2 PYLON OTBD IAW SRM 51-40-02, PAGE 240, CUT OUT THE CRACK DAMAGE IAW ERA 487267-14, REV 0, STEPS 5 FAB REPAIR DOUBLER IAWSDR DALA1035135533Support Channel · corrodedDURING M-CHECK FOUND SEAT TRACK SUPPORT CHANNEL CORRODED ON UPPER SURFACE AT STA 365, RBL 24. FOUND TO BE OUT OF LIMITS IAW SRM 53-10-15, PAGE 105. REMOVED SEAT TRACK SUPPORT CHANNEL, INSTALLED NEW SEAT TRACK SUPPORT CHANNEL IAW SRM 51-40-02, PAGE 7.SDR DALA1034825533Floorbeam · corrodedDURING M-CHECK, FOUND MAIN CABIN FLOORBEAM UPPER SURFACE CORRODED STA 377.7 LBL64-RBL 40. FOUND OUT OF LIMITS IAW SRM 53-00-51, PAGE 103, DETAIL IV. REMOVED CORRODED EXISTING FLOORBEAM REPAIR FROM LBL 64 TO BL 0 AND EXTEND CUT OUT ON FLOORBEAM STA 377 UPPER SDR DALA1034725533Floorbeam · corrodedDURING M-CHECK FOUND MAIN CABIN FLOORBEAM UPPER SURFACE CORRODED STA 1661, LBL 5-RBL 24. REMOVED CORROSION FOUND TO BE OUT OF LIMITS FROM LBL 5 TO RBL 23 IAW SRM 53-00-51, PAGE 103, FIG 101, DETAIL V1. CUT OUT DAMAGE AREA AT STA1661 LBL 5 TO RBL 23 IN REF B75SDR DALA1034715533Floorbeam · corrodedDURING M-CHECK FOUND MAIN CABIN FLOORBEAM UPPER SURFACE CORRODED BS 1661 LBL 5-RBL 24. REMOVED CORROSION ON FLOORBEAM UPPER SURFACE IAW SRM 53-00-51, FIG 201 REPAIR 3. FABRICATED & INSTALLED CHORD, ANGLE, STRAP IAW SRM 53-00-51, FIG 201, REPAIR 3.SDR DALA1034695533Floorbeam · corrodedDURING M-CHECK FOUND MAIN CABIN FLOORBEAM UPPER SURFACE CORRODED BS 1661, LBL 5 TO RBL 24. REMOVED CORROSION ON FLOORBEAM UPPER SURFACE FOUND TO BE OUT OF LIMITS. INSTALLED NEW CHORD, 2(EA) ANGLE. 2EA STRAP IAW SRM 53-00-51 REPAIR 3 FIG 201 PG 201-206 ON BSSDR DALA1034685533Floor Skin · corrodedDURING M-CHECK FOUND MAIN CABIN AFT DECK PLATE UPPER SURFACE CORRODED STA 1680-1720, BL0-BL54. REMOVED CORROSION FROM MAIN CABIN AFT DECK PLATE UPPER SURFACE SRM 53-00-51, PG 101-103. FOUND TO BE OUT OF LIMITS. FABRICATED, TREATED, PRIMED AND INSTALLED 1EA FSDR DALA1034705533Floorbeam · corrodedDURING M-CHECK FOUND MAIN CABIN FLOORBEAM CORRODED ON UPPER SURFACE OF REPAIR CHORD EXTENDING ONTO ORIGINAL CHORD ON BOTH ENDS, STA 345, RBL 36 TO LBL 18. REMOVED CORRODED EXISTING REPAIR FLOORBEAM STA 345 CUT OUT FLOORBEAM FROM LBL 53 TO RBL 36, FABRICATESDR DALA1034335533Floor Panel · corrodedDURING M-CHECK FOUND MAIN CABIN AFT DECK PLATE UPPER SURFACE CORRODED. STA 1680-1720, BL 0-RBL 54. REMOVED CORROSION IAW SRM 53-00-51, PG 103, DETAIL III. ORIGINAL THICKNESS .071 IAW SRM 53-60-51, PG 7. MAIN CABIN AFT DECK PLATE UPPER SURFACE FOUND TO BE WISDR DALA1034345533Seat Track · gougedDURING M-CHECK, FOUND MAIN CABIN SEAT TRACK GOUGED BEYOND ALLOWABLE LIMITS, BETWEEN STA 1502 TO STA 1504, RT OTBD SEAT TRACK. R & R 1EA SEAT TRACK AND 1EA SPLICE FROM STA 1490 TO 1540, IAW SRM 53-00-52, REPAIR NR3, FIG 201, ON RBL 45.SDR DALA1035325537Seat Track · gougedDURING M-CHECK, FOUND LT OTBD SEAT TRACK BETWEEN STA 1468 TO 1470, GOUGED BEYOND ALLOWABLE LIMITS. R & R SEAT TRACK SECTION SPLICE, AT STA 1450 TO 1540, REF SRM 53-00-52, REPAIR 3, LBL 45.SDR DALA1035125533Seat Track · gougedDURING M-CHECK FOUND LT OTBD SEAT TRACK BETWEEN STA 1468 TO 1470 GOUGED BEYOND ALLOWABLE LIMITS. R & R SEAT TRACK SECTION SPLICE, AT STA 1450 TO 1540, REF SRM 53-00-52, REPAIR 3, LBL 45.SDR DALA1034325533Floorbeam · corrodedDURING M-CHECK FOUND RT NLG W/W TUNNEL, STA 365, LBL 24 TO RBL 24, FLOORBEAM HAS CORROSION. FABRICATED REPLACEMENT CHORD, 02 EA REPAIR ANGLES, AND 02 EA REPAIR STRAPS, TO FLOORBEAM 70 IAW SRM 53-00-51, REPAIR 3, PAGE 203, FIG 201. TREATED AND PRIMED REPLACEMESDR DALA100425533Wire · brokenFIRST CLASS FLOOR ESCAPE PATH EMERGENCY LIGHTS WOULD NOT TEST. FOUND WIRES W3532-9006-18 AND W3532-9007-18 BROKEN AT RACEWAY 6" FORWARD OF FORWARD RT SEAT ROW, FORWARD LEG. REPAIRED WIRES IAW SWPM 20-30-12. LIGHTS OPERATED NORMAL.SDR DALA100155533Lamp · inoperativeEMERGENCY EXIT SIGNS ABOVE 4L AND 4R HAVE MULTIPLE LAMPS INOPERATIVE. RELAMPED SIGNS. OPS CHECK GOOD.SDR NWAA083135533Lamp · inoperativeDURING OVERNIGHT MAINTENANCE FOUND THE EMERGENCY ESCAPE PATH LIGHTING INOPERATIVE FROM ROW 33 TO ROW 39, THE SECTION AFT OF DOOR 3. MAINTENANCE RELAMPED THE EFFECTED LIGHTS AND ALL OPERATIONS CHECKED GOOD. (S)SDR NWAA082315533Skin · dentedDURING "L" CHECK, FOUND DENT AND GOUGE IN FUSELAGE SKIN AT BS 630 BETWEEN S24R TO S25R. REPAIRED PER EA 55-212820 SECTION I, SECTION II REQUIRES FOLLOW UP INSPECTIONS BEGINNING NO LATER THAN 37,500 TOTAL AIRCRAFT FLIGHT CYCLES. SECTION III REQUIRES REPEAT INSDR NWAA072515533Battery Pack · inoperativeEMERGENCY ESCAPE LIGHTS AT 4B AND 13D INOP. REPLACED EMERGENCY LIGHT POWER SUPPLY AND BATTERY AT STA 369, CHECKS OK.SDR 0400905533Floor Support · corrodedDURING H-CHECK FOUND CORROSION IN FLOOR SUPPORT AT BS 365 RBL 46. REPAIRED PER EA 55-199272.SDR 0002565533Power Supply · inoperativeAFT CABIN EMERGENCY FLOOR LIGHTS INOPERATIVE FROM COCKPIT AND DOOR 1L TEST SWITCH. MAINTENANCE REPLACED THE M9004 POWER SUPPLY AND BATTERY. OPERATIONAL CHECK OK.SDR 9509465533Smoke Detector · failedDURING CLIMB, THE SMOKE LIGHT CAME ON FOLLOWED BY EQUIPMENT OVERHEAT FIVE MINUTES LATER. DECISION WAS MADE TO RETURN WHEN THE FLIGHT INSTRUMENTS WENT DIM. EQUIPMENT OVERHEAT LIGHT WENT OUT WHEN ALTERNATE SYSTEM WAS USED. THE AIRCRAFT RETURNED TO MSP AND LANSDR 9506335533Apu · failedTHE APU FAILED DURING CRUISE AND RESTART ATTEMPTS WERE UNSUCCESSFUL. THE RIGHT IDG WAS ON MEL, SO THE AIRCRAFT DIVERTED TO ATL. REPLACED THE RIGHT IDG, PERFORMED BITE ON APU, NO FAULTS WERE DETECTED. APU OPERATIONAL CHECK WAS NORMAL.
Back to N533US, cancelled Nov 3, 2017