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 SWAA2018031220320Lamp · inoperativeAFT R1 DOOR EXTERIOR EMERGENCY LIGHT INOPERATIVE. R & R THE LAMP IAW AMM.SDR SWAA2018031220311Lamp · inoperativeLEFT OVERWING EMERGENCY EXT DOOR LIGHT INOPERATIVE. REPLACED THE LAMPS IAW MM.SDR SWAA2018031220307Sign · looseEMERGENCY EXIT LIGHT SIGN COVER LOOSE. SECURED THE SIGN IAW SIP.SDR AALA201803099022Lens · brokenAIRCRAFT WAS NOT GROUNDED. FLIGHT ATTENDANT REPORTS THE COVER ON THE LOWER EMERGENCY LIGHT AT R1 DOOR BROKEN. REPLACED LENS.SDR AALA201803099014Lens · missingEMERGENCY LIGHT ON L53 WALL, CLEAR LENS IS MISSING. INSTALLED THE LENS.SDR C77A20180309001Battery · defectiveFORWARD R1 F/A FLASHLIGHT INOPERATIVE. . REMOVED AND REPLACED THE BATTERY IAW AMM33-51-01. OPS CHECKED GOOD.SDR SIMA20180308005Lamp · inoperativeLEFT EXTERNAL FWD EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE LAMP IAW AMM 33-50-10-000-801-A, AND 33-50-10-400-801-A.. OPS CHECKED GOOD.SDR AALA201803099017Lens · missingEMERGENCY LIGHT LENS MISSING AT ROW 37. MAINTENANCE INSTALLED THE LENS IAW AMM 33-50-00, AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR S9BA20180308001Connector · unsecureEMERGENCY EXIT LIGHT OVER ROW 6A INOPERATIVE. FOUND THE CONNECTOR UNSECURE.SDR DALA2018030801498Power Supply · inoperativeEMERGENCY LIGHTS AT SEATS 22-30 ARE INOPERATIVE. REPLACED POWER SUPPLY. SYSTEM OPERATION IS NORMAL.SDR ASAA2018030724140Battery Pack · no testL1 DOOR EMERGENCY LIGHT BATTERY FAILED A CHECK. ACFT GROUNDED. REMOVED AND INSTALLED A SERVICEABLE BATTERY PACK, OPS CHECKED GOOD IAW AMM 33-51-06-960-805.SDR ASAA2018030724139Battery Pack · no testR1 DOOR EMERGENCY LIGHT BATTERY FAILED A CHECK. ACFT GROUNDED. REMOVED AND INSTALLED A SERVICEABLE R1 DOOR EMERGENCY EXIT LIGHT BATTERY PACK IAW AMM 33-51-06-960-805.SDR ASAA2018030724130Battery Pack · no testLEFT FWD OVERWING EMERGENCY LIGHT BATTERY FAILED A CHECK. ACFT GROUNDED. REMOVED, AND REPLACED THE LT OVERWING EMERGENCY LIGHT BATTERY PACK M1694. EMERGENCY LIGHTS OPS CHECKED GOOD IAW AMM 33-51-06-960-805.SDR SWAA2018031220358Battery Pack · inoperativeRIGHT EMERGENCY EXIT AISLE LIGHTS INOPERATIVE AT ROW 9. R & R THE BATTERY PACK IAW AMM.SDR SWAA2018031220327Battery Pack · inoperativeLEFT EMERGENCY EXIT AISLE LIGHTS INOPERATIVE BETWEEN ROWS 7 TO 12. R & R THE BATTERY PACK IAW AMM.SDR SWAA2018031220314Lens · looseR1 DOOR AFT EMERGENCY LIGHT LENS LOOSE. SECURED THE LENS IAW MM.SDR AALA201803089012Lens · missingEMERGENCY LIGHT LENS MISSING ON ROW 15. INSTALLED THE LENS IAW AMM 33-51-03.SDR AALA201803099015Lens · damagedEMERGENCY LIGHT LENS AT THE R1 DOOR WILL NOT STAY ATTACHED. INSTALLED AND SECURED THE EMERGENCY LIGHT LENS IAW AMM 33-51-01.SDR DALA2018030801543Lens · detachedDURING INSPECTION, FOUND EMERGENCY LIGHT LENS DETACHED. MAINTENANCE REINSTALLED LENS. OK FOR SERVICE.SDR DALA2018030701542Light · inoperativeDURING INSPECTION, FOUND A SEAT MOUNTED EMERGENCY LIGHT INOPERATIVE AT ROW 1CD. MAINTENANCE REMOVED AND REPLACED THE EMERGENCY LIGHT ASSY IAW AMM 33-51-11. OPS CHECKED GOOD.SDR YENA201803070127Power Supply · failedMID CABIN OVERHEAD EMERGENCY EXIT LIGHT INOPERATIVE. FOLLOWED FIM 33-50-00-810-813-A. FOUND THE POWER SUPPLY INOPERATIVE. R & R THE POWER IAW AMM 33-50-01. OPS NORMAL.SDR AALA201803099013Sign · missingEXIT SIGN OVER DOOR 3L MISSING. MAINTENANCE SECURED EXIT SIGN AND PERFORMED SATISFACTORY OPERATIONAL CHECK IAW AMM 33-51-00.SDR AALA201803089010Lens · defectiveSEAT 15D EMERGENCY LIGHT LENS DEFECTIVE. REPLACED THE LENS IAW AMM 33-51-11.SDR AALA201803089015Lens · crackedRIGHT AFT DOOR EMERGENCY EXIT LIGHT LENS CRACKED. MAINTENANCE REPLACED THE LENS IAW AMM 33-50-00, AND PERFORMED A SATISFACTORY OPERATIONAL CHECK.SDR AALA201803089013Lens · detachedEXIT LIGHT COVER NEAR THE L4 DOOR FELL OFF. REMOVED AND REPLACED THE LIGHT ASSEMBLY.SDR AALA201803089008Lens · looseEMERGENCY EXIT COVER 2R IS LOOSE. REPLACED VELCRO AND RESEATED SLIDE COVER. AIRCRAFT WAS GROUNDED.SDR MASA2018030713035Battery Pack · inoperativeROW 13 EMERGENCY SIGNS INOPERATIVE. REPLACED THE LAMPS AND REPLACED THE BATTERY.SDR SWAA2018031220359Battery · no testEMERGENCY LIGHT BATTERY FAILED A CAPACITY TEST AT M1675. R & R THE BATTERY IAW MM.SDR SWAA2018031220338Battery Pack · inoperativeLEFT AFT EMERGENCY LIGHTS INOPERATIVE IN THE CABIN. R & R THE BATTERY PACK IAW MM.SDR SWAA2018031220337Battery · no testEMERGENCY LIGHT BATTERY FAILED A CAPACITY TEST AT M1674. R & R THE BATTERY IAW MM.SDR SWAA2018031220332Cover · brokenEMERGENCY LIGHT SWITCH COVER BROKEN. R & R THE SWITCH COVER IAW SIP.SDR SWAA2018031220317Battery Pack · no testEMERGENCY LIGHTS BATTERY PACK M1675 FAILED A CAPACITY CHECK. R & R THE BATTERY PACK IAW AMM.SDR SWAA2018031220316Battery Pack · no testEMERGENCY LIGHTS BATTERY PACK M1670 FAILED A CAPACITY CHECK. R & R THE BATTERY PACK IAW AMM.SDR SWAA2018031220313Lamp · inoperativeFORWARD OF AFT CARGO BAY DOOR EXTERIOR EMERGENCY FLOOD LIGHT INOPERATIVE. REPLACED THE LAMP IAW AMM.SDR SWAA2018031220310Bulb · inoperativeRIGHT OVERWING EXIT AFT EMERGENCY EXIT LIGHT, THE BULB WAS INOPERATIVE. R & R THE BULB IAW AMM.SDR SWAA2018031220309Bulb · inoperativeFORWARD ENTRY DOOR LOWER FORWARD EMERGENCY EXIT LIGHT, BULB INOPERATIVE. R & R THE BULB IAW AMM.SDR YENA201803060126Battery Pack · no testFWD LEFT EPSU BATTERY 10WL FAILED AN EMERGENCY LIGHT SYS TEST. R & R THE BATTERY PACK IAW AMM 33-51-38, SYSTEM TESTED OK.SDR AALA201803089011Lens · detachedTHE AIRCRAFT WAS NOT GROUNDED. AFT LEFT ENTRY DOOR EXIT LIGHT COVER CAME OFF. REMOVED AND REPLACED AFT LEFT ENTRY DOOR EXIT LIGHT LENS IAW AMM 33-51-02.SDR ASAA2018030623782Lens · detachedFWD GALLEY R1 DOOR EMERGENCY EXIT SIGN LIGHT COVER FELL OFF. ACFT GROUNDED. VERIFIED FAULT, REPLACED THE SIGN ASSEMBLY. TEST PASSED IAW AMM 33-51-01-710-002.SDR DALA2018030701497Power Supply · inoperativeDURING SERVICE CHECK FOUND EMERGENCY LIGHTS FROM SEAT 17AB TO 20AB INOPERATIVE. REPLACED POWER PACK M1209. SYSTEM OPERATION IS NORMAL.SDR AALA201803079016Light · malfunctionedR3 DOOR EMERGENCY LIGHT ILLUMINATED AND ASSOCIATED AISLE EXIT LIGHT ILLUMINATED IN FLIGHT WITH COCKPIT EMERGENCY EXIT LIGHT SWITCH IN ARM. ALL OTHER EXIT LIGHTS EXTINGUISHED. PERFORMED TSM 33-51-00-710-001-A, AND 33-51-00-710-004-A. OPS CHECKED OK AND NO FAULSDR AALA201803079015Light · inoperativeEMERGENCY LIGHT AT ROW 18 LEFT IS INOPERATIVE. REPAIRED THE LIGHT. THE AIRCRAFT WAS GROUNDED.SDR AALA201803079011Lens · detachedL4 DOOR EXIT LIGHT LENS DETACHED ON LANDING. INSTALLED THE LENS.SDR MASA2018030613034Battery Pack · dischargedEMERGENCY LIGHTS INOP. CHARGED EMER BATTERIES.SDR MASA2018030613033Light · inoperativeR2 DOOR EMER LIGHT INOP.SDR UIEA2018030600344Light · inoperativeFLOOR EMERGENCY LIGHT INOPERATIVE. PINNED THE LIGHTS IAW AMM 33-51-10, OPS CHECKED OK.SDR UIEA2018030600345Lens · missingSEATS 37J, 32C, FWD OF 19D, EMERGENCY LIGHT LENSES ARE MISSING. REPLACED EMERGENCY LIGHTS LENSES IAW MM 33-53-00.SDR SWAA2018030820287Fuse · inoperativeLEFT SIDEWALL LIGHT ON OVERWING EMERGENCY EXIT DOOR INOPERATIVE. R & R THE FUSE IAW AMM.SDR REXA2018030500178Light · missingROW 13 EXIT ROW EMERGENCY LIGHT MISSING. REPLACED EMERGENCY LIGHT STRIP IAW AMM 33-51-01.SDR AALA201803069033Sign · inoperativeAIRCRAFT WAS NOT GROUNDED. EXIT SIGN LIGHT AT AFT GALLEY DOOR INOPERATIVE. EVALUATE THE AFT GALLEY LEFT HAND EMERGENCY EXIT LIGHT ASSEMBLY BY L2 DOOR AND REPAIR OR REPLACE AS REQUIRED. REPLACED DAMAGED AFT GALLEY LEFT HAND REAR LOWER EXIT SIGN BY GALLEY DOOR P
Back to JASC 3350