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 SWAA2018011619108Battery Pack · failedEMERGENCY LIGHT BATTERY PACK FAILED CAPACITY CHECK AT LOCATION M01668. R&R BATTERY PACK PER AMM.SDR SWAA2018011619047Light · inoperativeLT EMERGENCY AISLE LIGHT INOP AT ROW 9. R&R LAMP IAW AMM.SDR SWAA2018011619038Holder · damagedBATTERY CHARGER BATTERY PACK HOLD DOWN CLIPS DAMAGED AT M01670. R & R HOLD DOWN AMM.SDR SWAA2018011619037Battery Pack · no testEMERGENCY LIGHT BATTERY PACK FAILED CAPACITY CHECK AT LOCATION M01673. R & R THE BATTERY PACK IAW AMM.SDR SWAA2018011619034Battery · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M01669. R & R THE BATTERY IAW AMM & DWG.SDR AALA201801129041Sign · missingAIRCRAFT WAS NOT GROUNDED: CABIN ENTRY EMERGENCY CABIN ENTRY EMERGENCY EXIT SIGN AND LIGHT MISSING AT DOOR 4L. REINSTALLED CABIN ENTRY EMERGENCY EXIT SIGN AND LIGHT AT DOOR 4L PER 33-51-01 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR SIMA20180110007Light · inoperativeEMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE EMERGENCY LIGHT IAW AMM 33-50-12. OPS CHECKED GOOD. NO DISCREPANCY NOTEDSDR CALA2018011200116Battery Pack · dischargedL1 DOOR EMERGENCY LIGHT BATTERY PACK M33093, FOUND CAPACITY LOW. REPLACED THE BATTERY PACK. TEST CARRIED OUT AND OPS NORMAL IAW AMM 33-51-06.SDR CALA2018011200115Battery Pack · dischargedR4 DOOR EMERGENCY LIGHT POWER PACK M33408 FOUND CAPACITY LOW. THE BATTERY PACK WAS REPLACED. TEST CARRIED OUT, AND OPS NORMAL IAW AMM 33-51-06.SDR CALA2018011200114Fuse · failedSEAT 33 AFT EMERGENCY LIGHTS DO NOT COME ON. REPLACED THE FUSE ON THE BATTERY PACK M736 IAW IAW AMM 33-51-07. OPS CHECKED GOOD.SDR ASAA2018011023136Lens · missingDURING A PRE-FLIGHT INSPECTION, LENS ON INTERIOR EXIT LIGHT AT SEAT 17A, MISSING. ACFT GROUNDED. REPLACED THE LENS IAW EA-19797.SDR AALA201801129036Lens · missingEMERGENCY LIGHT LENS MISSING AT THE R4 DOOR. MAINTENANCE REPLACED THE LENS AND PERFORMED A SATISFACTORY OPERATIONAL CHECK.SDR RAIA201801100002Battery Pack · dischargedMAIN CABIN INTERIOR LIGHTS INOPERATIVE DUE TO A DISCHARGED BATTERY. R & R THE NR 1 & 2 EMRGENCY LIGHT BATTERY. OPS CHECKED GOOD.SDR SIMA20180110006Switch Panel · intermittentEMERGENCY LIGHTS INTERMITTENT IN FLIGHT. OPS NORMAL ON GROUND. REMOVED AND REPLACED COCKPIT EMERGENCY LIGHT SWITCH PANEL IAW AMM 33-24-07.SDR AALA201801129017Power Supply · no testDURING OPERATIONAL TESTS OF THE EMERGENCY LIGHT POWER SUPPLY. THE TEST DID NOT PASS. REPLACED EPSU.SDR AALA201801129004Light · missingR1 DOOR EMERGENCY EXIT LIGHT LENS MISSING. REPLACED THE LENS.SDR AALA201801129003Lens · missingL2 DOOR EXIT LIGHT LENS MISSING. REPLACED MISSING LENS.SDR SIMA20180110003Charger · failedEMERGENCY EXIT SIGN OVER AISLE, BACKSIDE WILL NOT ILLUMINATE, REMOVED AND REPLACED EPSU BATTERY AND CHARGER IAW CRJ-700 AMM 33-51-17. POSITION #3. OPC GOOD AT THIS TIME. EMERGENCY LIGHTING BATTERY P/N 2013-1ASMI S/N 68415SDR MASA2018011012904Lamp · inoperativeCEILING ROW 18 EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMP.SDR DALA2018011000203Lens · unsecureEMERGENCY EXIT LIGHT LENS UNSECURE. SECURED THE LENS.SDR U2RA201801100001Lamp · inoperativeEXTERIOR EMERGENCY LIGHT AT THE L3 DOOR FOUND INOPERATIVE. REPLACED THE LAMP IAW AMM 33-51-06.SDR KCSA201801101007Sign · inoperativeUD EXIT SIGN AT STA 690R INOP.SDR QXEA2018011000012Lamp · inoperativeEMERGENCY LIGHT SWITCH AT FORWARD FA POSITION, BACKGROUND LIGHT APPEARS INOPERATIVE. REMOVED FROM SERVICE. REPLACED THE LAMP IN THE EMERGENCY LIGHT SWITCH. OPS CHECKED GOOD. AIRCRAFT RETURNED TO SERVICE.SDR SWAA2018011018952Cover · unsecureRT PLASTIC OVERWING EMERGENCY EXIT SIGN LENS COVER FELL OFF. REINSTALLED COVER IAW AMM.SDR SWAA2018012919384Light · brokenPASSENGER CABIN SIDEWALL PANEL 232YHW, EMERGENCY LIGHT BROKEN. R&R LIGHT IAW AMM.SDR SWAA2018011719096Battery Pack · inoperativeL1 DOOR EMERGENCY LIGHT FAULTY AT M1675. R & R THE BATTERY PACK IAW AMM.SDR SWAA2018011719063Light · inoperativeRIGHT EXTERIOR EMERGENCY EXIT LIGHT INOPERATIVE AT BS 757. R & R THE LIGHT IAW AMM.SDR SWAA2018011719048Battery Pack · inoperativeEMERGENCY LIGHT BATTERY PACK INOPERATIVE AT D10714. R & R THE BATTERY PACK IAW AMM.SDR SWAA2018011619117Battery Pack · dischargedRT OVER WING ESCAPE GROUND LIGHT INOP. R&R BATTERY PACK PER AMM.SDR SWAA2018011619116Battery Pack · dischargedLT BULLNOSE ESCAPE GROUND LIGHT INOP BETWEEN ROW 9 TO ROW 11. R&R BATTERY PACK PER AMM.SDR SWAA2018011619046Battery Pack · dischargedLT OVER WING ESCAPE GROUND LIGHT INOP. R&R BATTERY PACK PER AMM.SDR AALA201801129001Power Supply · failedAIRCRAFT WAS IN BASE MAINTENANCE. EMERGENCY POWER SUPPLY UNIT 11WL IN PASSENGER CABIN DOESN'T PASS TEST. REPLACED EMERGENCY POWER SUPPLY UNIT 11WL IN PASSENGER CABIN PER AMM 33-51-38.SDR AALA201801129014Lens · missingEMERGENCY LIGHT LENS MISSING AT THE L3 DOOR. INSTALLED A NEW LENS.SDR DALA2018011000211Power Supply · inoperativeFOUND THE EMERGENCY LIGHTS WOULD NOT ILLUMINATE AT THE SIDE OF SEATS 1D, 2D AND 3D. REPLACED THE POWER SUPPLY UNIT. SYSTEM OPS NORMAL.SDR DALA2018011000206Housing · damagedFOUND THE EMERGENCY LIGHT HOUSING AT SEAT 44DEF DAMAGED. REPLACED THE EMERGENCY LIGHT HOUSING IAW CMM 25-21-52.SDR DALA2018011000202Sign · missingFOUND EXIT SIGN MISSING AT THE L3 & R3 DOORS DURING A WAKE UP CHECK. REPLACED THE MISSING EXIT SIGN.SDR SWAA2018011118988Battery Pack · failedEMERGENCY LIGHT BATTERY PACK FAILED CAPACITY CHECK AT POSITION M01672. R&R BATTERY PACK PER AMM AND DWG.SDR SWAA2018011118987Battery Pack · failedEMERGENCY LIGHT BATTERY PACK FAILED CAPACITY CHECK AT POSITION M01673. R&R BATTERY PACK PER AMM AND DWG.SDR SWAA2018011118986Battery Pack · failedEMERGENCY LIGHT BATTERY PACK FAILED CAPACITY CHECK AT POSITION M01670. R&R BATTERY PACK PER AMM AND DWG.SDR SWAA2018011118974Light · looseCENTER AISLE OVERHEAD EMERGENCY EXIT LIGHT ASSEMBLY LOOSE. SECURED LIGHT ASSEMBLY PER MM.SDR SWAA2018011118972Light · inoperativeRT OVERWING EXT EMERGENCY LIGHT INOP. SECURED LOOSE LIGHT CONNECTION PER SIP.SDR ASAA2018010923113Light · damagedA FLIGHT ATTENDANT REPORTED THAT THE FORWARD SIX INCHES OF THE FLOOR EMERGENCY LIGHT STRIP WAS MISSING. ACFT GROUNDED. INSTALLED A NEW SECTION OF EMERGENCY LIGHT IAW AMM 33-51-15-960-801.SDR MASA2018010912901Light · inoperativeROW 18 CEILING EMER LIGHT INOP. REPLACED BULB.SDR SWAA2018010918951Relay · faultyLT CABIN EMERGENCY EXIT LIGHT FAULTY. R&R RELAY PER MM.SDR SWAA2018010918933Relay · faultyRT CABIN EMERGENCY EXIT LIGHT FAULTY. R&R RELAY PER MM.SDR MASA2018010912899Light · inoperativeCEILING EMERGENCY FLOOD LIGHT ROW 19/21 INOP. RELAMPED.SDR AALA201801109013Bracket · crackedRIGHT AFT SERVICE DOOR EXIT SIGN BRACKET IS CRACKED. SECURED SIGN LENS. REPLACED LIGHT ASSY IAW AMM 33-51-00.SDR AALA201801129016Lens · missingSEAT 13G EMERGENCY LIGHT LENS MISSNG. REPLACED THE LIGHT ASSEMBLY.SDR ASOA201801084003Inverter · inoperativeDURING A MAINTENANCE INSPECTION, THE GALLEY SERVICE DOOR LOWER EMERGENCY LIGHT WAS FOUND TO BE INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE NR 2 EMERGENCY LIGHT INVERTER, OPS TESTED WITH NO DEFECTS AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR YENA201801080012Power Supply · malfunctionedFOUND THE EMERGENCY LIGHT FWD POWER SUPPLY MALFUNCTIONED. REMOVED AND REPLACED THE POWER SUPPLY IAW AMM 33-50-01. OPS CHECKED GOOD.
Back to JASC 3350