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 CALA2018012000257Socket · dirtyEMERGENCY LIGHT INOPERATIVE AT CEILING, BS 382. CLEANED THE SOCKET AND REPLACED THE BULB. OPS CHECKED OK.SDR CALA2018012000254Battery · inoperativeMAIN AISLE OVERHEAD EMERGENCY LIGHTS ROWS 17, AND 35 INOPERATIVE. REPLACED THE CONTROL UNIT BATTERY AND TESTED OK IAW 33-51-07-01 A-520.SDR CALA2018012000253Power Supply · no testDURING AN A CHECK, FOUND THE GALLEY EMERGENCY LIGHT INOPERATIVE. REPLACED THE POWER SUPPLY M33096, BATTERY & CHARGER IAW AMM 33-51-06. LIGHT TESTED OK.SDR MASA2018012012924Lamp · inoperativeROW 17 CEILING EMERGENCY FLOOD LIGHT INOPERATIVE. REPLACED THE LAMP.SDR SWAA2018013119468Lens · brokenFORWARD ENTRY HORSESHOE PANEL EMERGENCY LIGHT LENS BROKEN. R&R LENS PER MM.SDR DALA2018012100405Fuse · blownFOUND THE EMERGENCY LIGHTS INOPERATIVE AT SEATS 10ABC, 11ABCD AND 12ABCD. FOUND THE FUSE BLOWN ON THE POWER SUPPLY. REPLACED THE FUSE IAW AMM 33-51. CHECKED OK.SDR AALA201801239025Lens · damagedEXIT LIGHT LENS DAMAGED ON SEATS 17C AND 1C. REPLACED THE LIGHTS IAW AMM 33-51-19. OPS CHECKED OK.SDR AALA201801229016Lens · detachedG1 GALLEY, THE LENS ON THE EXIT SIGN DETACHED. MAINTENANCE REATTACHED EXIT SIGN AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR SWAA2018012319278Sign · unsecureLT OVERWING WINDOW LOWER EMERGENCY EXIT SIGN FELL OFF. R&R SIGN ASSEMBLY PER AMM.SDR SWAA2018012319272Light · inoperativeLT WING OVERWING EMERGENCY EXIT LIGHT INOP. RELAMPED LIGHT PER AMM.SDR AALA201801239012Sign · unsecureAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN 2R FELL OFF. REPLACED EMERGENCY EXIT SIGN.SDR DALA2018012200358Battery Pack · inoperativeMAINTENANCE FOUND THE FORWARD OVERWING EMERGENCY EXIT DOOR SIGNS NOT ILLUMINATING. MAINTENANCE REPLACED THE BATTERY PACK IAW AMM 33-51-06. OPS CHECKED GOOD.SDR AALA20180120003Power Supply · faultyEMERGENCY LIGHT FROM SEATS 13D TO 24D AND 13H TO 24H FAILED TEST. REPLACED EMERGENCY LIGHT POWER SUPPLY ASSEMBLY M33404 PER AMM 33-51-06-960-803.SDR AALA20180120002Power Supply · faultyAIRCRAFT IN BASE MAINTENANCE. 4 EMERGENCY LIGHTS - MOUNTED ON CEILING PANEL, 2 EMERGENCY EXIT SIGNS AND EXTERIOR EMERGENCY LIGHT ALL FAILED TEST. REPLACED EMERGENCY LIGHT POWER SUPPLY M33099 PER AMM 33-51-06-960-803.SDR SCNA20180119001Fuse · failedDURING AN EMERGENCY LIGHT SWITCH OPS TEST, FOUND THE L2 DOOR ESCAPE SLIDE LIGHT INOPERATIVE. REPLACED A BLOWN FUSE IN THE AFT POWER SUPPLY FOR THE L2 SLIDE LIGHT. OPS CHECKED GOOD.SDR SCNA20180119009Battery Pack · inoperativeEMERGENCY LIGHTS AT SEATS 14D, 16D, 19D, 21D, 24D, RIGHT OVERWING, AND RIGHT OVERWING AT GROUND ARE INOPERATIVE. REPLACED THE BATTERY PACK. EMERGENCY LIGHTS OPS CHECKED GOOD.SDR AALA201801229027Retainer · missingAFT EMERGENCY POWER SUPPLY BATTERY MOUNTING RETAINER MISSING. REMOVED AND REPLACED THE AFT EMERGENCY LIGHT POWER SUPPLY IAW AMM-33-51-38-400-001-A.SDR AALA201801229013Light · inoperativeEMERGENCY EXIT LIGHT AT SEAT 18C INOPERATIVE. REPLACED THE EMERGENCY EXIT LIGHT AT SEAT 18C IAW CMM 25-22-52.SDR IPXA2018011925680Switch · brokenTHE GUARDED SWITCH COVER ON THE EMERGENCY EXIT LIGHTS HAS A BROKEN PIECE. REMOVED & REPLACED EMERGENCY LIGHT CONTROL PANEL IAW MM 33-51-08-004-002, AND MM 33-51-08-404-010. OPS CHECKED GOOD IAW 33-51-08-404-010.SDR DALA2018012000330Light · inoperativeOVERHEAD EMERGENCY LIGHT AT ROW 27 INOPERATIVE, REPLACED EMERGENCY LIGHT.SDR AALA201801229008Lamp · inoperativeR4 DOOR EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMP.SDR SIMA20180119003Power Supply · inoperativeDURING A CHECK, FOUND THE LEFT AND RIGHT OVERWING EMERGENCY LIGHTS INOPERATIVE. R & R THE POWER SUPPLY NR 4 IAW AMM 33-50-04. OPS CHECKED GOOD. NO DEFECTS NOTICED.SDR MASA2018011912923Bulb · inoperativeROW 3 EMERGENCY CEILING LIGHT INOPERATIVE. REPLACED THE BULBSSDR CALA2018011900244Power Supply · no testEMERGENCY LIGHT TEST FAILED AT PTP PANEL. REPLACED THE EPSU AND BATTERY AT 11WL IAW AMM 33-51-38. OK FOR SERVICESDR CALA2018011900243Lens · missingLENS FOUND MISSING ON THE EMERGENCY LIGHT, AFT SIDE OF COAT CLOSET. REPLACED THE LENS.SDR CALA2018011900242Lens · crackedLEFT WING AFT OVERWING EXTERNAL EMERGENCY LIGHT LENS IS CRACKED. REPLACED THE LENS.SDR CALA2018011900241Lens · looseEMERGENCY LIGHTS AT SEAT 31C LENS PUSHED INTO SEAT FAIRING . SECURED THE LENS. OK FOR SERVICE.SDR CALA2018011900237Switch · inoperativeEMERGENCY LIGHTS TOGGLE SWITCH COVER ON THE OVERHEAD PANEL IS INOPERATIVE. REPLACED THE SWITCH.SDR CALA2018011900236Battery · inoperativeEMERGENCY LIGHTS OUT AT SEAT 25, 26 & 27. ABC. R & R THE BATTERY CHARGER AND BATTERY M11082 AT BS 1334 ABOVE THE L3 DOOR IAW AMM 33-51-07. OPS CHECKED GOOD.SDR CALA2018011900235Lamp · inoperativeFLIGHT DECK P5 ANNUNCIATORS HALF ILLUMINATED EMERGENCY LIGHTS IN THE UNARMED POSITION. REPLACED THE LAMPS.SDR CALA2018011900230Battery Pack · inoperativeL1 DOOR EXTERIOR EMERGENCY LIGHT INOPERATIVE. REPLACED THE BATTERY PACK . OP CHECKED NORMAL IAW AMM 33-51-07.SDR CALA2018011900226Control Unit · abnormalNOTED ON AHM AND ON PLF EMERGENCY LIGHTING WELS UNITS HAS 3 INCOMBATIBLE DATABASE ERRORS. MESSAGES 33-13125, 33-13121 AND 33-13105 IAW FIM DMC-B787-A-33-51-07-04A-750A-A. CDB RELOADED TO ALL WELS UNITS. LOAD SUCESSFUL, SYS CONFIG PAGE NOW SHOWS ALL SOFTWARE NOSDR CALA2018011900246Power Supply · faultedEMERGENCY LIGHT TEST WILL NOT PASS. LEFT EPSU UNIT FAULTED. REMOVED AND RELACED THE LI DOOR EPSU AND BATTERY PACK IAW AMM33-51-38. OPS CHECKED NORMAL, NO FAULTS NOTED.SDR CALA2018011900227Guard · brokenFLIGHT DECK EMERGENCY LIGHT SWITCH GUARD BROKEN. REPLACED THE GUARD. CHECKED OK.SDR K11A2018040931039Light · inoperativeR1 DOOR EMERGENCY EXIT LIGHT INOPERATIVE.SDR AALA201801229024Bracket · bentEMERGENGY EXIT LIGHT, ROW 9D, IS BENT INTO THE AISLE. STRAIGHTENED AND REPOSITIONED THE EMERGENCY LIGHT BRACKET, LIGHT OPS NORMAL.SDR AALA201801229025Connector · unsecureWHITE EMERGENCY LIGHT INOPERATIVE AT ROW 3. SECURED A LOOSE CONNECTOR IAW AMM 33-50-00. OPS CHECKED GOOD.SDR ASAA2018011823841Battery Pack · dischargedTHE FOLLOWING EMERGENCY LIGHTS ARE INOP, AISLE LIGHTS AT LT ROWS 6 THRU 11 AND LT FWD EXTERIOR OVERWING LIGHT. GROUNDED - YES. REMOVED REPLACED & OPS CHECKED GOOD LT ROW 8 EMERGENCY LIGHTS BATTERY PACK IAW AMM 33-51-06-960-805 STEPS 4D(1)(2)(C), (3-5) & (6)(C)SDR AALA201801229035Lens · missingSEAT MOUNTED EMERGENCY LIGHT LENS MISSING. MAINTENANCE REPLACED THE LIGHT ASSEMBLY IAW AMM 33-51-19, AND PERFORMED SATISFACTORY OPS CHECK.SDR SWAA2018012319280Light · missingEMERGENCY EXIT LIGHT NOT ARMED LIGHT MISSING. INSTALLED LIGHT IAW SWPM.SDR SWAA2018012319274Guard · brokenSWITCH GUARD SPRING BROKEN ON EMERGENCY LIGHT SWITCH AT AFT FLIGHT ATTENDANT STATION. R&R SWITCH GUARD PER SIP.SDR AALA201801229020Lens · missingLIGHT NEXT TO RIGHT FORWARD DOOR HAS EXIT LIGHT LENS MISSING. REPLACED EMERGENCY PROXIMITY EXIT LIGHT ASSEMBLY AT 1R PER 33-51-14.SDR SWAA2018012219254Battery Pack · failedEMERGENCY LIGHTING BATTERY PACKS FAILED CAPACITY TEST AT LOCATION M01672. R&R BATTERY PACK PER AMM.SDR SWAA2018012219218Battery Pack · failedEMERGENCY LIGHTING BATTERY PACKS FAILED CAPACITY TEST AT LOCATION M01673. R&R BATTERY PACK PER AMM.SDR DALA2018011800349Lens · brokenL2 DOOR EMERGENCY SIGN BROKEN AND FELL OFF DURING FLIGHT. REPLACED THE EMERGENCY LIGHT LENS IAW AMM 33-51.SDR DALA2018012200345Lens · missingTHE LENS ON BOTTOM OF L2 DOOR EMERGENCY SIGN IS MISSING. REMOVED AND REPLACED THE LENS IAW AMM 33-51.SDR AALA201801229026Lens · missingLEFT AFT SERVICE DOOR IS MISSING THE EMERGENCY LIGHT LENS. REPLACED THE EMERGENCY LIGHT LENS IAW AMM 33-51-01.SDR AALA201801199018Lens · missingSEAT 9D RED EMERGENCY LIGHT LENS MISSING. REPLACED THE EMERGENCY LIGHT ASSY IAW AMM 33-51-19.SDR AALA201801229019Lens · missingRIGHT AFT GALLEY DOOR EMERGENCY EXIT LIGHT MISSING THE LENS. REPLACED THE LIGHT ASSY IAW AMM 33-53-01.SDR REXA2018011800032Lens · crackedG2 GALLEY LOWER FLOOR EMERGENCY LIGHT LENS CRACKED. REMOVED AND REPLACED THE LENS IAW AMM 33-51-11-000-801, STEP 4.B(1), AND 33-51-11-400-801, STEP 4.B.4.
Back to JASC 3350