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 SWAA2019101437754Sign · detachedEXIT SIGN AT EXIT ROW OVER FIRST OFFICER'S WING FELL OFF. SECURED RIGHT EMERGENCY OVERWING EXIT SIGN PER SIP.SDR SWAA2019101437753Battery Pack · inoperativeR1 EXTERIOR EMERGENCY ESCAPE LIGHT AND L1 OVERHEAD EXIT LIGHTS ARE INOP. R&R BATTERY PACK PER AMM.SDR AALA2019101429005Battery · no testAIRCRAFT NOT GROUNDED: MAINTENANCE REPORTS EPSU BAT FAIL ON 12WL, 14WL, 17WL, REMOVED AND REPLACED EPSU BATTERY ON EPSU 12WL, 14WL & 17WL IAW AMM 33-51-38. (SEE SDR # AALA201910149023, AALA201910149024)SDR AALA201910149023Battery · inoperativeAIRCRAFT NOT GROUNDED: MAINTENANCE REPORTS EPSU BAT FAIL ON 12WL, 14WL, 17WL, REMOVED AND REPLACED EPSU BATTERY ON EPSU 12WL, 14WL & 17WL IAW AMM 33-51-38. (SEE SDR # AALA201910129005, AALA201910149024)SDR AALA201910149024Battery · inoperativeAIRCRAFT NOT GROUNDED: MAINTENANCE REPORTS EPSU BAT FAIL ON 12WL, 14WL, 17WL, REMOVED AND REPLACED EPSU BATTERY ON EPSU 12WL, 14WL & 17WL IAW AMM 33-51-38. (SEE SDR # AALA201910129005, AALA201910149023)SDR HALA2019101430170Switch · malfunctionedDURING FLIGHT, EMERGENCY LIGHTS ILLUMINATED IN THE ARM POSITION AND WOULD NOT RESET. CYCLED COCKPIT EMERGENCY LIGHT SWITCH.SDR HALA2019101430169Lens · detachedSEAT 39G CEILING LIGHT COVER FELL OFF. RE-FITTED SEAT 39G CEILING LIGHT COVER. LP 6773249SDR HALA2019101430167Light · unsecureAFT GALLEY EMERGENCY FLOOR LIGHTING IS LOOSE. SECURED AFT GALLEY EMERGENCY STRIP. LP 6778211SDR HALA2019101430166Switch · malfunctionedEMERGENCY EXIT LIGHTS STAY ON IN ARM POSITION. REPLACED SWITCH 4WL, AND RELAY 8WL. LP 131141SDR IPXA201910147792Control Panel · malfunctionedWHEN EXTERNAL POWER TURNED OFF IN COCKPIT EMERGENCY EXIT SIGNS & LIGHTS CAME ON WITH EMERGENCY LIGHT SWITCH TURNED OFF. R&R EMERGENCY EXIT OVERHEAD PANEL ON P11 REF MM 33 51 08 EMERGENCY EXIT LIGHTS OPS CKS OK 33 51 08 01A OOSSDR 2DYA20191014002Light · inoperative4R CEILING EMERGENCY LIGHTS INOPERATIVE. 4R 2 EMERGENCY EXIT SIGNS INOP. OPENSDR 2DYA20191014001Light · inoperativeRT AND LT OVERWING EMERGENCY EXIT LIGHTS INOPERATIVE. OPENSDR CALA2019101401749Lamp · burned outEXTERIOR EMERGENCY LIGHT AT DOOR 4R INOP. RELAMPED 4R EMERGENCY LIGHT PER AMM 33-51-04-960-801,OPS TEST OKSDR VNAA201910121106Light · not reportedR&R PAX DOOR EMERGENCY LIGHT IAW CRJ900 AMM 33-51-15-000/400-801. OPS TEST GOOD AT THIS TIME.SDR SIMA20191011002Light · inoperativePAX EMERGENCY GROUND ILLUMINATION LIGHT INOPERATIVE. INSPECTED AND CORRECTLY REASSEMBLED PAX EMERGENCY GROUND ILLUMINATION LIGHT ASSY IAW EMB 145 AMM 33-50-10, OPC GOOD.SDR KCSA201910111237Battery Pack · inoperativeRIGHT UPPER DECK EMERGENCY DOOR BATTERY INOPSDR CALA2019101101742Lamp · inoperativeSMALL EEL EXIT SIGN JUST FWD OF RH OVERWING EXIT LAMPS INOP. RELAMPED REF AMM 33-51-01-960-801 OPS CHECKED OK. IT IS THE AFT RH OVERWING EXIT SIGN. ACCOMPLISHED THE INSPECTION AND OPERATION OF EXIT EEL LIGHT SIGN JUST FWD OF RH OVERWING EXIT.SDR CALA2019101101740Lamp · inoperativeSMALL EEL EXIT SIGN JUST FWD OF LH AFT OVERWING EXIT LAMPS INOP. RELAMPED REF AMM 33-51-01-960-801 OPS CHECKED OK. ACCOMPLISHED THE INSPECTION AND OPERATION OF EEL EXIT SIGN JUST FWD OF LH AFT OVERWING EXIT.SDR CALA2019101101739Lamp · inoperativeSEAT 29ABC EMER EXIT PATHWAY LIGHT INOP. RELAMPED REF AMM 33-51-11-960-801 OPSCHECKED OK. ACCOMPLISHED INSPECTION OF THE EMERGENCY EXIT PATHWAY LIGHT AT SEAT 29ABC.SDR CALA2019101101741Light · inoperativeDOOR 2R LOWER EMERG. EXIT LIGHT INOP. INSTALLED NEW LIGHT ASSY.TEST OK. REF AMM 33-51-00SDR DALA2019101105831Battery Pack · inoperativeCEILING EMERGENCY LIGHTS FROM ROW 4-1 ARE INOP. REPLACED BATTERY PACK LIGHT BATTERIES IN OVERHEAD BIN AT ROW 4D, C PER MD88 AMM 33-53-00. EMERGENCY LIGHTS WORK GOOD. (LP5588281)SDR SWAA2019102538221Lens · wornGALLEY # 1 EMERGENCY EXIT LIGHT LENS WORN. / R&R LIGHT LENS PER AMM.SDR YENA2019102400610Battery · failedFT # 1890, DCA-BOS. AFT SERVICE DOOR EMERGENCY EXIT LIGHT AND COURTESY LIGHT INOP; REPLACED EMERGENCY LIGHT POWER UNIT IAW AMM 33-50-01. OPS CHECK GOOD.SDR N6WA20191016001Light · out of positionEME. EXIT LIGHT NEAR L/H EME. EXIT DOOR IS OUT OF PLACE. RESECURED EXIT LIGHT IAW CRJ 700 AMM 35-51-05 PERFORM OPS CHECK IAW CRJ 700 AMM 33-50-00SDR SWAA2019101437783Lens · looseEMERGENCY EXIT LIGHT LENS FACING AFT, OVER CENTER ISLE IN CABIN DETACHED. SECURED LENS PER AMM.SDR SWAA2019101437769Sign · detachedCENTER AISLE EMERGENCY EXIT SIGN HANGING LOOSE FROM CEILING. / SECURED EXIT SIGN PER AMM.SDR SWAA2019101437762Battery Pack · no test3 EACH CABIN EMERGENCY LIGHT BATTERY PACKS FAIL CAPACITY TEST. R&R BATTERY PACKS AT POSITIONS M01672, M01670, AND M01669 PER AMM.SDR SWAA2019101437759Lamp · inoperativeAFT SERVICE DOOR EXTERIOR EMERGENCY LIGHT INOP. RELAMPED LIGHT PER AMM.SDR SWAA2019101437758Lamp · inoperativeLEFT AFT ENTRY DOOR EMERGENCY LIGHT INOP. RELAMPED LIGHT PER AMM.SDR SWAA2019101437756Battery Pack · inoperativeEMERGENCY LIGHTS INOP IN CABIN AT 3D, 6D, R1 ESCAPE SLIDE OUTSIDE, AND RIGHT WING ESCAPE DOOR OUTSIDE. R&R BATTERY PACK IAW AMM.SDR SWAA2019101437751Lamp · inoperativeEMERGENCY LIGHT OUT AT ROW 5 DEF. RELAMPED LIGHT PER AMM.SDR DALA201910145880Battery Pack · no testEMERGENDCY LIGHT POWER SUPPLY BATTERY PACKS M11613 AND M11487 WILL NOT KEEP EMERGENCY LIGHTS ILLUMINATED FOR AT LEAST 15 MINS. REPLACED THE BATTERY PACKS. OK FOR SERVICE IAW AMM 3351.SDR YENA201910100592Power Supply · failedLEFT OVERWING EMERGENCY EXIT SIGN INOPERATIVE. R & R THE NR 4 ELPU IAW AMM 33-50-01. OK FOR SERVICE.SDR ASAA2019101103987Battery Pack · dischargedR1 AND L1 EMERG EXIT LIGHTS AND SIGNS INOP. GROUNDED - YES. SWAPPED LEFT AND RIGHT BATTERY PACKS, PROBLEM FOLLOWS. REPLACED R1 & R2 EMERG LITE PWR SUPPLY & BATTERY ASSYS. OPS CKS GOOD, REF B737-800 AMM 33-51-06.SDR AALA201910119004Light · faultyAIRCRAFT WAS NOT GROUNDED: EPAS LIGHT WAS NOT FLASHING ON R1 DOOR. MAINTENANCE RESET CIRCUIT BREAKER PER AMM 52-11-20 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201910119003Switch · inoperativeAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHT SWITCH WAS NOT WORKING. MAINTENANCE PERFORMED SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-00.SDR SIMA201910110007Light · inoperativeSERVICE DOOR EMERGENCY FLOOD LIGHT INOPERATIVE. REMOVED AND REPLACED SERVICE DOOR EMERGENCY FLOOD LIGHT ASSY IAW EMB 145 AMM 33-50-10SDR SIMA201910110006Lamp · inoperativeSERVICE DOOR EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED SERVICE DOOR EMERGENCY LAMP IAW AMM TASK 33-50-10-000-801-A AND 33-50-10-400-801-A. OPC GOOD. END.SDR SIMA201910110005Fuse · failedOVERHEAD AISLE LIGHT NR 4 INOPERATIVE. -REMOVED AND REPLACED FUSE ON BATTERY CHARGER #4 IAW CMM 25-60-03. OPS CHECK GOODSDR HALA2019101100409Sign · detachedEXIT SIGN NEAR FORWARD ENTRANCE WILL NOT STAY ATTACHED. SECURED EXIT SIGN REF AMM 25-60-00 SECURITY CHECK GOOD.SDR HALA2019101100408Unknown · unknownEMERGENCY EXIT LIGHT REMAIN ON IN ARMED POSITION, WILL NOT RESET. PERFORMED OPERATIONAL CHECK OF MANUAL & AUTOMATIC EMERGENCY LIGHTS IAW AMM TASK 33-51. OPS NORMAL. ALSO PERFORMED BITE TEST OF EPSU CIDS 1 SYS. PER AMM 33-51. TEST OK. OK FOR SVC.SDR QXEA2019101100380Light · looseFLOOR MOLDING LOOSE AT SEATS 2E/D. REMOVED FROM SERVICE. RESECURED EMERGENCY FLOOR PATH LIGHTING AT SEAT 2D/E IAW AMM 33-51-16-400-801. OK FOR SERVICE. AIRCRAFT RETURNED TO SERVICE.SDR MASA2019101012083Light · inoperativeROW 6 EMERGENCY FLOOD LIGHT INOPERATIVE. SDR MASA2019101012082Light · inoperativeFLIGHT DECK EMERGENCY LIGHT INOPERATIVE.SDR MASA2019101012081Battery Pack · inoperativeLAST 3 CEILING EMER LTS INOP. R&R EMER BATT PACKSDR DALA2019101005822Lens · missingTHE OVERHEAD EMERGENCY LIGHT LENS COVER WAS FOUND MISSING DURING THE SERVICE CHECK. MAINTENANCE REPLACED THE LENS COVER. THE SYSTEM IS NOW OK FOR SERVICE.SDR DALA2019101005821Lens · missingTHE AFT DOOR EMERGENCY EXIT LIGHT DIFFUSER COVER IS MISSING. MAINTENANCE LOCATED THE LENS AND RESECURED IT. SYSTEM IS NOW OK FOR SERVICE. (LP #6567004)SDR 2DYA20191010003Power Supply · inoperativeDURING TEST OF EMERGENCY LIGHT SYSTEM LIGHT AT DOOR R1/R2 WAS FOUND INOP. REMOVED AND REPLACED THE POWER SUPPLY.SDR SWAA2019101637854Lamp · inoperativeR/H EMERGENCY LIGHT INOP AT OVERHEAD BIN ROW 11. / RELAMPED LIGHT PER AMM.SDR SWAA2019101437778Light · inoperativeL1 DOOR EMERGENCY LIGHT ON FWD LAV INOP. REPAIRED LIGHT IAW WDM AND SWPM.
Back to JASC 3350