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 R61A201702010080Light · malfunctionedCREW RECEIVED AN EICAS MESSAGE THAT AN EMERGENCY LIGHT WAS ON. AN EMERGENCY WAS NOT DECLARED AND CREW LANDED WITHOUT INCIDENT. MAINTENANCE REPACKED AND CLEANED EMERGENCY LIGHT IAW AMM AND OPS CHECKED GOOD.SDR JJBA20170201001Bulb · inoperativeEMG EXIT LIGHT ROW 18 INOPERATIVE. R & R THE BULB. OPS CHECKED SATISFACTORY.SDR MASA2017020112850Light · inoperativeROW 21 CEILING EMERGENCY FLOOD LIGHT INOP. RE-LAMPED.SDR HNAA2017020100032Module · inoperativeEMERGENCY LIGHT IS INOPERATIVE AT ROW 4AC. REMOVED AND REPLACED THE LIGHT MODULE, CRIMPED THE WIRES IAW PPS 9.35. OPS CHECKED GOOD.SDR HNAA2017020100031Bulb · inoperativeEMERGENCY LIGHT INOPERATIVE AT ROW 1. REMOVED AND REPLACED THE BULBS. OPS CHECKED GOOD.SDR DALA2017020100833Battery Pack · no testEMERGENCY LIGHT BATTERY FAILED BATTERY CAPACITY TEST. REPLACED THE BATTERY PACK.SDR DALA2017020100815Lens · looseTHE FLIGHT ATTENDANT DISCOVERED THAT THE GALLEY DOOR EMERGENCY EXIT SIGN COVER WAS LOOSE. MAINTENANCE SECURED THE LENS/COVER AND THE OPERATIONAL CHECK WAS GOOD.SDR SWAA2017020311670Light · inoperativeR2 DOOR EMERGENCY EXIT LIGHT BULB INOP. RELAMPED LIGHT PER AMM.SDR SWAA2017020311669Light · inoperativeFORWARD RT OVERWING EMERGENCY EXIT LIGHT BULB INOP. RELAMPED LIGHT IAW AMM.SDR DALA2017013100955Lens · missingTHE FLIGHT ATTENDANT DISCOVERED THAT AN EMERGENCY EXIT SIGN DIFFUSER COVER AT AFT F/A SEAT WAS MISSING. MAINTENANCE REPLACED THE LENS AND OPS CHECKED GOOD.SDR DALA2017020100926Connector · unsecure4F EXIT SIGN DOES NOT ILLUMINATE, SECURED THE CONNECTOR.SDR AALA20170202014Light · brokenAIRCRAFT WAS NOT GROUNDED. SEAT MOUNTED EMERGENCY ESCAPE PATH LIGHT AT SEATS 13DEF IS BROKEN. REMOVED AND REPLACED LIGHT IAW AMM 33-51-11. OPERATIONAL CHECK GOOD.SDR AALA20170202009Sign · detachedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN OVER SEAT 24H IS DETACHED. REPAIRED IAW AARD 33-51-01-1. OPERATIONAL CHECK GOOD.SDR AALA20170202006Battery · failedAIRCRAFT WAS NOT GROUNDED. EMERGENCY POWER SUPPLY UNIT AT 10WL FAILED TEST. REMOVED AND REPLACED EPSU BATTERY IAW AMM 33-51-38. OPERATIONAL CHECK GOOD.SDR AALA20170131035Light · detachedAIRCRAFT IN BASE MAINTENANCE. AFT GALLEY LEFT DOOR EMERGENCY LIGHT FIXTURE DETACHED AT BOTTOM MOUNT. REPLACED L2 DOOR EMERGENCY EXIT MARKER PER AMM 33-51-13.SDR AALA20170131003Portable Light · dimAIRCRAFT IN BASE MAINTENANCE. PORTABLE EMERGENCY LIGHT VERY DIM. REPLACED LIGHT AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA20170131002Battery Pack · dischargedAIRCRAFT WAS NOT GROUNDED. EMERGENCY LIGHT IN AFT GALLEY ABOVE L4 DOOR INOPERABLE. REPLACED LEFT AFT BATTERY PACK PER AMM 33-51-06.SDR SWAA2017020211641Light · unsecureR1 EMERGENCY EXIT LIGHT COVER FELL OFF. R&R LIGHT ASSEMBLY IAW AMM.SDR SWAA2017020211627Lens · unsecureL1 DOOR EMERGENCY EXIT LIGHT LENS COVER FELL OFF. SECURED COVER IAW AMM.SDR SWAA2017020211621Light · inoperativeFORWARD GALLEY AREA EMERGENCY EXIT SIGN BULB INOP. R&R BULB IAW AMM.SDR REXA2017013100144Inverter · inoperativeLT LOWER EXIT LIGHT AT ESCAPE HATCH IS INOP. R/R EXIT LIGHT PN 6020-6 IAW 33-51-00, DID NOT FIX. R&R EMERGENCY LIGHT INVERTER IAW AMM 33-51-07, OPS CK GOOD.SDR UIEA2017020100139Light · malfunctionedEMERGENCY LIGHTS AT L4 DOOR INTERMITTENTLY ILLUMINATING. CYCLED EMERGENCY LIGHTS, OPS CHECKED NORMAL IAW AMM 33-51-01.SDR DALA2017020100835Power Supply · faultedDURING SERVICE CHECK, FOUND A FAULT IN THE FWD EMERGENCY LIGHT POWER SUPPLY, SWAPPED EPSU 10WL AND 11WL. SYS NOW OPS CHECKED NORMALSDR GLBA2017020100631Light · inoperativeSIG EVENT - MAINTENANCE NOTED THAT THE FLOOR EMERGENCY LIGHTING BETWEEN SEAT 5 AND 7 WILL NOT ILLUMINATE. MAINTENANCE REPLACED BULB IAW AIM 12.11.0 P/N ON/OFF: 3071BPEGPL. REPLACED FUSE IAW EMB120 MM 33-50-03, P/N ON/OFF: AGC1, NSN. OPS CHECK GOOD IAW MM 33-50SDR IPXA2017013113563Control Panel · defectiveEMERG EXIT LIGHT"UNARMED" ON OVERHEAD INOP. TRIED TO RELAMP, DISINTEGRATED. R&R EMERGENCY EXIT LIGHT CONTROL PANEL REF AMM33-51-00-501.SDR SWAA2017020111615Battery · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY CHECK AT LOCATION M1672. R & R THE BATTERY IAW MM.SDR SWAA2017020111614Battery · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY CHECK AT LOCATION M1670. R & R THE BATTERY IAW MM.SDR SWAA2017020111613Battery · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY CHECK AT LOCATION M1669. R & R THE BATTERY IAW MM.SDR SWAA2017020111612Battery · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY CHECK AT LOCATION M1668. R & R THE BATTERY IAW MM.SDR SWAA2017020111611Battery · no testAIRCRAFT EMERGENCY LIGHT BATTERY FAILED CAPACITY CHECK AT LOCATION M1674. R&R BATTERY PER MM.SDR SWAA2017020111610Battery Pack · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY CHECK AT LOCATION M1675. R & R THE BATTERY IAW MM.SDR SWAA2017020111605Bulb · inoperativeLEFT OVERWING EMERGENCY LIGHT INOPERATIVE. R & R THE BULB IAW AMM.SDR SWAA2017020111595Battery Pack · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY CHECK AT LOCATION M1673. R & R THE BATTERY IAW MM.SDR SWAA2017020111594Battery Pack · inoperativeL1 DOOR OVERHEAD EMERGENCY LIGHT INOPERATIVE. R & R THE BATTERY PACK IAW AMM.SDR SWAA2017020111591Light · inoperativeUPPER FUSELAGE AFT GALLEY AREA EMERGENCY LIGHT INOPERATIVE BETWEEN BS 986.5 TO 1006. R & R LIGHT IAW AMM.SDR DALA2017013100014Battery Pack · no testDURING INSPECTION, THE EPSU BATTERY 13WL FAILED ON THE EPSU CAP TEST AT DOOR 2. REPLACED DOOR 2L EPSU BATTERY AT DOOR 2L (13WL). LP 2872107SDR AALA20180326004Battery Pack · inoperativeTHE EMERGENCY LIGHTS ON THE SIDE OF THE SEATS 2AB THROUGH 5AB ARE NOT WORKING. ALL THE BATTERY PACKS WERE REPLACED.SDR REXA2017013000147Light · missingEMERGENCY LIGHT MISSING IN ROW 13 A/B. REINSTALLED REPLACED THE LIGHT IAW AMM 33-51-01.SDR DALA2017013100924Sign · looseEMERGENCY EXIT SIGN LOOSE. REATTACHED SIGN. OK FOR SERVICE.SDR AALA20170202015Lens · brokenAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT ILLUMINATED SIGN BY R2 DOOR HAS A BROKEN LENS COVER. REPLACED LENS COVER IAW AMM 33-51-00. OPERATIONAL CHECK GOOD.SDR AALA20170201006Power Supply · no testAIRCRAFT IN BASE MAINTENANCE. DOOR 3R EMERGENCY POWER SUPPLY (M33401) CAPACITY TEST FAILED. REPLACED POWER SUPPLY AND ACCOMPLISHED SATISFACTORY INSTALLATION TEST PER AMM 33-51-06.SDR AALA20170201005Power Supply · failedAIRCRAFT IN BASE MAINTENANCE. DOOR 4R EMERGENCY POWER SUPPLY (M33408) FAILED ON TEST. REPLACED POWER SUPPLY AND ACCOMPLISHED SATISFACTORY INSTALLATION TEST PER AMM 33-51-06.SDR AALA20170201004Power Supply · failedAIRCRAFT IN BASE MAINTENANCE. DOOR 2R EMERGENCY POWER SUPPLY (M33097) CAPACITY TEST FAILED. REPLACED POWER SUPPLY AND ACCOMPLISHED SATISFACTORY INSTALLATION TEST PER AMM 33-51-06.SDR AALA20170201003Power Supply · failedAIRCRAFT IN BASE MAINTENANCE. DOOR 3L EMERGENCY POWER SUPPLY (M33406) CAPACITY TEST FAILED. REPLACED POWER SUPPLY AND ACCOMPLISHED SATISFACTORY INSTALLATION TEST PER AMM 33-51-06.SDR AALA20170201002Power Supply · failedAIRCRAFT IN BASE MAINTENANCE. DOOR 1R EMERGENCY POWER SUPPLY (M33094) CAPACITY TEST FAILED. REPLACED POWER SUPPLY AND ACCOMPLISHED SATISFACTORY INSTALLATION TEST PER AMM 33-51-06.SDR AALA20170201001Power Supply · failedAIRCRAFT IN BASE MAINTENANCE. DOOR 1L EMERGENCY POWER SUPPLY (M33424) CAPACITY TEST FAILED. REPLACED POWER SUPPLY AND ACCOMPLISHED SATISFACTORY INSTALLATION TEST PER AMM 33-51-06.SDR SWAA2017020211643Lens · dirtyEMERGENCY LIGHT LENS DIRTY AT BS 757, LBL 51. CLEANED LENS IAW AMM.SDR SWAA2017020211637Lens · dirtyEMERGENCY LIGHT LENS DIRTY AT BS 757, RBL 51. CLEANED LENS IAW AMM.SDR YENA201701300056Battery Pack · failedFWD EPSU (10WL) FAILED OPS CHECK. R & R THE BATTERY PACK IAW AMM 33-51-38-000-002-A AND 33-51-38-400-002-A. PERFORMED OPS CHECK. OPS CHECK PASSED.SDR YENA201701300055Epsu · failedEMERGENCY LIGHTS BATTERY PACK FOR EPSU 11WL DID NOT ILLUMINATE WITH SWITCH IN THE ARM POSITION. R & R THE EPSU IAW AMM 33-51-38-000-002-A AND 33-51-38-400-002-A. PEFORMED EMERGENCY LIGHT OPS CHECK. OPS CHECK PASSED.
Back to JASC 3350