N7881A
Service difficulty reports · 185
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 = 'N7881A' 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 = 'N7881A' 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 SWAA2022013160463Stiffener · crackedLEFT HAND HORIZONTAL STABILIZER INSPAR RIB; STATION 120.30.; 4TH VERTICAL STIFFENER IS CRACKED. ; / CUT AND REMOVED THE DAMAGE FROM THE 4TH VERTICAL STIFFENER OF THE L/H HORIZONTAL STABILIZER RIB STA 120.30 IAW SRM 55-10-09-2R-4 ; REPAIR 4FABRICATED -3FILLER FSDR SWAA2022013160462Stiffener · crackedLEFT HAND HORIZONTAL STABILIZER INSPAR RIB; STATION 120.30.; 3RD VERTICAL STIFFENER IS CRACKED. ; / CUT AND REMOVED THE DAMAGE FROM THE 3RD VERTICAL STIFFENER OF THE L/H HORIZONTAL STABILIZER RIB STA 120.30 IAW SRM 55-10-09-2R-4 ; REPAIR 4; [03] VERIFIED CORRESDR SWAA2022013160461Stiffener · crackedLEFT HAND HORIZONTAL STABILIZER INSPAR RIB; STATION 120.30.; 2ND VERTICAL STIFFENER IS CRACKED. ; / VERIFIED THE APPLICABILITY OF SRM 55-10-09-2R-4; [03] VERIFIED CORRECTIVE ACTIONS 1; 2. <BR><BR>VERIFIED APPLICABILITY AND DAMAGE REMOVAL.FABRICATED -1 T-SECTIOSDR SWAA2022013160466Rib · crackedRIGHT HAND HORIZONTAL STABILIZER INSPAR RIB; STATION 120.30.; 4TH VERTICAL STIFFENER IS CRACKED. ; / REMOVED DAMAGE FROM RH HORIZONTAL STABILIZER INSPAR RIB STA. 120.30 2ND VERTICAL STIFFENER IAW SRM 55-10-09-2R-4 REPAIR-4; [04] VERIFIED CORRECTIVE ACTION 1-3;SDR SWAA2021081807317Nut Plate · brokenR/H INBD MAIN FLAP BROKEN NUTPLATE AT RIB ATTACH POINT (MARKED) 24.5' INBD OF OTBD EDGE ON LEADING EDGE ; / [01] REPLACED BROKEN NUT PLATE. WITH A NEW ONE IAW SRM 51-40-02 DWG 113A2100. REV BSDR SWAA2020020641143Cover · looseL/H EMERGENCY EXIT ROW EMERGENCY ROPE COVER LOOSE AT ROW 11. / SECURED COVER PER AMM.SDR SWAA2022040526066Stringer Clip · crackedPASSENGER CABIN; STA 277; STR 10R; FWD SIDE OF FRAME. STRINGER CLIP IS CRACKED COMMON TO FRAME. / REMOVED AND REPLACED PASSENGER CABIN STA 277 STR 10R; FWD SIDE OF FRAME; STRINGER CLIP IAW DWG 141A1110 REV- AND B-737 SRM 51-40-02 A TAG WN 6387 P/N 141A125-92SDR SWAA2022040726064Intercostal · crackedCRACK AT STA 540 INTERCOSTAL AFT SIDE ABOVE FASTENER LBL 0-24. / REMOVED AND REPLACED STA 540 INTERCOSTAL LBL 0-24 IAW BOEING DWG 143A0060 REV:- AND B737 SRM 51-40-02-0G-0SDR SWAA2019123039953Stringer Clip · crackedPASSENGER CABIN STRINGER CLIP BRACKET CRACKED IN RADIUS AT BS. 259, STR. 8L. / R&R STRINGER CLIP PER SRM AND DWG.SDR SWAA2019120939403Floorboard · brokenFORWARD CABIN FLOOR BOARD PANEL 221BF CORNER TAB BROKEN, BETWEEN BS. 270 TO BS. 420. / REPAIRED FLOOR BOARD 221BF IAW SRM.SDR SWAA2022041126016Panel · missingCABIN PANEL 242UF TOP SURFACE PLY IS DAMAGED 16' FROM AFT EDGE. / REPAIRED UPPER FACESHEET WITH MISSING FIBERS ON FLOORBOARD PANEL (242 VF) WITH WET-LAY-UP REPAIR I/A/W B737-700 SRM 53-00-50-2R-1 (3) A-M (REV 69)SDR SWAA2022041126015Panel · missingCABIN PANEL 241AAF TOP SURFACE PLY IS DAMAGED IN SEVERAL AREAS. / REPAIRED UPPER FACESHEET MISISNG FIBERS ON FLOORBOARD PANEL (241AAF) WITH WET-LAY-UP REPAIR I/A/W B737-700 SRM 53-00-50-2R-1 (3) A-M (REV 69)SDR SWAA2022041126012Tail Cone · delaminatedEMPENAGE TAIL CONE LEFT HAND SIDE WHERE ELEVATOR SEAL RUBS HAS AN AREA OF DELAMINATION / REPAIRED EMPENAGE TAIL CONE 4H SIDE AREA OF DECLAMINATION I/A/W B737-700 SRM'S 53-80-70-2R-1 REV 69+51-70-04-2R-1 REV 69+ 51-70-04-2R-0 REV 69 AND B737-700 AMM 51-21-99-30SDR SWAA2022041126007Floor Panel · missingCABIN PANEL 241XF TOP SURFACE PLY IS DAMAGED AT SEVERAL LOCATIONS / REPAIRED UPPER FACESHEET AT MISSING PLIES AREAS ON FLOORBOARD PANEL (241 XF) WITH WET-LAY-UP REPAIR IAW B737-700 SRM 53-00-50-2R-1 (3) A-M (REV 69)SDR SWAA2022041126006Floor Panel · looseCABIN PANEL 241XF LOWER SURFACE PLY IS DAMAGED AT BL 0 10' FROM AFT EDGE / REPAIRED LOOSE PLIES ON LOWER SURFACE OF FLOORBOARD PANEL (241 XF) WITH WET-LAY-UP REPAIR IAW B737-700 SRM 53-00-50-2R-1 (3) A-M (REV 69)SDR SWAA2022041126004Panel · missingCABIN PANEL 242TF UPPER FACE PLIES ARE DAMAGED 7' FROM AT EDGE. / REPAIRED UPPER FACESHEET MISSING FIBERS ON FLOORBOARD PANEL (242TF) I/A/W B737-700 SRM 53-00-50-2R-1 (3) A-M (REV 69)SDR SWAA2022041125996Beam · crackedREF CARD #I14079 FORWARD SERVICE DOOR #4 BEAM FOUND TO BE CRACKED DURING NDT INSP. / REMOVED FORWARD SERVICE DOOR #4 BEAM AND INSTALLED NEW #4 BEAM FOR FORWARD SERVICE DOOR IAW SRM 51-40-02-0G-0 AND BOEING DWG # 141A6535 REV:CSDR SWAA2020010940320Beam · crackedR1 DOOR #5 BEAM FOUND TO BE CRACKED. / R&R #5 BEAM IAW SRM AND DWG.SDR SWAA2022041125986Fairing · crackedRIGHT WING #6 FLAP TRACK FORWARD FAIRING 642AB OUTBOARD SEAL RETAINER IS CRACKED / REMOVED AND REPLACED RT WING #6 FLAP TRACK FORWARD FAIRING 642AB OUTBOARD SEAL RETAINER IAW B737 SRM 51-40-02-0G-0 STEP 9 AND B737 IPC 27-51-18-02 P. 7. ATAG A73917SDR SWAA2022040525982Floor Panel · corrodedFWD CARGO COMPARTMENT FLOOR PANEL 120AF HAS CORROSION AROND THE OUTSIDE EDGES / REMOVED AND EVALUATED CORROSION ON PANEL 120AF ORIGINAL MATERIAL THICKNESS .071' LOSS OF .004' WITH .067' REMAINING. BLEND FOUND TO BE OUT OF LIMITS DUE TO LENGTH OF BLEND OVER 20'SDR SWAA2022040525980Floor Panel · corrodedFWD CARGO COMPARTMENT FLOOR PANEL 120CF HAS CORROSION AROND THE OUTSIDE EDGES / REMOVED AND EVALUATED CORROSION ON PANEL 120CF. ORIGINAL MATERIAL THICKNESS .071' LOSS OF .005' WITH .066' REMAINING. BLEND FOUND TO BE OUT OF LIMITS DUE TO LENGTH OF BLEND OVER 20SDR SWAA2019120939492Rib · crackedL/H HORIZONTAL STABILIZER LEADING EDGE 331B RIB CRACKED AT LEADING EDGE STA. 188.94. / R&R RIB IAW SRM AND DWG.SDR SWAA2019120939491Rib · crackedR/H HORIZONTAL STABILIZER LEADING EDGE 341B RIB EVIDENCE OF CRACKED AT LEADING EDGE STA. 291.21. / R&R RIB IAW SRM AND DWG.SDR SWAA2019120939490Rib · crackedR/H HORIZONTAL STABILIZER LEADING EDGE 341B RIB CRACKED AT LEADING EDGE STA. 198.23. / R&R RIB IAW SRM AND DWG.SDR SWAA2019120939489Rib · crackedR/H HORIZONTAL STABILIZER LEADING EDGE 341B RIB CRACKED AT LEADING EDGE STA. 179.64. / R&R RIB IAW SRM AND DWG.SDR SWAA2019120939488Rib · crackedR/H HORIZONTAL STABILIZER LEADING EDGE 341B RIB CRACKED AT LEADING EDGE STA. 160.04. / R&R RIB IAW SRM AND DWG.SDR SWAA2019120939487Rib · crackedR/H HORIZONTAL STABILIZER LEADING EDGE 341B RIB CHORD CRACKED AT LEADING EDGE STA. 123.85. / R&R RIB IAW SRM AND DWG.SDR SWAA2019120439332Rib · crackedL/H HORIZONTAL STABILIZER LEADING EDGE 331B RIB CHORD CRACKED AT LEADING EDGE STA. 105.26. / R&R RIB IAW SRM AND DWG.SDR SWAA2022032525946Angle · corrodedAFT CARGO COMPARTMENT STA 767-787 RBL 22 WL 158; SHEILD SUPPORT ANGLE IS CORRODED AT NUTPLATES. / REMOVED AND EVALUATED CORROSION ON SHIELD SUPPORT ANGLE ORIGINAL THICKNESS .050' LOSS OF .012' WITH .038' REMAINING. BLEND FOUND TO BE OUT OF LIMITS PER SRM 53-00SDR SWAA2022032525945Shield · corrodedAFT CARGO COMPARTMENT STA 767 TO 793 RBL 22 WL 158; SHIELD IS CORRODED TOP AND BOTTOM SIDES. / REMOVED AND EVALUATED CORROSION ON AFT CARGO FWD SHIELD. ORIGINAL THICKNESS .050' LOSS OF .014' WITH .036' REMAINING. BLEND FOUND TO BE OUT OF LIMITS PER SRW 53-00-5SDR SWAA2022032525944Intercostal · corrodedAFT CARGO COMPARTMENT STA 747-767 RBL 22 WL 158; INTERCOSTAL IS CORRODED ON UPPER FLANGE AT NUTPLATES. / REMOVED AND EVALUATED CORROSION ON INTERCOSTAL STA 747-767 RBL 22. ORIGINAL THICKNESS .030' LOSS OF .010' WITH .020' REMAINING BLENDS FOUND TO BE OUT OF LISDR SWAA2022032525943Intercostal · corrodedAFT CARGO COMPARTMENT STA 727A-727B LBL22 WL 158; INTERCOSTAL IS CORRODED ON UPPER FLANGE AT FASTENER HOLES. / REMOVED AND EVALUATED CORROSION. ORIGINAL MATERIAL THICKNESS .030' LOSS OF .020' WITH .010' REMAINING. BLEND FOUND TO BE OUT OF LIMITS PER SRM 53-00-SDR SWAA2022032525942Bracket · crackedFWD CARGO COMPARTMENT STA 727 BL0; FWD BULKHEAD PANEL SUPPORT BRACKET IS CRACKED. / REMOVED AND REPLACED BRACKET AT STA 727 BLO PER SRM 51-40-02-0G-0 AND AIPC 53-11-01-26ASDR SWAA2022032525947Strap · corrodedAFT CARGO COMPARTMENT STA 793 RBL 22 WL 158; NUT PLATE STRAP IS CORRODED ON BOTTOM. / REMOVED AND REPLACED NUTPLATE STRAP PART #146A8128- 21 AT STA 793 RBL 22 PER SRM 51-40-02-0G-0 AND DWG 146A8128 REV-SDR SWAA2022032525953Bracket · crackedAFT CARGO COMPARTMENT STA 867 LBL 10; BULKHEAD PANEL SUPPORT BRACKET IS CRACKED AT BOTTOM. / REMOVED AND REPLACED SUPPORT BRACKET PART #149A8109-114 PER SRM 51-40-02-0G-0 AND DWG 149A8109 REV BSDR SWAA2022032525948Strap · corrodedAFT CARGO COMPARTMENT STA 793 RBL 22 WL 158; NUT PLATE STRAP IS CORRODED ON BOTTOM. / REMOVED AND REPLACED NUTPLATE STRAP PART #146A8128-22 PER SRM 51-40-02-0G-0 AND DWG 146A8128 REV- AT STA 799 RBL 22.SDR SWAA2019121039523Angle · corrodedAFT CARGO COMPARTMENT Z CHANNEL CORRODED BETWEEN BS. 727E+10 TO BS. 807, LBL 22. / R&R Z-ANGLE PER SRM.SDR SWAA2022032525936Support Angle · corrodedFORWARD CARGO PIT STA 500D BULKHEAD STRUCTURE RIGHT CURVED LOWER CHORD RBL 25 WL 157 HAS CORROSION AROUND LOWER FASTENER HOLE / REPLACED FORWARD CARGO STA 500D RH COVERED BLKHD SUPPORT PN 143A9485-34 I/A/W SRM 51-40-02-0G-0 & DWG 143A7902 SHEET 209.SDR SWAA2019121839811Angle · corrodedFORWARD CARGO PIT R/H SIDE PLATE HAD CORROSION ON UPPER SURFACE BETWEEN BS. 500A TO BS. 500D, RBL 24. / R&R R/H Z-ANGLE PER SRM AND DWG.SDR SWAA2019121739739Door Sill · corrodedFORWARD CARGO DOOR SURROUND STRUCTURE LOWER SILL WEB CORRODED BETWEEN BS. 440 TO BS. 492, RBL 28, ON UPPER SURFACE. / R&R SILL WEB IAW SRM & DWG.SDR SWAA2019121639654Baffle · crackedFORWARD CARGO PIT BAFFLE CLIP FORWARD SIDE OF BS. 500C FRAME LBL 24 CRACKED. / R&R BAFFLE CLIP IAW SRM & DWG.SDR SWAA2019121639653Baffle · crackedFORWARD CARGO PIT BAFFLE CLIP AFT SIDE OF BS. 500C FRAME, LBL 24 CRACKED. / R&R BAFFLE CLIP IAW SRM & DWG.SDR SWAA2019121639652Gusset · crackedFORWARD CARGO PIT GUSSET CRACKED AT BS. 500D, STR. 19L. / R&R GUSSET IAW SRM, DWG, AND AMM.SDR SWAA2019121639651Gusset · crackedFORWARD CARGO PIT GUSSET CRACKED AT BS. 500D, STR. 19R. / R&R GUSSET IAW SRM, DWG, AND AMM.SDR SWAA2019121639650Shield · corrodedFORWARD CARGO DOOR SURROUND STRUCTURE FORWARD SHIELD CORRODED AT BS. 420+17, RBL 24, AROUND NUTPLATE ON UPPER AND LOWER SURFACE. / R&R SHIELD IAW SRM & DWG.SDR SWAA2022032425917Bracket · crackedL-2 DOOR LOWER HINGE PANEL 834DZ AFT VERTICAL SUPPORT BRACKET IS CRACKED / REMOVED AND REPLACED L2 DOOR LOWER HINGE PANEL 834DZ; ASSEMBLY; IAW SRM 51-40-02-0G-0 STEP 8E; 9B ATAG: IM 1047SDR SWAA2019121839810Panel · crackedR/H WING TRAILING EDGE PANEL 661CB INTERNAL AFT MATING SURFACE HAD SEVERAL FASTENER HOLES CRACKED. / REPAIRED PANEL 661CB IAW SRM.SDR SWAA2019121839809Panel · crackedR/H WING TRAILING EDGE PANEL 661AB INTERNAL AFT MATING SURFACE HAD SEVERAL FASTENER HOLES CRACKED. / REPAIRED PANEL 661AB IAW SRM AND AMM.SDR SWAA2022032425924Bracket · crackedR-2 DOOR LOWER HINGE PANEL 844DZ AFT VERTICAL SUPPORT BRACKET IS CRACKED IN RADIUS / REMOVED AND REPLACED R2 DOOR PANEL 844DZ ASSEMBLY ON W/O 40254-8500-0002; Y142045.SDR SWAA2022032425922Panel · corrodedR-2 DOOR LOWER HINGE PANEL 844DZ HAS CORROSION AROUND FORWARD NUTPLATE / REMOVED AND REPLACED R2 DOOR ACCESS PANEL 844DZ; ASSEMBLY; IAW SRM 51-40-02-0G-0 STEP 8E; 9B.
Back to N7881A