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 CALA2016090900637Light · detachedLAVATORY 102 EMERGENCY LIGHT FELL OFF. SECURED THE LIGHT AND OPS OKSDR ASOA2016090715365Wire · misinstalledCABIN CEILING, AFT MOST EMERGENCY FLOOD LIGHT INOPERATIVE. TROUBLESHOT THE FLOOD LIGHT, FOUND WIRING INCORRECTLY CONNECTED TO LIGHT ASSY. CORRECTED THE WIRING IAW AMM 33-51-16. OPS CHECK GOOD.SDR IPXA2016090808006Power Supply · inoperativeEMERGENCY LIGHT NR 1 BATTERY LOW ILLUMINATED DURING TEST. REMOVED AND REPLACED POWER SUPPLY IAW AMM 33-51-01.SDR REXA2016090701687Battery · dischargedNR 2 AND NR 4 EMERGENCY CEILING LIGHTS ARE INOPERATIVE. REF W/O 1013379, CARD NR 9000-0020. R & R NR 4 EMERGENCY LIGHT BATTERY. OPS CHECKS GOOD.SDR AALA201609089008Cover · unsecureAIRCRAFT WAS NOT GROUNDED: EXIT SIGN COVER ABOVE DOOR 3R NEEDS TO BE RESECURED. REPLACED EXIT SIGN COVER AT 3R DOOR.SDR SWAA2016090855608Battery Pack · inoperativeFORWARD ENTRY EMERGENCY LIGHT BATTERY PACK INOPERATIVE. R & R BATTERY PACK IAW MM.SDR SWAA2016090855607Sign · looseR2 DOOR EXIT SIGN LOOSE. SECURED THE SIGN IAW SIP.SDR SWAA2016090855594Light · inoperativeRIGHT WING AFT LOWER EMERGENCY LIGHT INOPERATIVE. R & R THE LIGHT IAW AMM.SDR SWAA2016090855589Lens · brokenRIGHT EMERGENCY LIGHT LENS BROKEN AT ROW 6. R & R LENS IAW AMM.SDR SWAA2016090855588Lens · missingRIGHT LOWER EMERGENCY EXIT LENS MISSING AT ROW 15. R & R THE LENS ASSEBMLY IAW MM.SDR DALA2016090806470Battery Pack · inoperativeSEAT MOUNTED EMERGENCY LIGHTS FROM ROW 1 THROUGH ROW 12 INOPERATIVE. REPLACED BATTERY PACK.SDR DALA2016090806456Battery Pack · dischargedMAINTENANCE DETERMINED THAT THE BATTERY FOR THE EMERGENCY PATHWAY LIGHTING IN THE TAIL COMPARTMENT WAS INOPERATIVE. MAINTENANCE REPLACED THE BATTERY PACK FOR THE NOTED AREA AND THE OPS CHECK WAS GOOD.SDR MASA2016090712365Bulb · inoperativeSERVICE DOOR EMERGENCY EXIT SIGN BULB INOPERATIVE. REPLACED THE BULB.SDR MASA2016090712364Bulb · inoperativeMAIN CABIN DOOR EMERGENCY EXIT SIGN BULB INOPERATIVE. REPLACED THE BULB.SDR MASA2016090712363Lamp · inoperativeFOUND ONE LAMP INOPERATIVE ROW 13A LOWER EXIT SIGN.SDR AALA20160907004Battery Pack · faultyEMERGENCY LIGHTS BETWEEN ROWS 22-26 FAILED TO STAY OFF WHEN POWER WAS REMOVED FROM AIRCRAFT. REMOVED AND REPLACED THE BATTERY PACK IAW AMM 33-53-00. OPS CHECKED NORMAL.SDR AALA20160907003Battery Pack · faultyEMERGENCY LIGHTS AT ROWS 27-32 FAILED TO STAY OFF WHEN POWER WAS REMOVED FROM AIRCRAFT. REMOVED AND REPLACED THE BATTERY PACK IAW AMM 33-53-00. OPS CHECKED NORMAL.SDR AALA20160907002Battery Pack · faultyAFT INTERIOR OVERWING EMERGENCY EXIT LIGHTS WILL NOT STAY OFF WHEN POWER WAS REMOVED FROM AIRCCRAFT. REMOVED AND REPLACED THE BATTERY PACK IAW AMM 33-53-00.SDR MASA2016090712362Bulb · inoperativeROW 3 EXIT SIGN HAD TWO BULBS INOPERATIVE.SDR DALA2016090706402Battery Pack · dischargedDURING LINE CHECK, MAINTENANCE FOUND THAT THE EMERGENCY PATHWAY LIGHTING AT ROW 19, IN THE CABIN WAS INOPERATIVE. MAINTENANCE REPLACED THE BATTERY PACK FOR THE NOTED LIGHTED AREA AND THE OPS CHECK WAS GOOD.SDR CALA2016091400646Lamp · inoperativeLEFT HALF OF EMERGENCY LIGHTS UNARMED LIGHT INOPERATIVE. REPLACED THE LAMP, OPS NORMAL.SDR AALA20160906010Battery Pack · no testEMERGENCY BATTERY PACK M33408 FAILED PC 2735. REMOVED AND REPLACED THE BATTERY PACK.SDR AALA20160906009Battery Pack · no testEMERGENCY BATTERY PACK FAILED PC 2735. REMOVED AND REPLACED BATTERY PACK IAW AMM 33-51-06.SDR AALA20160906008Battery Pack · no testEMERGENCY BATTERY PACK M33407 FAILED PC 2735. REMOVED AND REPLACED THE BATTERY PACK IAW AMM 33-51-06.SDR AALA20160906007Battery Pack · no testEMERGENCY BATTERY PACK M33094 FAILS PC 2735. REMOVED AND REPLACED THE BATTERY PACK IAW AMM 33-51-06.SDR AALA20160906006Battery Pack · no testEMERGENCY BATTERY PACK M33424 FAILED PC 2735. REMOVED AND REPLACED THE BATTERY PACK IAW AMM 33-51-06.SDR AALA20160906005Battery Pack · no testEMERGENCY BATTERY PACK M33093 FAILED PC 2735. REMOVED AND REPLACED THE BATTERY PACK IAW AMM 33-51-06.SDR VNAA2016090600004Battery Pack · dischargedEXIT PATH FLOOR LIGHTING AND RT SIDE OVERWING EXIT LIGHT INOPERABLE. MAINTENANCE INSPECTED, R & R FORWARD EMERGENCY LIGHTING BATTERY PACK AND PERFORMED CHECKS IAW THE AMM. THE ACFT WAS RELEASED FOR SERVICE.SDR CALA2016090895726Power Supply · faultedDURING TEST, MESSAGE FOR LT FWD BATTERY. REPLACED POWER SUPPLY UNIT.SDR AALA201609079008Light · brokenAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT ON SEAT 16AB BROKEN. REPLACED EMERGENCY LIGHT AND ACCOMPLISHED A SATISFACTORY OPS CHECK IAW AMM 33-51-11.SDR AALA201609079006Lens · unsecureAIRCRAFT WAS NOT GROUNDED: EMERGENCY PATH FLOOR LIGHTING AT ROW 1 LEFT HAS DETACHED BROKEN PLASTIC LENS COVER. SECURED LENS COVER FOR EMERGENCY PATH FLOOR LIGHTING AT ROW 1 LT.SDR AALA201609079005Lens · out of adjustAIRCRAFT WAS NOT GROUNDED: LEFT OVERWING EMERGENCY EXIT LIGHT IS NOT WORKING. ADJUSTED LENS COVER AND ACCOMPLISHED A SATISFACTORY OPS CHECK.SDR ASOA20160906004Battery Pack · dischargedFLIGHT CREW REPORTED, EMERGENCY EXIT ROW SIGNS, BOTH SIDES, KEEP FLICKERING AT ROW 12 CENTER CEILING LIGHT, AFT LIGHT ASSY AND BOTH LT AND RT LOWER EXIT SIGNS FLICKER WHEN OFF AND DO NOT COME ON WHEN SELECTED ON. MX REPLACED EMERGENCY BATTERY AT ROW 10 OVERHESDR SWAA2016090855601Sign · brokenR1 DOOR EXIT FORWARD LOWER SIGN BROKEN. R & R THE SIGN IAW AMM.SDR SWAA2016090755559Lamp · inoperativeL/H OVERWING EXIT LIGHT INOPERATIVE. REPLACED THE LAMP IAW MM.SDR SWAA2016090755555Lamp · inoperativeL2 DOOR SLIDE EMERGENCY EXIT LIGHT INOPERATIVE. REPLACED THE LAMP IAW AMM.SDR SWAA2016090755549Light · inoperativeLEFT OVERWING EXTERIOR EMERGENCY LIGHT INOPERATIVE. R & R THE LIGHT IAW AMM.SDR DALA2016090706457Battery · dischargedDURING LINE CHECK, MAINTENANCE FOUND THAT THE EMERGENCY EXIT SIGN FOR THE AFT EXIT DOOR WAS INOPERATIVE. MAINTENANCE REPLACED THE BATTERY SUPPLY AND THE OPS CHECK WAS GOOD.SDR AALA20160906001Power Supply · inoperativeEMERGENCY LIGHTS INOPERATIVE BETWEEN SEAT ROWS 16 AND 20. REMOVED AND REPLACED EMERGENCY POWER SUPPLY M1671 IAW AMM 33-51-06. OPS CHECKED NORMAL.SDR ASOA2016090615358Battery Pack · failedEMERGENCY EXIT ROW SIGNS KEEP FLICKERING AT ROW 12. REPLACED THE BATTERY PACK. LIGHTS OPS CHECKED GOOD IAW AMM 33-51-00.SDR HNAA2016090700269Light · inoperative4TH FLOOR PATH EMERGENCY LIGHT INOPERATIVE. R & R BULB FOR 4TH FLOOR EMERGENCY LIGHT RESECURED LENS AND TRIM.SDR SIMA20160906006Light · inoperativeSERVICE DOOR GROUND ILLUMINATION EMERGENCY LIGHT INOPERATIVE. R & R SERVICE DOOR EXTERNAL GROUND ILLUMINATION EMERGENCY LIGHT LAMP IAW AMM 33-50-10. OPS CHECK GOOD.SDR SIMA20160906005Light · inoperativeSERVICE DOOR EMERGENCY LIGHT INOPERATIVE. R & R SERVICE DOOR EXTERNAL EMERGENCY LIGHT LAMP IAW AMM 33-50-10-000-801-A & 33-50-10-400-801-A, OPS CHECK GOOD AT THIS TIME.SDR UIEA2016090600748Power Supply · inoperativeUPPER DECK EMERGENCY LIGHT INOPERATIVE. R & R EMERGENCY LIGHT POWER SUPPLY. OPS CHECK OK, IAW AMM 33-51-04.SDR SWAA2016090655385Light · inoperativeRIGHT FORWARD OVERWING EXTERIOR EMERGENCY LIGHT INOPERATIVE. R & R THE LIGHT IAW MM.SDR CALA2016090600628Power Supply · inoperativeEMERGENCY LIGHTS FLICKERING BRIEFLY DURING CRUISE BY L4 DOOR. CYCLED THE CIRCUIT BREAKER H18 ON P1 AND OPS TESTED IAW AMM 33-51-00. ALL CHECKED GOOD. POWER SUPPLY REPLACED.SDR CALA2016090600634Lens · out of positionEMERGENCY LIGHTS AT SEAT 20C HAS BEEN PUSHED INTO FLOOR AND NOT VISIBLE. R & R THE RED LENS. OPS CHECKED GOOD.SDR CALA2016090600633Lamp · inoperativeEXTERIOR R1 EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMP, OPS CHECKED GOOD IAW AMM 33-51-00.SDR CALA2016090600632Fuse · inoperativeR1 OVERWING EMERGENCY EXIT LIGHT DOES NOT ILUMINATE. REPLACED THE FUSE. OPS NORMAL.SDR CALA2016090600631Lamp · inoperativeEXTERIOR EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMP. OPS CHECKED GOOD .OK FOR SERVICE IAW 33-51-15
Back to JASC 3350