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 YENA201806180251Battery Pack · failedCABIN EMERGENCY LIGHTS FAILED A BITE TEST. REMOVED AND REPLACED THE POWER SUPPLY BATTERIES AT 10WL, 11WL, AND 13WL, IAW AMM 33-51-38. EMERGENCY LIGHTS CHECKED GOOD.SDR YENA201806180250Battery Pack · no testCABIN EMERGENCY LIGHTS FAILED A BITE TEST. REMOVED AND REPLACED THE POWER SUPPLY BATTERIES AT LOCATION FIN 10WL,11WL AND 13WL IAW AMM 33-51-38. EMERGENCY CABIN LIGHTS CHECKED GOOD.SDR MASA2018061813329Light · inoperativeROW 11 OVERHEAD EMERGENCY FLOOD LIGHT WAS INOPERATIVE.SDR SWAA2018062523057Light · inoperativeFORWARD HORSE SHOE PANEL EMERGENCY EXIT LIGHT INOP. REPAIRED LIGHT IAW AMM.SDR SWAA2018062523056Light · inoperativeLT BULLNOSE BIN EMERGENCY EXIT LIGHT INOP BETWEEN ROW 6 TO ROW 12. REPAIRED LIGHT IAW AMM.SDR SWAA2018062523009Light · inoperativeRT LOWER EXTERIOR EXIT SLIDE LIGHT INOP. REPAIRED LIGHT IAW AMM.SDR AALA2018062109019Housing · crackedAFT LEFT DOOR EMERGENCY LIGHT BASE CRACKED. MAINTENANCE REPLACED THE EMERGENCY LIGHT IAW AMM 33-51-13 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA2018062109017Light · inoperativeEMERGENCY LIGHT AT THE L1 DOOR, FLOOR LEVEL WAS INOPERATIVE. MAINTENANCE THE EMERGENCY LIGHT. PERFORMED A SATISFACTORY OPERATIONAL CHECK IAW AMM 33-50-00.SDR DALA2018062104123Light · detachedFLOOR EMERGENCY LIGHT AT SEAT 18C WAS HANGING LOOSE. SECURED THE LIGHT.SDR REXA2018062017519Light · missingFLOOR EMERGENCY LIGHTING MISSING IN FRONT OF GALLEY, NEAR THE LAVATORY SIDE. REPLACED THE EMERGENCY LIGHTING IAW AMM 33-51-01.SDR ASAA2018061975110Battery · no testEMERGENCY BATTERY AT THE R2 DOOR FAILED A CHECK. ACFT GROUNDED. REMOVED AND REPLACED BATTERY AND POWER SUPPLY IAW AMM 33-51-06-960-805, AND 33-51-06-960-806, OPS CHECKED GOOD IAW AMM 33-51-06-960-805, STEP 5E.4 A-C.SDR SWAA2018061922893Sign · brokenFORWARD GALLEY EMERGENCY EXIT LIGHT HOUSING BROKEN. R&R SIGN ASSEMBLY PER MM.SDR AALA201806189009Pin · backed outTHE AIRCRAFT WAS GROUNDED. SEAT MOUNTED EMERGENCY PATH LIGHT AT ROW 31 ABC AND 32 ABC ARE INOPERATIVE. CHECKED AND REPAIRED PUSH BACK PIN UNDER THE SEAT OF 31 ABC PER AMM 33-51-00. BOTH SEAT MOUNTED PATH LIGHT AT 31 ABC AND 32 ABC GND TEST NORMAL.SDR AALA201806189007Sign · looseTHE AIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN (OVERHEAD) SCREWS (MOUNTING) ARE LOOSE. SECURED LIGHT AS REQUIRED. OK FOR SERVICE.SDR SWAA2018061822862Cover · unsecureLT FORWARD OVERWING EXIT LIGHT COVER FELL OFF. R&R LIGHT ASSEMBLY PER SIP.SDR DALA2018061804059Light · defectiveALL 4 OVER WING EMERGENCY EXIT DOOR LIGHT DIM OR INOPERATIVE. RELAMPED. OPERATION CHECKS OK.SDR REXA2018061870493Light · burned outLOWER MAIN CABIN ENTRY EMERGENCY FLOOD LIGHT WAS BURNED OUT. REMOVED & REPLACED THE FLOOD LIGHT IAW AMM 33-51-19-000. OPS CHECKED GOOD.SDR DALA2018061804045Battery Pack · inoperativeTHE EXTERIOR OVERWING EMERGENCY LIGHTS WERE FOUND INOPERATIVE. MAINTENANCE REPLACED THE OVERWING EMERGENCY LIGHTS BATTERY PACK AND CHARGER IAW AMM 33-51-06. OPS CHECKED GOOD.SDR 29GA2018061870001Power Supply · inoperativeEMERGENCY LIGHTS INOPERATIVE. CIRCUIT BREAKER TRIPPED. R & R THE POWER SUPPLIES IAW AMM 33-50-10-04-1. OPS CHECKED GOOD.SDR DALA2018061804042Light · inoperativeEMERGENCY LIGHT AT PASSENGER SEAT 19D IS INOP. R&R EMERGENCY LIGHT ASSY REF AMM 33-50. OPS CHECKS GOOD.SDR DALA2018081430569Lens · crackedTWO ISLE MOUNTED EMERGENCY LIGHTS HAD CRACKED LENS. R & R THE EMERGENCY LIGHTS AT FWD GALLEY ENTRANCE IAW AMM 33-51. OPS CHECKED GOOD. OK FOR SERVICE.SDR ASAA2018061625228Battery Pack · shortEMERGENCY LIGHT BATTERY PACK M1673 REQUIRES REPLACEMENT. GROUNDED - YES. REMOVED AND REPLACED EMERGENCY LIGHT BATTERY PACK M1673 AND OPS CHECK "GOOD" IAW AMM 33-51-06, SSM 33-51-14 AND 33-51-21.SDR ASAA2018061625212Battery Pack · defectiveEMERGENCY BATTERY PACK WIL NOT HOLD CHARGE. GROUNDED - YES. REMOVED AND REPLACED BATTERY PACK S/N 11205 PER TASK CARD 78233000SDR DALA2018061804087Light · brokenDURING INSPECTION FOUND EMERG ISLE LIGHT AT CLOSET BACKING BROKEN. MAINTENANCE REPLACED LIGHT ASSY OPS CHECK GOOD AMM 33-51.SDR DALA2018062084071Lens · damagedRED EMERGENCY LIGHT LENS DAMAGED NEAR THE AFT RIGHT LAV. REPLACED THE LIGHT ASSY. OPS CHECKED GOOD.SDR AALA201806199025Power Supply · no testSEAT ROW 24L POWER SUPPLY INOPERATIVE. MAINTENANCE REPLACED THE POWER SUPPLY IAW CMM 25-22-52, AND PERFORMED SATISFACTORY OPS CHECK.SDR SWAA2018061822853Light · inoperativeR1 DOOR EXTERIOR EMERGENCY LIGHT INOP. RELAMPED LIGHT PER AMM.SDR SWAA2018061822806Sign · unsecureEMERGENCY EXIT SIGN FELL OFF. INSTALLED EXIT SIGN IAW SIP.SDR AALA2018061989014Cover · brokenTHE R2 DOOR EMERGENCY EXIT SIGN COVER WAS BROKEN. REPLACED THE SIGN COVER. OK FOR SERVICE IAW AMM 33-51-11.SDR JJBA20180616008Light · unsecureFLOOR EMERGENCY LIGHT PATH STRIP NOT SECURE AT ROW 2. RE SECURED FLOOR LIGHT STRIP.SDR AALA201806189042Battery · dischargedAIRCRAFT WAS NOT GROUNDED. LOWER TAILCONE HANDLE EMERGENCY LIGHT INOPERATIVE. REPLACED TAILCONE HANDLE EMERGENCY LIGHT BATTERY (B5-28) PER AMM 33-53-00. OPERATIONS CHECKS GOOD.SDR AALA201806189043Battery · dischargedAIRCRAFT WAS NOT GROUNDED. BOTH TAIL COMPARTMENT OVERHEAD EMERGENCY LIGHTS INOPERATIVE. REPLACED EMERGENCY BATTERY (B5-27) PER AMM 33-51-00. OPERATIONS CHECKS GOOD.SDR ASAA2018061865099Bulb · inoperativeR1 DOOR EXTERIOR EMERGENCY EXIT LIGHT WAS INOPERATIVE. ACFT GROUNDED. REPLACED THE LAMP IAW AMM 33-51-04-960-801, OPS CHECKED GOOD.SDR SWAA2018072323658Battery Pack · dischargedBOTH LOWER FUSELAGE EMERGENCY LIGHTS INOP. R&R BATTERY PACK IAW AMM.SDR REXA2018061500566Light · wornNUMEROUS EMER PATH LIGHTING STRIPS IN CABIN ARE WORN. REMOVED AND REPLACED EMER PATH LIGHTING STRIPS AT CABIN IAW AMM 33-51-01-400-801.SDR ASOA2018062541033Battery Pack · dischargedDURING MAINTENANCE INSPECTION, AN EMERGENCY LIGHT WAS FOUND TO BE INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE NUMBER 3 EMERGENCY LIGHT BATTERY PACK, OPERATIONALLY TESTED WITH NO DEFECTS NOTED AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR CALA2018062101479Battery · dischargedDR L2 OVERDOOR EMER LT POWER SUPPLY M33099 BATTERY PACK LOW CAPACITY. DR L2 OVERDOOR EMER LIGHT POWER SUPPLY BATTERY M33099 REPLACED AND TESTED NORMAL AS PER AMM 33-51-06.SDR CALA2018062101478Battery Pack · dischargedOHAR AREA EMER LT FOUND DIM. OHAR AREA EMER LIGHT POWER SUPPLY BATTERY PACK REPLACED AND TESTED NORMAL AS PER AMM 33-51-06.SDR CALA2018062101477Battery · dischargedDR L3 OVERDOOR EMER LT POWER SUPPLY M33400 BATTERY PACK LOW CAPACITY. DR L3 OVERDOOR EMER LIGHT POWER SUPPLY BATTERY M33400 REPLACED AND TESTED NORMAL AS PER AMM 33-51-06.SDR DALA2018061504031Light · inoperativeDURING INSPECTION FOUND FED SEAT MOUNTED ESCAPE PATH LIGHT INOPERATIVE. MAINTENANCE DEFERRED PER MEL 33-00-19A. PLACARD INSTALLED. INSTALLED SEAT 15FED SEAT MOUNTED ESCAPE PATH LIGHT PER AMM 33-51. OPS CHK GOOD.SDR ASOA2018062045155Bulb · inoperativePILOT REPORTED THE BACK OF EXIT SIGN WAS NOT ILLUMINATING ON THE INDICATOR PANEL. MX REMOVED AND REPLACED THE EXIT SIGN BULB AND OPS CHECKED GOOD. ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR ASAA2018061955100Power Supply · inoperativeEXTERIOR EMERGENCY LIGHT WAS INOPERATIVE, LEFT AFT OVERWING EXIT. ACFT GROUNDED. REMOVED AND REPLACED THE EMERGENCY LIGHT POWER SUPPLY M1670 AND OPS CHECK GOOD IAW AMM 33-51-06.SDR REXA2018061500518Light · missingFA`S REPORT, LUMINESANT STRIP IN FRONT OF GALLEY CARTS MISSING. REPLACED ILLUM STRIP IN GALLEY PER AMM 33-51-01, CHECKS SECURE PN PL88-930-LH07, PL88-900-LH00 STRIP.SDR SWAA2018061822807Cover · looseAISLE OVERHEAD EMERGENCY EXIT COVER LOOSE. SECURED COVER PER MM.SDR AALA2018061989016Power Supply · no testEMERGENCY LIGHT POWER SUPPLY AT 11WL FAILED A CIDS TEST. REPLACED THE POWER SUPPLY IAW AMM 33-51-38.SDR ASAA2018061855098Bulb · inoperativeFWD LEFT OVERWING EXIT SIGN HAD TWO BULBS INOPERATIVE. AFT LEFT HAD ONE. ACFT GROUNDED. REPLACED THE LAMPS. OPS GOOD IAW AMM 33-51-01.SDR ASAA2018061855076Power Supply · failedEXTERIOR EMERGENCY EXIT LIGHT WAS INOPERATIVE, AFT OF LEFT AFT OVERWING EXIT. ACFT GROUNDED. REMOVED AND REPLACED POWER SUPPLY M1670, OPS CHECKED GOOD IAW AMM 33-15-06.SDR C77A2018061800002Power Supply · failedEMERGENCY LIGHTS AT THE L1, R1, AND L2 DOORS WERE INOPERATIVE. REMOVED AND REPLACED THE FUSES AT L1 & L2 AT ELPUS IAW SMPE17X-33-002. REMOVED AND REPLACED R1 ELPU IAW AMM 33-50-01. OK FOR SERVICE.SDR YENA2018061850257Lens · missingEMERGENCY LIGHT LENS MISSING. INSTALLED THE LENS IAW AMM 25-65-00.SDR RAIA2018061850001Bulb · inoperativePAX DOOR EMERGENCY EXIT LIGHT WAS INOPERATIVE. REMOVED AND REPLACED THE BULB IAW AMM 33-50-10. OPS CHECKED GOOD.
Back to JASC 3350