JASC 3350
Service difficulty reports · 225,886
Reports filed under 3350 · Emergency Lighting, 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 jasc_code = '3350' 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 jasc_code = '3350' 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 PNSA2019050802Light · inoperativeEMERGENCY LIGHT ON F/A PANEL BURNT OUT. RE-LAMPED ARMED SIDE OF EMERGENCY LIGHT PUSH BUTTON ON F/A PANEL, OPS CHECK OK.SDR SWAA2019050932510Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATIONS M1668. R&R BATTERY PER AMM.SDR SWAA2019050932496Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATIONS M1675. R&R BATTERY PER AMM.SDR HALA2019050900229Sign · defective3R EXIT SIGN - DEFECTIVE. RE-SECURED 3R EXIT SIGN. OK FOR SERVICE.SDR DALA2019050802917Battery · failedEMERGENCY LIGHT TEST FAILED FWD LEFT BATTERY, REPLACED FWD LEFT EMERGENCY BATTERY.SDR MASA2019050811847Light · inoperativeSVC DOOR EMERG EXIT LIGHTS INOP.SDR DALA2019050802895Battery · dischargedCABIN STANDBY LIGHTS BETWEEN STA.1100 AND STA. 1200 INOP WHEN TESTED. REPLACED BATTERIES IN POWER PACK IAW AMM 33-52. CHECKS GOOD. (LP5654060)SDR DALA2019050802892Battery Pack · dischargedDURING CK FOUND FIRST CLASS CEILING PANEL EMERGENCY LIGHTS INOP. REMOVED AND REPLACED BATTERY PACK IN PWR SUPPLY B5-100 IAW AMM 33-53. OPS CKS NML. (LP5800797)SDR VNAA2019100151102Battery Pack · inoperativeNR 2 POWER SUPPLY BATTERY FAILED OPS CHECK. R & R THE NR 2 BATTERY POWER SUPPLY IAW AMM 33-51-17-000/400-801SDR SWAA2019062133998Battery Pack · no testEMERGENCY EXIT LIGHT BATTERY PACK 1669 FAILED CAPACITY CHECK. R&R M1669 BATTERY PACK PER AMM.SDR SWAA2019052433018Lens · discoloredR2 DOOR EXIT LIGHT LENS DISCOLORED. R&R LENS IAW AMM.SDR SWAA2019052433007Lens · discoloredAFT ENTRY AFT CENTER LINE EXIT LIGHT LENS DISCOLORED. R&R LENS IAW AMM.SDR SWAA2019052433006Lens · discoloredL2 DOOR EXIT LIGHT LENS DISCOLORED. R&R LENS IAW AMM.SDR SWAA2019052433005Lens · discoloredFORWARD LOWERED CEILING CENTER LINE EMERGENCY EXIT LIGHT LENS DISCOLORED. R&R LENS IAW AMM.SDR SWAA2019051532620Light · inoperativeL1 DOOR EXTERIOR EMERGENCY LIGHT INOP. RELAMPED LIGHT PER AMM.SDR YENA201905070263Lens · missingFLT 679, LAS-LGB. DURING PREFLIGHT NR 1 FA NOTICED EMER EXIT LIGHT ON FWD BULKHEAD PORT SIDE MISSING COVER; INSTALLED NEW COVER LENS ON FWD BULKHEAD ROW 1 AS REQUIRED.SDR ASOA201905075068Light · inoperativeDURING MX INSPECTION THE CEILING EXIT LIGHT AT ROW 23 WAS INOP. REMOVED AND REPLACED AISLE CEILING EXIT LIGHT AT ROW 23 IAW AMM 33-50-08, OPS CHECK GOOD. A/C WAS APPROVED FOR RETURN TO SERVICESDR DALA2019050802959Lens · broken(LOG 1064370) DURING INSPECTION FOUND BROKEN EMERGENCY EXIT LIGHT ASSY RED ON GALLEY 2 AT FWD GALLEY AREA. REPLACED EMERGENCY EXIT LIGHT ASSY RED ON GALLEY NR 2 AT FWD GALLEY AREA AS PER DWG BR2800-7378-DL-UKA-03 REV R. PERFORMED OPERATIONAL TEST OF EMERGENCY SDR DALA2019050802958Lens · broken(LOG 1064083) DURING INSPECTION FOUND BROKEN EMERGENCY EXIT LIGHT LENS RED AFT LAV E AT AFT GALLEY AREA. REPLACED EMERGENCY EXIT LIGHT LENS RED AFT LAVE AT AFT GALLEY AREA AS PER DWG BR2800-7378-DL-UKA-03.SDR DALA2019050802957Light · broken(LOG 1063960) DURING INSPECTION FOUND BROKEN EMERGENCY EXIT LIGHT ASSY AFT GALLEY 4 RT AND LT SIDE AT AFT GALLEY AREA. REPLACED EMERGENCY EXIT LIGHT ASSY AFT GALLEY 4RT AND LT SIDE AT AFT GALLEY AREA ASPER DWG BR2800-7378-DL-UKA REV R AND AMM 33-51-00-710-801.SDR IPXA2019050741861Battery · dischargedINSPECTION TYPE:SDR EMER LT BAT 1 LO LEVEL 1 ALERT ON PREFLIGHT. DEFERRED PER MEL 33 50 4 DMP C/W INSTALLED PLACARD. **SUPPLEMENTAL SDR** R&R'D EMERGENCY BATTERY IAW MM 33-51-01-401. OPS CHECKS GOOD. THIS CLEARS M669394. PLACARD REMOVED.SDR DALA2019050802942Lens · unknown(AIRCRAFT 6807, L/P 1063816) EMERGENCY EXIT COVER DIFFUSER LENS DAMAGED OR MISSING / LOCATIONS:400 / ACARS TEXT:FRC335102400 / INTERIOR. REINSTALLED LENS COVER.SDR DALA2019050802941Fuse · not seated(AIRCRAFT 6709, L/P 5510117) EMERGENCY LIGHTS AT ROW 38 THRU 42 INOP. T/S PER WDM 33-51 - RESEATED BATTERY AND POWER PACK FUSES - ALL EMERGENCY LIGHTS CHK GOOD - OK FOR SERVICE.SDR AALA201905099006Battery · dischargedAIRCRAFT WAS NOT GROUNDED: DURING PS CHECK OF THE EMERGENCY LIGHTS, FOUND FAULT BATTERY/EPSU (13WL) AFT LEFT. MAINTENANCE REPLACED BATTERY OF THE EPSU PER MM 33-51-38.SDR SIMA20190507005Sign · inoperativeUPPER EMERGENCY EXIT SIGN BY RT OVER WING EXIT INOP. C/A-REMOVED AND REPLACED RH UPPER EMERGENCY EXIT SIGN IAW AMM 33-50-14. OPS CHECK GOODSDR SWAA2019050832472Light · inoperativeRT AFT EMERGENCY LIGHT ON EXTERIOR INOP. RELAMPED LIGHT PER AMM.SDR SWAA2019050832467Lens · unsecureCEILING EMERGENCY EXIT SIGN LENS FELL OFF. R&R LIGHT ASSEMBLY PER AMM.SDR IPXA2019050741877Light · inoperativeINSPECTION TYPE:SDR EMERGENCY LIGHT HAS TWO INOP BULBS. INSTALL TWO BULBS IN THE EMERGENCY LIGHT PER AMM 33-51-01-2.SDR DALA2019050802897Power Supply · inoperativeDURING C CHECK, EMERGENCY LIGHTS FAILED FUNCTIONAL CHECK. REPLACED POWER SUPPLY UNIT 16WL AND SEAT 40 RT EMERGENCY LIGHT CONNECTOR. LP 1064284SDR CALA2019050700713Battery · dischargedREF NR LP 9130085 B777-33-3-0018 LT 1 DR EMER LIGHT BATTERY M33093 LOW CAPACITY LT 1 DOOR EMERGENCY LIGHT BATTERY PACK (M33093) REPLACED AND TESTED NORMAL AS PER AMM 33-51-06.SDR CALA2019050700712Battery Pack · dischargedREF NR LP 9130076 B777-33-3-0018 RT 4 DR EMER LIGHT BATTERY M33409 LOW CAPACITY RT 4 DOOR EMERGENCY LIGHT BATTERY PACK (M33409) REPLACED AND TESTED NORMAL AS PER AMM 33-51-06.SDR CALA2019050700704Battery Pack · dischargedREF NR LP 9130075 B777-33-3-0018 LT 4 DOOR EMER LIGHT BATTERY M33407 LOW CAPACITY LT 4 DOOR EMERGENCY LIGHT BATTERY PACK (M33407) REPLACED AND TESTED NORMAL AS PER AMM 33-51-06.SDR IPXA2019060762899Battery Pack · inoperativeEMERG LT BATT LO & 1 ON TESTC/W FIM 33-51-0200 TO BRAKE 3 "SYSTEM OK" OK FOR CONTINUED SERVICESDR SWAA2019053133220Lens · discoloredL1 DOOR EXIT LIGHT LENS DISCOLORED. R&R LENS IAW AMM.SDR SWAA2019053133219Lens · discoloredR1 DOOR EXIT LIGHT LENS DISCOLORED. R&R LIGHT ASSEMBLY IAW AMM.SDR SWAA2019053133198Lens · discoloredR1 DOOR EXIT LIGHT LENS DISCOLORED. R&R LENS IAW AMM.SDR DALA2019050702954Battery · dischargedEMERGENCY LIGHT AT RIGHT CEILING ROW 16-28 ARE INOPERATIVE. MAINTENANCE REPLACED THE BATTERY AND CHARGER. SYSTEM OPERATION IS NORMAL.SDR AALA20190508001Battery · dischargedAIRCRAFT WAS NOT GROUNDED: DURING PS CHECK OF THE EMERGENCY LIGHTS, FOUND FAULT BATTERY/EPSU (13WL) AFT LEFT. MAINTENANCE REPLACED BATTERY OF THE EPSU PER MM 33-51-38.SDR I5EA2019050800001Power Supply · failedDISCREPANCY: EMERGANCY LIGHT POWER SUPPLY M1479 STA 598A INOP. CORRECTIVE ACTION: REMOVED AND REPLACED EMERGANCY LIGHT POWER SUPPLY M179 AT STA 597A IAW AMM 33-51-51.SDR AALA20190507002Sign · brokenAIRCRAFT WAS NOT GROUNDED: CREW REPORTED LOWER EMERGENCY EXIT LIGHT SIGN BROKEN. MAINTENANCE REPLACED LOWER EMERGENCY EXIT SIGN ASSEMBLY AT R1 DOOR PER STANDARD PRACTICES AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR SWAA2019050832487Power Supply · inoperativeAFT RT EMERGENCY EXIT POWER SUPPLY M1672 INOP. R&R POWER SUPPLY PER AMM.SDR SWAA2019050832476Light · inoperativeRT AFT OVERWING EXIT SIGN LIGHT INOP. RELAMPED LIGHT IAW AMM.SDR SWAA2019050832465Battery · dischargedAFT RT EMERGENCY EXIT BATTERY M1672 INOP. R&R BATTERY PER AMM.SDR N6WA2019050601Light · malfunctionedEMERG EXIT LIGHT KEEPS BLINKING (MID CABIN CALL LIGHTS). DEFERRED MID CABIN F/A CABIN CALL ON OPEN CONTROL # 70055295
PER MEL 23-40-01J CAT B AUTHORIZED BY MXC.SDR SWAA2019050832432Light · inoperativeR1 DOOR EMERGENCY EXIT LIGHT INOP. RELAMPED LIGHT IAW AMM.SDR SWAA2019050832425Lens · unsecureEXIT ROW CEILING EXIT SIGN LENS CAME OFF. SECURED LIGHT LENS PER SIP.SDR IPXA2019050641835Light · inoperativeINSPECTION TYPE:SDR EMERGENCY EGRESS LIGHT BELOW L-1 DOOR INOP. R&R EMERGENCY EGRESS LIGHT BELOW L-1 DOOR IAW MM 33-51-6 PAGE BLOCK 401. OPS CHECK NORMAL.SDR DALA2019050702880Cover · brokenEMERGENCY LIGHT SEAT 20C BROKEN OFF SEAT, INSTALLED LIGHT COVER.SDR SWAA2019050732412Power Supply · defectiveFIRST OFFICER OVERWING EMERGENCY EXIT LIGHT CONSTANTLY FLICKERED. R&R POWER SUPPLY PER MM.SDR SWAA2019050732411Battery Pack · defectiveFIRST OFFICER OVERWING EMERGENCY EXIT LIGHT CONSTANTLY FLICKERED. R&R BATTERY PACK PER MM.
Back to JASC 3350