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 DALA2018111976676Battery Pack · inoperativeEMERGENCY ROW LIGHTS ABOVE SEATS 24, 25 INOP. REMOVED AND REPLACED BATTERIES PER MD88 AMM 33-53. ALL LIGHTS OPS CHECK GOOD. (LP5001016)SDR DALA2018111976675Battery Pack · inoperativeFOUND ROW 10-12 CEILING OVERHEAD EMER LIGHTS OUT ON SVC. R+R ROW 10-12 CEILING LIGHT BATTERY PER MD AMM 33-50. OPS CHECK GOOD. (LP4755447)SDR DALA2018111986673Battery Pack · inoperativeTHE CAT WALK IN THE TAIL CONE LOWER EMERGENCY LIGHTS WERE FOUND TO BE INOPERATIVE. MAINTENANCE REPLACED THE BATTERY IN REAR OF AIRCRAFT AND THE CAT WALK EMERGENCY LIGHTS RETURNED TO NORMAL FUNCTION IAW B717 AMM 33-50. (LP #5174986)SDR MASA2018111711526Battery · dischargedEMERGENCY LIGHTS INOP. CHARGED BATTERIES.SDR SWAA2018111926910Light · inoperativeLT EMERGENCY LIGHT INOP AT SEAT ROW 9. R&R LIGHT PER AMM.SDR SWAA2018111926873Power Supply · inoperativeRT OVERWING EXIT EXTERIOR EMERGENCY LIGHT INOP. R&R POWER SUPPLY PER AMM.SDR HALA2018111900599Lens · loose3L DOOR EXIT LIGHT COVER LOOSE.// RE-SECURED 3L DR EXIT LIGHT COVER. SECURITY CK GOODSDR HALA2018111900598Light · missingEXIT FLOOR LIGHTING MISSING IN FIRST CLASS. // RE-SECURED EXIT FLOOR LIGHTING STRIP IN FIRST CLASS AREA.SDR AALA201811199014Battery Pack · no testDURING AN EMERGENCY LIGHT TEST, RECEIVED CODE 335100, BATTERY EPSU 13WL AFT LEFT FAULT. REPLACED THE BATTERY IAW AMM 33-51-38.SDR MASA2018111611525Light · inoperativeAFT EMER FLOOD LIGHT INOP. RELAMPED.SDR KCSA201811161319Light · inoperativeAFT 2 UPPER DECK EMERGENCY LIGHTS INOPSDR PNSA2018111603Power Supply · failedEMERGENCY LIGHTING POWER SUPPLY ON AIRCRAFT INSPECTION FAILED FOUND 23LN FAILEDSDR DALA2018111606643Battery Pack · inoperativeTHE OVERHEAD EMERGENCY EXIT SIGN FOR THE OVERWING EXITS WAS INOPERATIVE. MAINTENANCE REPLACED THE BATTERY PACK B5-120 AND THE POWER SUPPLY REF B717 AMM 33-51. OPERATIONAL CHECK WAS GOOD. (LP #4616688)SDR U2RA201811210001Lamp · burned outDURING MAINTENANCE INSPECTION FOUND EMERGENCY AISLE LIGHT AT BULLNOSE OF OVERHEAD BIN 6A INOPERATIVE. REMOVED AND REPLACED AISLE LIGHT LAMP AT BIN 6A OVERHEAD BULLNOSE IN ACCORDANCE WITH B757 AMM 33-51-05. OPERATIONAL CHECK OF LIGHT FOUND SATISFACTORY.SDR SWAA2018112026948Lens · crackedAFT ENTRY LOWERED CEILING EXIT SIGN, AFT LENS CRACKED. R&R SIGN ASSEMBLY IAW AMM.SDR SWAA2018111926926Battery Pack · dischargedEMERGENCY LIGHT BATTERY PACK INOP AT LOCATION M2335. R&R BATTERY PACK PER AMM.SDR SWAA2018111926917Strip · delaminatedRT AFT FLOOR EGRESS STRIP DELAMINATED. R&R STRIP PER DWG.SDR SWAA2018111926914Charger · inoperativeEMERGENCY LIGHT BATTERY PACK INOP AT LOCATION M2335. R&R CHARGER PER AMM.SDR YENA2018111950780Power Supply · failedFT # 1354, DCA-BOS. LH LOWER EXTERNAL EMERGENCY EXIT LIGHT INOP; R & R POWER SUPPLY #6, OPS NORMAL REF AMM 33-50-01.SDR DALA2018111966687Lens · missing(AIRCRAFT 5805, L/P 3303788) ON PREFLIGHT FOUND EXIT SIGN LENS MISSING AT ROW 37. REPLACED EXIT SIGN LENS. OPN GOOD. REF B757 AMM 33-24.SDR DALA2018111966686Battery Pack · inoperative(AIRCRAFT 6712, L/P 4697788) ON SVC CK FOUND EMERGENCY LIGHTS INOP ON SECTION OF SEAT ROWS 23-26 AND L OVERWING EXIT SIGNS. REMOVED AND REPLACED BATTERY PACK AT POWER SUPPLY M10567 REF. B757 AMM 33-51-07.SDR AALA2018111979008Power Supply · inoperativePOWER SUPPLY AT THE R3 DOOR INOPERATIVE. REPLACED POWER SUPPLY IAW AMM 33-51-06. OK FOR SERVICE.SDR CALA2018111602384Power Supply · inoperativeLT AFT OVER WING EXIT IN DOOR EEL LIGHTS INOP. REPLACED POWER SUPPLY REF AMM 33-51-06 OPS CHECKED OK. ACCOMPLISHED INSPECTION OF THE INSTALLATION OF POWER SUPPLY REF AMM 33-51-06.SDR CALA2018111602381Light · inoperativeSTOWBIN EEL LIGHT AT 3FE INOP. RELAMPED REF AMM 33-51-03 OPS CHECKED OK. ACCOMPLISHED THE OPERATIONAL CHECK OF THE EEL LIGHT AT 3FE.SDR CALA2018111602380Light · inoperativeRT AFT OVER WING EXIT IN DOOR EEL LIGHTS INOP. RELAMPED REF AMM 33-51-03 OPS CHECKED OK. ACCOMPLISHED THE INSPECTION AND OPERATIONAL CHECK OF RT AFT OVER WING EXIT EEL LIGHT.SDR AALA201811179009Housing · crackedTHE AIRCRAFT WAS NOT GROUNDED. ESCAPE PATHWAY LIGHTING HOUSING ASSEMBLY CRACKED AT SEATS 18ABC AND 20 ABC. REPLACED LIGHTING HOUSING ASSEMBLY AT 20 ABC PER CMM 25-22-52. OPERATIONS CHECK GOOD.SDR AALA201811179005Housing · crackedTHE AIRCRAFT WAS NOT GROUNDED. ESCAPE PATHWAY LIGHTING HOUSING ASSEMBLY CRACKED AT SEATS 18ABC AND 20 ABC. REPLACED LIGHTING HOUSING ASSEMBLY AT 18 ABC PER CMM 25-22-52. OPERATIONS CHECK GOOD.SDR PNSA20181116502Power Supply · failedEMERGENCY LIGHTING POWER SUPPLY ON AIRCRAFT INSPECTION FAILED FOUND 21LN FAILEDSDR AALA201811169017Lens · missingL4 DOOR EMERGENCY LIGHT LENS WAS MISSING. MAINTENANCE REPLACED THE LENS AND PERFORMED A SATISFACTORY OPERATIONAL CHECK.SDR AALA201811169014Battery · no testDURING PS2, EMERGENCY POWER SUPPLY SYSTEMS TEST, A FAULT CAME UP. MAINTENANCE REPLACED EMERGENCY BATTERY AT L2 DOOR IAW AMM 33-51-38, AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR SIMA201811165003Light · inoperativeNO ORANGE EMERGENCY LIGHT SECTION BESIDE WINDOW EXIT ROWS PER FA-C/A-REMOVED AND REPLACED EMER. EXIT ROW FLOOR FLIGHTING STRIP AND OPC GOOD IAW EMB145 AMM 33-50-12 AND 33-50-00.SDR AALA2018111609007Lens · missingSEAT MOUNTED EMERGENCY LIGHT LENS WAS MISSING. REPLACED THE LIGHT ASSY IAW AMM 33-51-19. OPS NORMAL.SDR 29GA2018111600001Lens · detachedFLIGHT# 0089 EYW/TPA REPORT: F/A EMERGENCY LIGHTS COVER CAME OFF. CORRECTIVE ACTION: RESECURED EMERGENCY LIGHT COVER ON F/A PANEL IAW SAAB AMM 33-50-00.SDR ASOA201811157182Battery · dischargedTYS A/C WAS FOUND TO HAVE SEVERAL EMERGENCY LIGHTS INOP. MAINTENANCE REMOVED AND REPLACED NR 2 BATTERY IAW AMM 33-50-04; IPC REFERENCE 33-50-04 FIG 01 ITEM 30. OPS CHECK GOOD AND WAS RELEASED TO SERVICE.SDR 2DYA2018012134001Lamp · inoperative1 SMALL EMERG EXIT LIGHT AFT OF CARGO DOOR, EXTERIOR INOP. RELAMPED SMALL EMERGENCY LIGHT AFT OF REAR CARGO DOOR IAW AMM 33-31-06. OPS CHECK OKSDR SWAA2018111926913Light · inoperativeRT OVERWING EMERGENCY EXIT LIGHT INOP. R&R LAMP PER AMM.SDR SWAA2018111926872Cover · missingR1 DOOR LOWER EMERGENCY EXIT SIGN MISSING DIRECTIONAL ARROWS. R&R COVER PER AMM.SDR SWAA2018111926840Cover · missingL1 DOOR LOWER EMERGENCY EXIT SIGN MISSING DIRECTIONAL ARROWS. R&R COVER PER AMM.SDR AALA201811169013Power Supply · no testAN OPS TEST OF THE EMERGENCY LIGHTS, THROUGH CIDS, FAULT ON EMERGENCY POWER SUPPLY, EXIT RIGHT 12WL IAW JC 26L00005005. THE AIRCRAFT WAS GROUNDED. MAINTENANCE REPLACED THE POWER SUPPLY IAW AMM 33-51-38, AND PERFORMED A SATISFACTORY OPS CHECK. NO FAULTS NOTED.SDR R61A2018111641148Battery · inoperativeEMERGENCY LIGHT OVER AT ROW 3 IS INOP. R&R EMERGENCY BATTERY 2 IAW AMM 33-50-01.SDR IPXA2018111655993Battery Pack · no testFOUND THE UPPER DECK LEFT DOOR EMERGENCY SYSTEM BATTERY TEST FAILED IAW AMM 52-23-14-004-001, AND AMM 52-23-14-404-005 REV.93.03. REPLACED THE BATTERY PACK AND PERFORMED NEW BATTERY PACK INSTALLATION TEST, RESULT WAS SATISFACTORYSDR AALA201811169011Lens · inoperativeSEAT 25D EXIT LIGHT INOPERATIVE. INSTALLED A REPLACEMENT LENS ON THE EXIT LIGHT. OPS NORMAL.SDR DALA2018111406640Lens · missingEMERGENCY EXIT COVER DIFFUSER LENS MISSING AT LOCATION 606. INSTALLED NEW LENS.SDR AALA201811159019Power Supply · faultedAIRCRAFT WAS NOT GROUNDED: DURING TEST OF EMERGENCY LIGHTS FOUND EMERGENCY POWER SUPPLY UNIT (14WL) FAULTING. MAINTENANCE REPLACED EMERGENCY POWER SUPPLY UNIT PER AMM 33-51-38 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201811159017Cover · missingAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHT COVER MISSING AT SEAT 5C. MAINTENANCE REPLACED LIGHT COVER PER AMM 33-51-19 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201811159007Lens · missingAIRCRAFT WAS NOT GROUNDED. 4R DOOR EMERGENCY EXIT LIGHT MISSING. INSTALLED NEW EXIT LIGHT LENS (DOOR 4R) CHECK GOOD.SDR SWAA2018111526804Cover · looseOVERHEAD EMERGENCY EXIT SIGN COVER LOOSE. SECURED SIGN PER SIP.SDR SWAA2018111526798Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1672. R&R BATTERY PER MM.SDR SWAA2018111526796Cover · unsecureOVERWING EXIT LIGHT COVER FELL OFF. SECURED COVER PER AMM.SDR SWAA2018111526782Light · inoperativeR1 DOOR EXIT LIGHT BULB INOP. RELAMPED LIGHT PER AMM.
Back to JASC 3350