N8687A
Service difficulty reports · 88
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 = 'N8687A' 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 = 'N8687A' 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 SWAA2024052980755Nut · looseL2 DOOR INNER HANDLE HAS PLAY AT CAM PLATE AXLE .TIGHTENED NUT (30) IAW CMM 52-16-15.SDR SWAA2024052980934Angle · crackedR-2 GALLEY SERVICE DOOR LOWER PANEL ASSEMBLY # 411A2119-174A AFT STIFFENER ANGLE IS CRACKED. {MARKED}<[01] RECIEVED NEW PANEL ASSEMBLY #411A2113-174A. WORK WILL BE ACCOMPLISHED ON TASK CARD TTG8Q00T2924.;[02] CORRECTION TO STEP 1: RECIEVED NEW PANEL ASSEMBLY #SDR SWAA2024052980756Isolation Mount · brokenL2 DOOR LOWER 834DZ HAS BROKEN ISOLATOR MOUNT..<[01] REMOVED AND REPLACED L2 DOOR LOWER INSOLATOR MOUNT.REF: SRM 51-40-02-0G-0.;[02] VERIFIED STEP 1.;[03] AUDIT C/W REF. MPM 52.02.02SDR SWAA2024052980754Nut · looseR2 DOOR HAS A LOOSE CAM PLATE AXEL GIVING THE INNER HANDLE PLAY.<[01] RE-TIGHTENED NUT (30) AS PER CMM 52-16-15.;[02] FINAL INSPECTION; VERIFIED STEP #1.<BR> AUDIT C/W REF. MPM 52.02.02.SDR SWAA2024052980593Fairing · delaminatedNUMBER 5 FLAP TRACK AFT FAIRING PANEL 194BR, FWR LWR CORNER DELAMINATED. APPLIED PERMANEMT REPAIR ON DAMAGE AREA AS MARKED ON PANEL 194BR IAW SRM 51-70-04-2R-13 PARAG 4-D-G. .APPLIED TOP COAT AT PANEL 194BR IAW AMM 51-21-99-300-802.SDR SWAA2024052980592Panel · damagedRIGHT WING I/B #5 FLAP TRACK PANEL 3194CR; ELONGATED FASTENER HOLES NOTED. APPLIED PERMANEMT REPAIR ON DAMAGE AREA AS MARKED ON PANEL #194CB AS PER B737 SRM 51-70-04-2R-9 PARAG 4-D-G. APPLIED PERMANEMT REPAIR ON DAMAGE AREA AS MARKED ON PANEL #194CR IAW SDR SWAA2024021552550Battery Pack · inoperativeR2 SLIDE AND INTERIOR EMERCENCY LIGHTS INOP<[01] R&R?D M 1672 BATTERY PACK PER AMM 33-51-06SDR SWAA2023110316659Light · damagedPHOTO LUMINESCENT STRIP BY 1 DEF IS DAMAGED BEYOND LIMITS<[01] REMOVED AND REPLACED PHOTO LUMINESCENT STRIP @ 1DEF PER AMM 33-51-15SDR SWAA2023101810905Light · inoperativeEMERGENCY SLIDE LIGHT R2 SERVICE DOOR INOPERATIVE<[01] REMOVED AND REPLACED LAMP IAW AMM 33-51-04SDR SWAA2023101108817Battery Pack · inoperativeFWD EMERGENCY LIGHTS INOP<[01] REPLACED BATTERY PACK REF AMM 33-51-06. OPS CHECK GOOD.SDR SWAA2023092805129Flashlight · failedAFT EMERGENCY FLASHLIGHT RT OUTBOARD FLASHING RED<[01] REPLACED FLASHLIGHT BATTERY REF AMM 25-64-00SDR SWAA2023050845904Battery Pack · inoperativeALL FWD ENTRY DOOR EMERGENCY LIGHTS FOUND INOP<[01] REMOVED AND REPLACED EMERGENCY EXIT LIGHT BATTERY PACK M1675; OP CKD AND FOUND OK AS PER AMM 33-51-06.SDR SWAA2023042730734Slide · out of adjustRT FWD SERVICE DOOR SLIDE PARTIALLY OUT OF SLIDE CONTAINER<[01] COMPLIED W/ MT 725-61-06SDR SWAA2023031515971Lens · missingR-2 EMG LT LENS MISSING<[01] RE-INSTALLED R-2 DOOR EMG LT LENS PER AMM 35-51-01 OPS CKS GOODSDR SWAA2023021602797Battery Pack · inoperative4 EMERGENCY LIGHTS INOP. THREE AISLE LIGHTS FROM ROWS 4; 8; AND 12ABC AND THE FWD L/H OVER/WING LIGHT.<[01] REPLACED THE CABIN BATTERY PACK (M2235) PER AMM 33-51-06. OPS CHECK NORMAL.SDR SWAA2022060815270Flashlight · inoperative1 AFT FLASHLIGHT NEEDS REPLACEMENT / [01] R-R #1 AFT FLASHLIGHT BATTERY & TEST GOOD PER 25-64-00SDR SWAA2022052409976Flashlight · inoperativeAFT FO RIGHT SIDE EMERGENCY FLASHLIGHT INOP / [01] REMOVE AND REPLACE FLASHLIGHT AND BRACKET PER AMM 25-64-00. OPS CHECK GOOD.SDR SWAA2022051808117Battery Pack · inoperative9 EA EMERGENCY LIGHTS ARE INOP. / [01] AFTER FURTHER INVESTIGATION; FOUND THAT INOP LIGHTS ARE ASSOCIATED WITH EMERGENCY EXIT LIGHTS BATTERY PACKS M2335 AND M1672.REMOVED AND REPLACED EMERGENCY EXIT LIGHT POWER SUPPLIES M2335 AND M1672. PERFORMED GOOD INSTALLASDR SWAA2022051808921Battery Pack · inoperative9 EA EMERGENCY LIGHTS ARE INOP. AFTER FURTHER INVESTIGATION; FOUND THAT INOP LIGHTS ARE ASSOCIATED WITH EMERGENCY EXIT LIGHTS BATTERY PACKS M2335 AND M1672.REMOVED AND REPLACED EMERGENCY EXIT LIGHT POWER SUPPLIES M2335 AND M1672. PERFORMED GOOD INSTALLATION TESDR SWAA2022051903014Support Plate · corrodedAFT CARGO BAY L/H FLOOR TO SIDEWALL SUPPORT PLATE HAS AREAS OF CORROSION BS727G+13 TO BS787+6 LBL21 WL 156 / [01] EVALUATED CORROSION AT ALL LOCATIONS; FOUND DEEPEST LOCATION TO BE AT BS 767+10 LBL 21 WL 156; FOUND 0.015 REMOVED FROM ORIG 0.040 IN NUMEROUS 1'XSDR SWAA2022051903010Splice Strap · corrodedAFT CARGO BAY FLOOR PANEL SPLICE STRAP HAS CORROSION BS727I+5 LBL20 WL156 / [01] EVALUATED CORROSION ON SPLICE STRAP BS 727I+5 LBL 20 WL 156; FOUND TO BE OUT OF LIMITS DUE TO NO LIMITS IN THE SRM AND REQUIRES REPLACEMENT PER SRM 51-10-02-0G-0;[02] VERIFIED CORSDR SWAA2022051203008Bracket · brokenAFT CARGO BAY LAV TANK BULKHEAD LOWER BRACKET IS BROKEN BS867 LBL10 WL166 / [01] REMOVED BRACKET AFT CARGO BAY BS867 LBL10 WL166; PER SRM 51-40-02-0G-0.;[02] LOCATED; DRILLED AND DEBURRED BRACKET AFT CARGO BAY BS867 LBL10 WL166; PER SRM 51-40-05-0G-0; AND DGW SDR SWAA2022051203004Shield · corrodedFWD CARGO BAY SHIELD AFT OF DOOR HAS CORROSION AT BS500+10 RBL24 WL156 / [01] EVALUATED CORROSION ON SHIELD BS 500+10 RBL 24 WL 156; FOUND TO BE OUT OF LIMITS DUE TO NO LIMITS IN THE SRM AND REQUIRES REPLACEMENT PER SRM 51-10-02-0G-0;[02] VERIFIED CORRECTIVE ASDR SWAA2022051203006Bracket · corrodedFWD CARGO BAY AFT BULKHEAD BS500I LOWER SUPPORT BRACKET HAS AREAS OF CORROSION FROM RBL24 TO LBL24 WL156 / [01] EVALUATED CORROSION AT ALL LOCATIONS ON BULKHEAD SUPPORT; FOUND DEEPEST LOCATION TO BE AT BS 500I RBL 18 WL 156; FOUND 0.021 REMOVED FROM ORIG 0.071SDR SWAA2022051203012Attach Angle · corrodedAFT CARGO BAY ATTACH ANGLE UNDER R/H SHIELD HAS AREAS OF CORROSION BS767 TO BS787 RBL21 WL156 / [01] EVALUATED CORROSION ON ATTACH ANGLE BS 767 TO 787 RBL 21 WL 156; FOUND TO BE OUT OF LIMITS DUE TO NO LIMITS IN THE SRM AND REQUIRES REPLACEMENT PER SRM 51-10-0SDR SWAA2022051203011Support Plate · corrodedAFT CARGO BAY R/H FLOOR TO SIDEWALL SUPPORT PLATE HAS AREAS OF CORROSION BS727G TO BS787 RBL21 WL156 / [01] EVALUATED CORROSION AT ALL LOCATIONS; FOUND DEEPEST LOCATION TO BE AT BS 747+10 RBL 21 WL 156; FOUND 0.015 REMOVED FROM ORIG 0.040 IN NUMEROUS 1'X1' ARESDR SWAA2022051203005Sidewall Support · corrodedFWD CARGO BAY RT FLOOR TO SIDEWALL SUPPORT PLATE HAD MULTIPLE AREAS OF CORROSION FROM BS 500A - 500I, RBL24, WL156. FOUND DEEPEST LOCATION AT BS 500C+10, RBL 24, WL 156. FOUND 0.015 REMOVED FROM ORIG 0.040 IN NUMEROUS 1'X1' AREAS, FOUND TO BE OUT OF LIMITS SDR SWAA2022051203009Shield · corrodedAFT CARGO BAY R/H SHIELD FWD OF CARGO DOOR AS AREAS OF CORROSION BS767 TO BS794; RBL22; WL156 / [01] EVALUATED CORROSION ON SHIELD BS 767 TO 794 RBL 22 WL 156; FOUND TO BE OUT OF LIMITS DUE TO NO LIMITS IN THE SRM AND REQUIRES REPLACEMENT PER SRM 51-10-02-0G-0SDR SWAA2022051901119Attach Angle · crackedR/H VAPOR BARRIER UPPER ATTACH ANGLE IS CRACKED AT RBL8; WL167.68 UPDATED MEASUREMENT TABLE AND VERIFIED APPLICABILITY OF SRM 57-10-10-2R-5 TO BE CORRECT INSTALLED REPAIR PARTS @ BS663 VAPOR BARRIER UPPER ATTACH ANGLE RBL8-RBL20 WL167.8 IAW SRM 57-10-10-2R-5. SDR SWAA2022051801120Angle · crackedL/H BS663 VAPOR BARRIER UPPER ATTACH ANGLE IS CRACKED AT LBL8; WL167.68 / REMOVED DAMAGED SECTION OF BS663 LH VAPOR BARRIER UPPER ATTACH ANGLE FROM LBL8-LBL20 WL167.68 IAW SRM 57-10-10-2R-5.PERFORM A DETAILED INSPECTION OF THE REPAIR AREA AND THE UNDERLYING STSDR SWAA2021090915222Battery · dischargedAFT FA FLASHLIGHT DEAD BATTERY / REPLACED AFT RH OB FA FLASHLIGHT ASSY PER AMM 25-64-00.SDR SWAA2021081606536Slide · out of positionR1 DOOR EMERGENCY ESCAPE SLIDE PARTIALLY OUT OF CASE. / REINSTALLED SLIDE IN CASE. COMPLIED WIHT MT 725-61-06 AND A.M.M 25-66-01SDR SWAA2021072696244Flashlight · no testAFT OUTBOARD FLASH LIGHT TEST RED F.O. SIDE ( CABIN EMERGENCY FLASHLIGHT HOLDERS/FLASHLIGHTS ) / R/R FLASHLIGHTREMOVED AND REPLACED AFT OTBD FLASHFLIGHT AFT F/O SIDE PER AMM 25-64-00 OPS CHECK GOOD .CL# 91618SDR SWAA2021051270819Flashlight · inoperativeEMERGENCY FLASHLIGHT ON AFT FA STATION INOP. REMOVED AND REPLACED AFT EMERGENCY FLASHLIGHT ON AFT FA STATION REF AMM 256400.SDR SWAA2018082024447Wire · looseL1 DOOR EMERGENCY SLIDE WIRE LOOSE. SECURED WIRE PER MM.SDR SWAA2022020753983Scuff Plate · crackedAFT CARGO BAY; AFT CORNER SCUFF PLATE IS CRACKED / REPAIRED ACB; AFT CORNER SCUFF PLATE PER SRM 53-60-15-2R-1 REPAIR 1 STEPS 4 B (1) THRU (D) REFERENCE SWA TSR # 201800468SDR SWAA2022020753980Skin · dented(TRANSFERRED FROM CUST. CARD # N/R-00001; W/O# 0627212) AS REPORTED BY MX FUSELAGE DENTED BY BELT LOADER @ BS 807 STR. 25R DENT IS 5' LONG 3' WIDE .62 DEEP W/Y=48 DAMAGE 10' FROM DOORWAY CUTOUT. OVER STR. 25R NOT ALLOWED PER SRM53-00-01-01A-5 (MX NOTE) / REPAISDR SWAA2016080554573Battery Pack · dischargedAFT CABIN INBD ON RT SIDE EMERGENCY FLASHLIGHT INOPERATIVE. R & R BATTERY PACK IAW AMM.
Back to N8687A