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 AALA20170502001Control Unit · faultyAIRCRAFT WAS NOT GROUNDED. AIRPLANE HEALTH MONITORING ALERTS RECEIVED FOR THE WIRELESS EMERGENCY LIGHTING SYSTEM. REMOVED AND REPLACED WELS CONTROL UNIT ABOVE L1 DOOR AND WELS CONTROL UNIT ABOVE L4 DOOR (AALA201705039008) IAW DMC-B787-A-33-51-07-01A. OPERATSDR AALA201705019039Lens · crackedEMERGENCY EXIT LIGHT AT G5 GALLEY CROSS AISLE HAS A CRACKED LENS. REMOVED AND REPLACED LIGHT ASSEMBLY IAW DMC-B787-A-33-51-03. OPS CHECKED GOOD.SDR AALA201705039025Battery Pack · no testAFT BATTERY PACK FAILED A FUNCTIONAL CHECK. REMOVED AND REPLACED AFT EMERGENCY BATTERY PACK IAW AMM 33-51-06. OPS CHECKED GOOD. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA201705039024Sign · crackedEMERGENCY EXIT SIGN BASE IS CRACKED, LIGHT OPERATES AS REQUIRED LOCATED AT AFT GALLEY SERVICE DOOR. REMOVED AND REPLACED EXIT SIGN ASSY IAW AMM 33-51-01 AT AFT GALLEY SERVICE DOOR. OPS CHECKS OK. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA201705039023Sign · crackedEMERGENCY EXIT SIGN BASE IS CRACKED, LIGHT OPERATES AS REQUIRED AT THE AFT SERVICE DOOR. REMOVED AND REPLACED EXIT SIGN ASSY IAW AMM 33-51-01. OPS CHECK OK AT AFT ENTRY DOOR.SDR AALA201705039022Bezel · brokenR2 SERVICE DOOR, EMERGENCY LIGHT BEZEL HOLDER BROKEN. R & R THE R2 EMERGENCY EXIT SIGN IAW AMM 33-51-02. OPS CHECKED GOOD.SDR AALA201705039021Battery Pack · no testFWD BATTERY PACK FAILED A FUNCTIONAL CHECK. REMOVED AND REPLACED FWD BATTERY PACK IAW AMM 33-15-06. THE AIRCRAFT WAS NOT GROUNDED.SDR DALA2017050103535Guard · out of positionEMERGENCY LIGHTS DO NOT COME ON WHEN SELECTING ON. POSITIONED EMERGENCY LIGHT SWITCH GUARD. PERFORMED OPS TEST OF EMERGENCY LIGHTS IAW AMM 33-51. OPS TESTED GOOD. ACFT OK FOR SERVICE.SDR SWAA2017050313539Lens · looseL1 DOOR SLIDE LIGHT LENS LOOSE. R & R THE LIGHT IAW AMM.SDR AALA20170429002Light · brokenEMERGENCY EXIT LOCATOR LIGHT LENS BY L2 DOOR REPORTED BROKEN BY FLIGHT CREW. REPLACED LENS AND LIGHT ASSEMBLY L2 DOOR REF AMM 33-51-01 (EMERGENCY EXIT LOCATOR SIGN), OPS CK NORMAL, OK FOR SERVICE. THE AIRCRAFT WAS NOT GROUNDED.SDR HALA2017043000163Light · looseEMERGENCY EXIT PATH LIGHT STRIP PEELING IN AFT GALLEY. RE-SECURED EMERGENCY EXIT PATH LIGHT STRIP.SDR REXA2017042900558Sign · inoperativeRT EMERGENCY OVERWING EXIT IDENTIFICATION INOP. REMOVED AND REPLACED RT EMERGENCY EXIT IDENTIFIER P/N 6020-5 IAW AMM 33-51-10. OPS CHECK GOOD.SDR SWAA2017050213508Sign · looseR2 DOOR EXIT SIGN WILL LOOSE. R&R SIGN PER MM.SDR SWAA2017050213499Lamp · inoperativeRIGHT OVERWING EMERGENCY EXIT DOOR EXTERIOR LIGHT INOPERATIVE. REPLACED THE LAMPS IAW AMM.SDR DALA2017050103528Shroud · brokenEMERGENCY LIGHT DAMAGED SEAT 43D. FOUND SEAT SHROUD BROKEN AT EMERGENCY LIGHT ATTACH POINT. REPLACED THE SHROUD IAW CMM 25-27-89. ATTACHED EMERGENCY LIGHT ASSY TO SHROUD.SDR DALA2017050103526Charger · inoperativeOVERWING EMERGENCY LIGHTS INOPERATIVE. REMOVED AND REPLACED BATTERY CHARGER AND PACK. OPERATION CHECKED GOOD.SDR R61A201705020338Power Supply · inoperativeEMERGENCY LIGHT OVER R2 SERVICE DOOR IS NOT WORKING. REMOVED AND REPLACED EMERGENCY LIGHT POWER SUPPLY IAW AMM 33-50-01.SDR R61A201705020337Power Supply · inoperativeEMERGENCY EXIT LIGHT OVER L1 PASSENGER DOOR IS NOT WORKING. REMOVED AND REPLACED EMERGENCY POWER UNIT IAW AMM 33-50-010.SDR ASAA2017042920561Lens · missingFA REPORTED AN EMERGENCY EXIT SIGN LENS MISSING FROM WALL NEAREST AFT LEFT LAVATORY. ACFT GROUNDED. INSTALLED THE LENS.SDR AALA201705019029Lens · missingAIRCRAFT WAS NOT GROUNDED. R2 DOOR EMERGENCY EXIT SIGN LENS MISSING. REPLACED EXIT SIGN LENS IAW AMM 33-51-18. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201705019028Lens · brokenBROKEN EMERGENCY LIGHT LENS AT LAVATORY D. REPLACED THE LENS IAW AMM 33-51-18. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201705019027Lens · crackedLAVATORY L EMERGENCY LIGHT LENS CRACKED. REPLACED THE LENS IAW AMM 33-51-18. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR DALA2017050103497Power Supply · inoperativeDURING CHECK, FOUND EMERGENCY LIGHT INOPERATIVE AT MID LAVATORY, CROSS AISLE, LEFT SIDE. REPLACED THE POWER SUPPLY. SYSTEM OPERATION IS NORMAL.SDR AALA201705019017Lens · missingREAR PORT SIDE EXIT LIGHT COVER MISSING. INSTALLED MISSING EMERGENCY LIGHT LENS.SDR DALA2017050103493Cover · looseEMERGENCY EXIT SIGN COVER LOOSE. REINSTLD EMERGENCY EXIT HANDLE COVER LOC 17A.SDR DALA2017050103483Lens · missingEMERGENCY EXIT SIGN LENS MISSING OVER R1 DOOR. INSTALLED A NEW LENS, OPS CHECKED GOOD.SDR AALA201705039045Lens · unsecureAIRCRAFT NOT GROUNDED. MAIN ENTRANCE 1 EXIT SIGN CAME OFF. REINSTALLED LIGHT LENS AT DOOR 1R.SDR ASOA201704285069Light · inoperativeDURING MX INSPECTION, THE FLOOR EMERGENCY LIGHT AT SEATS 8 & 9A WERE INOPERATIVE. REMOVED AND REPLACED THE EMERGENCY LIGHT, AND OPS CHECKED GOOD. ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR SWAA2017050313555Lens · brokenR2 DOOR EXIT LIGHT LENS BROKEN. R & R THE LIGHT IAW AMM.SDR HNAA2017042500140Bulb · inoperativeRED FLOOR EMERGENCY LIGHT INOPERATIVE. R & R THE BULB.SDR HNAA2017042500139Power Supply · inoperativeGROUND EMERGENCY LIGHT BY FWD EMERGENCY EXIT DIMS AND GOES OUT AFTER A FEW SECONDS R & R THE POWER SUPPLY AT SEAT 7AC IAW AMM 33-50-00.SDR AALA201705029058Light · brokenLIGHT ASSY BROKEN AT GALLEY NR 2 (EMERGENCY LIGHT). REMOVED AND REPLACED LIGHT ASSY AT GALLEY NR 2 (EMERGENCY LIGHT) IAW AMM 33-51-05. OPS CKD OK. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA201705029057Sign · brokenEMERGENCY LIGHT AT L2 DOOR BROKEN. REMOVED AND REPLACED L2 DOOR EMERGENCY EXIT SIGN IAW AMM 33-51-01. OPS CHECK GOOD. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA201705029056Sign · brokenEMERGENCY LIGHT ON FWD GALLEY BROKEN. REMOVED AND REPLACED FWD GALLEY EMERGENCY EXIT SIGN IAW AMM 33-51-01. OPS CHECK GOOD. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA201705029055Sign · brokenEMERGENCY LIGHT AT L1 DOOR BROKEN. REMOVED AND REPLACED L1 DOOR EMERGENCY EXIT SIGN IAW AMM 33-51-01. OPS CHECK GOOD. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA201705029054Holder · brokenR1 DOOR EMERGENCY SIGN BEZEL HOLDER IS BROKEN. R&R LITE ASSY IAW AMM 33 51 01 CKS GOOD. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA201705029050Closeout Panel · damagedCLOSEOUT AT SEAT 15F EMERGENCY EXIT DAMAGED. REMOVED AND REPLACED CLOSEOUT AT SEAT 15F EMERGENCY EXIT IAW ESO 90861 PAG 10123 OK FOR SVC. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA201705029049Light · brokenEMERGENCY LIGHT ASSY AT R1 DOOR BROKEN. REPLACED EMERGENCY LIGHT ASSY R1 DOOR IAW MM 33-51-01, OPS CHECK GOOD. THE AIRCRAFT WAS NOT GROUNDED.SDR SWAA2017050213533Battery Pack · failedBATTERY PACK M01672 FAILED CAPACITY TEST. R&R BATTERY PACK PER AMM AND DWG.SDR SWAA2017050213532Battery Pack · failedBATTERY PACK M01669 FAILED CAPACITY TEST. R&R BATTERY PACK PER AMM AND DWG.SDR SWAA2017050213531Battery Pack · failedBATTERY PACK M01673 FAILED CAPACITY TEST. R&R BATTERY PACK PER AMM AND DWG.SDR SWAA2017050213512Battery Pack · failedBATTERY PACK M01668 FAILED CAPACITY TEST. R&R BATTERY PACK PER AMM AND DWG.SDR SWAA2017050213497Fuse · inoperativeRIGHT EMERGENCY EXIT FLOOR LIGHT INOPERATIVE. R & R THE LIGHT ASSEMBLY FUSE IAW MM.SDR SWAA2017050113489Cover · unsecureLT OVERWING EMERGENCY EXIT SIGN COVER FELL OFF. SECURED COVER PER AMM.SDR SIMA20170428003Lamp · inoperativeAFT CABIN OVERHEAD EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE LAMP IAW AMM 33-50-08-000-801-A, AND 33-50-08-400-801-A. OPS CHECKED GOOD.SDR SIMA20170428004Lamp · inoperativeLEFT FWD EXTERNAL EMERGENCY LIGHT LAMP 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 SIMA20170428002Charger · failedEMERGENCY LIGHTS ON IN FLIGHT. REMOVED AND REPLACED THE BATTERY AND CHARGER IAW AMM 33-51-17. OPS CHECKED GOOD. NO FURTHER DEFECTS NOTED.SDR AALA201705019048Light · inoperativeSEAT MOUNTED EMERGENCY LIGHT AT SEAT 5J IS INOPERATIVE. REMOVED AND REPLACED THE LIGHT IAW AMM 33-51-05. OPERATIONAL CHECKED GOOD.SDR AALA201705019040Lens · unsecureEMERGENCY EXIT LIGHT BY G5 GALLEY LEFT SIDE HAS AN UNSECURE LENS COVER. SECURED THE LENS COVER IAW AMM 25-00-00. OPS CHECKED GOOD.SDR AALA201705019016Lens · damagedEMERGENCY EXIT LIGHT COVER DAMAGED ON R4 DOOR IN AFT GALLEY. REPLACED EMERGENCY EXIT SIGN COVER.
Back to JASC 3350