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 AALA201811209030Battery Pack · no testWHILE ACCOMPLISHING JC 33C20033002, THE R3 DOOR EMERGENCY POWER SUPPLY BATTERIES FAILED. MAINTENANCE REPLACED THE BATTERIES, AND PERFORMED SATISFACTORY OPERATIONAL CHECK IAW AMM 33-51-38.SDR AALA201811209021Battery · no testWHILE ACCOMPLISHING JOBCARD 33C20033002, THE R1 DOOR EMERGENCY POWER SUPPLY BATTERIES FAILED. MAINTENANCE REPLACED THE POWER SUPPLY BATTERIES AND PERFORMED SATISFACTORY OPERATIONAL CHECK IAW AMM 33-51-38.SDR AALA201811209019Power Supply · no testEMERGENCY POWER SUPPLY RIGHT CENTER, WAS INOPERATIVE. MAINTENANCE REPLACED THE POWER SUPPLY IAW AMM 33-51-38, AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR RAIA2018112000001Bulb · inoperativeAFT OVERWING EMER LIGHT#5 IS INOP- R&R RH OVERWING EMERGENCY LIGHT BULB OPS CHECK GOODSDR AALA201811209022Lens · missingSEAT MOUNTED EMERGENCY EXIT LIGHT LENS WAS MISSING FROM SEAT 22D. REPLACED THE LENS. OPS CHECKED GOOD, OK FOR SERVICE.SDR AALA201811209007Lens · detachedFLIGHT ATTENDANT REPORTED THE EMERGENCY LIGHT LENS AT SEAT 9D WAS DETACHED. SECURED THE LENS. CHECKED OK IAW AMM 33-50-00.SDR AALA201811209006Lens · missingSEAT MOUNTED EMERGENCY EXIT LIGHT LENS WAS MISSING FROM SEATS 10C AND 22D. REPLACED THE LENSES. OPS CHECKED GOOD, OK FOR SERVICE.SDR AALA201811209004Power Supply · no testPOWER SUPPLY FAILED TO TEST ON THE CIDS PANEL. THE AIRCRAFT WAS GROUNDED. REPLACED THE POWER SUPPLY IAW AMM 33-51-38.SDR SWAA2018112026938Battery · failedAFT GALLEY EMERGENCY LIGHT BATTERY FAILED DEEP CYCLE TEST. R&R BATTERY PER AMM.SDR SWAA2018112026933Lens · unsecureRT OVERWING EMERGENCY EXIT LIGHT COVER FELL OFF. REINSTALLED LENS PER MM.SDR SWAA2018112026932Light · inoperativeRT LOWER EMERGENCY EXIT SIGN LIGHT INOP. RELAMPED LIGHT PER MM.SDR SIMA2018112019001Cradle · brokenAFT FA FLASHLIGHT HOLDER ASSEMBLY BROKEN-C/A-FLIGHT CREW PLACARDED AFT FA FLASHLIGHT HOLDER REF: MEL 25- 60 AUTH: 110658-CMOC: 056020SDR MASA2018111911538Light · inoperativeRH AFT EXT OVWNG EMERG LIGHT INOP. PLACED ON MELSDR MASA2018111911537Light · inoperativeROW 9 CEILING FLOOD LIGHT INOP. PLACED ON MELSDR DALA2018111906671Battery Pack · inoperativeDURING THE SERVICE CHECK, MAINTENANCE FOUND THE AFT LEFT LOWER EMERGENCY EXIT SIGN WAS INOPERATIVE. MAINTENANCE REPLACED THE BATTERY FOR THE AFT LEFT LOWER EMERGENCY EXIT SIGN PER B717 AMM 33-55. (LP #5088722)SDR IPXA2018112196109Connector · inoperativeEMERGENCY LIGHT TEST FAILED. REPLACED THE POWER SUPPLY IAW 33-51-01-501, TEST FAILED. THE EMERGENCY LIGHTS WOULD NOT GO OFF. INSTALLED THE ORIGINAL POWER SUPPLY. RESEATEDA LOOSE CONNECTOR. OPS CHECKED GOOD IAW AMM 33-50-00.SDR R61A2018112181172Lens · crackedR2 DOOR EXIT LENS COVER CRACKED. R&R EXIT LENS COVER IAW AMM 20-10-09.SDR SWAA2018112127005Light · unsecureCENTER WING AISLE EMERGENCY EXIT OVERHEAD LIGHT FELL OFF. SECURED LIGHT IAW AMM.SDR HALA2018112090339Sign · brokenDOOR 3R EXIT SIGN AND VENT COVER BROKEN. RE-SECURED DOOR 3R EXIT SIGN. LP 5409101SDR AALA2018112099031Battery Pack · inoperativeDURING ACCOMPLISHMENT OF WORK CARD 2735, NOTICED A SEQUENCE OF THE THREE CEILING EMERGENCY LIGHTS WERE OFF. MAINTENANCE REPLACED THE BATTERY PACK IAW AMM 33-51-06.SDR AALA2018112099030Connector · not seatedSEAT EMERGENCY LIGHT AT THE L3 WAS INOPERATIVE. MAINTENANCE SEATED THE ELECTRICAL CONNECTOR AND PERFORMED SATISFACTORY OPERATIONAL CHECK IAW AMM 33-51-00.SDR SWAA2018111926882Light · inoperativeAFT ENTRY EXTERNAL EMERGENCY LIGHT INOP. RELAMPED LIGHT PER AMM.SDR SWAA2018111926874Light · inoperativeL2 DOOR EXTERNAL SLIDE LIGHT INOP. RELAMPED LIGHT IAW AMM.SDR ASAA2018111986894Battery Pack · dischargedEMERGENCY LIGHT EXIT SIGN ABOVE L-2 DOOR, EXIT LOCATOR SIGN AT L-2 DOOR, AND EXTERIOR SLIDE LIGHT AT L-2 DOOR ARE INOP. GROUNDED - YES. REFERENCE B737-900 SSM 33-51-14-102 - REMOVED, REPLACED, AND TESTED M1673 EMERGENCY LIGHT BATTERY PACK PER B737-900 AMM 33-5SDR ASAA2018111986893Lens · brokenEMERGENCY LIGHT EXIT LOCATOR SIGN AT RIGHT FORWARD OVERWING EXIT IS BROKEN. GROUNDED - YES. REMOVED, REPLACED, AND TESTED EXIT LOCATOR SIGN ASSY PER B737-900 AMM 33-51-01-960-802 - OPS NORMAL.SDR ASAA2018111986892Lamp · inoperativeEMERGENCY LIGHT EXIT LOCATOR SIGN AT R-1 DOOR HAS SEVERAL LAMPS INOP. GROUNDED - YES. RELAMPED AND TESTED PER B737-900 AMM 33-51-01-960-801 - OPS NORMAL.SDR ASAA2018111986891Lamp · inoperativeEMERGENCY LIGHT EXIT LOCATOR SIGN AT L-1 DOOR HAS SEVERAL LAMPS INOP. GROUNDED - YES. RELAMPED AND TESTED PER MM 33-51-01-960-801 - OPS NORMAL.SDR AALA201811199033Lens · detachedSEAT 22C EMERGENCY LIGHT LENS WAS MISSING. FOUND AND ATTACHED THE LENS. OPS CHECKED GOOD.SDR AALA201811199034Lens · missingEXIT ROW EMERGENCY LIGHT LENS MISSING. THE AIRCRAFT WAS GROUNDED. INSTALLED THE SEAT MOUNTED EMERGENCY LIGHT LENS IAW AMM 33-51-18. OPS CHECKED NORMAL.SDR RAIA2018111980001Flashlight · weakFWD FA FLASHLIGHT IS DIM- R&R FWD FA FLASHLIGHT OPS CHECK GOODSDR IPXA2018111986080Light · malfunctionedEMERGENCY LIGHTS INOPERATIVE. REPLACED THE POWER SUPPLY IAW MM 33-51-01-501, TEST FAILED. EMERGENCY LIGHTS WOULD NOT TURN OFF. INSTALLED THE ORIGINAL POWER SUPPLY.SDR AALA201811199039Battery Pack · inoperativeOVERHEAD EMERGENCY LIGHTS WERE INOPERATIVE IN THE CABIN FROM ROWS 29 - 31. REPLACED THE BATTERY PACK IAW AMM 33-53-00.SDR AALA201811199038Battery Pack · inoperativeOVERHEAD EMERGENCY LIGHTS WERE INOPERATIVE IN THE CABIN FROM ROWS 8 - 10. REPLACED THE BATTERY PACK IAW AMM 33-53-00.SDR DALA2018111986672Battery Pack · inoperativeTHE TAIL CONE CAT WALK EMERGENCY LIGHTS ARE INOPERATIVE. MAINTENANCE REPLACED THE EMERGENCY BATTERY B5-260 FOR THE TAIL CONE WALK WAY AND THE EMERGENCY LIGHTS RETURNED TO NORMAL OPERATION. (LP #5100286)SDR DALA2018111986670Battery Pack · inoperativeMULTIPLE EMERGENCY LIGHTS OUT IN THE CABIN. MAINTENACE REPLACED BATTERY PACKS B5-118 AND B5-119 REF B717 AMM 33-51. OPERATIONAL CHECK IS GOOD. (LP #4722813)SDR MASA2018111811533Battery · dischargedALL EMER LIGHTS INOP. RECHARGED BATTERY.SDR AALA201811209017Flashlight · inoperativeFORWARD RIGHT CABIN ATTENDANT EMERGENCY FLASHLIGHT WAS INOPERATIVE. MAINTENANCE REPLACED THE FLASHLIGHT IAW MM 25-64-00, AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA2018112099028Lens · looseTHE L2 DOOR PLASTIC COVER LENS THE EMERGENCY EXIT SIGN WAS LOOSE. MAINTENANCE SECURED THE LIGHT LENS AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA2018112019001Battery · no testEMERGENCY LIGHT POWER SUPPLY BATTERY FAILED A PS21 CHECK. MAINTENANCE REPLACED THE BATTERY AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA2018112018008Battery Pack · no testDURING ACCOMPLISHMENT OF WORK CARD 2735, FOR THE EMERGENCY LIGHTS BATTERY PACKS , NOTICED SEQUENCE OF THE 3 CEILING EMERGENCY LIGHTS OFF AT THE LT AISLE. MAINTENANCE REPLACED THE BATTERY PACK AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR DALA2018112096729Light · missingDOOR 1R RED EMERGENCY PATH LIGHT MISSING, REPLACED DOOR 1R PATH LIGHTSDR SWAA2018112026969Battery Pack · dischargedLT EMERGENCY AISLE LIGHT INOP AT BS 560. R&R BATTERY PACK PER AMM.SDR SWAA2018112026968Battery Pack · dischargedLT BOTH OVERWING EMERGENCY ESCAPE GROUND LIGHT INOP. R&R BATTERY PACK PER AMM.SDR SWAA2018112026945Battery Pack · dischargedLT EMERGENCY AISLE LIGHT INOP AT BS 640. R&R BATTERY PACK PER AMM.SDR DALA2018112096727Sign · detachedSHIP 692 THE EXIT SIGN AT DOOR 2L FELL OFF. CORRECTIVE ACTION: RE-SECURED EXIT SIGN AT SAME. (5357886)SDR YENA2018112070781Bulb · inoperativeFT # 1654,SJU-FLL. MID CABIN OVERHEAD EMERGENCY EXIT LIGHT ONLY HAS ONE LIGHT BULB WORKING; RELAMPED PER AMM 33-51-17 ALL BULBS CKS OK.SDR DALA201811206713Lens · damaged(AIRCRAFT 7110, L/P 0830341) EMERGENCY FLOOR LIGHTING DAMAGED OR INOPERATIVE / LOCATIONS:103 / INTERIOR. INSTALLED LENS OK FOR SVC.SDR ASAA2018111976895Lens · brokenR/H FWD OVERWING EXIT LIGHT LENS BROKEN. GROUNDED - YES. REPLACED R/H FWD OVERWING EXIT SIGN LENS PER B737-900 AMM 33-51-01 NO FURTHER DEFECTS NOTED.SDR HALA2018111900591Lens · missingMISSING EMERGENCY LIGHT COVER BY 4R DOOR ISLE. // REMOVED AND REPLACED EMERGENCY LIGHT COVER BY 4R DOOR. OPS CHK GOOD, OK TO CONTINUE.SDR AALA201811198009Battery Pack · inoperativeEXTERIOR LEFT EMERGENCY LIGHT AT THE AFT FUSELAGE WAS INOPERATIVE. REPLACED THE BATTERY CHARGER AND BATTERY IAW AMM 33-51-07. OPS CHECKED NORMAL.
Back to JASC 3350