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 DALA2019041502444Light · brokenEMERGENCY LIGHTS AT SEAT 33F ARE BROKEN AND LAYING ON THE FLOOR. INSTALLED LIGHT ASSEMBLY.SDR AALA2019041549018Battery Pack · defectiveAIRCRAFT WAS GROUNDED: MAINTENANCE FOUND THE CEILING EMERGENCY LIGHTS ABOVE SEATS 7-11 WILL NOT EXTINGUISH WITH POWER OFF, CYCLING SWITCH NO HELP. REPLACED THE CEILING EMERGENCY LIGHT BATTERY PACK IAW AMM.SDR AALA2019041549017Battery Pack · inoperativeAIRCRAFT IN BASE VISIT: CEILING EMERGENCY EXIT LIGHTS INOP. BETWEEN ROW 13 AND 21. REPLACED BATTERY PACK IAW AMM 33-53-00. OPS TEST OK.SDR AALA2019041549007Ballast · inoperativeAIRCRAFT NOT GROUNDED: MAINTENANCE REPORTS ENTRY LIGHT AT FORWARD DOOR IS NOT WORKING OR VERY DIM. REPLACED BALLAST FOR ENTRY LIGHT IAW AMM 33-22-00.SDR DALA2019041542419Sign · missingMISSING EMERGENCY EXIT SIGN BTW EMERGENCY EXIT DOORS AT CABIN PAX. EXIT SIGNAL BTW EMERGENCY EXIT DOORS AT CABIN PAX WAS INSTALLED PER AMM 33-51-00.SDR MASA2019041211805Bulb · inoperativeROW 13 LT FLOOR LEVEL EMERG EXIT SIGN 1 BULB INOPSDR SWAA2019041231631Sign · brokenVERTICAL EMERGENCY EXIT SIGN ON WALL NEAR L2 DOOR BROKEN OFF. / R&R SIGN ASSEMBLY PER AMM.SDR SWAA2019041231625Power Supply · inoperativeL/H OVERWING EMERGENCY LIGHT BATTERY PACK INOP AT M1668. / R&R POWER SUPPLY PER AMM.SDR IPXA2019041240981Retainer · out of positionWHEN THE EMERGENCY LIGHTS SWITCH IS CLOSED THE EMERGENCY LIGHTS DO NOT ARM.RE-POSITIONED RETAINER. OPS CHECK OK.SDR REXA2019041200458Light · inoperativeRIGHT EXTERIOR EMERGENCY LIGHT INOP. R&R EXTERIOR EMERGENCY LIGHT IAW CRJ200 AMM 33-51-21-000-801. OPS CHECK GOOD AT THIS TIME.SDR DALA2019041202398Battery Pack · inoperativeTHE LT AND RT AFT OVERWING EXIT IDENTIFIERS ARE INOPERATIVE. MAINTENANCE REPLACED THE BATTERY PACK B5-230 PER B717 AMM 33-51. OPERATIONAL CHECK WAS GOOD. (LP #5668218)SDR DALA2019041202397Lamp · inoperativeMULTIPLE EMERGENCY LIGHT INTERIOR BULBS WERE OUT IN THE TAIL COMPARTMENT. MAINTENANCE RELAMPED ALL OF THE TAIL CONE EMERGENCY SIGNS.SDR SIMA20190411004Light · damagedBOTH AFT EMERGENCY FLOOR LIGHTING EXTRUSIONS IN LAV AREA DAMAGED. C/A-COMPLETE:INSTALLED NEW LT AND RT AFT EMERGENCY FLOOR LIGHTING EXTRUSIONS IN LAV AREA IAW AMM 53-01-02.SDR SIMA20190411003Light · inoperativeNR 3 EMERGENCY FLOOR PATH LIGHT STRIP IS INOP. C/A-COMPLETE: REMOVED AND REPLACED NR 3 FLOOR PATH LIGHT STRIP IAW AMM 33-50-12 (REF NRWC E705441 FOR OPERATIONAL TEST)SDR SIMA20190411002Light · crackedCABIN PROXIMITY LIGHT STRIPS (LT) NR 8,6,4,3,2 AND 1 ARE CRACKED. C/A-COMPLETE:RAR CABIN PROXIMITY LIGHT STRIPS EXTRUSIONS LT NR 8,6,4,3,2,1 IAW AMM 33-50-12 (REF NRWC E705441 FOR OPS TEST)SDR SWAA2019041531735Bulb · inoperativeL/H OVERWING EMERGENCY EXIT IDENTIFIER BULBS BURNED OUT. / R&R LAMP PER AMM.SDR SWAA2019041531732Bulb · inoperativeL/H OVERWING EMERGENCY EXIT IDENTIFIER BULBS BURNED OUT. / R&R EXIT SIGN LIGHT ASSEMBLY PER AMM.SDR AALA2019041549020Light · damagedAIRCRAFT IN BASE VISIT: MAINTENANCE REPORTS EMERGENCY LIGHT BESIDE GALLEY G3 DAMAGED. REMOVED AND REPLACED EMERGENCY LIGHT ASSEMBLY BESIDE G3 GALLEY IAW AMM 33-51-05.SDR AALA2019041549006Battery · failedAIRCRAFT NOT GROUNDED: MAINTENANCE REPORTS EMERGENCY BATTERY 13WL FAILED ESPU TEST. REPLACED EMERGENCY BATTERY 13WL IAW AMM 33-51-38. OPS CHECK GOOD.SDR AALA2019041529009Switch · malfunctionedAIRCRAFT NOT GROUNDED: PILOT REPORTS THE EXIT LIGHT ON DOOR 2R IS NOT ILLUMINATED. CYCLED PED SWITCH TO OFFER POS EMERGENCY EXIT LIGHTS RETURNED TO NORMAL OPERATION IAW TSM 33-51-00.SDR AALA2019041529008Battery · failedAIRCRAFT NOT GROUNDED: MAINTENANCE FOUND FWD LEFT (10WL) FAILS EPSU SYSTEM TEST. REMOVED AND REPLACED EMERGENCY POWER SUPPLY UNIT BATTERY IAW AMM 33-51-38 .SDR ASAA201904128962Lens · detachedEMERGENCY EXIT SIGN AT OVERWING EXIT FELL OFF. GROUNDED - YES. REATTACHED EMERGENCY EXIT LENS COVER REF B737-800 AMM TASK 33-51-01, OK.SDR AALA20190412001Battery Pack · failedMAINTENANCE REPORTS EMERGENCY BATTERY 13WL FAILED THE EPSU TEST. REPLACED THE EMERGENCY BATTERY 13WL IAW AMM 33-51-38. OPS CHECK GOOD.SDR DALA2019041202415Cover · detached(LOG 5834696) DURING INSPECTION FOUND COVER FOR EMERGENCY EXIT LINER OFF. REINSTALLED COVER ON EMERGENCY EXIT LINER, AFT RT EXIT PER B737 AMM 25-22.SDR SWAA2019041231660Battery · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATIONS M1673. R&R BATTERY PER MM.SDR SWAA2019041231656Light · inoperativeR/H EMERGENCY BULL NOSE LIGHT INOP AT ROW 22. RELAMPED LIGHT IAW AMM.SDR SWAA2019041231630Battery · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATIONS M1672. / R&R BATTERY PER MM.SDR SWAA2019041231626Housing · damagedL/H EXTERNAL EMERGENCY LIGHT HOUSING JUST AFT OF OVERWING EXIT DAMAGED. / R&R LIGHT ASSEMBLY PER AMM.SDR QXEA2019041200172Light · looseCREW REPORTS EMERGENCY LIGHT STRIP LOOSE BY MCD @ ROW 1. REMOVED FROM SERVICE. RESECURED EMERGENCY LIGHT STRIP AT ROW 1 AND SEALED WET FLOOR AS REQUIRED. NO FURTHER DEFECTS. AIRCRAFT RETURNED TO SERVICE.SDR IPXA2019041214962Bulb · inoperativeEMERGENCY LIGHT HAS THREE INOP BULBS.R&R THREE BULBS IN EMERGENCY LIGHT PEN AMM 33-51-01-2.SDR DALA2019041102393Battery Pack · inoperativeTHE EMERGENCY LIGHTS IN ROW 5, 6, & 7 ARE INOPERATIVE. MAINTENANCE REPLACED THE BATTERY PACK IAW B717 AMM 33-55. ALL CHECKS ARE GOOD. (LP #5531007)SDR MASA2019041111804Lamp · inoperative3RD FROM AFT EMERG CEILING LIGHT INOP. RELAMPED.SDR REXA2019041100457Battery Pack · inoperativeFOUND EMERGENCY LIGHTING INOP. REMOVED AND REPLACED BATTERY PACK #4 IAW CRJ 200 AMM 33-51-04. REMOVED AND REPLACED BATTERY CHARGER ASSEMBLY #4 IAW CRJ 200 AMM 33-51-05. OPS CHECK GOOD.SDR MYWA2020021300157Battery Pack · dischargedWE HAD A FEW EMERGENCY LIGHT BATTERY PACK P/N: D717-01-100 THAT FAILED DURING FUNCTIONAL CHECK. 11472,11388,11388, 11387, 11386,11385,210667,450464,458637,458741SDR SWAA2019050132169Light · inoperativePASSENGER CABIN NR 4 LT STOW BIN EMERGENCY LIGHT INOP. R&R LIGHT PER AMM.SDR ASOA20190415053Bulb · inoperativeDURING MX INSPECTION THE EMERGENCY LIGHT OVER SEAT 18CD WAS INOP. MX REMOVED AND REPLACED THE BULB WITH OPS CHECK GOOD. A/C WAS APPROVED FOR RETURN TO SERVICE.SDR ASOA20190415052Bulb · inoperativeDURING MX INSPECTION THE EMERGENCY LIGHT OVER SEAT 18A WAS INOP. MX REMOVED AND REPLACED THE BULB WITH OPS CHECK GOOD. A/C WAS APPROVED FOR RETURN TO SERVICE.SDR DALA2019041102445Charger · inoperativeEMERGENCY SIGN LIGHT ON LEFT SIDE OF CABIN BETWEEN 1ST CLASS AND ECONOMY IS INOPERATIVE. REPLACED BATTERY CHARGER M9011. SYSTEM OPERATION IS NORMAL.SDR YENA2019041500193Lamp · inoperativeFT # 1234, SEAT 1C EMERGENCY LIGHT IS BROKEN. RELAMPED EGRESS LIGHT & INSTALLED LIGHT ASSY AS REQD. OPS CHK GOOD IAW AMM 33-51-00SDR AALA201904129005Light · inoperativeAIRCRAFT WAS NOT GROUNDED: ROW 34 EMERGENCY DOME LIGHT INOPERATIVE. MAINTENANCE RESECURRED GND WIRE FOR ROW 34 EMERGENCY DOME LIGHT (210WL) PER ESPM 20-44-71 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR SWAA2019041231658Fuse · inoperativeLOWER EXIT LOCATOR SIGN INOP. R&R FUSE PER WDM AND AMM.SDR SWAA2019041231657Fuse · inoperativeL/H OVERWING EMERGENCY EXIT LOCATOR SIGN LIGHT INOP. R&R FUSE PER WDM AND AMM.SDR SWAA2019041231651Fuse · failedOVERWING ESCAPE HATCH LIGHT INOP. / R&R FUSE PER WDM AND AMM.SDR SWAA2019041231641Light · debondedL/H EMERGENCY LIGHT DEBONDED ON THE STOW BIN BULLNOSE AT ROW 9. / REPAIRED LIGHT IAW SOPM AND DWG.SDR SWAA2019041231629Light · inoperativeL/H SIDE EMERGENCY EXIT OVERWING LIGHT INOP. / REPAIRED LIGHT PER AMM.SDR HNAA2019041100095Power Supply · inoperative628 33-51 0016860 10APR19 SBY CLOSE
R/H OVERWING EMERGENCY EXIT LIGHT INOP
FACT 10APR19 08:38 SBY
REMOVED EMERGENCY LIGHT #4 BATTERY & POWER SUPPLY IA
W AMM 33-50-04-000-801A & AMM 33-50-04-000-802A R&R F1 FUSE IN PSDR AALA201904119014Light · inoperativeAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT INOPERABLE BY L2 DOOR. MAINTENANCE REPLACED EMERGENCY LIGHT ASSEMBLY PER JOB CARD 26L00005005 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR SIMA201904110002Lamp · inoperativeCOCKPIT EMERGENCY LIGHT INOP-C/A-REMOVED AND REPLACED COCKPIT EMERGENCY LIGHT LAMP IAW EMB AMM 33-50-05-000-801-A AND 33-50-05-400-801-A. OPC GOOD NO FURTHER DEFECTS NOTED. END.SDR SWAA2019041131624Battery Pack · inoperativeEMERGENCY LIGHTS IN FORWARD GALLEY AREA INOP ABOVE R1 DOOR AT LOCATION M1674. R&R BATTERY PACK PER AMM.SDR SWAA2019041131623Power Supply · inoperativeEMERGENCY LIGHTS IN FORWARD GALLEY AREA INOP ABOVE R1 DOOR AT LOCATION M1674. R&R BATTERY POWER SUPPLY PER AMM.
Back to JASC 3350