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 UIEA2017110602183Power Supply · inoperativeLEFT EMERGENCY OVERWING LIGHT INOPERATIVE. REMOVED AND REPLACED THE POWER SUPPLY, OPS CHECKED GOOD IAW AMM 33-51-07.SDR K11A2017110573302Battery Pack · dischargedEMERGENCY LIGHT FAILED LIGHTS TEST. R&R BATTERY PACK IAW AMM 33-51-51, OP'S CHECK GOOD.SDR K11A2017110573301Battery Pack · dischargedEMERGENCY LIGHT FAILED LIGHTS TEST. R&R BATTERY PACK IAW AMM 33-51-51, OP'S CHECK GOOD.SDR DALA2017112708350Charger · inoperativeDURING INSPECTION, FOUND THE RT AFT EMERGENCY LIGHTS INOPERATIVE. MAINTENANCE R & R THE CHARGER IAW AMM 33-51. OPS CHECKED GOOD.SDR SWAA2017110817696Battery Pack · dischargedL1 DOOR UPPER EMERGENCY LIGHT INOP. REPAIRED BATTERY PACK PER AMM.SDR SWAA2017110817695Battery Pack · dischargedR1 DOOR LOWER EMERGENCY LIGHT INOP. REPAIRED BATTERY PACK PER AMM.SDR SWAA2017110717622Lamp · inoperativeLEFT AFT SERVICE DOOR EXTERIOR EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS IAW AMM.SDR AALA201711079010Battery Pack · dischargedDURING AN EMERGENCY LIGHTS TEST, RECIEVED A FAULT CODE FOR THE EXIT SIGNS EPSU 14WL. REMOVED AND REPLACED THE BATTERY PACK.SDR ASAA2017110522443Lamp · failedEMERGENCY LIGHT EXIT SIGN ADJACENT TO THE L2 DOOR HAS SEVERAL LAMPS INOPERATIVE. ACFT GROUNDED. REPLACED THE LAMPS AND TESTED IAW AMM 33-51-01-960-801. OPS NORMAL.SDR ASAA2017110522442Lamp · failedEMERGENCY LIGHT EXIT SIGN ADJACENT TO THE RIGHT AFT OVERWING EXIT HAS SEVERAL LAMPS INOPERATIVE. ACFT GROUNDED. REPLACED THE LAMPS AND TESTED IAW AMM 33-51-01-960-801, OPS NORMAL.SDR ASAA2017110522431Power Supply · failedEMERGENCY LIGHTS LT AFT AREA & GALLEY INOP DURING LIGHT TEST (T/C 78233008). GROUNDED - YES. REMOVED AND REPLACED AFT GALLEY LT EMERGENCY LIGHT POWER SUPPLY REF AMM 33-51-06. LIGHTS OPS CK GOOD.SDR ASAA2017110522430Lens · detachedOVERHEAD PLASTIC EXIT SIGN ABOVE EXIT ROW 15 OFF. GROUNDED - YES. REINSTALLED LENS.SDR AALA201711069010Lens · missingL4 DOOR EXIT SIGN LENS MISSING.SDR AALA201711069005Lens · crackedEMERGENCY LIGHT LENS CRACKED AT THE RIGHT FWD GALLEY. REPLACED THE LENS.SDR AALA201711069016Sign · detachedEXIT SIGN AT THE L3 DOOR FELL OFF. ATTACHED THE SIGNSDR DALA2017110607953Lens · missingEMERGENCY LIGHT RED LENS MISSING AT GALLEY AISLE INTERIOR. SECURED THE RED LENS.SDR REXA2017110501151Lamp · burned outLEFT FORWARD EMERGENCY LIGHT BURNED OUT. REPLACED THE LAMPS IAW AMM 33-51-21.OPS CHECKED GOOD.SDR MASA2017110512743Bulb · inoperativeROW 21 OVERHEAD EMERGENCY LIGHT INOPERATIVE. REPLACED THE BULB.SDR AALA201711069052Charger · inoperativeAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT OVERWING AT ROW 17ABC IS INOPERATIVE. REMOVED AND REPLACED CHARGER ASSEMBLY (POWER SUPPLY) M10567 PER AMM 33-51-07. OPERATIONAL CHECK GOOD.SDR AALA201711069051Lens · missingAIRCRAFT WAS NOT GROUNDED. SEAT MOUNTED AFT WHITE EMERGENCY ESCAPE LIGHT AT SEAT 15D HAS A MISSING LENS COVER. INSTALLED LENS COVER PER AMM 33-51-11. OPERATIONAL CHECK GOOD.SDR AALA201711069049Light · inoperativeAIRCRAFT WAS NOT GROUNDED. EMERGENCY ESCAPE PATH LIGHT AT SEAT 18D IS INOPERATIVE. REMOVED AND REPLACED LIGHT ASSEMBLY PER AMM 33-60-98. OPERATIONAL CHECK GOOD.SDR AALA201711069048Sign · detachedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN BY THE R2 DOOR IS DETACHED. REPLACED EXIT SIGN PER AMM 33-25-00. OPERATIONAL CHECK GOOD.SDR AALA201711069046Lens · crackedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT ON THE L1 DOOR HAS A CRACKED LENS COVER. REMOVED AND REPLACED LENS COVER PER AMM 33-51-00. OPERATIONAL CHECK GOOD.SDR AALA20171104001Portable Light · inoperativeAIRCRAFT WAS NOT GROUNDED. COCKPIT PORTABLE EMERGENCY EXIT LIGHT IS INOPERATIVE. REMOVED AND REPLACED LIGHT ASSEMBLY PER AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA201711079030Battery · faultedEMERGENCY POWER SUPPLY BATTERY FAULTED DURING A BITE TEST. REPLACED THE BATTERY IAW AMM 33-51-38.SDR AALA201711079029Battery · faultedEMERGENCY POWER SUPPLY BATTERY FAULTED DURING A BITE TEST. REPLACED THE BATTERY IAW AMM 33-51-38.SDR AALA201711069025Sign · brokenR1 LOWER EMERGENCY EXIT SIGN BROKEN. REPLACED THE SIGN AND PERFORMED AN OPS TEST IAW AMM 33-51-33.SDR AALA201711069024Sign · brokenL1 LOWER EMERGENCY EXIT SIGN BROKEN. REPLACED THE SIGN AND PERFORMED OPERATIONS TEST IAW AMM 33-51-13.SDR AALA201711069022Battery · dischargedEMERGENCY POWER SUPPLY UNIT BATTERY FAULTED DURING A BITE TEST. REPLACED THE EMERGENCY POWER SUPPLY BATTERY IAW AMM 33-51-38.SDR AALA20171105001Battery · no testEMERGENCY BACKUP BATTERY FAILED DURING CIDS TEST & PS CHECK. REPLACED EMERGENCY BACKUP BATTERY IAW AMM 33-51-38.SDR REXA2017110401156Battery Pack · inoperativeFOUND BOTH REAR EXTERNAL EMERGENCY LIGHTS INOPERATIVE. REMOVED AND REPLACED THE BATTERY PACK AT PS38 IAW AMM 33-51-17. OPS CHECKED GOOD. NO OTHER DEFECTS NOTIED.SDR DALA2017110607961Power Supply · inoperativeDURING INSPECTION FOUND RT AFT OVERWING EXTERIOR EMERGENCY LIGHT INOPERATIVE. MAINTENANCE R&R POWER SUPPLY M1671 PER AMM 33-51. OPS CHECK GOOD.SDR AALA201711069009Battery · inoperativeL3 OVERWING EMERGENCY EXIT LIGHT INOPERATIVE. REPLACED EMERGENCY LIGHT BATTERY IAW AMM.SDR AALA201711069006Lens · damagedDOOR AFT LEFT EMERGENCY LIGHT LENS DAMAGED. INSTALLED A NEW LENS.SDR AALA201711069004Lens · crackedEXIT LIGHT LENS AT THE R2 DOOR FOUND CRACKED. REPLACED THE LENS IAW AMM.SDR 29GA2017110500001Sign · unsecureFLIGHT 0099, EXIT SIGN IN CEILING FELL OUT. RE-SECURED ROW 7 EXIT LOCATOR IAW AMM 33-50-45-04. OPS CHECK GOOD.SDR SWAA2017110817651Sign · brokenRIGHT OVERWING DOOR EXIT SIGN BROKEN. R & R THE SIGN MM.SDR SWAA2017110817646Sign · detachedLEFT EMERGENCY EXIT ROW EXIT SIGN FELL OFF. REPLACED THE SIGN ASSEMBLY IAW MM.SDR SWAA2017110717624Lamp · inoperativeRIGHT EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS IAW AMM.SDR SWAA2017110717623Light · damagedRIGHT EMERGENCY LIGHT STRIP DAMAGED AT ROW 1. R & R THE LIGHT STRIP IAW AMM.SDR ASOA201711035206Bulb · inoperativeCREW REPORTED TWO AFT OVERHEAD EMERGENCY LIGHTS INOPERATIVE. MX REMOVED AND REPLACED THE BULBS AND OPS CHECKED GOOD. ACFT WAS APRROVED FOR RETURN TO SERVICE.SDR YENA201711030884Switch · inoperativeEMERGENCY LIGHT SWITCH WILL NOT TURN LIGHTS OFF. R & R THE LIGHT SWITCH IAW ESPM 20-45-51. OPS OK IAW AMM 33-51-00.SDR ASAA2017110322444Battery Pack · failedWHILE ACCOMPLISHING TC 78233008. FOUND THE EMERGENCY EXIT LIGHTS L1063, L1065 AND L1417 INOPERATIVE. ACFT GROUNDED. REMOVED AND REPLACED THE BATTERY PACK IAW AMM 33-51-06-960-805 AND WDM 33-51-12. LIGHTS OPS TESTED NORMAL.SDR DALA2017110607960Battery Pack · dischargedEMERGENCY LIGHTS INOP ROW 5, 6, 7CD. R&R BATTERY PACK FOR EMERGENCY LIGHTS ROW 5, 6, 7CD.SDR SWAA2017110617594Sign · detachedEMERGENCY EXIT SIGN OVER ROW 15 DETACHED. REATTACHED THE SIGN IAW AMM.SDR ASOA201711047026Battery Pack · dischargedAFT OVERWING EMERGENCY LIGHT INOP. REMOVED AND REPLACED THE NR 4 BATTERY AND CHARGER ASSY. OPS CHECK GOOD. AIRCRAFT RELEASED AND RETURNED TO SERVICE.SDR CALA2017110303930Lens · brokenON CHK FOUND 47G SEAT MOUNT EMER LT COVER BROKEN. COVER REPLACED LT CHK OK IAW AMM 33-51-00.SDR CALA2017110303927Light · inoperativeDOOR 2R EMERGENCY SLIDE LIGHT INOP. REPLACED DOOR 2R EMER SLIDE LAMP REF AMM 33-51-06. LIGHT CHECKS GOOD.SDR CALA2017110303925Battery · faultyPTP PANEL SYSTEM TEST DISPLAYS ATA 33-51-38 EPSU BATTERY EMER R T/S AND FOUND BATTERY 11WL AND 12WL TO BE BAD. REMOVED AND REPLACED 11WL AND 12WL BATTERY REF AMM 33-51-39 OPS CHECK GOOD.SDR CALA2017110303923Battery Pack · dischargedEMERG LIGHTS RT FWD OVERHEAD BINS NOT WORKING. REPLACED BATTERY PACK M1676 CKS OK.
Back to JASC 3350