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 SWAA2019091937022Lens · missingBULLNOSE LENS @ 3D IS MISSING. REPLACED MISSING BULLNOSE EMERGENCY LIGHT LENS AT 3D IAW AMM.SDR SWAA2019091937002Light · inoperativeEMERGENCY LIGHT AT SEAT 6C INOP. R&R BULB PER AMM.SDR R61A201909160967Power Supply · inoperativeCOCKPIT EMER LIGHT INOP. R&R EMERGENCY BATTERY POWER SUPPLY, #1 RT FWD IAW AMM 33-50-01, OPS CHECK GOOD.SDR DALA2019091705405Lens · unsecure(AIRCRAFT 5815, L/P 6077346) EXIT SIGN FELL OFF. CENTER AISLE TOWARD REAR OF A/C. REATTACHED LIGHT LENS.SDR YENA201909160536Battery · failedFLT 225, JFK-TPA. EPSU BATT AT 11WL REQUIRES REPLACEMENT; R & R EPSU BATT AT 11WL IAW AMM 33-51-38. OPS CHECK GOOD.SDR DALA2019091705364Battery · discharged(LOG 5957074) DURING INSPECTION FOUND RT FIRST CLASS EMERGENCY LIGHTS INOPERATIVE. R/R RT FIRST CLASS EMERGENCY LIGHTS BATTERY PER AMM 33-51. OPS CHECK GOOD.SDR AALA201909179013Lens · unsecureAIRCRAFT NOT GROUNDED: OVERWING EXIT SIGN CAME OFF DURING FLIGHT. REPLACED R1 DOOR EXIT MARKER LENS IAW MM 33-51-01 AND OPS CKS NORMAL.SDR DALA2019091605349Light · inoperativeEMERGENCY AISLE LIGHTS AT SEAT 10J AND 32J INOPERATIVE. FOUND ROW 10J RECEPTACLE DISCONNECTED, RE-CONNECTED, AND REPLACED EMERGENCY ESCAPE PATH LIGHT ASSEMBLY AT SEAT 32J. LP 6204965SDR SIMA2019102315010Charger · inoperativeEMERGENCY FLOOR PROX LIGHTS # 6, 7 AND 8 INOP.-C/A-COMPLETE:REMOVED AND REPLACED #4 BATTERY AND BATTERY CHARGER, IAW ENVOY W.C 33-700-19SDR SIMA2019100715008Light · damagedRH FWD EMERGENCY LIGHT STRIP DAMAGED. REMOVED AND REPLACED THE RT FWD EMERGENCY LIGHT STRIP IAW AMM 33-50-21.SDR SWAA2019092337039Fuse · blownEMERGENCY EXIT LIGHT INOP (EXTERIOR). REPLACED POWER SUPPLY FUSE PER AMM.SDR SWAA2019091937018Lens · looseEMERGENCY EXIT SIGN FOR THE LT OVERWING EMERGENCY EXIT DOOR LENS LOOSE. RE-INSTALLED PER M/M.SDR R61A201909150966Power Unit · inoperativeEMERGENCY LIGHT OVER ROW 4 INOP. R&R EMERGENCY LIGHT POWER UNIT #2 IAW AMM 33-50-01, OPS CHECK GOOD.SDR DALA2019091505380Housing · brokenCABIN SEAT ROW24 ISLE EMERGENCY LIGHT MOUNTED UNDER SEAT 24C HAS A BROKEN LIGHT HOUSING, REPLACED HOUSING UNIT AT SEAT 24C.SDR AALA201909169017Light · damagedAIRCRAFT WAS GROUNDED: EMERGENCY EXIT PATH LIGHT AT 18H DAMAGED. TROUBLESHOOTING. ***SUPPLEMENTAL INFORMATION SECT 4 AND 5: REMOVED AND REPLACED EMERGENCY LIGHT ON CORNER WALL OF LAV 3F-1LC IAW AMM 33-51-06. OPS CHECK GOOD.***(CLOSED)SDR SIMA20190915003Inverter · inoperativeCOCKPIT EMERGENCY SIGN EXIT LIGHT INOP. C/A-REMOVED AND REPLACED EMERGENCY EXIT SIGN INVERTER 1 IAW AMM 33-50-11. OPS CHECK GOOD.SDR SIMA20190915002Battery · dischargedMULTIPLE EMER LIGHTS INOP. C/A-REMOVED AND REPLACED #3 EMER BATTERY IAW W/C 33-700-19 AND PERFORMED EMER LIGHT CHECK IAW W/C 33-700-17. OPC GOOD.SDR SWAA2019091636961Sign · detachedEMERGENCY EXIT SIGN AT MID CABIN DETACHED. R&R EMERGENCY EXIT SIGN PER AMM.SDR DALA2019091605347Charger · inoperative(LOG 5375276) DURING INSPECTION FOUND FWD EMERGENCY LIGHTS BATTERY AND CHARGER AT FWD RT GALLEY LOCATION BAD. REPLACED EMERGENCY LIGHT BATTERY AND CHARGER AT LOC M1674 PER AMM 33-51. OPS CK GOOD.SDR DALA2019091605346Battery · discharged(LOG 5375275) DURING INSPECTION FOUND FWD EMERGENCY LIGHTS BATTERY AND CHARGER AT FWD LT GALLEY LOCATION BAD. REPLACED EMERGENCY LIGHT BATTERY AND CHARGER AT LOC M1675 PER AMM 33-51. OPS CK GOOD.SDR 29GA2019091600001Circuit Breaker · trippedFLIGHT 0137 MCO/MCO REPORT: L 8 EMERGENCY LIGHT EXT CONTROL CB TRIPPED CORRECTIVE ACTION: PERFORMED RESET BREAKER IAW AMM 33-50-00. OP'S CHECK GOOD. NO DEFECT FOUND THIS TIME.SDR MASA2019091512044Battery · dischargedALL EMER LIGHTS INOP. CHARGED BATTERIES.SDR MASA2019091512043Charger · inoperativeROW 14 LT/RT LWR EMER EXIT SIGN INOP. R&R BATT PACK CHARGER.SDR DALA2019091505311Battery · dischargedFOUND OVERHEAD EMER LIGHTS OUT FROM ROW 22-25. REMOVED AND REPLACED EMER LT BATTERY PER AMM 33-52. OPS CHECK GOOD AC OK FOR SERVICE. (LP6125224)SDR XMXR20191211002Battery Pack · failedEMERGENCY LIGHTS STAYS ON IN ARM POSITION OR FLASHES ON/OFF IN ARM AND ON. REPLACED BATTERY PACK.SDR XMXR20191211001Battery Pack · failedEMERGENCY LIGHTS STAYS ON IN ARM POSITION OR FLASHES ON/OFF IN ARM AND ON. REPLACED BATTERY PACK.SDR SWAA2019092337006Lens · missingEXIT SIGN MISSING LENS. REPLACED LENS IAW AMM.SDR SWAA2019092337005Battery Pack · dischargedEXTERIOR EMERGENCY LIGHT INOP. R&R BATTERY PACK PER AMM.SDR SWAA2019091937004Battery Pack · unsecureEXTERIOR EMERGENCY LIGHT INOP. SECURED BATTERY PACK TO EMERGENCY LIGHT POWER SUPPLY PER AMM.SDR SWAA2019091937003Light · inoperativeEMERGENCY LIGHT OUT AT 22DEF. RELAMPED & OPS CK'S GOOD IAW AMM 33-51-03.SDR RAIA201909140002Light · inoperativePAX DOOR HANDLE EMERGENCY LIGHT (1) INOP. ADJUSTED PAX DOOR HANDLE EMERGENCY LIGHT. OPS CHECK GOOD.SDR DALA2019091605373Battery · discharged(AIRCRAFT 5808, L/P 5953839) EGCY AISLE LIGHTS AT 28C, 30C AND 33C EXTINGUISH AFTER SHORT TIME ON. CORRECTIVE ACTION: RPLCD M111383 BATTERY. ALL CKS OK IAW AMM 33-51.SDR DALA2019091605370Charger · inflt separation(AIRCRAFT 684, L/P 6196462) EMERG BATT AT M737 INOP. CORRECTIVE ACTION: R/R EMERG CHARGER AND BATTERY PER AMM 33-51.SDR AALA201909159006Control Panel · defectiveAIRCRAFT NOT GROUNDED: AFT FAP EMERGENCY PUSHBUTTON SWITCH INOPERATIVE (4WL EMERGENCY EXIT LIGHT SWITCH). PLACED ON MEL. ***SUPPLEMENTAL INFORMATION SECT 4 AND 5: REMOVED AND REPLACED AFT FAP PANEL IAW AMM 23-73-13 P/B 401.***(CLOSED)SDR ASAA2019091430708Power Supply · inoperativeRIGHT OVERWING EMERGENCY LIGHTS INOP. GROUNDED - YES. REMOVED AND REPLACED LIGHT OVERWING EMERGENCY LIGHT POWER SUPPLY S/N 39707, OPS CHECK GOOD IAW AMM 33-51-06-960-806.SDR QXEA2019091600357Light · inoperativeBURNED OUT BULB, FWD F/A EMERGENCY LIGHT PUSH-BUTTON. REMOVED FROM SERVICE. RELAMPED FWD EMER. LIGHT SWITCH AS REQUIRED. OPC GOOD. RETURNED TO SERVICE.SDR WX0A2019091673422Battery · faultyEMERGENCY LIGHT TEST GIVES FAULTS. REPLACED BATTERY.SDR SIMA20190914003Light · inoperativeROW 17 AISLE EMERGENCY LIGHT INOP. C/A-REMOVED AND REPLACED ROW 17 AISLE EMERGENCY LIGHT LAMP. OPS CHECK GOOD. NO FURTHER DEFECTS FOUND.SDR SIMA20190914002Light · inoperativeOVERWING EXTERNAL EMERGENCY LIGHT INOP. C/A-REMOVED AND REPLACED EXTERNAL EMERGENCY LIGHT BULB IAW AMM 33-50-10. OPS CHECK GOOD. NO DEFECTS NOTED.SDR SIMA20190914004Inverter · inoperativeRT UPPER EMERGENCY EXIT LIGHT AT ROW 12C INOP. C/A-REMOVED AND R EPLACED EMERGENCY LIGHT DC/AC INVERTER IAW AMM 33-50-11 OPC GOOD.SDR SWAA2019091636959Sign · missingOVERHEAD EXIT SIGN IN CEILING MISSING. R&R SIGN ASSEMBLY PER MM.SDR SWAA2019091636901Lens · crackedR2 DOOR SMALL EXIT LIGHT LENS CRACKED. R&R LIGHT ASSEMBLY PER MM.SDR JJBA20190914002Light · unsecureEMERGENCY LIGHT STRIP BY SEAT 1A NOT SECURED. RE SECURED EMERGENCY FLOOR LIGHTING NEAR SEAT 1A.SDR HNAA2019091600274Light · inoperativeNDIS 602 33-50 0024580 14SEP19 SBY CLOSE EMERGENCY FLOOR LIGHT STRIP BETWEEN ROWS 6 & 7 IS INOP. FACT 14SEP19 14:42 SBY. R&R EMERGENCY FLOOR LIGHT STRIP BETWEEN ROWS 6 & 7 IAW AMM 33-50-12. P/N ON LIGHT STRIP 1013194 P/N OFF LIGHT STRIP 1013194.SDR DALA2019091505317Light · inoperativeEMERGENCY EXIT LIGHT INOPERATIVE AT DOOR 4L (27WL). REPLACED EXIT LIGHT AT DOOR 4L. LP 6577161SDR CALA2019091401545Light · damagedEMERGENCY LIGHT CART 712 DAMAGED UPDATED MAA CODE FIX USING VENDOR MAA SCREEN EVALUATE AND CONTACT TOMC MAC RELATED WORK ORDER 000000002120647 AND PRTR TECH REPAIRED PER ECRA 3300-01168. OK FOR SERVICE. MAC METER INITIATED. PERFORMED INTERIM REPAIR PER PART 1SDR SWAA2019091637000Battery Pack · failedEMERGENCY LIGHTING BATTERY PACKS FAILED CAPACITY TEST AT M01673. R&R BATTERY PACK PER AMM.SDR SWAA2019091636963Battery Pack · failedEMERGENCY LIGHTING BATTERY PACKS FAILED CAPACITY TEST AT M01672. R&R BATTERY PACK PER AMM.SDR SWAA2019091636962Lens · out of positionOVERWING OVERHEAD EMERGENCY EXIT LIGHT LENS OUT OF POSITION. REINSTALLED LENS COVER PER SIP.SDR SWAA2019091636912Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M668 IN CABIN. R&R BATTERY PER AMM.
Back to JASC 3350