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 CALA2018062501518Battery · dischargedL3 DOOR EMERGENCY LIGHT BATTERY CAPACITY LOW. THE BATTERY WAS REPLACED AND TESTED NORMAL IAW AMM 33-51-06.SDR AALA201806259008Cover · detachedFLOOR EMERGENCY EXIT LIGHT COVER IN FORWARD GALLEY DETACHED. REPLACED THE LIGHT ASSEMBLY, CHECKED GOOD IAW AMM 33-51-02.SDR SIMA201806254002Light · inoperativeCABIN EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE EMERGENCY LIGHT IAW AMM 33-50-13. OPS TESTED GOOD IAW AMM 33-50-00.SDR ASOA201806247113Inverter · inoperativeAFT FACING GALLEY EXIT LIGHT INOPERATIVE. REMOVED AND REPLACED INVERTER IAW AMM 33-50-11, OPERATIONAL CHECK GOOD.SDR MASA2018062413350Light · inoperativeROW 11 CEILING EMER FLOOD LIGHT INOP. PLACED ON MEL.SDR AALA20180626003Power Supply · failedAIRCRAFT IN BASE MAINTENANCE: EMERGENCY POWER SUPPLY UNIT (M33400) LOCATED ABOVE DOOR 3L FAILED TEST. REPLACED EMERGENCY POWER SUPPLY UNIT ASSEMBLY PER AMM 33-51-06, LOCATED ABOVE DOOR 3L (M33400) AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR REXA2018062300537Battery · dischargedROW 13 FWD FACING, 12 & 13 SIDE, EMERGENCY LIGHTS NOT ILLUMINATING SIGNS. CHARGED EMERGENCY LIGHT BATTERIES AND PERFORMED OPS CHECK OF EMERGENCY LIGHTING SYSTEM IAW AMM 33-51-00. OPS CHECK GOOD AT THIS TIME. AIRCRAFT OK FOR SERVICE.SDR REXA2018062300536Light · inoperativeEMERGENCY EXIT SIGN FLOOR LEVEL HAS MORE THAN 50% OF LIGHTS INOP NEEDS TO BE RELAMPED. RELAMPED EMERGENCY EXIT SIGN LIGHT BULBS IAW AMM 33-51-11. OPS CHECK GOOD.SDR R61A201806230733Light · missingEMERGENCY EXIT PATHWAY PHOTOLUMINESCENT STRIP MISSING AT SEAT 20D. R&R STRIP LIGHT AT SEAT 20D IAW AMM 33-50-21.SDR DALA2018062654222Power Supply · inoperativeL1 DOOR UPPER EXIT EMERGENCY LIGHT WAS INOPERATIVE. REPLACED THE POWER SUPPLY.SDR DALA201806264216Lens · missingEMERGENCY LIGHT LENS AT SEAT ROW 36DEF WAS MISSING. INSTALLED THE LENS . OPS NORMAL. OK FOR SERVICE.SDR HNAA2018062600128Sign · inoperativeEMERGENCY SIGN INOPERATIVE BY SEAT 12A. R & R EMERGENCY SIGN. OPS CHECKED GOOD.SDR SWAA2018062522976Lens · detachedLT OVERWING EMERGENCY EXIT EMERGENCY LOWER LIGHT LENS DETACHED. INSTALLED COVER PER MM.SDR FDEA201806231573Charger · inoperativeRT EMERGENCY EXIT SIGN DID NOT TEST, LAMPS OUT/MISSING. REMOVED AND REPLACED BATTERY PACK/ CHARGER TRAY FOR RT EMERGENCY EXIT SIGN, REF AMM 33-51-07-2. OPS CHECKS GOOD, A/C OK FOR SERVICE.SDR DALA2018062504191Light · missingR1 DOOR SLIDE ARMED LIGHT MISSING. INSTALLED THE SLIDE LIGHT.SDR CALA2018062501521Charger · no testL3 DOOR EMERGENCY LIGHT BATTERY CAPACITY CHECK FAILED. THE CHARGER WAS REPLACED AND TESTED NORMAL IAW AMM 33-51-00.SDR CALA2018062501520Charger · no testR3 DOOR EMERGENCY LIGHT BATTERY CAPACITY CHECK FAILED. THE CHARGER WAS REPLACED AND TESTED NORMAL IAW AMM 33-51-06.SDR CALA2018062501524Charger · no testL1 DOOR EMERGENCY LIGHT BATTERY M33424 CAPACITY CHECK FAILED. THE CHARGER WAS REPLACED AND TESTED NORMAL IAW AMM 33-51-06.SDR CALA2018062501523Battery · dischargedR3 DOOR EMERGENCY LIGHT BATTERY M33401 CAPACITY WAS LOW. THE BATTERY WAS REPLACED AND TESTED NORMAL IAW AMM 33-51-06.SDR CALA2018062501522Battery · dischargedL1 DOOR EMERGENCY LIGHT BATTERY M33424 CAPACITY FOUND LOW. THE BATTERY WAS REPLACED AND TESTED NORMAL IAW AMM 33-51-06.SDR DALA2018062504175Power Supply · inoperativeEMERGENCY EXIT LIGHTS WERE INOPERATIVE AT ROW 19AB UPPER AND LOWER EXIT, SIGN, AND 19CDE LOWER EXIT SIGN. MAINTENANCE FOUND BOTH LOWER LIGHT ASSEMBLIES AT 40 OHMS AND REPLACED THE RIGHT SIDE. INSTALLED POWER SUPPLY IAW SSM 33-51. OPS CHECKED GOOD. THE AIRCRSDR AALA20180625001Control Unit · inoperativeEMERGENCY LIGHTS AT SEATS 3D-H THRU 5D-H WERE INOPERATIVE. REPLACED THE CONTROL UNIT IAW AMM 33-51-07.SDR MASA2018062313349Battery Pack · dischargedCABIN EMERGENCY LIGHTS INOP.SDR R61A201807090761Light · crackedWHILE AIRCRAFT WAS OUT OF SERVICE FOR HEAVY CHECK, R2 FWD LOWER EMERGENCY EXIT LIGHT WAS FOUND DAMAGED (CRACKED). LIGHT ASSY WAS REMOVED AND REPLACED IAW AMM 33-50-15. AIRCRAFT REMAINS OUT OF SERVICE FOR HEAVY CHECK COMPLETION.SDR UIEA2018062601263Battery · dischargedFOUND EMER SLIDE LIGHT AT M/D L1 DOOR INOP. IAW AMM 33-51-06-000-801 AND 33-31-06-400-801 REV 92 REPLACED LIGHT BATTERY. IAW AMM 33-51-00-T151-105 REV 92 REV 92 PERFORMED EMERGENCY LIGHTS OPERATIONAL TEST AND THE RESULT WAS SATISFACTORY.SDR UIEA2018062601264Battery · dischargedFOUND M/D EMERGENCY LIGHT INOP. IAW AMM 33-51-07--902-001-001 REV 92 REPLACED 3 EMERGENCY LIGHT POWER SUPPLY BATTERIES AND CONDITION CHECK NORMAL. IAW AMM 33-51-04-902-001-001 REV 92 STEP E PERFORMED POWER SUPPLY TEST AND THE RESULT WAS SATISFACTORY.SDR R61A201806220732Battery · discharged2 OVERHEAD EMERGENCY LIGHTS OUT IN CABIN. R&R EMERGENCY BATTERY FWD LT SIDE IAW AMM 33-50-01.SDR DALA2018062604212Light · unsecureLIGHT ASSEMBLY ON FLOOR UNDER SEAT 20D LOOSE. SECURED THE LIGHT. OK FOR SERVICE.SDR SWAA2018062523024Lens · brokenRT AFT DOOR EXIT SIGN BROKEN. R&R LENS PER MM.SDR SWAA2018062522984Lens · missingR1 DOOR LOWER EMERGENCY LIGHT LENS MISSING DIRECTIONAL ARROW. INSTALLED LENS PER MM.SDR SWAA2018062522983Lens · missingL1 DOOR LOWER EMERGENCY LIGHT LENS MISSING DIRECTIONAL ARROW. INSTALLED LENS PER AMM.SDR ASAA201806255170Battery Pack · inoperativeOVERWING EXIT DOORS LT & RT EMERGENCY EXIT LIGHTS WILL NOT STAY ON FOR 15 MINUTES. ACFT GROUNDED. R & R THE BATTERY PACK. OPS CHECKED GOOD.SDR IPXA2018062523960Pin · stuckFOUND BROKEN PIN STUCK INSIDE THE EXIT SIGN. REMOVED AND REPLACED THE EXIT SIGN IAW AMM 33-51-13-0401.SDR DALA2018062504181Lens · missingTHE LENS FOR THE EMERGENCY EXIT FLOOD LIGHT AT THE L1 DOOR WAS MISSING. MAINTENANCE REPAIRED THE LIGHT IAW ERA 569644-14.SDR SIMA20180622006Light · inoperativeLEFT FWD 1A AND 2A EMERGENCY LIGHT STRIP WAS INOPERATIVE. R & R THE EMERGENCY LIGHT IAW SRM 33-50-21.OPS CHECKED GOOD.SDR MASA2018062213346Battery Pack · dischargedOVHD EMER LIGHT AT ROW 18 INOP. REPLACED BATTERY PACK 5.SDR MASA2018062213345Battery Pack · dischargedOVHD EMER LIGHT AT ROW 20 INOP. REPLACED BATTERY PACK 5.SDR MASA2018062213344Battery Pack · dischargedAFT FLT ATTEND SEAT OVHD EMER LIGHT INOP. REPLACED BATTERY PACK 5.SDR SIMA20180622001Light · inoperativeMAIN PAX DOOR EMERGENCY LIGHT DOES NOT COME ON. REMOVED AND REPLACED THE EMERGENCY LIGHT ASSY. OP TESTED OK. IAW AMM 33-30-02 AND AMM 33-50-10.SDR REXA2018062200528Lamp · inoperativeTHE EXTERIOR EMERGENCY LIGHT, BY THE PAX DOOR WAS INOPERATIVE. REPLACED THE LAMPS IAW AMM 33-51-15. OPS CHECKED GOOD.SDR IPXA2018062230912Terminal · unsecureEMERG EXIT LIGHT INOP WITH SWITCH IN AUTO POSITION. FOUND POOR CONTROL CIRCUIT GROUND. VERIFIED WIRING SECURITY AT RELAY 69WL REF AWM 33-51-12. SECURED TERMINALS REF: ESPM 20-46-50-0101. OPERATIONAL CHECK GOOD.SDR AALA201806269024Power Supply · inoperativeAIRCRAFT WAS NOT GROUNDED. PER CARD 2908 EMERGENCY LIGHTS SIGN (OVER WING HATCH SIGN) ROW 13, 14 AND 15 RIGHT HAND SIDE FAILED TO STAY ON DURING TEST OF BATTERY PACK CAPACITY CHECK. REPLACED POWER SUPPLY (M1695) PER AMM 33-51-06, OPERATIONS CHECK NORMAL.SDR DALA201806264213Lens · brokenEXIT LIGHT COVER AT THE BOTTOM OF L1 DOOR WAS MISSING. FOUND LENS AND THE BASE TABS WERE BROKEN. REPLACED THE LENS AND BASE ASSY IAW AMM 33-52. OPS CHECKED NORMALSDR SWAA2018062523055Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1674. R&R BATTERY PER AMM.SDR SWAA2018062523054Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1675. R&R BATTERY PER AMM.SDR SWAA2018062523053Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1672. R&R BATTERY PER AMM.SDR SWAA2018062523052Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1670. R&R BATTERY PER AMM.SDR SWAA2018062523051Battery · failedBATTERY FAILED CAPACITY TEST AT LOCATION M1672. R&R BATTERY PER MM AND DWG.SDR SWAA2018062523033Battery · failedBATTERY FAILED CAPACITY TEST AT LOCATION M1673. R&R BATTERY PER MM AND DWG.SDR SWAA2018062522985Light · inoperativeRT OVERWING EXIT LIGHT INOP AFT OF DOOR. RELAMPED LIGHT PER AMM.
Back to JASC 3350