N7888A
Service difficulty reports · 242
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 = 'N7888A' AND registry_match = 'registration' 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 = 'N7888A' AND registry_match = 'registration' 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 SWAA2022011053103Web · corrodedCORROSION ON WEB AT AFT CARGO BAY BS774 RBL20. MARKED. ; / [01] REMOVED CORROSION ON WEB AT BS 774; RBL20; WL 156 PER SRM51-10-02-0G-0 MEASURE L=3.3'X W=1.1'X D=0.002' MAX. MAT LOSS IS 0.002'; REMAINING THICKNESS IS 0.048'; ORIGINAL THICKNESS IS 0.050' WAS FOUSDR SWAA2022011053098Stiffener · crackedLEFT HAND HORIZONTAL STABILIZER INSPAR RIB AT STATION 129.50 3RD VERTICAL STIFFENER IS CRACKED ; / [01] REMOVED THE DAMAGED PART AT LH HORIZONTAL STABILIZER STA 129.50 RIB 3RD VERTICAL STIFFENER IAW SRM 55-10-09-2R-4; [02] VERIFIED CORRECTIVE ACTION 1; [03] HFSDR SWAA2022010453282Gusset · crackedFCB GUSSET IS CRACKED AT BS500D STR 19L ; / [01] DAMAGE FOUND ON FCB GUSSET AT BS500D STR19L; FOUND TO BE OUT OF LIMITS DUE TO O LIMITS ON SRM PART WILL BE REPAIRED BY REPLACEMENT IAW SRM 51-10-02-0G-0 PAR. 9.C.; [02] VERIFIED CORRECTIVE ACTION 1; [03] RECEIVESDR SWAA2022010552765Panel · pulledSUPPLEMENTAL INFORMATION: PANEL 194E HAS FASTENER HOLES PULLED THROUGH AND ELONGATED ON THE LEADING AND TRAILING EDGE FASTENER HOLES. ; PANEL 194E HAS FASTENER HOLES PLLED THROGH AND ELONGATED ON THE LEADING AND TRAILING EDGE FASTENER HOLES. / [01] IDENTIFIED SDR SWAA2022010552766Panel · pulledPANEL 193D HAS FASTENER HOLES PULLED THROUGH ON THE AFT SIDE FASTENER ROW. ; PANEL 193D HAS FASTENER HOLES PLLED THROGH ON THE AFT SIDE FASTENER ROW. FOUND DAMAGE TO BE OUT OF ALLOWABLE LIMITS IAW SRM 53-40-70-1A-1 PARA 4B(2). REMOVED DAMAGED PLIES AND CLEASDR SWAA2021121351370Intercostal · crackedSUPPLEMENTAL INFORMATION: FWD CARGO AIR DISTRIBUTION BAY AT BS 540 CABIN FLOOR BOARD INTERCOSTAL IS CRACKED LEFT OF CENTER ; / [01] REMOVED FWD CARGO AIR DISTRIBUTION BAY AT BS 540 CABIN FLOOR BOARD INTERCOSTAL LEFT OF CENTER IAW SRM 51-40-02; [02] INSTALLED RSDR SWAA2021100828085None · out of toleranceFORWARD ENTRY DOOR L1 SLIDE PRESSURE INDICATOR OUT OF THE GREEN TOLERANCE BAND ; / [01] REMOVED AND REPLACED L1 SLIDE PACK ASSY. IAW M/M 25-66-01 AND MT 725-61-06SDR SWAA2020052680390Battery Pack · dischargedEXTERIOR EMERGENCY LIGHT AFT OF WING TO BODY FAIRINGS INOP ON BOTH SIDES OF ACFT. CHARGED BATTERY PACKS PER AMM 33-51-06.SDR SWAA2020032442709Vapor Barrier · crackedRH WHEEL WELL CENTER WING REAR SPAR VAPOR WEB CRACKED 8" LONG FROM LOWER ROW OF FASTENERS BEHIND HYDRALIC SERVICE HAND PUMP C/W INTERIM SEAL APPLIED SPEED TAPE TO DAMAGED AREA IAW SRM 57-10-10-1A-2 PAR. 2.C. (4) (A). DO A VISUAL INSPECTION OF REPAIR ARSDR SWAA2019121939845Lamp · inoperativeFORWARD CABIN OVER WALK WAY EMERGENCY AREA LIGHT INOP. / RELAMPED LIGHT IAW AMM.SDR SWAA2019121939844Bulb · inoperativeEXTERIOR EMERGENCY LIGHT AT R/H OVERWING EXIT DOOR INOP. / R&R BULB PER AMM.SDR SWAA2019121939843Bulb · inoperativeEXTERIOR EMERGENCY LIGHT AFT OF THE R1 DOOR INOP. / R&R BULB PER AMM.SDR SWAA2019122339878Light · inoperativeEMERGENCY LIGHT OVER THE RIGHT OVERWING EXIT DOOR INOP. REPAIRED EMERGENCY LIGHT IAW SWA SAM 326.SDR SWAA2019122339863Light · inoperativeEMERGENCY LIGHT OVER THE LEFT OVERWING EXIT DOOR INOP. REPAIRED EMERGENCY LIGHT PER SWA SAM 326.SDR SWAA2019121839801Battery Pack · inoperativeEMERGENCY LIGHTS OVER R2 DOOR AND ON AFT LAV INOP. / R&R BATTERY PACK M1673 IAW AMM.SDR SWAA2022040128822Door Sill · crackedAFT CARGO COMPARTMENT AFT SCUFF PLATE FWD CORNER IS CRACK / LOCATED ANBD DRILLED NEW SCUFF PLATE AFT CARGO FWD CORNER I.A.W SRM 51-40-05-0G-0 P/O #771000/2. COUNTERSINKED FASTENER HOLES I.A.W. SRM 51-40-08-0G-0. AFT CARGO FWD CRONER SCUFF PLATE TO BE INSTALLEDSDR SWAA2022022228807Plate · brokenLEFT HAND WING ACCESS PANEL 561CB INBOARD WIGGLE PLATE BROKEN / REMOVED AND REPLACED IB WIGGLE PLATE ON LH WING ACCESS PANEL 561CB PER SRM 51-40-02 AND DRAWING 115A3700SDR SWAA2019121239575Panel · crackedL/H WING LEADING EDGE PANEL 521QB CRACKED ON FORWARD INBOARD CORNER. / REPAIRED PANEL 521QB IAW SRM.SDR SWAA2019121239574Shield · corrodedAFT OF AFT CARGO DOOR SHIELD CORRODED BETWEEN BS. 847 TO BS. 867, RBL 25. / R&R SHIELD PER SRM, AMM, AND DWG.SDR SWAA2019121639614Sign · brokenAFT LOWERED CEILING PANEL EXIT SIGN BROKEN. / R&R SIGN IAW AMM.SDR SWAA2019121239573Baffle · crackedAFT CARGO BAFFLE CRACKED BETWEEN BS. 927 TO BS. 947, RBL 22. / R&R BAFFLE IAW DWG & SRM.SDR SWAA2019120659368Angle · corrodedCLIP CORRODED AT BS. 947, LBL 8.1. / R&R CLIP IAW SRM AND DWG.SDR SWAA2019121239572Support · corrodedAFT CARGO AFT LOWER BULKHEAD SUPPORT CORRODED AT BS. 947, BETWEEN RBL 24 TO LBL 10. / R&R SUPPORT PER SRM AND DWG.SDR SWAA2019120659367Channel · crackedFORWARD ENTRY DOOR MOPSILL (INNER CHORD) CRACKED AT BS. 303, LBL 57. / R&R CHORD PER SRM AND DWG.SDR SWAA2022032428791Angle · corroded***CORROSION*** VERTICAL FIN CORROSION UNDER PANEL 324WL; AT LOWER O/B SUPPORT ANGLE; BODY STA. 1198; RUDDER STA. 151 APPROX. / REMOVED SUPPORT ANGLE FROM BODY STA 1198 RUDDER STA 151 APROX UNDER PANEL 324WL LOWER O/B RIB. AND INSTALLED REPLACEMENT SUPPORT ANGSDR SWAA2019121039515Angle · crackedR/H WING UPPER ATTACH ANGLE FOR VAPOR BARRIER CRACKED AT BS. 663, RBL 9. / REPAIRED ANGLE IAW SRM.SDR SWAA2019121039514Structure · delaminatedL/H OUTBOARD AFT FLAP DELAMINATED ON INBOARD LOWER CORNER. / REPAIRED AFT FLAP IAW SRM & AMM.SDR SWAA2022032428776Floor Panel · delaminatedPASSENGER CABIN FLOORBOARD 241AF HAS DAMAGED FASTENER HOLES / REPAIRED PASSENGER CABIN FLOORBOARD 241AF HAS DAMAGED FASTENER HOLES IAW 737 SRM 53-00-50-2R-1. DAMAGE DETERMINED TO BE BEYOND ALLOWABLE LIMITS IAW 737 SRM 53-00-50-1A-1; PARA 1;4F. DELAMINATIONS ARSDR SWAA2019120659366Frame · corrodedAFT CARGO BAY FRAME CORRODED AT BS. 947, LBL 8. / R&R FRAME IAW SRM AND DWG.SDR SWAA2019121039513Stiffener · crackedR/H HORIZONTAL STABILIZER STIFFENER 3RD FROM FORWARD CRACKED AT LOWER SECTION ON RIB ASSEMBLY 4 STA. 120.30. / REPAIRED STIFFENER PER SRM.SDR SWAA2019120659365Channel · corrodedFORWARD CARGO COMPARTMENT Z CHANNEL CORRODED BETWEEN BS. 500A TO BS. 500D, RBL 24. / R&R Z-CHANNEL IAW SRM AND DWG.SDR SWAA2019120239280Shield · corrodedFORWARD CARGO COMPARTMENT SHIELD CORRODED AROUND HOLES BETWEEN BS. 492 TO BS. 500A, RBL 24. / R&R SHIELD PER SRM AND DWG.SDR SWAA2019120239278Channel · corrodedFORWARD CARGO COMPARTMENT Z CHANNEL CORRODED AROUND HOLES BETWEEN BS. 400 TO BS. 420, RBL 24. / R&R ZEE CHANNEL IAW SRM, AMM, AND DWG.SDR SWAA2019120239259Channel · corrodedFORWARD CARGO COMPARTMENT Z CHANNEL CORRODED BETWEEN BS. 397 TO BS. 500D, LBL 24. / R&R Z CHANNEL IAW SRM AND DWG.SDR SWAA2019112739200Shield · corrodedFORWARD CARGO COMPARTMENT SHIELD CORRODED BETWEEN BS. 420 TO BS. 442, RBL 24, AROUND HOLES. / R&R SHIELD IAW SRM AND DWG.SDR SWAA2022040728761Channel · corroded***CORROSION*** AFT CARGO Z CHANNEL RBL 22 STA727B+3-757 WL156 / REMOVED AND REPLACED AFT CARGO Z CHANEL RBL22 STA 727A-767 WL156 PER SRM 51-40-02-0G-0 AND DWG# 146A7500 57903U 04DEC19 AFTER EVALUATION OF CORROSION ON AFT CARGO R/H Z CHANNEL FOUND TO BE OUT OFSDR SWAA2019121039512Shield · corrodedAFT CARGO SHIELD CORRODED BETWEEN BS. 769 TO BS. 779, RBL 22, FORWARD OF DOOR. / R&R SHIELD PER SRM, AMM, AND DWG.SDR SWAA2019120939454Angle · corrodedR1 DOOR CORRODED ON THRESHOLD SUPPORT ANGLE CORRODED AT BS. 329, RBL 58. / R&R SUPPORT ANGLE IAW SRM AND DWG.SDR SWAA2019120939453Channel · corrodedAFT CARGO Z CHANNEL CORRODED BETWEEN BS. 727 TO BS. 847, LBL 22. / REPAIRED Z CHANNEL IAW SRM AND DWG.SDR SWAA2019120939452Channel · corrodedAFT CARGO Z CHANNEL CORRODED AT BS. 900, RBL 22. / R&R Z CHANNEL PER SRM & DWG.SDR SWAA2019112739190Intercostal · corrodedFORWARD CABIN FLOOR WET AREA CORRODED AT BS. 294+6, LBL 15. / R&R INTERCOSTAL IAW SRM & DWG.SDR SWAA2022040828749Floorboard · delaminatedFWD PASSENGER CABIN FLOORBOARD 222BF HAS SURFACE DAMAGE / FWD PASSENGER CABIN FLOORBOARD 222BF SURFACE DAMAGE REPAIRED IAW SRM 53-00-50-2R-1. DAMAGE DETERMINED TO BE BEYOND ALLOWABLE LIMITS IAW SRM 53-00-50-1A-1 PARA 4.F. DELAMINATIONS ARE NOT PERMITTED.SDR SWAA2022040828737Panel · crackedWING PANEL 621FB I/B FWD CORNER FASTENER HOLE IS CRACKED / WING PANEL 621FB I/B FWD CORNER FASTENER HOLE CRACK REPAIRED IAW SRM 57-41-01-2R-1 TABLE 202 AND IAW SRM 51-70-05-2R-9. DAMAGE BEYOND ALLOWABLE LIMITS IAW SRM 57-41-01-1A-1 PARA 4A(2)(A). DAMAGE EXCEEDSDR SWAA2019112739189Shear Web · corrodedWEB CORRODED BETWEEN BS. 1016 TO BS. 1026, BETWEEN LBL 0 TO LBL 37. / R&R SHEAR WEB IAW SRM & DWG.SDR SWAA2019120239258Plate · crackedL/H WING WIGGLE PLATE CRACKED AT APPROXIMATELY WS. 477 AT WING PANEL 661CB. / R&R WIGGLE PLATE IAW SRM & AMM.SDR SWAA2019112769188Plate · crackedL/H WING WIGGLE PLATE CRACKED AT APPROXIMATE WS. 303 AT WING PANEL 661AB. / R&R WIGGLE PLATE IAW SRM.SDR SWAA2019112739187Plate · crackedL/H WING WIGGLE PLATE CRACKED AT APPROXIMATE WS. 290 AT WING PANEL 661AB. / R&R WIGGLE PLATE IAW SRM.SDR SWAA2019112539098Gusset · crackedFORWARD CARGO GUSSET CRACKED AT BS. 500D, STR. 19L. / R&R GUSSET PER SRM AND DWG.SDR SWAA2019112539097Gusset · crackedFORWARD CARGO GUSSET CRACKED AT BS. 500D, STR. 19R. / R&R GUSSET PER SRM & DWG.SDR SWAA2019032731090Bracket · looseFORWARD ENTRY GIRT BAR AFT BRACKET LOOSE. REATTACHED AFT BRACKET IAW MT.
Back to N7888A