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 SIMA20161213001Charger · failedRT & LT EXTERIOR OVERWING EMERGENCY LIGHTS INOP. REMOVED AND REPLACED NR 4 BATTERY CHARGER. OPS CHECKED GOOD IAW AMM 33-50-04.SDR AALA20161214029Lens · damagedEMERGENCY EXIT AISLE LIGHT LENS AT 15ABC IS DAMAGED. REPLACED LENS COVER IAW AMM 33-51-03. OPERATIONAL CHECK GOOD.SDR AALA20161214028Lens · damagedEMERGENCY EXIT AISLE LIGHT LENS AT 14FED IS DAMAGED. REPLACED LENS COVER IAW AMM 33-51-03. OPERATIONAL CHECK GOOD.SDR AALA20161214027Lens · damagedEMERGENCY EXIT AISLE LIGHT LENS AT 10FED IS DAMAGED. REPLACED LENS COVER IAW AMM 33-51-03. OPERATIONAL CHECKED GOOD.SDR AALA20161214024Lens · missingEMERGENCY EXIT LIGHT AT SEAT 1G IS MISSING LENS COVER. INSTALLED LENS COVER IAW ESO 20913. OPERATIONAL CHECKED GOOD.SDR AALA20161214023Power Supply · no testEMERGENCY LIGHTS AT ROW 13 THRU 21 DO NOT PASS TEST IAW WORK CARD 2908. REMOVED AND REPLACED THE POWER SUPPLY M1673 IAW AMM 33-51-06.SDR AALA20161213018Power Supply · no testEMERGENCY LIGHTS AT R2 DOOR AREA DO NOT TEST. REMOVED AND REPLACED EMERGENCY POWER SUPPLY M33097 IAW AMM 33-51-00. SYSTEM CHECKS NORMAL.SDR AALA20161213005Power Supply · no testEMERGENCY LIGHTS AT ROW 13 - 21 DO NOT PASS TEST IAW WORK CARD 2908. REMOVED AND REPLACED EMERGENCY POWER SUPPLY M1675 IAW AMM 33-51-06.SDR AALA20161213004Cover · missingEMERGENCY EXIT SIGN IS MISSING THE COVER. REMOVED AND REPLACED EMERGENCY EXIT SIGN IAW AMM 33-51-01. OPS CHECKED NORMAL.SDR AALA20161213003Light · no testPORTABLE EMERGENCY LIGHT FAILED TEST. REMOVED AND REPLACED LIGHT ASSEMBLY IAW AMM 33-53-00.SDR REXA2016121302466Light · detachedEMERGENCY LIGHT DETACHED NEXT TO SEAT 1C. REPLACED THE EMERGECY LIGHT IAW 33-51-01.SDR SWAA2016121410476Cover · looseL1 DOOR EMERGENCY EXIT PLASTIC COVER LOOSE. SECURED THE COVER IAW SIP.SDR SWAA2016121410475Cover · missingRIGHT EMERGENCY EXIT SIGN PLASTIC COVER MISSING. INSTALLED A NEW COVER IAW SIP.SDR SWAA2016121410467Sign · missingRIGHT OVERWING EXIT LIGHT MISSING. REPLACED THE SIGN IAW MM.SDR AALA201612149010Light · missingFIRST SEGMENT OF EMERGENCY LIGHT STRIP 1C MISSING. INSTALLED THE MISSING EMERGENCY LIGHT IAW AMM 33-50-00.SDR SWAA2016121310465Lens · crackedRT OVERHEAD BIN EMERGENCY LIGHT LENS CRACKED AT ROW 6. R&R LENS PER AMM.SDR SWAA2016121310439Lens · crackedLT OVERHEAD BIN EMERGENCY LIGHT LENS CRACKED AT ROW 12. R&R LENS PER AMM.SDR MASA2016121312548Bulb · inoperativeROW 13F FLOOR LEVEL EMERGENCY LIGHT HAD ONE BULB INOPERATIVE. REPLACED THE BULB.SDR SIMA20161212002Light · inoperativeRT CABIN FLOOR EMERGENCY LIGHT EXTRUSIONS NR 3, 5, 6, AND 7 DAMAGED. REMOVED AND REPLACED THE LIGHTS IAW AMM 33-50-12SDR SWAA2016122910833Lens · brokenAFT GALLEY EXIT LIGHT LENS BROKEN. R & R LENS IAW MM.SDR VNAA2016121200021Sign · brokenEMERGENCY LIGHT AT PASSENDOR DOOR BROKEN. SECURED HARDWARE ON ENTRANCE COMPARTMENT EMERGENCY EXIT SIGN.SDR ASOA201611091308Sign · inoperativeDURING C CHECK, FOUND WINDSCREEN EMERGENCY EXIT LIGHT INOPERATIVE. REMOVED & REPLACED THE EMERGENCY EXIT SIGN IAW ESPM 20-16-00. OPS TESTED IAW AMM 33-51-00-710-801. CHECKED GOOD.SDR DALA2016121309954Power Supply · inoperativeFORWARD FLIGHT ATTENDANT PANEL EMERGENCY LIGHT ARM SWITCH WILL NOT TURN ON EMERGENCY LIGHTS. TROUBLESHOT REMOVED AND REPLACED POWER SUPPLY B5-125 IAW MM. ALL LIGHTS CHECK GOOD.SDR AALA20161214021Lens · missingEMERGENCY EXIT NEAR AFT REAR DOOR G4 AREA HAS A MISSING LENS COVER ALLOWING WIRES TO BE EXPOSED. REINSTALLED LENS COVER. OPERATIONAL CHECKED GOOD.SDR AALA20161213001Power Supply · faultyCEILING MOUNTED EMERGENCY LIGHTS AT MID GALLEY TO ROW 12 LEFT SIDE, CLOSET MOUNTED EMERGENCY LIGHTS MID GALLEY AND 2L SLIDE LIGHT ARE INOPERATIVE. REMOVED AND REPLACED POWER SUPPLY M33099 IAW AMM 33-51-06. ALL LIGHTS CHECK NORMAL.SDR IPXA2016121311673Battery Pack · inoperativeEMERGENCY EXIT LIGHTS INOPERATIVE. REMOVED & REPLACED THE BATTERY PACK IAW MM 33-51-07, OPS CHECKED GOOD.SDR SWAA2016121410477Sign · inoperativeAFT GALLEY ENTRANCE EMERGENCY EXIT SIGN LIGHT STRIP BULB INOPERATIVE. R & R THE SIGN ASSEMBLY IAW AMM.SDR AALA201612139005Reflector · missingAIRCRAFT WAS NOT GROUNDED. REFLECTOR AT SEAT 1C MISSING OVER EMERGENCY EXIT LIGHT, BULB STILL WORKS. REPLACED COVER. REPLACED LED LIGHT AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201612139004Light · looseAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT LOOSE (FLOOR). RESTOWED EXIT LIGHT AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR SWAA2016121310464Light · inoperativeL2 DOOR EXTERIOR EMERGENCY EXIT LIGHT INOP. RELAMPED LIGHT AMM.SDR SWAA2016121310444Light · inoperativeAFT CABIN CEILING EMERGENCY LIGHT INOP. RELAMPED LIGHT MM.SDR SWAA2016121310438Lens · brokenRT FORWARD OVERWING EXIT SIGN LENS BROKEN. R&R LENS PER AMM.SDR SWAA2016121210435Cover · unsecureL1 DOOR LOWER EXIT LIGHT COVER FELL OFF. R&R LIGHT ASSEMBLY IAW MM.SDR HNAA2016121300388Battery Pack · inoperativeEMERGENCY CEILING LIGHT AT ROW 4 INOPERATIVE. R & R THE BATTERY AT ROW 3AC IAW 33-51-00.SDR MASA2016121212547Light · inoperativeROW 12 RT EXIT SIGN ONE BULB OUT. REPLACED BULB.SDR CALA2016121201077Battery Pack · inoperativeLEFT EMERGENCY EXIT PSEU FAILED CAPACITY CHECK. REPLACED THE BATTERY PACK IAW MM 33-51-38-0401.SDR CALA2016121201076Switch · faultyEMERENCY EXIT LIGHTS ON IN ARMED POSITION. ACFT POWER NORMAL IAW AWM 33-51-01, OVERHEAD EMERGENCY LIGHT SWITCH INTERMITTENTLY TURNS ON EMERGENCY LIGHTS WHEN IN ARM POSITION. R & R SWITCH EMERGENCY EXIT LIGHTS OP CK NORMAL IAW 33-51-00-710-004-A. ACFT OKAY FOSDR CALA2016121201075Lamp · inoperativeL4 DOOR EXTERIOR EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMP IAW MM 33-51-04. OPS CHECKED GOOD.SDR CALA2016121201074Bulb · inoperativeAFT EMERGENCY EXIT ROW AFT EMERGENCY LIGHT BULBS INOPERATIVE. REPLACED THE BULBS AND OP CHECKED GOOD IAW AMM 33-51-01-201-960-802SDR CALA2016121201072Battery Pack · inoperativeFOUND EMERGENCY LIGHTS IN SEAT ROW 22-30, ONE MID-CEILING EMERGENCY LIGHT AND TWO EXT EMERGENCY LIGHTS INOPERATIVE. REMOVED AND REPLACED THE BATTERY PACK, OPS TESTED GOOD. ACFT OK TO CONTINUE.SDR CALA2016121201071Bulb · inoperativeSEAT 20A EMERGENCY LIGHT HAD A BULB INOPERATIVE. REPLACED THE BULB, NOW OKSDR CALA2016121201069Light · unknownTWO EMERGENCY LIGHTS FLASHING ON AND OFF NEAR L2 LAVATORY. CARRIED OUT EMERGENCY LIGHT TEST, ALL GOOD.SDR SWAA2017010410951Battery Pack · inoperativeRIGHT OVERWING EMERGENCY EXIT LIGHT INOPERATIVE. R & R THE BATTERY PACK IAW AMM.SDR SWAA2017010410931Lamp · inoperativeRIGHT OVERWING EMERGENCY EXIT LIGHT INOPERATIVE. R & R THE LAMP IAW AMM.SDR SWAA2017010410930Battery Pack · inoperativeRIGHT EMERGENCY LIGHT INOPERATIVE BETWEEN ROWS 9 TO 13. R & R THE BATTERY IAW AMM.SDR AALA20161215007Lens · unsecureAIRCRAFT WAS NOT GROUNDED. EXIT LIGHT LENS COVER AT L2 DOOR WILL NOT STAY ON FIXTURE. SECURED LENS COVER IAW STANDARD MAINTENANCE PRACTICES.SDR AALA20161215006Lens · unsecureAIRCRAFT WAS NOT GROUNDED. EXIT LIGHT LENS COVER AT L2 DOOR WILL NOT STAY ON FIXTURE. SECURED LENS COVER IAW STANDARD MAINTENANCE PRACTICES.SDR SWAA2016121510520Lens · brokenAFT ENTRY EXIT LENS COVER BROKEN. R&R COVER ASSEMBLY PER AMM.SDR AALA20161214016Battery Pack · inoperativeEMERGENCY LIGHTS BATTERY PACK M33093 FOR POWER SUPPLY RIGHT CEILING IS INOPERATIVE. REMOVED AND REPLACED BATTERY PACK IAW AMM 33-51-06. OPERATIONAL CHECKED GOOD.SDR AALA20161214013Charger · no testSEAT MOUNTED EMERGENCY LIGHTING DOES NOT ILLUMINATE DURING TEST AT SEATS 32H THROUGH 42H. REMOVED AND REPLACED BATTERY CHARGER ASSEMBLY AT ROW 42H. OPERATIONAL CHECKED GOOD.
Back to JASC 3350