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 AALA2019122099013Light · damagedAIRCRAFT WAS NOT GROUNDED: MAIN CABIN ALL PHOTOLUMINESCENT STRIPS WERE MORE THAN 10% DAMAGED. MAINTENANCE REPLACED PHOTOLUMINESCENT STRIPS PER AMM 33-50-21.SDR AALA2019122099012Light · brokenAIRCRAFT WAS NOT GROUNDED: L1 LOWER EMERGENCY LIGHT BROKEN. MAINTENANCE REPLACED LIGHT ASSEMBLY PER AMM 33-51-13.SDR AALA2019122099011Light · brokenAIRCRAFT WAS NOT GROUNDED: L4 LOWER EMERGENCY LIGHT BROKEN. MAINTENANCE REPLACED LIGHT ASSEMBLY PER AMM 33-51-13.SDR VNAA2019122081102Battery · dischargedEMERGENCY LIGHTS ASSOCIATED WITH BATTERY PACK 4 ILLUMINATE FOR A FEW SECONDS THEN EXTINGUISH. R/R NUMBER 4 EMERGENCY LIGHT BATTERY PACK IAW CRJ-200 AMM 33-51-04-000/400-801 OPS CHECK GOODSDR IPXA2019122085173Battery · inoperativeINSPECTION TYPE:N/AFLT DEL EMERGENCY LIGHTS INOPR&R'D FLT DECK EMERGENCY LIGHTS BATTERY PACK REF AMM 33-51-07 OPS CHKS NORMAL PER SAME IPC 33-51-07-032-020SDR DALA2019122087446Battery Pack · inoperative(AIRCRAFT 676, L/P 6424990) AFT CABIN EMERGENCY LIGHTS INOP. CORRECTIVE ACTION: R/R BATTERY PACKS AND FUSE FOR AFT CABIN EMERGENCY LIGHT PER B757 AMM 33-51.SDR UIEA2019122056073Light · missingSEAT 56C MISSING EMERGENCY TRACK LIGHT ASSY.(<P>TRANSFERRED TO MDDR 122269 IAW DDG 33-51-03-01-01, CAT 'C', DUE 28DEC19. PLACARD INSTALLED AND MCC NOTIFIED. </P>)SDR AALA201912199014Power Supply · inoperativeAIRCRAFT NOT GROUNDED: MAINTENANCE REPORTS EMERGENCY POWER SUPPLY (13WL) FAILED TEST. REMOVED & REPLACED EPSU (13WL) IAW AMM 33-51-38. OPS/ BITE TEST NORMAL.SDR ASAA2019121983642Battery Pack · no testR1 EMERGENCY EXIT LIGHT (EXTERNAL) INOP. GROUNDED - YES. FOUND R1 EXIT SIGN AND OVERDOOR CEILING EMERGENCY LIGHTS INOP AS WELL. REPLACED BATTERY PACK M1674 PER AMM TASK 33-51-06-960-805, EMERGENCY LIGHTS OPS CHECKED GOOD. OK FOR SERVICE.SDR UIEA2019121956070Light · inoperativeEMERGENCY LIGHTS AT MID-CABIN GALLEY, LENS BROKEN AT FLOOR LEVEL ON BOTH R/H AND L/H SIDE.(<P>REMOVED AND REPLACED EMERGENCY PROXIMITY LIGHTS, 3 EA, AT MID CABIN GALLEY PER SWPM 20-30-12, PAGES 97-99, STEP G. OPS CHECK GOOD PER B747 AMM 33-51-12.</P>)SDR UIEA2019121956071Battery Pack · inoperativeEMERGENCY TRACK LIGHTS INOP FROM ROW 1 THROUGH 6, UPPER DECK. (<P>REMOVED AND REPLACED M5055 EMERGENCY POWER SUPPLY FOR EMERGENCY TRACK LIGHTS, ROW 1 THROUGH 6, UPPER DECK, PER B747 AMM 33-51-04-402-012-00. OPS CHECK GOOD PER B747 AMM 33-51-04-712-015-001.</P>SDR UIEA2019121956072Bulb · inoperativeEMERGENCY LIGHTS (CEILING) INOP AT REAR SECTION ON MAIN DECK. (<P>RELAMPED MAIN DECK REAR EMERGENCY CEILING LIGHTS AS NEEDED, AND OPS CHECK GOOD PER B747 AMM 33-51-07-962-001. </P>)SDR UIEA2019121956074Lamp · inoperativeSEVERAL LAMPS BURNED OUT AT LATERAL EXIT SIGNS ON MAIN AND UPPER DECKS. (<P>RELAMPED UPPER AND MAIN DECK LATERAL EXIT SIGN LIGHTS, AND OPS CHECKED GOOD PER B747-400 AMM 33-51-02-962-001.</P>)SDR UIEA2019121986102Battery Pack · inoperativeDOOR 1L DOOR SILL LIGHTS AND NEARBY OUTER DOOR LIGHTS FOUND NOT ILLUMINATED.(<P>EMERGENCY POWER SUPPLY BATTERY ASSY (M5170) REPLACED AND OPERATIONAL TEST CARRIED OUT. RESULT NORMAL IAW <SPAN>AMM 33-51-04.</SPAN></P>)SDR SWAA2019121939855Battery Pack · inoperativeR/H EMERGENCY LIGHTS INOP AT ROW 6. / R&R POWER SUPPLY BATTERY PACK IAW AMM.SDR SWAA2019121939854Battery Pack · inoperativeR/H EMERGENCY LIGHTS INOP AT ROW 3. / R&R POWER SUPPLY BATTERY PACK IAW AMM.SDR SWAA2019121939853Battery Pack · inoperativeL1 UPPER EMERGENCY LIGHTS INOP. / R&R POWER SUPPLY BATTERY PACK IAW AMM.SDR SWAA2019121939852Battery · no testEMERGENCY LIGHTS FAILED THE CAPACITY CHECK AT POSITION M1674. / R&R BATTERY PER MM.SDR SWAA2019121939851Battery · no testEMERGENCY LIGHTS FAILED THE CAPACITY CHECK AT POSITION M1669. / R&R BATTERY PER MM.SDR SWAA2019121939850Battery · no testEMERGENCY LIGHTS FAILED THE CAPACITY CHECK AT POSITION M1668. / R&R BATTERY PER MM.SDR SWAA2019121939849Battery · no testEMERGENCY LIGHTS FAILED THE CAPACITY CHECK AT POSITION M1675. / R&R BATTERY PER MM.SDR SWAA2019121939848Battery · no testEMERGENCY LIGHTS FAILED THE CAPACITY CHECK AT POSITION M1672. / R&R BATTERY PER MM.SDR SWAA2019121939841Lamp · inoperativeL/H EXTERIOR OVERWING EMERGENCY LIGHT INOP. / RELAMPED LIGHT PER MM.SDR SWAA2019121939836Battery Pack · inoperativeR1 LOWER EMERGENCY LIGHTS INOP. / R&R POWER SUPPLY BATTERY PACK IAW AMM.SDR SWAA2019121939830Battery · no testEMERGENCY LIGHTS FAILED THE CAPACITY CHECK AT POSITION M1673. / R&R BATTERY PER MM.SDR DALA2019121807418Power Supply · no testDURING HFA CHECK, EPSU SYSTEM TEST, EPSU 15WL AND 16WL AT DOOR 3 FAILED. REPLACED EMERGENCY EXIT SIGN ABOVE DOOR 3L. LP 6698126SDR SWAA2019122339869Battery Pack · inoperativeEMERGENCY EXITS LIGHTS ASSOCIATED WITH THE M1668 BATTERY PACK INOP. RECONNECTED EMERGENCY LIGHT BATTERY PACK CONNECTOR D10712 TO PACK M1668 PER SWPM & AMM.SDR DALA201912237497Lens · missingSEAT 35D MISSING EMERGENCY WHITE LENS COVER. REPLACED LENS REF AIPC 33-51-11.SDR MASA2019121712187Light · missingFLOOR LEVEL EMERGNECY LIGHT IN GALLEY MISSING.SDR DALA2019122087438Sign · malfunctioned(AIRCRAFT 6701, L/P 6631867) FOUND ISLE EXIT IDENTIFIER AT SEAT ROW 26 PARTIALLY ILUMMINATED DURING SVC CK. CORRECTIVE ACTION: R/R'D ISLE EXIT IDENTIFIER ASSY (LED) PER B757 AMM 33-51-10.SDR AALA2019121989013Control Unit · faultyAIRCRAFT NOT GROUNDED: MAINTENANCE REPORTS PERFORMING EMERGENCY LIGHTING SYS OPS CHECK IAW JOB CARD 2803, FOUND ELS SEAT MOUNTED LIGHTS FROM SEAT 25A ONWARDS TURNED OFF. TROUBLESHOT MTC MSG 33-12017 IAW FIM B787-A-33-50-F1-M8A-421A-A. REMOVED AND REPLACED DOORSDR AALA2019121989020Light · faultyAIRCRAFT WAS NOT GROUNDED: EXIT LIGHT AT DOOR 3L ILLUMINATED, ALL OTHERS DID NOT. MAINTENANCE RESET EMERGENCY LIGHT AND PERFORMED SATISFACTORY OPERATIONAL CHECK PER TSM 33-51-00.SDR AALA2019121989018Light · inoperativeAIRCRAFT WAS NOT GROUNDED: AISLE EMERGENCY LIGHT SEAT 1A AND 1B INOPERABLE. MAINTENANCE REPLACED EMERGENCY LIGHT PER AMM 33-50-00.SDR SWAA2019121939845Lamp · inoperativeFORWARD CABIN OVER WALK WAY EMERGENCY AREA LIGHT INOP. / RELAMPED LIGHT IAW AMM.SDR SWAA2019121939844Bulb · inoperativeEXTERIOR EMERGENCY LIGHT AT R/H OVERWING EXIT DOOR INOP. / R&R BULB PER AMM.SDR SWAA2019121939843Bulb · inoperativeEXTERIOR EMERGENCY LIGHT AFT OF THE R1 DOOR INOP. / R&R BULB PER AMM.SDR SWAA2019121939840Light · inoperativeCABIN INTERIOR INTERIOR PHOTOLUMINESCENT INOP BETWEEN ROW 7 TO ROW 25. / REPAIRED LIGHTS PER MM.SDR HALA2019121807409Lens · detachedDOOR 3R EXIT LIGHT AFT LENS COVER FALL OFF. RE-INSTALLED DOOR 3R EXIT SIGN LENS. LP724073SDR SWAA2019121839824Battery · no testEMERGENCY LIGHTS FAILED CAPACITY CHECK AT M01669. / R&R BATTERY PER MM.SDR SWAA2019121839823Battery · no testEMERGENCY LIGHTS FAILED CAPACITY CHECK AT M01672. / R&R BATTERY PER MM.SDR SWAA2019121839822Battery Pack · inoperativeALL FORWARD R/H EMERGENCY EXIT LIGHTS POWERED BY BATTERY PACK M2816 INOP. / R&R BATTERY PACK IAW AMM.SDR SWAA2019121839821Power Supply · inoperativeALL AFT R/H EMERGENCY EXIT LIGHTS POWERED BY / BATTERY PACK M12 INOP. / R&R POWER SUPPLY IAW AMM.SDR SWAA2019121839795Battery · no testEMERGENCY LIGHTS FAILED CAPACITY CHECK AT M01673. / R&R BATTERY PER MM.SDR SWAA2019121839791Battery Pack · inoperativeALL AFT R/H EMERGENCY EXIT LIGHTS POWERED BY / BATTERY PACK M12 INOP. / R&R BATTERY PACK IAW AMM.SDR SWAA2019121839790Power Supply · inoperativeALL FORWARD R/H EMERGENCY EXIT LIGHTS POWERED BY BATTERY PACK M2816 INOP. / R&R POWER SUPPLY IAW AMM.SDR 2DYA20191218001Power Supply · failedDURING SERVICE CHECK FOUND L1 AND R1 LOWER EMERGENCY LIGHTS INOP. FOUND BATTERY CHARGER AND BATTERY PACK INOP. REMOVED AND REPLACED BATTERY CHARGER AND BATTERY PACK IAW BOEING AMM 33-51-07. OPS CHECK GOOD.SDR MASA2019121712188Light · inoperativePHOTO LUMIN. STRIP NOT ILLUM. ROW 1&2 DC. REPLACED PHOTO LUMIN. STRIP AT ROW 1&2 DC.SDR MASA2019121712184Bulb · inoperativeBOTH ROW 18 EMER EXIT SIGNS 1 BULB EACH INOP- PLACED ON MELSDR SWAA2019122639911Light · crackedEMERGENCY EXIT LIGHT ASSEMBLY CRACKED AT CEILING PANEL ABOVE SEAT ROW 11. R&R LIGHT ASSEMBLY PER AMM.SDR SWAA2019122339878Light · inoperativeEMERGENCY LIGHT OVER THE RIGHT OVERWING EXIT DOOR INOP. REPAIRED EMERGENCY LIGHT IAW SWA SAM 326.
Back to JASC 3350