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 29GA2018012500001Light · inoperativeFLIGHT 0130 PNS/TPA REPORT: EMERGENCY LIGHTS ON BOTTOM FRONT INOP. R&R MOST FWD FLOOR PROXIMITY ESCAPE PATH LIGHT STRIP IAW MM 33-50-20-04.SDR DALA2018012500418Fuse · blownIN SEAT EMERGENCY LIGHTS OUT ROWS 31 AFT. REMOVED BATTERY PACK FOR ASSOCIATED SEATS AND FOUND ONE FUSE BAD ON THE CRADLE. REPLACED FUSE, REINSTALLED BATTERY AND OPS CK GOOD REF AMM 33-53.SDR QXEA2018012400028Battery Pack · dischargedLIGHTED EMERGENCY "EXIT" DOOR SIGNS INOP OVER BOTH DOORS IN AFT GALLEY. REMOVED & REPLACED EMERGENCY BATTERIES AT RT 4 AND LT 4 IAW AMM 33-51-00-820-001. PERFORMED OPS TEST IAW AMM 33-51-00-710-002. TESTED GOOD. CLEAR DEFECT.SDR MASA2018012412932Light · inoperativeROW 18 OVERHEAD EMERGENCY FLOOD LIGHT INOPERATIVE.SDR DALA2018012400411Charger · inoperativeBATTERY FAILED TO CHECK. R & R M1675 BATTERY CHARGER AND BATTERY IAW 33-51. OPS CHECKED NORMAL.SDR DALA2018012400410Battery Pack · inoperativeFOUND THE EMERGENCY LIGHTS AT THE RT OVERWING EXIT INOPERATIVE. TROUBLESHOT AND FOUND THE BATTERY PACK FAILED. REMOVED AND REPLACED THE BATTERY PACK IAW AMM 33-51-06. OPS CHECKED GOOD.SDR QXEA2018012400026Lens · brokenFA NOTE EMERGENCY EXIT SIGN PLASTIC LENS ON RIGHT SIDE WAS BROKEN. REMOVED FROM SERVICE. REPLACED THE EMERGENCY LIGHT ASSY. OPS TESTED IAW AMM 33-51-00-710-801. TESTED GOOD. AIRCRAFT RETURNED TO SERVICE.SDR AALA201801249005Power Supply · no testDURING AN EMERGENCY LIGHT SYSTEM TEST, THE TEST FAILED WITH A MESSAGE FOR THE EMERGENCY POWER SUPPLY UNIT, R3 DOOR. REPLACED THE POWER SUPPLY UNIT AND BATTERY PACK IAW AMM 33-51-38.SDR SWAA2018020719523Lens · looseRT CEILING EMERGENCY LIGHT LENS LOOSE AT ROW 6. R&R LIGHT IAW AMM.SDR SWAA2018012919367Light · inoperativeEMERGENCY LIGHT LAMP INOP AT BS 757, RBL 51. R&R LAMP IAW AMM.SDR JJBA20180123010Light · unknownEMERGENCY EXIT LIGHTS WILL NOT ARM. PERFORMED OPS CHECK.SDR AALA20180124009Switch · failedEMERGENCY LIGHT POWER SWITCH AT THE L1 CABIN FLIGHT ATTENDANT PANEL, POWER LIGHT REMAINS ILLUMINATED WITH SWITCH ON OR OFF. REPLACED THE SWITCH IAW 33-51-12. OPS CHECKED NORMAL.SDR REXA2018012300045Light · missingFLOOR EMERGENCY LIGHT MISSING. INSTALLED THE EMERGENCY LIGHT IAW AMM 33-51-01.SDR GTIA2018012302358Battery · no testWHILE PERFORMING BATTERY CAPACITY TEST, ESPU 12WL AND BATTERY 13WL FAILED. REMOVED AND REPLACED THE EPSU 12WL AND BATTERY 13WL IAW 33-51-38. OPS CHECKED GOOD.SDR AALA201801249003Light · inoperativeBLUE EMERGENCY LIGHT INOPERATIVE ON SEAT 9C. REPLACED THE EMERGENCY LIGHT.SDR AALA201801259020Lens · missingPASSENGER SEAT 1C EMERGENCY LIGHT LENS MISSING. REPLACED THE LENS IAW MM 33-51-19 AND PERFORMED A SATISFACTORY OPERATIONAL CHECK.SDR AALA201801259019Sign · detachedEXIT SIGN ON THE R2 DOOR DETACHED. ATTACHED THE SIGN AND PERFORMED A SATISFACTORY OPERATIONAL CHECK.SDR AALA201801249012Lens · brokenTHE AIRCRAFT WAS NOT GROUNDED. SEAT 3C EXIT PATH LIGHT LENS BROKEN. REPLACED LENS PER GPM 54-01-10.SDR AALA201801249009Power Supply · faultedFORWARD EMERGENCY CABIN POWER SUPPLY FAULTING. REPLACED FORWARD EMERGENCY LIGHT UNIT PER AMM 33-51-38-401.SDR ASOA201801234005Battery Pack · inoperativeDURING MAINTENANCE INSPECTION, THE EMERGENCY LIGHTS AT THE EMERGENCY EXIT WERE FOUND TO BE INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE BATTERY PACK. OPS TESTED GOOD. AIRCRATF WAS APPROVED FOR RETURN TO SERVICE.SDR ASAA2018012323275Light · inoperativeFOUND LT FWD (L1) EMERGENCY SLIDE LIGHT INOP. GROUNDED - YES. REMOVED AND REPLACED L1 EMERGENCY SLIDE LIGHT BULB REF AMM 33-51-04. OPS CHECK GOOD.SDR SIMA20180123009Unknown · unknownEMERGENCY LIGHT STRIP AT SEAT ROWS 3 - 7 INOPERATIVE. PERFORMED AN OPS CHECK OF THE EMERGENCY LIGHTS IAW AMM 33-50-00. OPS CHECKED GOOD.SDR SIMA20180123001Charger · inoperativeMULTIPLE EMERGENCY LIGHTS, SIGNS AND FLOOR STRIPS NOT ILLUMINATING. REMOVED AND REPLACED NUMBER 2 BATTERY POWER SUPPLY AND CHARGER IAW WORK CARD 33-700-19 OPS CHECK GOOD. EMERGENCY LIGHTING BATTERY P/N 2013-1A S/N 71928.SDR HALA2018012300004Charger · inoperativeFOUND EMERGENCY LIGHTS INOPERATIVE IN THE MID GALLEY AND SEAT ROWS 17HJ - 23HJ. FOUND CHARGER INOPERATIVE FOR THE SEATS AND A BROKEN JUMPER AT THE MID GALLEY. REPLACED CHARGER AND JUMPER. EMERGENCY LIGHTS OPS NORMAL, IAW AMM 33-51-10 AND 33-51-07.SDR AALA201801249011Battery · dischargedTHE AIRCRAFT WAS NOT GROUNDED. L3 DOOR EMERGENCY LIGHT BATTERY FAILS ESPU TEST. REMOVED AND REPLACED EMERGENCY LIGHT BATTERY 11WL PER AMM 33-51-38.SDR SWAA2018012919395Battery Pack · dischargedFORWARD GALLEY LOWER EXIT LIGHT INOP AT LOCATION M1674. R&R BATTERY PACK IAW AMM.SDR SWAA2018012919394Battery Pack · dischargedRT FORWARD ESCAPE LIGHT INOP AT LOCATION M1674. R&R BATTERY PACK IAW AMM.SDR SWAA2018012919364Battery Pack · dischargedRT FORWARD BULLNOSE EMERGENCY EXIT LIGHT INOP AT LOCATION M1674. R&R BATTERY PACK IAW AMM.SDR AALA201801259013Control Unit · faultedL2 DOOR FORWARD REMOTE WIRELESS EMERGENCY LIGHTING SYSTEM CONTROL UNIT HAS AN INTERNAL FAULT. MAINTENANCE TROUBLESHOT IAW FIM B787-A-33-50-F1-35A-421A-A AND REPLACED WIRELESS EMERGENCY LIGHTING CONTROL UNIT. RELOADED SOFTWARE AND PEFORMED SATISFACTORY OPERATISDR DALA2018012300452Light · unsecureOVERHEAD EMERGENCY LIGHT AT ROW 32 NOT SECURE. SECURED THE EMERGENCY LIGHT.SDR DALA2018012300451Lens · missingEMERGENCY LIGHT LENS MISSING AT AFT LT OVERWING EXIT. REPLACED THE LENS.SDR AALA201801249016Lens · missingEMERGENCY LIGHT LENS AT BS 727 MISSING. REPLACED THE LENS IAW AMM 25-63-00.SDR AALA201801259009Sign · brokenFOWARD GALLEY SERVICE DOOR EXIT SIGN BROKEN. REPLACED SIGN ASSEMBLY IAW AMM 33-51-01-960-802, AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201801259008Sign · brokenAFT ENTRY DOOR EXIT SIGN BROKEN. REPLACED THE SIGN IAW AMM 33-51-01-960-802, AND PERFORMED A SATISFACTORY OPERATIONAL CHECK.SDR SWAA2018012519324Sign · missingR1 DOOR LOWER EXIT SIGN MISSING DIRECTIONAL ARROW. INSTALLED SIGN IAW AMM.SDR SWAA2018012519320Lens · crackedR2 DOOR THRESHOLD EMERGENCY EXIT LIGHT LENS CRACKED. R&R LENS IAW AMM.SDR SWAA2018012519318Sign · dislodgedAFT GALLEY OVERHEAD EMERGENCY EXIT SIGN DISLODGED. INSTALLED SIGN PER MM.SDR AALA20180123001Battery · dischargedAIRCRAFT WAS GROUNDED: L3 DOOR EMERGENCY LIGHT BATTERY FAILED EMERGENCY SUPPLY POWER UNIT TEST. MAINTENANCE REPLACED EMERGENCY LIGHT BATTERY 11WL PER AMM 33-51-38 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201801239017Cover · damagedAIRCRAFT WAS NOT GROUNDED: EXIT DOOR 2R EXIT SIGN COVER WAS REMOVED AND APPEARED DAMAGED. MAINTENANCE REPLACED EXIT LIGHT ASSEMBLY PER AMM 33-51-01 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR SWAA2018012419305Lens · dirtyRIGHT EMERGENCY LIGHT LENS AFT OF WING FOUND DIRTY. CLEANED THE LENS IAW AMM.SDR SWAA2018012419302Lens · dirtyLEFT EMERGENCY LIGHT LENS DIRTY. CLEANED THE LENS IAW AMM.SDR SWAA2018012419296Lens · detachedEXIT AISLE SIGN LENS DETACHED. SECURED THE LENS IAW SIP.SDR SWAA2018012419294Light · detachedMID CABIN EMERGENCY EXIT SIGN DETACHED ON LANDING. INSTALLED THE SIGN IAW AMM.SDR AALA20180122005Lens · brokenEMERGENCY EXIT LIGHT ASSEMBLY LENS AT SEAT 14DEF AT LOWER FORWARD CORNER OVER WING EXIT DOOR BROKEN. REPLACED EMERGENCY EXIT LIGHT ASSEMBLY IAW AMM 33-51-04.SDR AALA20180122004Lens · brokenEMERGENCY EXIT LIGHT ASSEMBLY LENS BROKEN AT FORWARD GALLEY NEXT TO R1 DOOR. REPLACED THE EXIT LIGHT ASSEMBLY IAW AMM 33-51-01.SDR SIMA20180122006Bulb · inoperativeROW 17 EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE BULB IAW AMM 33-50-08-000-801-A, AND 33-50-08-400-801-A. OPS CHECKED GOOD.SDR CALA2018012200296Lens · crackedDURING AN A CHECK, FOUND THE EMERGENCY LIGHT LENS CRACKED. REPLACED THE LENS IAW AMM 33-51-05.SDR CALA2018012200292Battery Pack · faultyCAPT''S DOME LITE--EMERGENCY LITE INOP. RELAMPED, NOT ABLE TO OPS CK DUE TO EMERGENCY LIGHTS INOP OVER 1L AND 1L FLOOR LIGHTED, EMERGENCY SIGN OVER F/C TO COCKPIT ALSO INOP. TROUBLESHOT SYSTEM, REPLACED EMERGENCY LIGHT BATTERY PACK REF MM 33-51-06. ALL LIGHTS SDR CALA2018012200291Battery Pack · inoperativeEMERGENCY LIGHTS RH AND LH BULLNOSE ROW 4-12 AND 29-36 LIGHTS ARE INOPERATIVE, AND SEATS ROW 8-13 AND 29-34. R & R THE BATTERY PACKS. OPS CHECKED GOOD.SDR CALA2018012200289Lamp · inoperativeL3 DOOR EXTERNAL EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE LAMP IAW AMM 33-40-00. OPS CHECKED GOOD.
Back to JASC 3350