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 SWAA2018080824117Battery Pack · dischargedLT EMERGENCY EXIT AISLE LIGHTS INOP BETWEEN ROWS 7 TO ROW 12. R&R BATTERY PACK IAW AMM.SDR SWAA2018080824106Battery Pack · dischargedRT EMERGENCY EXIT AISLE LIGHTS INOP AT ROW 8. R&R BATTERY PACK IAW AMM.SDR HNAA2018080800184Inverter · inoperativeLEFT EMERGENCY EXIT, EMERGENCY LIGHT WAS INOPERATIVE. R & R THE NR 4 INVERTER IAW AMM 33-50-11-04.SDR AALA201808076001Battery Pack · inoperativeEMERGENCY LIGHT FOUND TO BE INOPERATIVE AT ROWS 7DEF - 14DEF. REPLACED THE EMERGENCY BATTERY PACK IAW MM 33-51-06.SDR SIMA201808064001Light · inoperativeFLOOR EMERGENCY LIGHT STRIPS NEAR THE LAVATORY WAS INOPERATIVE. REMOVED AND REPLACED FLOOR THE EMERGENCY LIGHTS IAW AMM 33-50-12. OPS CHECKED GOOD.SDR AALA2018080769023Lens · missingR4 DOOR EXIT LENS WAS MISSING. REPLACED THE SIGN LENS, OKAY FOR SERVICE.SDR DALA2018080764912Lens · brokenFOUND EMERGENCY LIGHT LENS BROKEN, AT ROW 39. R & R THE EMERGENCY LIGHT LENS.SDR SWAA2018080724081Sign · detachedRT OVERWING EMERGENCY EXIT ROW SIGN DETACHED. REINSTALLED LIGHT ASSEMBLY IAW AMM.SDR SWAA2018080724079Light · inoperativeLT OVERWING EXIT LIGHT INOP. R&R LIGHT IAW WPM & AMM.SDR SWAA2018080724070Light · inoperativeLT EMERGENCY EXTERIOR LIGHT BETWEEN OVERWING EXIT DOORS INOP. RELAMPED LIGHT PER AMM.SDR AALA2018080769054Lens · missingSEAT MOUNTED EMERGENCY LIGHT LENS MISSING AT 34C. REPLACED THE LENS IAW AMM 33-51-19.SDR AALA2018080769038Lens · missingSEAT MOUNTED EMERGENCY LIGHT LENSES WERE MISSING 25C. REPLACED THE LENS IAW AMM 33-51-19.SDR AALA2018080769012Light · damagedSEAT EMERGENCY LIGHT WAS FOUND DAMAGED AT ROW 9. THE AIRCRAFT WAS GROUNDED. SECURED THE EMERGENCY LIGHT. OPS NORMAL.SDR ASAA2018080645662Lens · missingEMERGENCY EXIT LIGHT LENS NEXT TO THE AFT LEFT LAVATORY WAS MISSING. ACFT GROUNDED. REPLACED THE LENS.SDR SIMA201808064002Light · inoperativeFLOOR EMERGENCY LIGHT STRIPS BY THE SERVICE DOOR WAS FOUND INOPERATIVE. REMOVED AND REPLACED THE EMERGENCY LIGHT BY SERVICE DOOR IAW AMM 33-50-12. OPS CHECKED GOOD. NO FURTHER DEFECT NOTED.SDR DALA2018080600207Connector · failedEMERGENCY LIGHT AT SEAT 24A WAS INOPERATIVE. REPLACED THE CONNECTOR PIN.SDR DALA2018080604863Battery Pack · malfunctionedEMERGENCY LIGHTS INOPERATIVE FROM ROW 31 AFT. AFTER TESTING FROM AFT BATTERY PACK, ALL LIGHTS OPS NORMAL.SDR DALA2018080644858Charger · inoperativeAFT CABIN EMERGENCY LIGHT ON THE CEILING FROM ROW 32 AND BACK WERE INOPERATIVE. FOUND THE CHARGER NOT CHARGING THE BATTERY PACK. REPLACED THE CHARGER IAW AMM 33-51. LIGHTS TESTED GOOD.SDR MASA2018080413448Lamp · inoperativeCEILING OVERHEAD EMERGENCY LIGHT LAMP INOPERATIVE.SDR MASA2018080413447Lamp · inoperativeCEILING OVERHEAD EMERGENCY LIGHT LAMP AT ROW 1 WAS INOPERATIVE.SDR MASA2018080413446Bulb · inoperativeFWD ENTRY EXIT SIGN HAD ONE BULB INOPERATIVE.SDR DALA2018081435076Lens · damagedEMERGENCY LIGHT COVER AT 39G WAS DAMAGED. REPLACED THE SHROUD AND REPAIRED LIGHT ASSEMBLY AND BOX. SYSTEM OPS NORMAL.SDR DALA2018081064996Fuse · failedEMERGENCY LIGHTS AT THE L4 DOOR HEADER WAS INOPERATIVE. REPLACED THE FUSE AT M739 POWER SUPPLY. SYSTEM OPS NORMAL.SDR HALA201808080209Light · looseREFLECTIVE LIGHT STRIPE IN FORWARD GALLEY IS LOOSE. SECURED THE LIGHT STRIPE.SDR AALA2018080879032Battery Pack · no testDURING CIDS1 TEST, BATTERY 11 WL FAILED. REPLACED THE BATTERY IAW AMM 33-51-38. TESTED OK.SDR DALA2018080704926Lens · unknownDURING INSPECTION, FOUND EMERGENCY EXIT SIGN INOPERATIVE. MAINTENANCE INSTALLED LENS. EMERGENCE LIGHTS OPS NORMAL.SDR AALA201808076021Lens · missingSEAT 4L EMERGENCY LIGHT LENS MISSING. REPLACED LIGHT ASSEMBLY AMM 33-51-18. OPERATIONS OK.SDR SWAA2018080724056Cover · missingLT OVERWING DOOR EMERGENCY LIGHT COVER MISSING. INSTALLED COVER IAW AMM.SDR SWAA2018080724052Power Supply · inoperativeR2 DOOR EXTERNAL FORWARD EMERGENCY EXIT SLIDE LIGHT INOP. R&R POWER SUPPLY PER AMM.SDR SWAA2018080724044Battery Pack · dischargedLT SIDE EMERGENCY LIGHTING FAULTY BETWEEN AT BS 952 TO BS 727C. R&R BATTERY PACK IAW AMM.SDR SWAA2018080724033Light · inoperativeAFT LT EMERGENCY LIGHT INOP BETWEEN ROW 23 AND ROW 24. RELAMPED LIGHT IAW AMM.SDR SWAA2018080724032Battery · failedLT OVERWING EMERGENCY EXIT LIGHT BATTERY FAILED CAPACITY CHECK. R&R BATTERY PER AMM.SDR SWAA2018080724031Battery · failedRT FORWARD EMERGENCY LIGHT BATTERY FAILED CAPACITY CHECK. R&R BATTERY PER AMM.SDR SWAA2018080724030Strip · delaminatedAFT GALLEY AISLE ESCAPE PATH STRIPS DELAMINATED. R&R STRIPS PER DWG.SDR SWAA2018080724026Cover · missingL1 DOOR LOWER "EXIT" SIGN LENS COVER MISSING. INSTALLED COVER PER AMM.SDR AALA2018080769041Battery · no testDURING CIDS1 TEST, EPSU BATTERY 11 WL FAILED. REPLACED THE BATTERY IAW AMM 33-51-38. TESTED OK.SDR ASAA2018080635673Lamp · failedWHILE PERFORMING TC 78233008, FOUND THE RT AFT OVERWING EXTERIOR EMERGENCY LIGHT WAS INOPERATIVE. ACFT GROUNDED. REPLACED THE LAMPS IAW AMM 33-51-04. OPS CHECKED GOOD.SDR ASAA2018080635672Lamp · failedL1 SLIDE EMERGENCY LIGHT WAS INOPERATIVE. ACFT GROUNDED. REPLACED THE LAMPS. OPS CHECKED GOOD IAW AMM 33-51-04.SDR CALA2018080601759Battery Pack · dischargedDURING THE PERFORMANCE OF AN EMERGENCY LIGHT OPS TEST, THE R4 DOOR SLIDE LIGHT DID NOT ILLUMINATE. REPLACED THE M33409 BATTERY PACK AND TESTED NORMAL IAW AMM 33-51-06-960-802, REV 83.SDR CALA2018080601758Battery Pack · dischargedDURING THE PERFORMANCE OF AN EMERGENCY LIGHT TEST, THE L3 DOOR FWD EXIT SIGN DID NOT ILLUMINATE. REPLACED THE M33400 BATTERY PACK AND TESTED NORMAL IAW AMM 33-51-06-960-802, REV 83.SDR CALA2018080601757Battery Pack · dischargedWHILE PERFORMING AN EMERGENCY LIGHT TEST, THE L3 DOOR SLIDE LIGHT AND AFT EXIT IDENTIFIER WERE NOT ILLUMINATED. REPLACED THE M33405 BATTERY PACK AND TESTED NORMAL IAW AMM 33-51-06-960-802, REV 83.SDR CALA2018080601753Battery Pack · inoperativeWHILE PERFORMING AN EMERGENCY LIGHT TEST, R4 DOOR EXIT SIGN WAS NOT ON. REPLACED THE BATTERY PACK M33408 AND TESTED NORMAL IAW AMM 33-51-06-960-802, REV 83.SDR DALA2018080644880Battery Pack · inoperativeOVERWING EMERGENCY EXIT LIGHTS DID NOT ILLUMINATE, LOWER INTERIOR EXIT SIGNS. REMOVED AND REPLACED THE BATTERY PACK IAW AMM 33-55-03. OK FOR SERVICE.SDR UIEA2018070901399Lens · missingMISSING EMERGENCY LIGHT LENS, LEFT AISLE LOWER CEILING BY AFT ENTRY DOOR. INSTALLED EMERGENCY LIGHT LENS AT LEFT AISLE LOWER CEILING BY AFT ENTRY DOOR. OPS CHECK GOOD IAW WDM 33-51-13.SDR UIEA2018070901400Circuit Breaker · not seatedLEFT AISLE EMERGENCY LIGHT INOP BY ROW 21. RE-SEATED CIRCUIT BREAKER, OPS CHECK NORMAL IAW AMM 33-10-00.SDR DALA2018080304836Battery · dischargedFWD EMERGENCY LIGHTS INOP. REMOVED AND INSTALLED NEW BATTERIES IAW AMM 33-53 OP CHECK GOOD P/N AD-4002P.SDR DALA2018081305053Relay · faultedEMERGENCY LIGHTS DO NOT COME ILLUMINATE WITH WHEELS DOWN, SWITCH OK. CHECKED ALL WIRING AT TB871VT. FOUND POWER SUPPLY RELAY 8WL AT FAULT. REMOVED AND REPLACED THE RELAY. OPS CHECKED OK.SDR AALA201808084001Battery · no testDURING A CIDS TEST, THE BATTERY 11WL FAILED. REPLACED THE BATTERY IAW 33-51-38.SDR DALA2018080754898Light · brokenSEAT 33 C SEAT MOUNTED EMERGENCY LIGHT BROKEN OFF, REPLACED LIGHT ASSY AT 33CSDR SWAA2018080724093Light · inoperativeRT EMERGENCY EXIT LIGHTS AFT WING TO BODY PANELS INOP. R&R LIGHT IAW AMM.
Back to JASC 3350