N7818L, cancelled Jun 28, 2023
Service difficulty reports · 218
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 = 'N7818L' AND deregistration_id = 'N7818L-2023-06-28' 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 = 'N7818L' AND deregistration_id = 'N7818L-2023-06-28' 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 SWAA2023042831171Girt Bar · out of adjustFWD ENTRY DOOR SLIDE MATERIAL HANGING OUT CAUSING GIRT BAR TO NOT STAY IN UNARMED POSITION<[01] REMOVED AND REINSTALLED FWD ENTRY SLIDE IAW MT 725-61-06; NO DEFECTS NOTED AT THIS TIME.SDR SWAA2023042028703Cover · out of adjustAFT SERVICE DOOR SLIDE COVER HAS A GAP<[01] VERIFIED PROPER INSTALLATION OF AFT SERVICE DOOR SLIDE IN REFERENCE TO AMM 25-66-01 AND MT 725-61-06. NO DEFECTS NOTED. A/C OKAY FOR SERVICE.SDR SWAA2023031515964Holder · looseFWD ENTRY GIRT BAR FWD HOLDER LOOSE<[01] INSPECTED GIRT BAR. GIRT BAR HOLDER PREFORMS INTENDED DUTY PER AMM 25-66-01<BR>AC OK FOR SERVICESDR SWAA2023021301912Hook · out of adjustFA REPORTS PROBLEM FWD SVC GIRT BAR<[01] ADJUSTED FWD SERVICE DOOR GIRT BAR STOW HOOKS PER SIPSDR SWAA2023011791583Battery Pack · inoperativeRIGHT SIDE FORWARD EMERGENCY EXIT LIGHTS INOPERATIVE. REMOVED AND REPLACED RIGHT FORWARD BATTERY PACK IAW AMM 33-51-06. OPS CHECK GOOD.SDR SWAA2022120578346Battery Pack · inoperativeEMERGENCY LIGHTING BATTERY PACK M1670 NOT HOLDING CHARGE. REMOVED AND REPLACED EMERGENCY LIGHT BATTERY PACK M1670, SEATS 17ABC, IAW AMM 33-51-06. OPS CHECKED GOOD.SDR SWAA2022092283367Slide · out of positionLH AFT SERVICE DOOR SLIDE FELL OUT / [01] REPACKED LH AFT SERVICE DOOR ESCAPE SLIDE IAW AMM 25-66-01. NO FURTHER DEFECTS NOTED. A/C OK FOR SERVICE.SDR SWAA2022080939108Inlet · pulled#2 ENGINE INLET O/B SKIN MULTIPLE FASTENERS PULLED THROUGH / [01] R&R #2 ENGINE INLET AS PER AMM 71-11-01. OPS CHECK OK.SDR SWAA2022052409963Cover · missingWHITE EXIT LIGHT COVER FORWARD ENTRY DOOR IS MISSING / [01] OK TO CONTINUE PER MEL 25-10-01<BR>SP 1 B<BR>67148;[02] INSTALLED NEW FWD ENTRY DOOR EXIT LIGHT COVER PER AMM 33-51-01 OPS CHECK GOOD MEL CLEARED.SDR SWAA2022031181274Pump · faulty#1 ENGINE WILL NOT ACCELERATE TO COMMANDED SETTING; THIS OCCURS DURING TAKE OFF AND CLIMB; THE N1 REMAINS 5% BELOW THE N2 ENGINE REGARDLESS OF THROTTLE POSITION; HAPPENS WITH A/T ON OR OFF; DIFFERENCE GOES AWAY SLOWLY UNTIL THE N1'S ARE MATCHED IN THE HIGH 20SSDR SWAA2022020766628None · crackedT-CLIP IS CRACK IN 193 PANEL LEFT SIDE APPROX. .75' ; / [01] INSTALLED FABRICATED T CLIP REF B737 SRM 51-40-02 USED I.P.C. 53-14-00 FOR FASTENER CALLOUT REF E.A.22-453-00329 REF P.O. COC (P.O.# P2345342)SDR SWAA2021061480210Skin · dentedDENT EXTERNAL SKIN LOCATED BETWEEN STA 219.5 TO STA 224.8 AND ABOVE S-24L FUSELAGE EXTERIOR ; 2021-217461 / EA # 21-153-01510 COMPLETED; EA # 21-153-01510 COMPLETED RII; EA # 21-153-01510 COMPLETED RIISDR SWAA2021061480205Skin · dentedDENT EXTERNAL SKIN LOCATED BETWEEN STA 219.5 TO STA 224.8 AND ABOVE S-24L FUSELAGE EXTERIOR ; 2021-217461 / PERFORMED REPAIR IAW EA # 21-153-01510-WIP1 AND EA# 21-153-01510; PERFORMED REPAIR IAW EA # 21-153-01510-WIP1 AND EA# 21-153-01510 RII; PERFORMED REPAIRSDR SWAA2021061475488Support Angle · crackedCRACK ANGLE SUPPORT OF COVER PLATE AUXILIAR TRACK INBOARD SLAT 3 AT LT WING (1 EA) ; 2021-217453 / REPLACED ANGLE SUPPORT OF COVER PLATE AUXILIAR TRACK INBOARD SLAT 3 AT LT WING (1 EA) IAW B737-700. SRM 51-40-02.; REPLACED ANGLE SUPPORT OF COVER PLATE AUXILIARSDR SWAA2021061475487Support Angle · crackedCRACK ANGLE SUPPORT OF COVER PLATE AUXILIAR TRACK INBOARD SLAT 6 AT RT WING (1 EA) ; / REPLACED ANGLE SUPPORT OF COVER PLATE AUXILIAR TRACK INBOARD SLAT 6 AT RT WING (1E/A) IAW B737-700 SRM 51-40-02-0G-0; REPLACED ANGLE SUPPORT OF COVER PLATE AUXILIAR TRACK INSDR SWAA2021061475486Angle · crackedCRACK ANGLE LOCATED ON BS 420 AND STRINGER 26L AT FWD CARGO COMPARTMENT ; 2021-217404 / REPLACED ANGLE LOCATED ON BS 420 AND STRINGER 26L AT FWD CARGO COMPARTMENT IAW B737-700 SRM 51-10-02 ITEM 9 AND DRAWING # 143A7505 REV :B; REPLACED ANGLE LOCATED ON BS 420 SDR SWAA2021061475485Web · crackedCRACK ON WEB LOCATED BETWEEN BS 400 TO BS 420 AND STRINGER 26L FWD CARGO COMPARTMENT ; 2021-217403 / REPLACED WEB LOCATED BETWEEN BS 400 TO BS 420 AND STRINGER 26L FWD CARGO COMPARTMENT IAW B737-700 SRM 51-10-02 ITEM 9 AND DRAWING #143A7505 REV: B; REPLACED WESDR SWAA2021061472432Stiffener · corrodedCORROSION SUPPORT BRACKET (STIFFENER) LOCATED BS1088 BETWEEN RBL11 TO LBL11 AND WL217 APPROX ON APU COMPARTMENT ; 2021-217348 / TOOL USED: TEMPERATURE CONTROLLER P/N P3015GOES00000 S/N 112031023 DUE DATE: 22-JAN-22.; REPLACED STIFFENER LOCATED BS1088 BETWEEN RSDR SWAA2021061472428Support Bracket · corrodedCORROSION SUPPORT BRACKET (STIFFENER) LOCATED BS1088 BETWEEN RBL11 TO LBL11 AND WL224 APPROX. ON APU COMPARTMENT ; 2021-217349 / TOOL USED: TEMPERATURE CONTROLLER P/N P3015GOES00000 S/N 112031023 DUE DATE: 22-JAN-22.; REPLACED SUPPORT BRACKET (STIFFENER) LOCATSDR SWAA2021061471552Bearing · crackedCRACK OB FLAP BEARING ROLLER TRACK #1 AT LT WING (2 EA) ; 2021-217318 / REPLACED BEARING ROLLER ON O/B FLAP TRACK CARRIAGE #1 AT LT WING (2 EA) IAW AMM 27-51-23-400-803 STEP 7.C.(2)(A) TOOL USED TORQUE PN:QD2R1000A. SN:0319122619. D/D:04 MAR 22.; COMPLETEDSDR SWAA2021061470487Scuff Plate · crackedCRACK FWD CORNER SCUFF PLATE AT FWD CARGO COMPARTMENT ; 2021-217206 / TOOL USED DIGITAL CALIPER PN:500-197-30;SN:15120588;DUE DATE:12-JUL-21.; REPAIRED FWD CORNER SCUFF PLATE AT FWD CARGO COMPARTMENT IAW 737-700 SRM 53-30-15-2R-1 REPAIR 1. TOOL USED DIGITAL CASDR SWAA2021061470494Lens · crackedCRACK EMERGENCY EXIT LENS GALLEY 4 AT AFT GALLEY AREA (1 EA) ; 2021-217269 / REPLACED EMERGENCY EXIT LENS GALLEY 4 AT AFT GALLEY AREA IAW AMM 33-51-01-960-802; REPLACED EMERGENCY EXIT LENS GALLEY 4 AT AFT GALLEY AREA IAW AMM 33-51-01-960-802SDR SWAA2021061470502Plate · crackedCRACK REAR SPAR CORRUGATED PLATE LOCATED BETWEEN WS 278.50 TO WS 302.50 AT RT WING ; 2021-217262 / INSTALLED NEW REAR SPAR CORRUGATED PLATE AND FASTENERS LOCATED BETWEEN WS278.50 TO WS302.50 AT RT WING IAW B737-700 SRM 51-40-02 AND DWG 115A3700 REV. C; INSTALLSDR SWAA2021061470501Plate · crackedCRACK REAR SPAR CORRUGATED PLATE LOCATED BETWEEN WS 228.25 TO WS 253.00 AT RT WING ; 2021-217259 / REPLACED REAR SPAR CORRUGATED PLATE LOCATED BETWEEN WS 228.25 TO WS 253.00 AT RT WING IAW B737-700 SRM 51-10-02 ITEM 9 AND DRAWING #115A2001 REV:-; TASK CARD COMSDR SWAA2021061470500Plate · crackedCRACK REAR SPAR CORRUGATED PLATE LOCATED BETWEEN WS 204.25 TO WS 228.25 AT RT WING ; 2021-217256 / REPLACED REAR SPAR CORRUGATED PLATE LOCATED BETWEEN WS 204.25 TO WS 228.25 AT RT WING IAW B737-700 SRM 51-10-02 ITEM 9 AND 51-40-02 AND DRAWING #115A2001 REV:B; SDR SWAA2021061470477Strut · crackedCRACK FUEL STATION PANEL STRUT ASSY AT RT WING ; 2021-217199 / REMOVED AND REPLACED FUEL STATION PANEL STRUT AT RT WING IAW AMM 52-49-21-400-801-NG SUBTASK 52-49-21-420-004; REMOVED AND REPLACED FUEL STATION PANEL STRUT AT RT WING IAW AMM 52-49-21-400-801-NG SSDR SWAA2021061470482Support Angle · crackedCRACK SUPPORT ANGLE LOCATED AT BS 690 AT RBBL 24.5 CENTER SECTION ; 2021-217196 / TOOL USED P/N: NORTEC 600D S/N 210138503 CAL DUE DATE: 05- MAR- 22; REPLACED SUPPORT ANGLE LOCATED AT BS 690 AT RBBL 24.5 CENTER SECTION IAW B737-700 SRM 51-40-02 DRAWING # 111A6SDR SWAA2021061470480Rib · crackedCRACK INSPAR RIB LOCATED STAB STA 120.30 AT 20 INCH FROM FRONT SPAR AT RT HORIZONTAL STABILIZER ; 2021-217186 / TOOL USED CALIPER P/N 700-113-10 S/N 0013356 DUE DATE 01-APR-22 RADIUS GAUGE P/N S167C S/N AE-28450 DUE DATE 17-JUN-21; PERFORMED REPAIRED INSPAR RISDR SWAA2021061470475Support Angle · crackedCRACK SUPPORT ANGLE LOCATED AT BS 690 AT BL 0 CENTER SECTION ; 2021-217197 / RECORD INSPECTION WAS SELECTED IN ERROR. NOT REQUIRED FOR THIS TASK. AEMP DOES NOT HAVE ABILITY TO ACCESS THE SIGN OFF ONCE CREATED; REPLACED SUPPORT ANGLE LOCATED AT BS 690 AT BL 0 CSDR SWAA2021061470471Rib · crackedCRACK INSPAR RIB LOCATED STAB STA 120 .30 AT 36 INCH FROM FRONT SPAR AT RT HORIZONTAL STABILIZER ; 2021-217187 / PERFORMED REPAIRED INSPAR RIB LOCATED STAB STA 120.30 AT 36 INCH FROM FRONT SPAR AT RT HORIZONTAL STABILIZER I.A.W B737-700 SRM 55-10-09-2R-5 REPAISDR SWAA2021061470473Access Panel · crackedCRACK ACCESS PANEL 542BB ON RETAINER SEAL AT LT WING. REPLACED ACCESS PANEL 542BB RETAINER SEAL AT LT WING IAW B737-700 SRM 51-10-02 ITEM 9 AND DRAWING #113A9375 REV:A; REPLACED ACCESS PANEL 542BB RETAINER SEAL AT LT WING IAW B737-700 SRM 51-10-02 ITEM 9 AND DSDR SWAA2021061470467Skin · crackedCRACK LOWER SURFACE SLAT 6 NOSE SKIN ACTUATOR FITTING RT WING ; 2021-217143 / TOOL USED PN/ NORTEC 600D; SN/ 2000053402; DUE DATE/ 23APR22.; RAISED NEW FAULT TTG8Q0058LX7 TO REMOVE AND REPLACE SLAT #6; RAISED NEW FAULT TTG8Q0058LX7 TO REMOVE AND REPLACE SLAT #SDR SWAA2021061470470Skin · crackedCRACK KRUEGER FLAP LOCATED AT 6 INCH AFT EDGE AND 15 INCH O/B EDGE AT RT WING ; 2021-217167 / PERFORMED REPAIR IAW EA #21-157-01349-WIP1 AND EA #21-157-0134-9; PERFORMED REPAIR IAW EA #21-157-01349-WIP1 AND EA #21-157-0134-9 RII; PERFORMED REPAIR IAW EA #21-15SDR SWAA2021061470469Light · crackedCRACK PHOTOLUMINESCENT FLOOR PROXIMITY LIGHTING AT PASSENGER CABIN (9 EA) ; 2021-217152 / REPLACED PHOTOLUMINESCENT FLOOR PROXIMITY LIGHTING AT PASSENGER CABIN (9 EA) I.A.W AMM 33-51-15-400-802; COMPLETE; REPLACED PHOTOLUMINESCENT FLOOR PROXIMITY LIGHTING AT PSDR SWAA2021021548358Vapor Barrier · crackedLEFT MAIN WHEEL WELL FORWARD LOWER VAPOR BARRIER CRACKED. / FACT AS A RESULT OF POST REPAIR INSPECTIONSDR SWAA2020041741601Light · inoperativeEXTERNAL EMERGENCY LIGHT AFT OF R2 DOOR INOP / RE-LAMPED EXT. EMERGENCY LIGHT AFT OF R2 DOOR; OPS CHECK GOOD IAW AMM 33-51-04-960-801SDR SWAA2020022441629Latch · looseR1 DOOR ESCAPE SLIDE COVER LATCH NOT SECURED. / RESECURED COVER LATCH PER AMM & MT.SDR SWAA201906133630Battery Pack · failedR/H AFT LOWERED CEILING PANEL EMERGENCY BATTERY PACK FAILED TO CHARGE (M1672). R&R BATTERY PACK IAW AMM.SDR SWAA2022031004400Floor Support · brokenFLOORBOARD SUPPORT AT STA. 540 BL0-24R BROKEN / REMOVED AND REPLACED FLOOR SUPPORT AT STA 540 BL-0 - RBL 24 IAW B737-700 SRM. 51-40-02-0G-0 AND DWG 143A0060 REV. BSDR SWAA2022030904396Vapor Barrier · unreliableDURING DTIP REPAIR SURVEY; DOUBLER REPAIR COMMON TO THE WING CENTER SECTION REAR SPAR VAPOR BARRIER; LOWER LH WEB (GFRP) BETWEEN LBL 6 TO LBL 31.83 WAS FOUND TO BE UNDOCUMENTED. REPLACEMENT REQUIRED. / VAPOR BARRIER @ STA 663 L/H SIDE REMOVED & REINSTALLED ON SDR SWAA2019061133530Bulkhead Web · crackedMAIN LANDING GEAR FORWARD PRESSURE BULKHEAD CRACKED AT BS. 663, RBL 34. REPAIRED BULKHEAD IAW EA.SDR SWAA2022030904375Stringer · damagedFWD CARGO COMPARTMENT STR 19R STA 500D REQUIRES REPAIR DUE TO FREEZE PLUG. / REMOVED DAMAGED STR SECTION; FABRICATED REPAIR PARTS FROM BAC1493-249 7075T6 ATAG A88270; BAC1493-574 7075T6 ATAG A08345; INSTALLED AT STR 19R STA 500C TO 500D + 6' IAW SRM 53-00-03-2SDR SWAA2022030904372Skin · out of toleranceDTIP - DOUBLER REPAIR FOUND ON LOWER EXTERNAL FUSELAGE SKIN AT BODY STATION 185; LBL 5; REPAIR DEVIATIONS REGARDING FASTENER TYPE; SPACING; AND REPAIR DOUBLER LOCATION REQUIRE INSTALLATION OF NEW REPAIR PER AAR EA 190305. / REMOVED EXISTING REPAIR ON EXTERNAL SDR SWAA2022030904369Panel · delaminatedLH WING LEADING EDGE PANEL 521PB IS WARPED / DELAMINATED AT FWD INBD CORNER. / REPAIRED AND APPLIED DECORATIVE RESTORATIVE FINISH TO L/H WING LEADING EDGE PANEL #521PB OF DISBONDING OF EROSION STRIP (AS MARKED) IAW B737-700 SRM 52-41-01-2R-6 REV 67 AND B737 AMSDR SWAA2019061133529Skin · damagedSKIN CREASED BETWEEN BS. 380 TO BS. 400, BETWEEN 1" ABOVE STR. 24L TO 1" BELOW STR. 23L. / REPAIRED SKIN IAW EA.SDR SWAA2019061133528Skin · crackedFASTENER HOLE OF T CORD CRACKED BETWEEN BS. 180 TO BS. 188, BETWEEN LBL 1 TO LBL 8. / REPAIRED SKIN PER EA.SDR SWAA2022030904349Fuel Cell · corrodedLEFT WING FUEL PANEL 532KB HAS CORROSION AROUND INNER LIP OF PANEL - MARKED / EVALUATED CORROSION AROUND INNER LIP OF LH WING FUEL 532KB. CORROSION DAMAGE OUTSIDE OF SRM REPAIR LIMITS. UNABLE TO ENSURE WIDTH AND WILL REMAIN FLAT TO WITHIN 0.005' IAW B737 SRM 5SDR SWAA2019051532712Support Fitting · crackedWEB SUPPORT CLIP CRACKED AT AFT END BS. 294, RBL 53. R&R CLIP IAW SRM AND DWG.SDR SWAA2019051332581Floorbeam · crackedFLOOR SUPPORT CRACKED AT BS. 540, BETWEEN BL 0 TO LBL 24. R&R FLOOR SUPPORT IAW SRM AND DWG.SDR SWAA2022030904347Floor Panel · delaminatedCABIN FLOOR PANEL 241BF UPR AND LWR SKINS DISBONDED AT FWD OTBD CORNER. / REPLACED PASENGER CABIN FLOOR PANEL 241 BF IAW B737-700 SRM 53-00-50-2R-0 GENERAL STEP 1 (A) BAC 5085 PAG 20 8.4.2.1; BOEING DOC PANEL NO INSTALLED ON THIS DOCUMENT (A40776; A49691; MP13
Back to N7818L, cancelled Jun 28, 2023