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 SWAA2018021419658Lamp · inoperativeR1 DOOR EXTERNAL EXIT LIGHT INOPERATIVE. REPLACED THE LAMPS IAW AMM.SDR SWAA2018021419657Battery · no testEMERGENCY LIGHT BATTERY FAILED A CAPACITY CHECK AT M01669. R & R THE BATTERY IAW AMM.SDR E07A201802140012Battery Pack · failedEMERGENCY LIGHTS STAYS ON IN ARM POSITION OR FLASHES ON/OFF IN ARM AND ON.SDR E07A201802140011Battery Pack · failedEMERGENCY LIGHTS STAYS ON IN ARM POSITION OR FLASHES ON/OFF IN ARM AND ONSDR AALA20180210001Lens · crackedAFT EXIT SIGN EMERGENCY LIGHT AT THE R3 DOOR, THE LENS WAS FOUND BROKEN. REPLACED THE LENS IAW MM 33-51-10. OPS CHECKED GOOD.SDR R61A201802080149Light · unsecurePART OF EMERGENCY LIGHT STRIP PEELED UP IN FIRST CLASS SECTION.SDR DALA2018020800841Housing · damagedFLOOR EMERGENCY LIGHT INOPERATIVE AT ROW 33AB. REPLACED THE LIGHT HOUSING IAW AMM 330 33-52-01.SDR CALA2018020900495Light · not seatedFLIGHT DECK EMERGENCY LIGHT INOPERATIVE. RESEATED THE LIGHT ASSY, OPS TEST PASSED IAW AMM 33-51-00.SDR REXA2018020800100Charger · inoperativeLT FORWARD OVERWING EMERGENCY LIGHT IS INOP. REMOVED & REPLACED NR 2 BATTERY CHARGER ASSEMBLY IAW AMM 33-51-05. P/N OFF/ON: BA5-0933-901. S/N OFF: C01854 S/N ON: C01059. OPS CHECK GOOD.SDR DALA2018020900797Fuse · failedRT SIDE FIRST CLASS SEATS, EMERGENCY LIGHTS INOPERATIVE. TROUBLESHOT AND FOUND THE FUSE TO BE FAILED. R & R THE FUSE IN THE POWER SUPPLY IAW AMM 33-51-07. OPS CHECKED GOOD, OK FOR SERVICE.SDR DALA2018020800796Lens · detachedEMERGENCY LIGHT LENS DETACHED. THE SECURED THE LENS.SDR DALA2018020900792Battery Pack · inoperativeEXIT SIGN ABOVE THE R2 DOOR INOPERATIVE. FOUND THE BATTERY PACK FAILED, INSTALLED A NEW BATTERY PACK, OPS CHECKED GOOD IAW MM 33-51-02.SDR MASA2018020812961Power Unit · inoperativeR1 DOOR EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED R1 DOOR EMER LIGHT POWER UNIT.SDR DALA2018020800780Lens · missingFOUND EMERGENCY LIGHT LENS AT ROW 33FG MISSING. REPLACED THE LIGHT LENS.SDR YENA201802080063Power Supply · failedFWD LT EPSU UNIT FAULT WHEN PERFORMING EMERGENCY LIGHT TEST. R & R THE EPSU IAW AMM 33-51-38.SDR UIEA2018020600187Light · inoperativeSEAT 28 LEFT OVERHEAD EMERGENCY LIGHT INOPERATIVE. REPLACED THE EMERGENCY LIGHT ASSY IAW MM 33-51-04-402-051.SDR UIEA2018020600186Lamp · inoperativeLEFT EXTERIOR EMERGENCY LIGHT INOPERATIVE, REPLACED THE LAMPS IAW 33-51-16-962-001.SDR SWAA2018031320391Power Supply · inoperativeLEFT EMERGENCY LIGHTS INOPERATIVE BETWEEN ROWS 1 TO 17. R & R THE POWER SUPPLY IAW AMM.SDR SWAA2018021919805Light · inoperativeR1 DOOR SLIDE LIGHT INOPERATIVE. R & R THE LIGHT IAW AMM.SDR IPXA2018020726297Controller · malfunctionedCOCKPIT ONE FLIGHT OF EMERGENCY LIGHTS RECEIVED LEVEL 1 EMERGENCY LIGHT BATTERY 1 LOW. REPLACED MISC SYSTEM CONTROLLER IAW AMM 31-42-01. OPS CHECKED GOOD.SDR AALA201802149026Light · brokenEMERGENCY EXIT LIGHT BROKEN IN THE CABIN ACROSS FROM FRONT THE CLOSET AND RWD ENTRY AREA. REMOVED AND REPLACED THE LIGHT ASSEMBLY IAW WDM 33-51-12. OPS CHECKED GOOD.SDR AALA201802149025Lens · missingLENS MISSING FROM THE RIGHT AFT SERVICE DOOR EMERGENCY LIGHT. INSTALLED THE LENS IAW AMM 33-51-02, OPS CHECKED GOOD.SDR SWAA2018021319700Battery Pack · no testEMERGENCY BATTERY PACK FAILED A CAPACITY CHECK AT M01673. R & R THE BATTERY PACK IAW AMM.SDR SWAA2018021319699Battery Pack · no testEMERGENCY BATTERY PACK FAILED A CAPACITY CHECK AT M01675. R & R THE BATTERY PACK IAW AMM.SDR SWAA2018021319638Battery Pack · no testEMERGENCY BATTERY PACK FAILED A CAPACITY CHECK AT M01670. R & R THE BATTERY PACK IAW AMM.SDR AALA20180209001Light · inoperativeEMERGENCY LIGHT AT SEAT 27C FOUND INOPERATIVE. MAINTENANCE REPAIRED THE EMERGENCY LIGHT IAW SWPM 20-1-13 AND PERFORMED A SATISFACTORY OPERATIONAL CHECK IAW AMM 33-51-00.SDR AALA201802129035Lens · damagedEMERGENCY LIGHT LENS FOR THE R1 DOOR FOUND DAMAGED. MAINTENANCE REPLACED THE LENS. OP CHECKED GOOD.SDR CALA2018020900504Battery Pack · no testDURING AN EMERGENCY LIGHT BATTERY PACK CAPACITY CHECK, FOUND THE L4 DOOR BATTERY PACK INOPERATIVE. THE BATTERY PACK WAS REPLACED. OPS TESTED NORMAL IAW AMM 33-51-06-960-802, REV 81.SDR CALA2018020900503Battery Pack · no testDURING AN EMERGENCY LIGHT BATTERY PACK CPACITY CHECK, FOUND THE R4 DOOR BATTERY PACK INOPERATIVE. THE BATTERY PACK WAS REPLACED. OPS TESTED NORMAL IAW AMM 33-51-06-960-802, REV 81.SDR CALA2018020900502Battery Pack · no testAN EMERGENCY LIGHT BATTERY PACK CAPACITY CHECK, FOUND THE R4 DOOR BATTERY PACK INOPERATIVE. THE BATTERY PACK WAS REPLACED. OPS TESTED NORMAL IAW AMM 33-51-06-960-802, REV 81.SDR CALA2018020900501Battery Pack · no testDURING AN EMERGENCY LIGHT BATTERY PACK CAPACITY CHECK, FOUND THE L2 DOOR BATTERY INOPERATIVE. THE BATTERY PACK WAS REPLACED. OP TESTED NORMAL IAW AMM 33-51-06-960-802, REV 81.SDR CALA2018020900500Battery Pack · no testDURING AN EMERGENCY LIGHT BATTERY PACK CAPACITY CHECK, FOUND L2 DOOR BATTERY PACK INOPERATIVE. THE BATTERY PACK WAS REPLACED. OPS TESTED NORMAL IAW AMM 33-51-06-960-802, REV 81.SDR CALA2018020900499Battery Pack · no testDURING AN EMERGENCY LIGHT BATTERY PACK CAPACITY CHECK, FOUND THE BATTERY INOPERATIVE. THE BATTERY PACK WAS REPLACED. OPS TESTED NORMAL IAW AMM 33-51-06-960-8 02, REV 81.SDR CALA2018020900498Battery Pack · no testDURING AN EMERGENCY LIGHT BATTERY PACK CAPACITY CHECK, FOUND THE BATTERY INOPERATVE. THE BATTERY PACK WAS REPLACED. OPS TESTED NORMAL IAW AMM 33-51-06-960- 802, REV 81.SDR CALA2018020900497Battery Pack · dischargedDURING AN EMERGENCY LIGHT BATTERY PACK CAPACITY CHECK, FOUND THE BATTERY INOPERATIVE. THE BATTERY PACK WAS REPLACED. OPS TESTED NORMAL IAW AMM 33-51-06-960-8, 02, REV.81SDR REXA2018020700099Battery Pack · inoperativeEMERGENCY LIGHTS FOUND INOPERATIVE. REPLACED AND CHARGED THE BATTERY PACKS IAW AMM 33-51-04. OPS CHECKED GOOD IAW AMM 33-51-00.SDR ASAA2018020723456Battery Pack · inoperativeDURING EMERGENCY LIGHT CHECK, FOUND EXTERIOR LEFT OVERWING LIGHT INOPERATIVE. ACFT GROUNDED. FOUND THE BATTERY PACK INOPERATIVE. REMOVED AND REPLACED THE BATTERY PACK IAW AMM 33-51-06. OPS CHECKED GOOD.SDR SIMA20180207005Bulb · inoperativeMAIN DOOR EMERGENCY LIGHT INOPERATIVE. R & R THE BULB AND OPS CHECKED GOOD IAW AMM 33-50-06.SDR YENA201802070062Battery · failedFLT 225, JFK-TPA. EMERGENCY LIGHT BATTERY 12WL FAILED CAP TEST. R & R BATTERY IAW AMM 33-51-01, OPS CKS OK.SDR YENA201802070061Battery · failedFLT 225, JFK-TPA. EMERGENCY LIGHT BATTERY 11WL FAILED CAP TEST. R & R BATTERY IAW AMM 33-51-01, OPS CKS OK.SDR DALA2018020700755Sign · brokenEXIT SIGN IN FIRST CLASS IS BROKEN. RE-SECURED EXIT SIGN PER AMM 33-22.SDR MASA2018020712957Sign · inoperativeROW 4 REAR FACING EMERGENCY EXIT SIGN INOPERATIVE.SDR DALA2018020700730Battery Pack · inoperativeTAILCONE EMERGENCY LIGHTS WERE FOUND TO BE INOPERATIVE. MAINTENANCE REPLACED THE BATTERY IAW AMM 33-51-03. OPS CHECKED GOOD.SDR AALA20180220013Cover · brokenFORWARD CREW REST, RIGHT AISLE EMERGENCY LIGHT PLASTIC COVER IS BROKEN. REMOVED AND REPLACED THE LIGHT ASSEMBLY.SDR FDEA201802060311Battery Pack · inoperativeDURING PREFLIGHT OF THE EMERGENCY LIGHTS, RECEIVED A LEVEL 1 ALERT FOR THE EMERGENCY LIGHT BATTERY 1 LOW. REMOVED AND REPLACED THE EMERGENCY LIGHTING BATTERY POWER SUPPLY IAW MM 33-51-01-4. OPS CHECKED NORMAL IAW MM 33-51-01-5. OK FOR SERVICE.SDR FDEA201802060306Power Supply · inoperativeEMERGENCY LIGHT BATTERY 6 LOW LEVEL 1. REMOVED AND REPLACED THE POWER SUPPLY IAW AMM 33-51-01-4. OPS TESTED GOOD.SDR SWAA2018021319692Lens · brokenR2 DOOR THRESHOLD EMERGENCY EXIT LIGHT LENS BROKEN. R & R THE LIGHT ASSEMBLY IAW AMM.SDR AALA201802129052Battery Pack · dischargedCOCKPIT & FWD GALLEY OVERHEAD EMERGENCY LIGHTS ARE DIM. THE AIRCRAFT WAS GROUNDED. REMOVED & REPLACED THE B5-23 BATTERY PACK ASSY IAW WDM 33-51-11, & 33-51-12. OPS CHECKED GOOD.SDR AALA201802099010Battery · dischargedAFT GALLEY LEFT AND CENTER LEFT FLIGHT ATTENDANT SEAT FLASHLIGHT INOPERATIVE, CENTER. GALLEY LEFT FOWARD. MAINTENANCE REPLACED THE FLASHLIGHT BATTERY AND PERFORMED SATISFACTORY OPS CHECK.SDR AALA201802089027Lens · brokenBROKEN EMERGENCY EXIT SIGN LENS IN THE AFT PASSENGER CABIN. REPLACED THE LENS.
Back to JASC 3350