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 SWAA2019100337513Cover · brokenL1 DOOR EXIT LIGHT COVER BROKEN. R&R COVER PER SIP.SDR DALA2019100205645Battery Pack · inoperativeEMERGENCY LIGHTS AT L1, R1 AND CO INOP. R/R BATTERIES AT BATERY PACK B5211 IAW MM 33-53.SDR REXA201910101394Light · dimRH AFT EMERGENCY WING LIGHT DIM. REPLACED EMERGENCY LIGHT IAW AMM 33-51-15. OPS CHECK GOODSDR YENA2019100710560Power Supply · inoperativeDURING HEAVY MAINTENANCE, INOPERATIVE EPSU AT THE EMERGENCY EXIT LT IN PASSENGER CABIN. REPLACED THE EPSU IAW 33-51-38-400-001-A.SDR DALA2019100705769Lens · missingTHE EMERGENCY EXIT COVER DIFFUSER LENS IS MISSING AT 102. MAINTENANCE REPLACED THE AFT LIGHT LENS. (LP #1295863)SDR CALA2019100501695Charger · no testB777-33-3-7019 DR R4 ENER LIGHT POWER SUPPLY M33409 BATTERY PACK CAPACITY LOW REF NR LP 9130234 DR R4 EMER LIGHT POWER SUPPLY M33409 CHARGER AND BATTERY PACK RE PLACED AND TESTED NORMAL AS PER AMM 33-51-06 ADD EMP:V898181 INSPECTED BY 161779, APPROVEDSDR CALA2019100501694Charger · no testB777-33-3-7019 DR R3 EMER LIGHT POWER SUPPLY M33401 BATTERY CAPA CITY LOW REF NR LP 9130232 DR R3 EMER LIGHT POWER SUPPLY M33401 CHARGER AND BATTERY PACK RE PLACED AND TESTED NORMAL AS PER AMM 33-51-06 ADD EMP:V898181 INSPECTED BY HX161779, APPROVEDSDR CALA2019100501693Charger · no testB777-33-3-7019 DR R3 EMER LIGHT POWER SUPPLY M33404 BATTERY PACK CAPACITY LOW REF NR LP 9130236 DR R3 EMER LIGHT POWER SUPPLY M33404 CHARGER AND BATTERY PACK RE PLACED AND TESTED NORMAL AS PER AMM 33-51-06 ADD EMP:V898181 INSPECTED BY HX161779, APPROVEDSDR DALA2019100425708Bulb · burned outBOTH CREW REST LADDER COMMON AREA EMERGENCY EXIT SIGNS ARE INOPERATIVE. FOUND 26 BULBS BURNT OUT AND REPLACED.SDR HNAA2019100400294Power Supply · inoperativeOVERHEAD EMERGENCY LIGHTS AT 12A AND 12BC PSU'S DO NOT ILLUMINATE. R & R THE EMERGENCY BATTERY AND POWER SUPPLY IAW AMM 33-50-11-000/400-801-A. OK FOR SERVICESDR AALA201910039009Battery Pack · inoperativeAIRCRAFT NOT GROUNDED: MAINTENANCE REPORTS EPSU SYSTEM TEST BATTERY AND EPSU (11WL) EXTERIOR LIGHT FAULT. REMOVED AND REPLACED EMERGENCY POWER SUPPLY UNIT BATTERY AT 11WL POSITION. TEST OK IAW AMM 33-51-38.SDR AALA2019100329008Light · brokenAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHT BROKEN AT LAVATORY D ISLE. MAINTENANCE REPLACED LIGHT ASSEMBLY PER AMM 33-51-11.SDR SWAA2019100337554Battery · inoperativeFORWARD GALLEY LOWER OUTBOARD EMERGENCY LIGHTS INOP. R&R BATTERY PER AMM.SDR SWAA2019100337549Lamp · not seatedFLIGHT DECK EMERGENCY LIGHT INOP. RESEATED LIGHT LAMP IAW MM.SDR SWAA2019100337547Battery · inoperativeFORWARD GALLEY AREA EMERGENCY LIGHTS INOPERATIVE AT L1 ENTRY OVERHEAD PANEL. R&R BATTERY PER AMM.SDR SWAA2019100337540Battery Pack · inoperativeOVERHEAD BINS AISLE EMERGENCY LIGHTS INOP BETWEEN ROW 3 TO ROW 6. R&R BATTERY PACK M1674 PER AMM.SDR SWAA2019100337539Fuse · inoperativeAFT GALLEY AREA SHOWS LT EMERGENCY EXIT LIGHT INOP, JUST OUTBOARD OF FLIGHT ATTENDANT SEAT. R&R FUSE AT EMERGENCY POWER SUPPLY (M1673) PER AMM.SDR HALA2019100200155Cids · malfunctionedEMERGENCY LIGHTS ALONG WITH THE FLOOD LIGHTS CAME ON WITH THE EMERGENCY LIGHTS SWITCH IN THE ARMED POSITION. RESET NBR 1 AND 2 CIDS NUMEROUS TIMES. LP 5865145SDR SWAA2019100237510Battery · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1673. R&R BATTERY PER AMM.SDR SWAA2019100237509Battery · no testR/H FORWARD EMERGENCY LIGHT BATTERY FAILED CAPACITY CHECK. R&R BATTERY PER AMM.SDR SWAA2019100237501Power Supply · no testR/H FORWARD EMERGENCY LIGHT BATTERY FAILED CAPACITY CHECK. / R&R POWER SUPPLY PER AMM.SDR SWAA2019100237493Light · crackedR/H EGRESS I LUMINESCENT STRIP IN FRONT OF SEAT 1 CRACKED. R&R STRIP IAW AMM.SDR SWAA2019100237461Battery · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1675. R&R BATTERY PER AMM.SDR MASA20191002071Light · missing18B EMERGENCY FLOOR LIGHT STRIP MISSING. INSTALLED STRIPSDR SIMA201910021001Lamp · inoperativeMAIN DOOR EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED MAIN DOOR EMERGENCY LIGHT LAMP IAW AMM 33-50-06-000-801-A, AND 33-50-06-400-801-A. OPS CHECKED GOOD.SDR AALA201910029012Warning Message · false indicationAIRCRAFT NOT GROUNDED: EPSU SYS TEST SHOWS BAT/EPSU EXT L FAULT. ACCOMPLISHED EPSU OPERATIONAL TEST OF THE EMERGENCY LIGHTS SYSTEM. TEST IS OK IAW AMM 33-51-00.SDR DALA2019100205635Power Supply · inoperativeEMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE EPSU LEFT EMERGENCY DOOR IAW AMM 33-51 AND REMOVED AND REPLACED EPSU BATTERY IAW AMM 33-51 OPS TESTED GOOD.SDR VNAA201910021103Battery Pack · inoperativeFA STATION EMERGENCY LIGHT SWITCH LEFT ON. REPLACED 4 EPSU BATTERIES IAW CRJ900 AMM. OPS CHECK GOOD. P/N 2013-1A S/N 169527, 503263, 126020, 500031.SDR MASA2019100112070Bulb · inoperativeCEILING EMER LIGHT ROW 17 INOPERATIVE. REPLACED THE BULB.SDR VNAA2019100111102Bulb · inoperativeMX FOUND LEFT AND RIGHT OVER WING EXITS LOWER SIGNS HAS A LIGHT NOT ILLUMINATING. RELAMPED RIGHT AND LEFT OVER WING EXIT LOWER SIGN BULBS , OPS CHECKS GOOD.SDR VNAA2019100111101Lamp · inoperativeMX FOUND AT SEAT 14 EMERGENCY OVERHEAD LIGHT WILL NOT ILLUMINATE.RELAMPED SEAT 14 OVERHEAD EMERGENCY FLOOD LAMP , OPS CHECKS GOOD IAW CRJ 700 AMM 33-51-09-000-801/400-801.SDR KCSA201910011236Battery Pack · inoperativeL/H UPPER DECK DOOR BATT OK LIGHT DOES NOT ILLUMINATESDR KCSA201910011235Battery Pack · inoperativeR/H UPPER DECK DOOR BATT OK LIGHT DOES NOT ILLUMINATESDR MASA2019100112069Battery · dischargedAFT CABIN EMERGENCY EXIT LIGHT INOPERATIVE. CHARGED BATTERIESSDR DALA2019100105611Battery Pack · inoperativeTHE RH OVERWING EMERGENCY EXIT LIGHT IS INOPERATIVE. MAINTENANCE REPLACED THE RH OVERWING EMERGENCY EXIT LIGHT BATTERY IAW B717 AMM 33-51-03. OPERATIONAL CHECK WAS GOOD. (LP #6172176)SDR YENA2019100493558Battery Pack · no testFT # 391, EPSU BATTERY EMER R/H BATTERY FAIL TEST; REMOVED AND REPLACED EPSU EMER R BATTERY PER AMM 33-51-38.SDR DALA2019100415707Bulb · burned outCREW REST LADDER AND COMMCON AREA EMERGENCY EXIT SIGNS ARE INOPERATIVE. FOUND ALL 24 BULBS BURNT OUT AND REPLACED. SYSTEM OPERATION IS NORMAL.SDR DALA2019100415685Shroud · brokenPRIOR DEPARTURE, DURING A CABIN CHECK, FOUND EMERGENCY LIGHT SHROUD BROKEN. REPLACED AND SECURED THE SHROUD. SYSTEM OPERATION NORMAL.SDR QXEA2019100300374Lamp · inoperativeFORWARD FLIGHT ATTENDENT EMERGENCY LIGHT SWITCH DOES NOT ILLUMINATED IN THE NORMAL POSITION. REMOVED FROM SERVICE. RELAMPED FWD F/A EMERGENCY LIGHT SWITCH NORMAL POSITION OPS CK. GOOD REF AMM TASK 33-51-710-802 NO OTHER DEFECTS NOTED AT THIS TIME. RETURNED TSDR DALA201910035671Light · failedDURING A SERVICE CHECK, FOUND CEILING EMERGENCY LIGHT INOPERATIVE AT ROW 34. FOUND THE LIGHT ASSY BAD AND REPLACED. THE FUSE IN THE POWER SUPPLY WAS ALSO BAD AND REPLACED IAW WDM 33-51-14. OPS CHECKED NORMAL.SDR AALA2019100219015Battery · no testAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT SIGN AT 3L DOOR INOPERABLE. MAINTENANCE REPLACED POWER BATTERY PER AMM 33-51-38.SDR SWAA2019100237455Lens · missingMID CABIN OVERHEAD EXIT SIGN MISSING FRONT LENS. INSTALLED THE LENS IAW AMM.SDR SWAA2019100217436Lamp · inoperativeAFT LT ENTRY EXTERIOR EMERGENCY LIGHT INOPERATIVE. RELAMPED LIGHT IAW MM.SDR SIMA2019100193006Lamp · inoperativeRT EXTERIOR EMERGENCY LIGHT FWD INOPERATIVE. REMOVED AND REPLACED LAMP IAW AMM 33-50-10 OPS CHECED FAILED IAW ITEM 2 THIS NRWCSDR SIMA2019100193005Lamp · inoperativeLEFT CENTER FAIRING EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE LAMP IAW AMM 33-50-10. OPS CHECKED GOOD.SDR SWAA2019093037276Lens · missingCENTER CABIN EMERGENCY EXIT SIGN LENS COVER MISSING. / INSTALLED LENS IAW AMM.SDR SWAA2019093037275Cover · missingR/H OVERWING EMERGENCY EXIT SIGN COVER MISSING. / R&R LIGHT ASSEMBLY PER AMM.SDR DALA2019093005607Battery Pack · dischargedEMERGENCY EXIT SIGNS AT 2L/2R DOORS ARE INOPERATIVE. REPLACED BATTERY PACK M1210. SYSTEM OPERATION NORMAL.SDR CALA2019093001677Light · inoperativeEXTERIOR EMERGENCY LIGHT AT DOOR 2R IS OUT. RELAMPED DOOR 2R EXTERNAL EMERGENCY LIGHT. OPS CHECK OK ACCOMPLISHED THE INSPECTION OF THE INSTALLATION OF 2R EMERGENCY LIGHT.SDR CALA2019093001674Light · inoperative(MULT-33-3-0001) 01 EACH L2 DOOR AND 02 EACH OVERWING EXTERNAL E MERGENCY LIGHTS INOP. (RELAMP). REF ST-SAA NR 0078793. RELAMPED L2 DR SLIDE LIGHT & OPS CK GOOD REF AMM 33-51-06-962-00 R/R BATTERY CHARGER & BATTERY PACK AT M11383 & 2EA OVERWING EXTERNAL EMERG
Back to JASC 3350