N533AU, cancelled Nov 6, 2014
Service difficulty reports · 183
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 = 'N533AU' AND deregistration_id = 'N533AU-2014-11-06' 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 = 'N533AU' AND deregistration_id = 'N533AU-2014-11-06' 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 USAA2012071700007Skin · crackedFLIGHT 1269 - RIGHT HORIZONTAL STAB LOWER SKIN CRACKED AT STAB STATION 133 JUST FORWARD OF AFT SPAR (NEXT TO EXISTING REPAIR). REPAIRED SKIN IAW EA 104132.SDR USAA2012051100005Light · brokenFLIGHT ATTENDANT REPORTED THE EMERGENCY EXIT ROW LIGHT ON SEAT 10C BROKEN. MAINTENANCE REPLACED THE EMERGENCY EXIT LIGHT AT 10C PER AMM 33-51-21. OPS CHECK GOOD.SDR USAA2012050200007Skin · crackedRON VISIT - 2 INCH CRACK IN FUSELAGE SKIN AT BS 727D+10 INCHES, S22L. REPAIRED FUSELAGE SKIN AT BS 727D+10 INCHES, S22L IAW B737 SRM 53-00-01-2R REPAIR 31.SDR USAA2012012400010Skin · crackedRON VISIT - CRACK IN FUSELAGE SKIN AT BS 767-7 INCHES, S19R. REPAIRED FUSELAGE SKIN AT BS 767-7 INCHES, S19R IAW B737 SRM 53-00-01 REPAIR 31 DETAIL X.SDR USAA2011112800001Battery Pack · dischargedROW 12-16 EMERGENCY LIGHTS INOP. REPLACED BATTERY PACK M1136 WITH SERVICABLE UNIT IAW AMM33-51-51, OPS CHECK NORMAL.SDR USAA2011110800026Intercostal · crackedLAP INSPECTION - CRACK IN INTERCOSTAL AT BS 277, S14R. REPLACED INTERCOSTAL AT BS 277, S14R IAW B737 SRM 53-10-15-01-3 & 51-42-00.SDR USAA2011072600025Smoke Detector · faultyCREW REPORTED THE FORWARD LAVATORY SMOKE DETECTOR ALARMING WITH NO VISIBLE SMOKE. UNABLE TO STOP ALARM, BATTERY REMOVED. LAVATORY BLOCKED FOR USE. MAINTENANCE REMOVED AND REPLACED FORWARD LAVATORY SMOKE DETECTOR AND BATTERY. SECURED AND OPERATIONAL CHECK GSDR USAA2011072500012Girt Bar · out of adjustDOOR 2L GIRT BAR WILL NOT STOW SECURE. ADJUSTED AND STOWED GIRT BAR, OK FOR SERVICE.SDR USAA2011071400002Pin · not seatedMX REPORTED THE EMERGENCY FLOOR LIGHTS AT SEATS 2-3-4 LT AND EMERGENCY EXIT LIGHT OVER DOOR 1L INOP. MX REPLACED THE BATTERY PACK, FUSE AND SHORTED LIGHT ASSEMBLY ON SEAT 3 LT. REMOVED WIRING FROM UNDERNEATH SEAT RAILS. OPS CHECK GOOD. WHEN SYSTEM WAS PUT SDR USAA2011071100021Charger · inoperativeMAINTENANCE REPORTED THE EMERGENCY SEAT MOUNTED LIGHTS ON ROWS 2, 3, 4, 9 AND 11 DO NOT OPERATE DURING EMERGENCY EXIT LIGHT TEST. MAINTENANCE REPLACED THE FORWARD CENTER BATTERY CHARGER. OPERATIONAL CHECK GOOD ON SEAT ROWS 2, 3 AND 4. SEAT ROWS 9 AND 11 EMESDR USAA20110603SB084Light · detachedCLT - THE EMERGENCY LIGHT ATTACHED TO SEAT 11C IS "BROKE". MAINTENANCE "RE-ATTACHED" LIGHT ASSEMBLY. OK FOR CONTINUED SERVICE.SDR USAA20110222SB032Warning System · malfunctionedCLT - ON CLIMBOUT FROM CLT, EN ROUTE TO CUN, CREW RECEIVED A NR 2 ENGINE DUAL FIRE LOOP FAULT (A & B LOOP) ON THE FIRE CONTROL PANEL. FLIGHT RETURNED TO FIELD AT CLT AND LANDED WITHOUT FURTHER INCIDENT. NO EMERGENCY WAS DECLARED. MAINTENANCE COULD NOT DUPLISDR USAA20110124SB012Battery Pack · dischargedCLT - EN ROUTE FROM PIT TO CLT, CREW REPORTED THE OVERWING EMERGENCY LIGHT ILLUMINATED DURING FLIGHT. MAINTENANCE REMOVED AND REPLACED THE BATTERY PACK. OPERATIONAL CHECK GOOD.SDR USAA2010092092048Spoiler · delaminatedCLT - Q2 - MAJOR REPAIR - AREA OF DELAMINATION ON NR 2 SPOILER 24 INCHES FROM UPPER OUTBOARD END. REPLACED NR 2 SPOILER IAW B737 AMM 27-61-11.SDR USAA2010092092039Bulkhead · crackedCLT - Q2 - MAJOR REPAIR - CRACK ON BULKHEAD SKIN AT BS 178, LBL 5, WL 184. REPAIRED BULKHEAD SKIN AT BS 178, LBL 5, WL 184 IAW EA 102147.SDR USAA2010092092038Bulkhead · crackedCLT - Q2 - MAJOR REPAIR - CRACKS ON BULKHEAD SKIN AT BS 178, RBL 5, WL 184. REPAIRED BULKHEAD SKIN AT BS 178, RBL 5, WL 184 IAW EA 102147.SDR USAA2010092092034Door Frame · crackedCLT - Q2 - MAJOR REPAIR - CRACK ON FORWARD SERVICE DOOR FRAME CUTOUT AT BS 312, S7R. REPLACED FORWARD SERVICE DOOR FRAME CUTOUT AT BS 312, S7R IAW B737 SRM 51-10-02.SDR USAA2010092092047Slat · delaminatedCLT - Q2 - MAJOR REPAIR - AREA OF DELAMINATION ON NR 2 SLAT AT OUTBOARD END OF UPPER TRAILING EDGE. REPAIRED NR 2 SLAT AT OUTBOARD END OF UPPER TRAILING EDGE IAW B737 SRM 51-70-10 REPAIR 4 & 57-43-02.SDR USAA2010091692006Frame · corrodedCLT - Q2 - MAJOR REPAIR - LEVEL 2 EXFOLIATION CORROSION ON FUSELAGE FRAME AT BS 807 BETWEEN S6L TO S6R. REPAIRED FUSELAGE FRAME AT BS 807 BETWEEN S6L TO S6R IAW B737 SRM 53-00-07.SDR USAA2010092092044Floorbeam · crackedCLT - Q2 - MAJOR REPAIR - CRACKS ON LONGITUDINAL FLOORBEAM AT BS 667 & AT BS 671, LBL 24.8. REPAIRED LONGITUDINAL FLOORBEAM AT BS 667 & AT BS 671, LBL 24.8 IAW EA 102139.SDR USAA2010092092041Floorbeam · crackedCLT - Q2 - MAJOR REPAIR - CRACK ON LONGITUDINAL FLOORBEAM BETWEEN BS 667 TO BS 671, RBL 24.5. REPAIRED LONGITUDINAL FLOORBEAM BETWEEN BS 667 TO BS 671, RBL 24.5 IAW EA 102140.SDR USAA2010092092043Support · crackedCLT - Q2 - MAJOR REPAIR - CRACK ON FLOORBEAM SUPPORT AT BS 500B BETWEEN S20L TO S21L. REPAIRED FLOORBEAM SUPPORT AT BS 500B BETWEEN S20L TO S21L IAW B737 SRM 53-00-07.SDR USAA2010091692019Angle · corrodedCLT - Q2 - MAJOR REPAIR - LEVEL 2 EXFOLIATION CORROSION ON AFT ENTRY DOOR Z-ANGLE AT BS 990, RBL 58. REPLACED AFT ENTRY DOOR Z-ANGLE AT BS 990, RBL 58 IAW SRM 51-00-02, 51-40-02 & BOEING DRAWING 65-53878U97.SDR USAA2010092092045Floorbeam · crackedCLT - Q2 - MAJOR REPAIR - CRACK ON FLOORBEAM WEB AT BS 710, BBL 07. REPAIRED FLOORBEAM WEB AT BS 710, BBL 07 IAW BOEING DRAWING & ROUTINE TASK CARD M2C57002.SDR USAA2010092092042Floorbeam · crackedCLT - Q2 - MAJOR REPAIR - CRACK ON LOWER CHORD OF LONGITUDINAL FLOORBEAM AT BS 685, LBL 24.8. REPAIRED LONGITUDINAL FLOORBEAM AT BS 685, LBL 24.8 IAW EA 102146.SDR USAA2010091692018Angle · corrodedCLT - Q2 - MAJOR REPAIR - LEVEL 2 EXFOLIATION CORROSION ON Z-ANGLE AT BS 1006, S17L. REPAIRED Z-ANGLE AT BS 1006, S17L IAW B737 SRM 51-40-02.SDR USAA2010091692017Angle · corrodedCLT - Q2 - MAJOR REPAIR - LEVEL 2 EXFOLIATION CORROSION ON AFT ENTRY DOOR Z-ANGLE AT BS 967, LBL 58. REPLACED AFT ENTRY DOOR Z-ANGLE AT BS 967, LBL 58 IAW B737 SRM 51-40-02.SDR USAA2010091692015Skin · corrodedCLT - Q2 - MAJOR REPAIR - LEVEL 2 EXFOLIATION CORROSION ON FUSELAGE SKIN BETWEEN BS 986.5 TO BS 1006, S27L. REPLACED FUSELAGE SKIN BETWEEN BS 986.5 TO BS 1006, S27L IAW EA 102137.SDR USAA2010091692004Shear Tie · corrodedCLT - Q2 - MAJOR REPAIR - LEVEL 2 EXFOLIATION CORROSION ON SHEAR TIE AT BS 967 BETWEEN S25L TO S26L. REPLACED SHEAR TIE AT BS 967 BETWEEN S25L TO S26L IAW EA 102137.SDR USAA2010090891959Skin · wornCLT - Q2 - MAJOR REPAIR - DEEP AREA OF WEAR ON UPPER SURFACE OF LEFT OUTBOARD FOREFLAP 48 INCHES FROM INBOARD END. REPLACED LEFT OUTBOARD FOREFLAP IAW B737 AMM 27-51-37.SDR USAA2010090391906Skin · crackedCLT - MAJOR REPAIR - Q2 CHECK - CRACK ON FUSELAGE SKIN AT BS 727+2 INCHES, STR 19R. REPAIRED FUSELAGE SKIN AT BS 727+2 INCHES, STR 19R IAW B737-300 SRM 53-00-01, REPAIR 31.SDR USAA2010090391897Shear Tie · corrodedCLT - MAJOR REPAIR - Q2 CHECK - LEVEL 2 CORROSION ON SHEAR TIE AT BS 967, BETWEEN STR 25L TO 26L. REPLACED SHEAR TIE AT BS 967, BETWEEN STR 25L TO 26L IAW EA 102137.SDR USAA2010090391896Skin · corrodedMAJOR REPAIR - Q2 CHECK - LEVEL 2 CORROSION ON SKIN AT BS 986.5, BETWEEN STR 26R TO 27R. REPLACED SKIN AT BS 986.5, BETWEEN STR 26R TO 27R IAW EA 102137.SDR USAA2010090391895Skin · corrodedCLT - MAJOR REPAIR - Q2 CHECK - LEVEL 2 CORROSION ON FUSELAGE SKIN BETWEEN BS 986.5 TO BS 1006, STR 27L. REPLACED FUSELAGE SKIN BETWEEN BS 986.5 TO BS 1006, STR 27L IAW EA 102137.SDR USAA2010092492094Seat Track · corrodedCLT - Q2 - MAJOR REPAIR - LEVEL 2 EXFOLIATION CORROSION ON SEAT TRACK BETWEEN BS 329 TO BS 330 & BETWEEN RBL 51 TO RBL 54. REPLACED SEAT TRACK BETWEEN BS 329 TO BS 330 & BETWEEN RBL 51 TO RBL 54 IAW BOEING DRAWING 65-46814.SDR USAA2010091692014Skin · corrodedCLT - Q2 - MAJOR REPAIR - LEVEL 2 EXFOLIATION CORROSION ON FUSELAGE SKIN BETWEEN BS 986.5 TO BS 1006, S27L. REPLACED FUSELAGE SKIN BETWEEN BS 986.5 TO BS 1006, S27L IAW EA 102137.SDR USAA2010091692009Intercostal · corrodedQ2 - MAJOR REPAIR - LEVEL 2 EXFOLIATION CORROSION ON INTERCOSTAL BETWEEN BS 986 TO BS 967, LBL 18. REPLACED INTERCOSTAL BETWEEN BS 986 TO BS 967, LBL 18 IAW SRM 53-60-02.SDR USAA2010091692008Intercostal · corrodedCLT - Q2 - MAJOR REPAIR - LEVEL 2 EXFOLIATION CORROSION ON INTERCOSTAL BETWEEN BS 967 TO BS 966, RBL 18. REPLACED INTERCOSTAL BETWEEN BS 967 TO BS 966, RBL 18 IAW B737 SRM 51-40-02.SDR USAA2010091692005Support · corrodedCLT - Q2 - MAJOR REPAIR - LEVEL 2 EXFOLIATION CORROSION ON RIGHT INBOARD FOREFLAP SUPPORT TUBE & ARMS. REPLACED RIGHT INBOARD FOREFLAP IAW JOB CARD 03C40927012.SDR USAA2010090391904Intercostal · corrodedCLT - MAJOR REPAIR - Q2 CHECK LEVEL 2 CORROSION ON INTERCOSTAL BETWEEN BS 967 TO 968, RBL 18. REPLACED INTERCOSTAL BETWEEN BS 967 TO 968, RBL 18 IAW B737-300 SRM 51-40-02.SDR USAA2010090391903Intercostal · corrodedCLT - MAJOR REPAIR - Q2 CHECK - LEVEL 2 CORROSION ON INTERCOSTAL BETWEEN BS 986 TO BS 987, LBL 18. REPLACED INTERCOSTAL BETWEEN BS 986 TO BS 987 LBL 18 IAW B737-300 SRM 53-60-02.SDR USAA2010090391899Shear Tie · corrodedCLT - MAJOR REPAIR - Q2 CHECK - LEVEL 2 CORROSION ON SHEAR TIE AT BS 986.5, BETWEEN STR 26R TO 27R. REPLACED SHEAR TIE AT BS 986.5, BETWEEN STR 26R TO 27R IAW B737-300 SRM 52-10-02.53057/012.SDR USAA2010090391898Tie Clip · crackedCLT - MAJOR REPAIR - Q2 CHECK - CRACK ON STRINGER TIE CLIP AT BS 1006, STR 27R. REPLACED STRINGER TIE CLIP AT BS 1006, STR 27R IAW B737-300 SRM 51-10-02.SDR USAA2010090391893Shear Tie · corrodedCLT - MAJOR REPAIR - Q2 CHECK - LEVEL 2 CORROSION ON SHEAR TIE AT BS 947, BETWEEN STR 24L TO 26L. REPLACED SHEAR TIE AT BS 947, BETWEEN STR 24L TO 26L IAW B737-300 SRM 51-10-02.SDR USAA2010090391908Skin · wornCLT - MAJOR REPAIR - Q2 CHECK - WORN AREA OF FLAP SKIN FROM WORKING RIVETS AT LEFT INBOARD FORE FLAP. REPLACED LEFT INBOARD FLAP IAW JOB CARD 03C30927015.SDR USAA2010090391905Attach Angle · crackedCLT - MAJOR REPAIR - Q2 CHECK - CRACK ON CRANK BOX ATTACH ANGLE AT BS 313.5, BEAM NR 4 FORWARD SERVICE DOOR. REPLACED CRANK BOX ATTACH ANGLE AT BS 313.5, BEAM NR 4 FORWARD SERVICE DOOR IAW B737-300 SRM 51-10-02 AND 52-10-02, DRAWING 65-45871.SDR USAA2010083191879Bulkhead · crackedCLT - Q2 - MAJOR REPAIR - CRACK ON FORWARD PRESSURE BULKHEAD WEB AT BS 178, LBL 17, WL 228. REPLACED FORWARD PRESSURE BULKHEAD WEB AT BS 178, LBL 17, WL 228 IAW B737 SRM 51-10-02 & 51-40-02.SDR USAA2010083191878Bulkhead · crackedCLT - Q2 - MAJOR REPAIR - CRACK ON FORWARD PRESSURE BULKHEAD WEB AT BS 178, LBL 17, WL 234. REPLACED FORWARD PRESSURE BULKHEAD WEB AT BS 178, LBL 17, WL 234 IAW B737 SRM 51-10-02 & 51-40-02.SDR USAA2010091692013Floorbeam · corrodedCLT - Q2 - MAJOR REPAIR - LEVEL 1 EXFOLIATION CORROSION ON FLOORBEAM T-CAP AT BS 328, BETWEEN RBL 27 TO RBL 29. REPLACED FLOORBEAM T-CAP AT BS 328, BETWEEN RBL 27 TO RBL 29 IAW B737 SRM 53-10-51 REPAIR 5.SDR USAA2010092092051Plate · corrodedCLT - Q2 - MAJOR REPAIR - CORROSION ON NR 4 ELEVATOR HINGE PLATE AT ELEV STA 121.59. REPLACED NR 4 ELEVATOR HINGE PLATE AT ELEV STA 121.59 IAW B737 AMM 27-31-11.
Back to N533AU, cancelled Nov 6, 2014