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 UIEA2016092700779Light · inoperativeAFT LIGHT CREW REST LIGHT ASSY INOPERATIVE. REPLACED AFT CREW REST LIGHT ASSY.SDR SWAA2016092308075Battery · failedAFT RT BATTERY PACK FAILED CAPACITY CHECK. R & R BATTERY IAW MM.SDR SWAA2016092308073Battery · failedAFT LT BATTERY PACK FAILED CAPACITY CHECK. R & R BATTERY IAW MM.SDR SWAA2016092308072Battery · failedFORWARD LT BATTERY PACK FAILED CAPACITY CHECK. R & R BATTERY IAW MM.SDR SWAA2016092308065Guard · inoperativeOVERHEAD EMERGENCY EXIT LIGHT SWITCH GUARD INOPERATIVE. R & R GUARD IAW SIP AND AMM.SDR SWAA2016092308061Cover · missingR2 DOOR EXIT LIGHT COVER MISSING. INSTALLED LIGHT ASSEMBLY IAW AMM.SDR SWAA2016092308057Sign · defectiveL1 DOOR EXIT SIGN ARROW MISSING. R & R SIGN ASSEMBLY IAW AMM.SDR U2RA201609220001Switch · dirtyL1 DOOR EXIT LIGHT INOPERATIVE. TROUBLESHOT SYSTEM IAW WIRING DIAGRAIM MANUAL 33-51-12. CLEANED AND SECURED EMERGENCY LIGHT SWITCH, ON P-5 PANEL. SYSTEM OPS CHECKED SATISFACTORY IAW AMM 33-51-00.SDR AALA201609239003Lens · missingEMERGENCY LIGHT LENS AT SEAT ROW 1 MISSING. INSTALLED LENS AND ACCOMPLISHED A SATISFACTORY OPS CHECK.SDR DALA2016092306804Battery Pack · inoperativeDURING SERVICE CHECK, FOUND TWO EXIT SIGNS AND ONE EMERGENCY LIGHT AT THE L4 DOOR WILL NOT STAY ON MORE THAN FEW SECONDS WHEN TEST SWITCH OR EMERGENCY LIGHT SWITCH IS TURNED ON (DOOR 4L). REPLACED THE BATTERY PACK. PERFORMED OPER TEST ANDNORMAL.SDR REXA2016092201806Light · detachedEMERGENCY LIGHT STRIP DETATCHED. SECURED THE STRIP AT SEAT 1A.SDR MASA2016092212409Bulb · inoperativeBULB INOPERATIVE AT 14F FLOOR LEVEL EMERGENCY SIGN. REPLACED THE BULBS, OPS CHECKED OK.SDR DALA2016092206775Fuse · defectiveCABIN EMERGENCY LIGHT AT SEAT 24 TO 30 INOPERATIVE. TROUBLESHOT IAW WDM 33-51 AND FOUND BAD FUSES. R & R FUSES IAW AMM 33-50. OPS CK GOOD.SDR YENA20160922826Power Supply · inoperativeEMERGENCY CEILING LIGHTED SIGN 52WL INOPERATIVE. R & R EPSU AND BATTERY, 13WL, IAW AMM 33-51-38. OPS CHECKS GOOD.SDR YENA20160922825Battery · dischargedEMERGENCY CEILING LIGHTED SIGN 52WL INOPERATIVE; R & R EPSU AND BATTERY, 13WL IAW AMM 33-51-38. OPS CHECKS GOOD.SDR SWAA2016092608174Lens · dirtyR2 DOOR AFT EMERGENCY LIGHT LENS DIRTY. CLEANED LENS IAW AMM.SDR SWAA2016092608173Lens · dirtyRIGHT WING TO BODY FAIRING AFT EMERGENCY LIGHT LENS DIRTY. CLEANED LENS IAW AMM.SDR SWAA2016092608172Lens · dirtyLEFT WING TO BODY FAIRING AFT EMERGENCY LIGHT LENS DIRTY. CLEANED LENS IAW AMM.SDR DALA2016092606847Battery Pack · inoperativeOVERWING EMERGENCY LIGHTS DO NOT TURN OFF WITH OVERHEAD PANEL SWITCH IN THE "OFF" POSITION. REMOVED AND REPLACED BATTERY PACK IAW MM. OPERATION CHECKS GOOD.SDR CALA2016092200673Lamp · inoperativeSLIDE RAFT LIGHT ON DOOR 1R INOP REPLACE THE LAMP, OPS NORMAL.SDR CALA2016092200671Light · malfunctionedEMERGENCY LIGHTS BY 22L KEEPS FLASHING ON & OFF. TEST PERFORMED IAW AMM 33-51-07. FOUND NORMAL OPSSDR AALA201609229005Light · looseFORWARD ENTRY BULKHEAD EMERGENCY LIGHT IS LOOSE. REINSTALLED LIGHT FIXTURE INTO WALL SOCKET PER AMM 33-51-18.SDR AALA201609229002Lens · missingSEAT 1L EMERGENCY LIGHT COVER MISSING. REPLACED LIGHT ASSEMBLY PER AMM 33-51-19.SDR AALA20160922003Battery Pack · inoperativeEMERGENCY BATTERY (11WL) FAULTED DURING CIDS TEST, REMOVED AND REPLACED EMERGENCY BATTERY AT 11WL IAW MM 33-51-00SDR AALA20160922002Battery Pack · inoperativeEMERGENCY LIGHT BETWEEN ROWS 9 AND 15 ARE INOPERATIVE. REMOVED AND REPLACED BATTERY PACK IAW AMM 33-51-07. OPERATIONAL CHECK GOOD.SDR SWAA2016092208050Battery · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATIONS M1675. R & R THE BATTERY IAW AMM.SDR SWAA2016092208049Battery · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATIONS M1674. R & R THE BATTERY IAW AMM.SDR SWAA2016092208047Battery Pack · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATIONS M1673. R & R THE BATTERY IAW AMM.SDR SWAA2016092208046Battery Pack · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATIONS M1672. R & R THE BATTERY PACK IAW AMM.SDR SWAA2016092208045Battery Pack · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATIONS M1670. R & R BATTERY PACK IAW AMM.SDR SWAA2016092208044Battery Pack · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATIONS M1669. R & R THE BATTERY PACK IAW AMM.SDR SWAA2016092208024Spring · brokenAFT STATION EMERGENCY EXIT LIGHT SWITCH GUARD SPRING BROKEN. R &R THE SWITCH GUARD BUTTON IAW AMM.SDR SWAA2016092208023Battery Pack · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATIONS M1668. R & R BATTERY PACK IAW AMM.SDR R61A201609210553Unknown · malfunctionedCREW REPORTED THAT THE EMERGENCY LIGHTS WOULD NOT TURN OFF. MAINTENANCE RESET ACFT POWER IAW AMM AND OPS CHECKED GOOD.SDR DALA2016092106772Battery Pack · dischargedOVERWING EMERGENCY LIGHT INOPERATIVE. R & R B5-49 BATTERY PACK REF AMM 33-53. OPS CK GOOD.SDR KCSA201609211071Lamp · burned outEMERGENCY L1 CEILING LAMP OUT.SDR HNAA2016092100289Battery Pack · inoperativeTW0 MOST FORWARD FLOOR EMERGENCY LIGHTS ARE INOPERATIVE. REMOVED AND REPLACED EMERGENCY LIGHT BATTERY AT ROW 3, RIGHT HAND CEILING LOCATION. OPS CHECKED GOOD.SDR ASOA20160920072HBattery Pack · dischargedDURING MAINTENANCE INSPECTION, THE AISLE PATH LIGHTING AT 18A TO 24A WAS FOUND TO BE INOPERATIVE. MAINTENANCE R & R THE NR 4 EMERGENCY LIGHT BATTERY PACK, OPERATIONALLY TESTED WITH NO DEFECTS NOTED. THE ACFT WAS APPROVED FOR RETURN TO SERVICE ON 09/21/16.SDR AALA201609219014Lens · missingROW 22 SEAT D EMERGENCY LIGHT COVER MISSING. REPLACED EMERGENCY LIGHT COVER, ACCOMPLISHED SATISFACTORY OPS CHECK.SDR DALA2016092106801Power Supply · inoperativePAX SEATS 41-45 ISLE EMERGENCY LIGHT INOPERATIVE. R & R THE POWER SUPPLY IAW AMM 33-51-07-022-023-002, & 33-51-07-862-029-002, OPS CHECKED GOOD.SDR IPXA2016092108525Battery Pack · dischargedLEVEL 1 EMERGENCY LIGHT BATTERY LOW, REPAIRED IAW 33-51-01 OPS OK.SDR AALA201609219016Lens · missingEMERGENCY EXIT LIGHT LENS COVER 4L MISSING. INSTALLED LENS COVER AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK.SDR SPAA201609020001Light · inoperativeOVERWING EXIT LIGHTS FAILED TO ILLUMINATE.SDR SPAA2016092200001Power Supply · inoperativeOVERWING EXIT LIGHT FAILED TO ILLUMINATE. REPLACED POWER SUPPLY PER AMM 33-51-11SDR AALA20160921010Wire · chafedEMERGENCY EXIT LIGHTS IN THE AFT RIGHT CABIN IS INOPERATIVE DURING TEST. MAINTENANCE FOUND CHAFED WIRES IN THE AFT RIGHT LAVATORY. REMOVED AND REPLACED WIRES IAW WDM 33-51-22. OPERATIONAL CHECK NORMAL IAW MCM CARD 2866.SDR SWAA2016092208028Battery Pack · inoperativeEMERGENCY LIGHT BATTERY PACK INOPERATIVE AT LOCATION M1674, BS 322. R & R THE BATTERY PACK IAW AMM.SDR SWAA2016092108021Battery Pack · failedEMERGENCY LIGHTING BATTERY PACK FAILED CAPACITY TEST AT M01675. R & R BATTERY PACK IAW DWG.SDR SWAA2016092108020Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1672. R & R BATTERY IAW DWG AND AMM.SDR SWAA2016092108002Light · inoperativeR2 DOOR EXTERIOR EMERGENCY LIGHT INOPERATIVE. REPAIRED LIGHT IAW MM.SDR AALA20160920007Power Supply · inoperativeEMERGENCY POWER SUPPLY M1672 IS INOPERATIVE. REMOVED AND REPLACED POWER SUPPLY AND PERFORMED OPERATIONAL CHECK IAW AMM 33-51-06. SYSTEM CHECKED NORMAL.
Back to JASC 3350