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 DALA2017050503670Fuse · inoperativeL1 AND R1 DOOR EMERGENCY EXIT ARROW LIGHTS INOPERATIVE. REMOVED AND REPLACED FUSES. OPERATION CHECKED GOOD.SDR CNMA2017050001Charger · inoperativeDURING MILITARY INSPECTION, R2 DOOR EMERGENCY LIGHTS INOPERATIVE. REPLACED THE CHARGER IAW AMM 33-51 AT M734. SYSTEM CHECKED NORMAL.SDR AALA201705069004Light · crackedCRACKED LOWER EMERGENCY LIGHT AT THE R4 DOOR. REPLACED EMERGENCY LIGHT IAW AMM 33-51-13.SDR AALA201705059047Battery Pack · dischargedAEMERGENCY LIGHT BATTERY PACK DISCHARGED. REPLACED THE BATTERY PACK IAW AMM 33-57-06.SDR DALA2017050803649Battery Pack · inoperativeEMERGENCY LIGHTS INOPERATIVE IN ZONE 2. REPLACED THE BATTERY AND POWER SUPPLY IAW AMM 33-51. EMERGENCY LIGHTS TESTED NORMAL.SDR R61A201705040340Light · detachedFWD BULKHEAD, RT EMERGENCY LIGHT DETACHED. SECURED THE LIGHT STRIP IAW AMM 33-50-21.SDR HNAA2017050400149Light · inoperativeROW 3AC CEILING LIGHT AND AFT EMERGENCY EGRESS LIGHT INOPERATIVE. R & R THE LIGHTS ASSYSDR ASAA2017050420640Light · inoperativeEMERGENCY LIGHTS AREA LIGHT AT SEAT ROW 10DEF IS INOP. GROUNDED - YES. RELAMPED AREA LIGHT PER AMM 33-51-03-960-801 OPS CHECKED GOOD.SDR CALA2017050501246Fuse · blownDURING A CHK EMERGENCY LIGHT OPS CHK, FOUND WING RT SLIDE GND ILLUMINATING LIGHT L644 INOP. REF WIRING MANUAL 33-51-21. T/SHOT WIRING LIGHT FIXTURE, NO VOLTAGE. FOUND LIGHT L644 AND L392 BOTH INOP, FOUND NR 2 FUSE ON BATTERY PACK M733 OPEN. REPLACED FUSE, BOTHSDR AALA201705059053Control Module · faultyAIRCRAFT WAS IN BASE MAINTENANCE. FIRST CLASS EMERGENCY PATH LIGHT INOPERATIVE. REMOVED AND REPLACED EMERGENCY BATTERY (AALA20170505002) AND CONTROL MODULE IAW AMM 33-51-07. ACCOMPLISHED OPERATIONAL CHECK IAW AMM 33-51-00. SYSTEM CHECKS NORMAL.SDR AALA201705059045Cover · unsecureAIRCRAFT WAS NOT GROUNDED. EXIT DOOR LIGHT COVER FOR 4R FELL OFF. MAINTENANCE REPLACED EXIT LIGHT SIGN PER 33-50-00.SDR AALA20170504004Battery Pack · dischargedAIRCRAFT WAS NOT GROUNDED. FORWARD BATTERY PACK ABOVE 3R DOOR DOES NOT DO TEST. REMOVED AND REPLACED BATTERY PACK AND ACCOMPLISHED OPERATIONAL CHECK IAW AMM 33-51-06. SYSYTEM CHECKS NORMALSDR AALA201705059021Lens · missingAFT GALLEY FLOOR LEVEL EMERGENCY SIGN LENS MISSING. INSTALLED THE LENS.SDR JJBA20170504004Light · inoperativeOVHD EMERGENCY LIGHT INOP. R&R BULB OPS CHECK SAT.SDR SWAA2017051013600Sign · brokenRT OVERWING EMERGENCY DOOR SIGN BROKEN. R&R SIGN ASSEMBLY PER MM.SDR SWAA2017050813617Lens · looseRT OVERWING EMERGENCY EXIT LIGHT LENS LOOSE. SECURED LENS PER AMM.SDR SWAA2017050813614Battery Pack · dischargedLT MID CABIN OVERHEAD CEILING EMERGENCY LIGHT INOP. R&R BATTERY PACK IAW AMM.SDR SWAA2017050813613Light · brokenMID CABIN CENTER EXIT SIGN LIGHT BROKEN. REPAIRED LIGHT IAW AMM.SDR SWAA2017050813611Cover · unsecureOVERHEAD FORWARD GALLEY DOOR EMERGENCY EXIT LIGHT FELL OFF. SECURED COVER PER SIP.SDR SWAA2017050813592Cover · unsecureFORWARD LOWER ENTRY EXIT SIGN LENS COVER FELL OFF. R&R COVER IAW MM.SDR SWAA2017050813591Sign · missingL1 DOOR EXIT LIGHT LENS COVER RED ARROW MISSING. R&R SIGN PER AMM.SDR SWAA2017050813586Lens · brokenAFT GALLEY EXIT SIGN LENS BROKEN. R & R SIGN IAW MM.SDR QXEA2017050800344Light · looseEMERGENCY LIGHT STRIP IN FRONT OF FORWARD CARGO DOOR PEELING OFF. SECURED, NO FURTHER DEFECTS NOTED.SDR ASAA2017050320639Lens · unsecureFA REPORTS PLASTIC EXIT / SALIDA COVER, ROW 16 ABC HAS FALLEN OFF. GROUNDED - YES. REPLACED BROKEN LIGHT ASSEMBLY REF AMM 33-25-00.SDR AALA201705059051Light · brokenAIRCRAFT WAS NOT GROUNDED. BROKEN LEFT HAND AFT GALLEY EMERGENCY LIGHT ASSEMBLY. REPLACED EMERGENCY PROXIMITY LIGHT ASSEMBLY PER AMM 33-51-00 AND AMM 33-51-14.SDR AALA201705059044Sign · brokenAIRCRAFT WAS NOT GROUNDED. BROKEN EXIT SIGN AT DOOR 2R. MAINTENANCE REPLACED EXIT LIGHT ASSEMBLY PER AMM 33-51-01.SDR AALA201705059043Lens · missingAIRCRAFT WAS NOT GROUNDED. DOOR L1 EMERGENCY EXIT IDENTIFIER LENS MISSING. REPLACED LIGHT ASSEMBLY PER AMM 33-51-01. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201705059040Light · brokenAIRCRAFT WAS NOT GROUNDED. BROKEN RIGHT HAND AFT GALLEY EMERGENCY LIGHT ASSEMBLY. REPLACED EMERGENCY PROXIMITY LIGHT ASSEMBLY PER AMM 33-51-00 AND AMM 33-51-14.SDR AALA201705059039Light · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY LIGHT COVER MISSING ON LEFT SIDE OF FORWARD GALLEY AND FORWARD OF SEAT 3E. REPLACED EMERGENCY PROXIMITY LIGHT ASSEMBLY FORWARD AIRCRAFT RIGHT SIDE PER AMM 33-51-00 AND TESTED PER AMM 33-51-14.SDR AALA201705059048Light · inoperativeSEAT 9G EMERGENCY LIGHT WAS FOUND INOPERATIVE. REPLACED EMERGENCY LIGHT ASSEMBLY IAW AMM 33-51-05.SDR IPXA2017050316739Cover · inoperativeEMERG EXIT LIGHT SWITCH ARMING COVER MECHANISM NOT OPERATING CORRECTLY. R & R EMERGENCY EXIT LIGHT SWITCH ARMING COVER IAW AMM 33-51-00-715-039.SDR MASA2017050312767Light · inoperativeROW 18 CEILING EMER LIGHT INOP. PLACED ON MEL.SDR SWAA2017050413558Light · unsecureON LANDING MID CABIN CEILING EXIT SIGN FELL DOWN. R&R LIGHT ASSEMBLY IAW MM.SDR DALA2017050403557Battery Pack · dischargedEMERGENCY LIGHTS 30AB-37AB COME ON THEN ALMOST IMMEDIATELY GO OUT. R&R BATTERY PACK AND CHARGER AT SEAT 32 AS PER AIM 33-50.SDR SIMA20170503002Battery · dischargedRT EXTERIOR FUSELAGE FWD EMERGENCY LIGHT INOP. REMOVED AND REPLACED EMERGENCY LIGHT BATTERY AND CHARGER IAW AMM 33-50-04 OPC GOOD. LIGHT EMERGENCY P/N 30-2510-3. BATTERY CHARGER ASSY P/N 11-0049 S/N 24446.SDR SIMA20170502002Light · inoperativeNR 2 FLOOR PROXIMITY LIGHT INOPERATIVE. REMOVED AND REPLACED THE LIGHT IAW AMM 33-50-12, OPS CHECKED GOODSDR RAIA201705020001Battery · dischargedLT UPPER EMERGENCY DOOR EXIT LIGHT INOP. R&R NR 3 EMERGENCY LIGHT BATTERY, OPS CHECK GOOD.SDR CALA2017050501233Charger · inoperativeEMER LT M33099 FOUND BATTERY LOW. L2 DOOR EMERGENCY LIGHT BATTERY PACK M33099 AND CHARGER REPLACED, OPERATIONAL TESTED NORMAL AS PER AMM 33-51-06.SDR CALA2017050501232Battery · dischargedEMER LT M33404 FOUND BATTERY LOW. R3 DOOR EMERGENCY LIGHT BATTERY PACK M33404 REPLACED AND CHECKED NORMAL AS PER AMM 33-51-06.SDR CALA2017050501231Battery · dischargedEMER LT M33406 FOUND BATTERY LOW. L3 DOOR EMERGENCY LIGHT BATTERY PACK M33406 REPLACED AND CHECKED NORMAL AS PER AMM 33-51-06.SDR AALA201705059042Cover · brokenAIRCRAFT WAS NOT GROUNDED. BROKEN LEFT HAND SIDE EMERGENCY LIGHT COVER IN PASSENGER CABIN AT SEAT ROW 14. REPLACED LIGHT COVER PER AMM 33-51-01.SDR AALA201705049023Panel · unsecureL1 DOOR LOWER EMERGENCY EXIT SIGN PANEL NOT SECURE. SECURED THE EXIT SIGN PANEL IAW MM 11-30.SDR IPXA2017050216702Power Supply · inoperativeEMERGENCY LIGHT TEST FAILED, EMERGENCY LIGHT BATTERY LOW. THE POWER SUPPLY WAS REPLACED IAW AMM 33-51-01, REV 88. TESTED GOOD.SDR IPXA2017050416742Battery Pack · inoperativeINSPECTION TYPE: C4, FOUND EXIT EMERGENCY LIGHTS NOT ILLUMINATING. REPLACED THE BATTERY PACK IAW AMM 33-51-07-022-001, AND AMM 33-51-07-422-012, REV 121. PERFORMED A BATTERY PACK TEST IAW AMM 33-51-07-422-012, REV.121.SDR AALA201705059011Battery Pack · no testLEFT OVERWING EXIT ROWS 14-15 UPPER SIGN AND ROW 14 LOWER SIGN FAIL TO TEST. FULLY CHARGED THE BATTERY PACKS IAW AMM TASK 33-51-06. ALL LIGHTS CHECKED GOOD. THE AIRCRAFT WAS GROUNDED.SDR AALA201705059010Battery Pack · no testSEAT 7-72 EMERGENCY LIGHT FAILED TO TEST. FULLY CHARGED THE BATTERY PACKS IAW AMM TASK 33-51-06. ALL LIGHTS CHECKED GOOD. THE AIRCRAFT WAS GROUNDED.SDR AALA201705059009Battery Pack · no testRIGHT BULL NOSE EMERGENCY LIGHT ROWS 7-11 FAIL TO TEST. FULLY CHARGED THE BATTERY PACKS IAW AMM TASK 33-51-06. ALL LIGHTS CHECKED GOOD. THE AIRCRAFT WAS GROUNDED.SDR AALA201705059008Battery Pack · dischargedLEFT BULL NOSE EMERGENCY LIGHT ROWS 14-21 FAIL TO TEST. FULLY CHARGED THE BATTERY PACKS IAW AMM 33-51-06. ALL LIGHTS CHECKED GOOD. THE AIRCRAFT WAS GROUNDED.SDR AALA201705059007Battery Pack · no testLEFT BULL NOSE EMERGENCY LIGHT AT ROW 11 THRU FIRST CLASS FAILED TO TEST. FULLY CHARGED THE BATTERY PACKS IAW AMM 33-51-06. ALL LIGHTS CHECKED GOOD. THE AIRCRAFT WAS GROUNDED.SDR AALA201705059006Battery Pack · no testLEFT BULL NOSE EMERGENCY LIGHTS AT ROWS 23-30 FAILED TO TEST. FULLY CHARGED THE BATTERY PACKS IAW AMM 33-51-06. ALL CHECKED GOOD. THE AIRCRAFT WAS GROUNDED.
Back to JASC 3350