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 SWAA2019101437764Light · delaminatedFORWARD RT EGRESS LIGHTING STRIP DELAMINATED. R&R LIGHT STRIP PER AMM.SDR SWAA2019101437723Battery Pack · dischargedEMERGENCY LIGHTING BATTERY PACK D10712 FOUND TO HAVE LOW CAPACITY. R&R BATTERY PACK D10712 PER AMM.SDR SWAA2019101437722Battery Pack · dischargedEMERGENCY LIGHTING BATTERY PACK D10714 FOUND TO HAVE LOW CAPACITY. R&R BATTERY PACK D10714 PER AMM.SDR DALA2019101315871Lens · missingEXIT SIGN "LENS" BOTTON OF DOOR 1R MISSING, INSTALLED EXIT LENSSDR AALA2019101109004Light · brokenAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT ASSEMBLY BROKEN AND INOPERATIVE. MAINTENANCE REPLACED LIGHT ASSEMBLY PER AMM 33-51-18.SDR DALA2019101115857Lens · detachedEMERGENCY EXIT SIGNS 28A FELL OFF. SECURED EXIT ROW SIGN COVER.SDR DALA2019101115856Sign · detachedEMERGENCY EXIT SIGN DETACHED SECURED EXIT ROW SIGN COVER.SDR AALA2019101099004Power Supply · inoperativeAIRCRAFT NOT GROUNDED: MAINTENANCE REPORTS EMERGENCY LIGHT TEST SHOWS EPSU EMER L. REMOVED & REPLACED EPSU 11WL IAW AMM 33-51-38. OPS CHECK GOOD.SDR SIMA201910109003Lamp · inoperativeAFT CEILING EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED AFT CEILING EMERGENCY LAMP IAW AMM 33-50-08-000-801-A AND 33-50-08-400-801-A. OPS CHECK GOOD.SDR DALA2019100900163Lens · missingEMERGENCY PATH LIGHT LENS COVER MISSING AT ROW 25 RIGHT SIDE. REPLACED LENS COVER.SDR DALA2019100900162Light · inoperativeLEFT EMERGENCY PATH LIGHT AT ROW 39 LEFT SIDE INOPERATIVE. REPLACED EMERGENCY LIGHT.SDR FDEA2019101082496Battery Pack · inoperativeEMERGENCY LIGHT TEST FAIL. FOUND LH SIDE EMERGENCY LIGHT BATTERY PACK UNSERVICEABLE. REPLACED BATTERY PACK ACC. AMM. 33-51-06. OPS CHECK FOUND SATISFACTORY.SDR SWAA2019101437790Battery Pack · inoperativeEMERGENCY EXIT LIGHTS FROM M1669 DO NOT LIGHT UP. R&R BATTERY PER AMM.SDR SWAA2019101437789Battery Pack · inoperativeEMERGENCY EXIT LIGHTS FROM M1670 DO NOT LIGHT UP. R&R BATTERY PACK PER AMM.SDR SWAA2019101437788Battery Pack · inoperativeEMERGENCY EXIT LIGHTS THAT ARE FROM M1673 DO NOT WORK. / R&R BATTERY PACK PER AMM.SDR SWAA2019101437787Battery Pack · inoperativeEMERGENCY EXIT LIGHTS THAT ARE FROM M1672 DO NOT WORK. R&R BATTERY PER AMM.SDR SWAA2019101437786Light · inoperativeFORWARD ENTRY DOOR ESCAPE SLIDE EMERGENCY EXIT LIGHT DOES NOT WORK. RELAMPED LIGHT PER AMM.SDR SWAA2019101437785Battery Pack · inoperativeEMERGENCY EXIT LIGHTS THAT ARE FROM M1675 DO NOT WORK. R&R BATTERY PACK PER AMM.SDR REXA2019101401476Bulb · burned outENTRANCE STOWAGE COMPARTMENT EMERGENCY EXIT SIGN HAS BURN OUT BULBS. REMOVED & REPLACED BURN OUT BULBS FOR EMERGENCY EXIT SIGN ON ENTRANCE STOWAGE COMPARTMENT IAW CRJ 900 AMM 33-51-05-960-801-A02.SDR REXA2019101401475Bulb · burned outFLOOR LEVEL EMERGENCY FLOOD LIGHT HAS BURN OUT BULBS. REMOVED & REPLACED BURN OUT BULBS FOR FLOOR LEVEL EMERGENCY FLOOD LIGHT IAW CRJ 900 AMM 33-51-05-960-801-A02.SDR ASOA201910148455Relay · inoperativeTHE CREW REPORTED THAT THE EMERGENCY LIGHTS FAILED TO ARM, AND THAT THE SWITCH WORKS IN THE IN AND OFF POSITIONS ONLY. MAINTENANCE REMOVED AND REPLACED RELAY K0275, OPERATIONALLY TESTED WITH NO DEFECTS AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR C77A2019101100001Sign · inoperativeR1 DOOR EMERGENCY LIGHT INOP - LOWER "EXIT" LIGHT. REPLACED R1 DOOR LIGHT ID SIGN PER AMM 33-50-17 OPS CHECK GOOD.SDR AALA2019101099010Light · inoperativeAIRCRAFT NOT GROUNDED: MAINTENANCE REPORTS EMERGENCY LIGHT ON SEAT 4C INOPERATIVE. REMOVED AND REPLACED EMERGENCY LIGHT AND HARNESS CABLE ON SEAT 4C IAW AMM 33-51-19. OPS TEST GOOD.SDR AALA2019101099009Cover · missingAIRCRAFT WAS NOT GROUNDED: SEAT 9D EMERGENCY EXIT SIGN COVER MISSING. MAINTENANCE REPLACED EMERGENCY EXIT SIGN COVER PER AMM 25-21-41.SDR AALA2019101099008Sign · damagedAIRCRAFT WAS NOT GROUNDED: ROW 8ABC EMERGENCY EXIT SIGN MISSING RED STRIP. MAINTENANCE REPLACED EMERGENCY EXIT SIGN COVER PER AMM 25-21-41.SDR AALA2019101099007Light · inoperativeAIRCRAFT WAS NOT GROUNDED: 12C EMERGENCY LIGHT WAS INOPERABLE. MAINTENANCE REPLACED LIGHT ASSEMBLY PER CMM 25-21-22.SDR 2DYA20191010002Power Supply · no testDURING EMERGENCY LIGHT TEST FOUND EMERGENCY EXIT SIGN FOR R3/L3 DOOR TURNING OFF AND ON. CORRECTIVE ACTION REMOVE AND REPLACE POWER SUPPLY.SDR 2DYA20191010001Battery Pack · faultedDURING EMERGENCY SYSTEM LIGHTING TEST FOUND THE L1 EMERGENCY EXIT SIGN TURNING ON AND OFF. REPLACED BATTERYSDR DALA2019101095825Light · inoperativeDURING S/C FOUND EMERGENCY PATH SEAT LIGHTS INOP FROM ROWS 27DEF TO 32DEF. REPLACED BATTERY PACK M10568 IAW AMM 33-51-07.SDR SWAA2019100937709Light · detachedFORWARD SERVICE DOOR EXIT LIGHT COVER FELL OFF. R&R LIGHT ASSEMBLY PER MM.SDR MASA2019100812079Lamp · inoperativeROW 6 CEILING LEVEL EMER FLOOD LIGHT INOP. RELAMPED.SDR DALA2019101195837Power Supply · faultedEPSU FAULT INT. LOADS EMER R, INSTALLED SERVICEABLE EPSU W/O BATTERYSDR AALA2019101099005Battery Pack · inoperativeAIRCRAFT NOT GROUNDED: MAINTENANCE REPORTS DURING PS EMERGENCY LIGHT OPS TEST EPSU 12WL UNDER RT OVER WING EXIT FAULTED. UNIT BITE FAULTED BATTERY. REMOVED AND REPLACED BATTERY PACK RT OVERWING EXIT DOOR IAW AMM 33-51-38, OK FOR SVC.SDR WX0A2019100973427Power Supply · inoperativeL2,R2 DOORS AND CENTER REAR CEILING EMERG. EXIT LIGHTS INOP / R&R AFT EPSU"SDR AALA2019100989012Battery · inoperativeAIRCRAFT WAS NOT GROUNDED: MID CABIN SEAT MOUNTED EMERGENCY LIGHTS INOPERABLE. MAINTENANCE REPLACED BATTERY FOR EMERGENCY LIGHTS PER AMM 33-51-07 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA2019100989011Battery · inoperativeAIRCRAFT WAS NOT GROUNDED: AFT CABIN SEATS 26 TO 36 EMERGENCY LIGHTS INOPERABLE. MAINTENANCE REPLACED BATTERY FOR EMERGENCY LIGHTS PER AMM 33-51-07 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA2019100989010Battery · inoperativeAIRCRAFT WAS NOT GROUNDED: FORWARD CABIN SEAT MOUNTED EMERGENCY LIGHTS INOPERABLE 1E TO 4E. MAINTENANCE REPLACED BATTERY FOR EMERGENCY LIGHTS PER AMM 33-51-07 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR HNAA2019100900305Bulb · inoperativeFLIGHT DECK CEILING EMERGENCY LIGHT BULB INOP. REPLACED THE BULB. OPS CHECK GOODSDR SWAA2019100937694Lens · missingR/H EMERGENCY EXIT SIGN LENS MISSING AT OVERWING EXIT DOOR. INSTALLED LENS IAW AMM.SDR SWAA2019100937692Battery · no testEMERGENCY LIGHT BATTERY FORWARD OF R/H OVERWING EXIT FAILED CAPACITY CHECK. R&R BATTERY PER AMM.SDR DALA2019100985807Sign · brokenR2 EMERGENCY EXIT SIGN ABOVE DOOR IS BROKEN. R & R WITH NEW EXIT SIGN ABOVE DOOR R2.SDR MASA2019100872078Battery Pack · inoperativeROW 14 LH/RH EXIT SIGNS INOP. REPLACED BATTERY PACK.SDR MASA2019100851277Bulb · inoperativeROW 18 RHS EXIT SIGN HAS 2 BULBS INOPERATIVE.SDR AALA201910079040Battery Pack · inoperativeAIRCRAFT WAS NOT GROUNDED: MID CABIN EMERGENCY LIGHTS WERE INOPERABLE AT SEATS 9D THROUGH 26D. REPLACED BATTERY PACK PER AMM 33-51-07.SDR AALA201910079039Battery Pack · inoperativeAIRCRAFT WAS NOT GROUNDED: MID CABIN EMERGENCY LIGHTS WERE INOPERABLE AT SEATS 9D THROUGH 26D. REPLACED BATTERY PACK PER AMM 33-51-07.SDR SIMA201910087001Lamp · inoperativeDURING PS-2 CHECK, FOUND RH EXTERIOR EMERGENCY LIGHT ABOVE WING INOP-C/A-REMOVED AND REPLACED RH EXTERIOR ABOVE WING EMERGENCY LIGHT LAMP IAW AMM 33-50-10. OPERATIONAL CHECK GOOD. NO DEFECTS NOTED AT THIS TIME. SEE NRWC 900-ORD-04100 FOR CURE CHECK.SDR SWAA2019100837684Lamp · inoperativeRIGHT OVERWING EXIT SIDEWALL EMERGENCY FLOOD LIGHT AFT LIGHT INOPERATIVE. R&R LAMP IAW AMM.SDR SWAA2019100837683Lamp · inoperativeFORWARD ENTRY HORSESHOE PANEL EMERGENCY CEILING LIGHT INOPERATIVE. R&R LAMP LIGHT IAW AMM.SDR HALA2019100800404Cids · malfunctionedEMERGENCY EXIT LIGHT COMES ON WITH SWITCH IN ARM POSITION, RESET OFF TO ARM, DOES NOT RESET. RESET CIDS SYS AND CYCLED CIRCUIT BREAKER OF CABIN EMERGENCY LIGHTS & EMERGENCY CABIN LIGHTS THEN,
BITE TEST OF CIDS 1& 2 AND OPS CHECKED NORMAL, IAW AMM 33-51-00,SDR AALA201910079038Battery Pack · inoperativeAIRCRAFT WAS NOT GROUNDED: MID CABIN EMERGENCY LIGHTS WERE INOPERABLE AT SEATS 9D THROUGH 26D. REPLACED BATTERY PACK PER AMM 33-51-07.
Back to JASC 3350