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 AALA201804029006Battery · no testOPS CHECK OF THE EMERGENCY LIGHTS FAILED TO TEST. REMOVED AND REPLACED THE BATTERY PACKS IAW AMM 33-51-38-400,33-51-38-0401. AIRCRAFT WAS GROUNDED.SDR SWAA2018040320949Battery · inoperativeEMERGENCY LIGHT BATTERY M1669 INOPERATIVE. R & R THE BATTERY IAW AMM.SDR SWAA2018040320924Lens · missingLEFT OVERWING EMERGENCY EXIT SIGN LENS MISSING AT ROW 11. REPLACED THE LENS IAW AMM.SDR SWAA2018040320913Lamp · inoperativeLEFT OVERWING EMERGENCY EXIT LIGHT INOPERATIVE. REPLACED THE LAMPS IAW AMM.SDR SWAA2018040320911Door · looseCENTER AFT OVERHEAD EMERGENCY EXIT LOOSE. SECURED EXIT IAW SIP.SDR SWAA2018040320907Lens · crackedR1 DOOR THRESHOLD EMERGENCY EXIT LIGHT LENS CRACKED. R & R THE LENS IAW AMM.SDR SWAA2018040320899Battery · inoperativeEMERGENCY LIGHT BATTERY M1672 INOPERATIVE. R & R THE BATTERY IAW AMM.SDR SWAA2018040320898Lens · missingLEFT EMERGENCY LIGHT LENS MISSING AT ROW 14. INSTALLED A NEW LENS IAW AMM.SDR SWAA2018040320897Lamp · inoperativeLEFT EMERGENCY LIGHT INOPERATIVE AT SEAT ROW 17. REPLACED THE LAMPS IAW AMM.SDR SWAA2018040320885Lamp · inoperativeLEFT OVERWING LOWER INTERIOR EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS IAW AMM.SDR SWAA2018040320876Lamp · inoperativeL2 DOOR AFT EXTERIOR EMERGENCY EXIT LIGHT INOPERATIVE. REPLACED THE LAMPS IAW AMM.SDR SWAA2018040320875Sign · looseOVERHEAD OVERWING AISLE EXIT SIGN LOOSE. SECURED THE SIGN IAW AMM.SDR AALA201804039016Lens · missingR2 DOOR LOWER EMERGENCY EXIT LIGHT LENS MISSING. INSTALLED THE LENS.SDR AALA201804039004Lens · missingLIGHT LENS MISSING IN CEILING. REPLACED EMERGENCY LIGHT ASSEMBLY ROW 22.SDR AALA201804039017Battery · misinstalledROW 21 OVERWING EMERGENCY LIGHT INOPERABLE. FOUND THE BATTERY PACK INSTALLED IN THE WRONG DIRECTION. INSTALLED BATTERIES CORRECTLY IAW AMM 33-60-98.SDR AALA201804039038Light · inoperativeSEAT 5E AFT EMERGENCY LIGHT ASSEMBLY INOPERATIVE. MAINTENANCE REPLACED THE LIGHT IAW AMM 33-60-95, AND PERFORMED SATISFACTORY OPS CHECK.SDR CALA2018040301067Light · brokenSEAT 8H EMERGENCY LIGHT FOUND BROKEN. REPLACED THE LIGHT. OPS TESTED GOOD IAW AMM 33-51-05-960-801, REV 82.SDR CALA2018040301066Light · brokenEMERGENCY LIGHT FOUND BROKEN. REPLACED THE LIGHT. OPS TESTED GOOD IAW AMM 33-51-05-960-801, REV 82.SDR CALA2018040301065Light · brokenEMERGENCY LIGHT FOUND BROKEN. REPLACED THE EMERGENCY LIGHT & OPS TESTED GOOD IAW AMM 33-51-03-960-801, REV 82.SDR CALA2018040301064Light · brokenFOUR EMERGENCY LIGHTS FOUND BROKEN. REPLACED THE EMERGENCY LIGHTS. OPS CHECKED GOOD IAW AMM 33-51-05-960-801, REV 82.SDR CALA2018040301063Light · brokenFOUR EMERGENCY LIGHTS FOUND BROKEN. REPLACED THE EMERGENCY LIGHTS. OPS TESTED GOOD IAW AMM 33-51-05-960-801, REV 82.SDR CALA2018040301062Sign · brokenTWO EXIT SIGNS FOUND BROKEN. REPLACED THE SIGNS, OPS TESTED GOOD IAW AMM 33-51-01-960-801, REV 82.SDR AALA201804029027Battery · inoperativeEMERGENCY FLASHLIGHT AT FLIGHT ATTENDANT SEAT NEAR THE L1 DOOR FOUND INOPERATIVE. REPLACED THE BATTERY IAW AMM 25-64-00.SDR N6WA20180040302Light · inoperativeCEILING EMERGENCY LIGHT AT ROW 11 INOPERATIVE. REMOVED AND REPLACED EMERGENCY FLOODLIGHT AT ROW 11 IAW MM 33-51-09. OPS CHECKED GOOD.SDR DALA2018033002134Battery Pack · inoperativeDURING INSPECTION, FOUND THE L2 DOOR EMERGENCY EXIT LIGHT INOPERATIVE. R & R THE BATTERY . OPS NORMAL.SDR DALA2018033002128Control Unit · no testEPCU FIN 11WL WILL NOT PASS IT'S SELF TEST, REPLACED THE EPCU FIN 11WLSDR DALA2018040202125Cover · detachedAISLE OVERHEAD EXIT SIGN, PLASTIC COVER DETACHED ABOVE ROW 26. INSTALLED THE COVER, OPS NORMALSDR QXEA2018033000126Lens · looseEMERGENCY LIGHT LENS, ROW 2 FEEL OFF. INSPECTED & FOUND CEILING LIGHT LENS LOOSE. SECURED THE LENS IAW AMM 33-22-00-01, NO OTHER DEFECTS NOTED. RETURNED TO SERVICE.SDR HNAA2018033000076Power Supply · inoperativeRIGHT FWD EMERGENCY LIGHT INOPERATIVE. MULTIPLE INTERIOR OVERHEAD AND EMERGENCY LIGHTS INOPERATIVE. R & R THE BATTERY AND POWER SUPPLY ASSY IAW AMM 33-58-04-400-801-A.SDR SIMA201803300003Lamp · inoperativeSERVICE DOOR EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE LAMP IAW AMM 33-50-10-000-801-A, AND 33-50-10-400-801-A. OPS CHECKED GOOD.SDR CALA2018032901059Battery Pack · dischargedMAIN DECK L1 DOOR HAD TWO EMERGENCY LIGHT BATTERY PACKS M33093 & M33424, TO HAVE LOW CAPACITY. REPLACED THE BATTERY PACKS, TESTED GOOD IAW AMM 33-51-06-960-802, REV 82.SDR CALA2018032901058Battery Pack · dischargedMAIN DECK R1 DOOR HAD ONE EMERGENCY LIGHT BATTERY PACK M33094 TO HAVE LOW CAPACITY. REPLACED BATTERY PACK AND OPS TESTED GOOD IAW AMM 33-51-06-960-802, REV 82.SDR CALA2018032901057Battery Pack · dischargedMAIN DECK L2 DOOR HAD ONE EMERGENCY LIGHT BATTERY PACK M33096 TO HAVE LOW CAPACITY. REPLACED THE BATTERY PACK, TESTED GOOD IAW AMM 33-51-06-960-802, REV 82.SDR CALA2018032901056Battery Pack · dischargedMAIN DECK L3 DOOR HAD ONE EMERGENCY LIGHT BATTERY PACK M33406 TO HAVE LOW CAPACITY. REPLACED THE BATTERY PACK, OPS TESTED GOOD IAW AMM 33-51-06-960-802, REV 82.SDR CALA2018032901055Battery Pack · dischargedMAIN DECK L4 DOOR ONE EMERGENCY LIGHT BATTERY PACK M33407 HAD LOW CAPACITY. REPLACED BATTERY PACK , OPS TESTED GOOD IAW AMM 33-51-06-960-802, REV.82.SDR SWAA2018040320883Sign · looseR1 DOOR EMERGENCY EXIT SIGN LOOSE. R & R THE SIGN IAW AMM.SDR AALA201804039027Lens · detachedL1DOOR EMERGENCY LIGHT LENS IS DETACHED. SECURED THE L1 EMERGENCY LIGHT LENS IAW AMM 33-51-13.SDR AALA201804039037Lens · damagedRIGHT SIDE EXIT EMERGENCY LIGHT COVER NOT CLEAR. MAINTENANCE REPLACED RIGHT SIDE AFT EXTERIOR EMERGENCY LIGHT LENS PER AMM 33-50-25 AND PERFORMED SATISFACTORY OPERATIONAL CHECK. AIRCRAFT WAS GROUNDEDSDR AALA201804039035Light · inoperativeEMERGENCY AISLE LIGHT ABOVE SEAT 23C INOPERATIVE. MAINTENANCE REPLACED THE LIGHT IAW AMM 33-51-05 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201804029005Sign · brokenEXIT SIGN AT THE R4 DOOR WAS FOUND BROKEN AND THE LENS DETACHED. INSTALLED AND SECURED THE EXIT SIGN.SDR AALA201804029004Lens · damagedTHE EMERGENCY ESCAPE AREA LIGHT ABOVE SEATS 12ABC LENS AND BEZEL FOUND DAMAGED. REPLACED EMERGENCY AISLE LIGHT LENS IAW AMM 33-51-03.SDR AALA201804019008Lens · detachedTHE AFT SERVICE DOOR EMERGENCY LIGHT LENS DETACHED. REPLACED THE SIGN ASSEMBLY IAW AMM 33-51-01.SDR AALA201803299026Lens · missingR2 DOOR EMERGENCY EXIT LIGHT LENS MISSING. INSTALLED A NEW LENS IAW AMM 33-51-16.SDR DALA2018033002046Fuse · failedDURING AN EMERGENCY LIGHT TEST, FOUND RIGHT AFT WING & RIGHT AFT GROUND EMERGENCY LIGHT INOPERATIVE. REMOVED & REPLACED THE FUSES, IAW AMM 33-51-06. OPS TESTED GOOD.SDR HNAA2018033000078Light · unknownFLOOR EMERGENCY LIGHT STRIP, SEAT 1A INOPERATIVE. PERFORMED AN OPS CHECK OF THE EMERGENCY LIGHT. OPS CHECKED NORMAL. OK FOR SERVICE.
E.SDR HNAA2018033000077Light · unknownREAR OVERHEAD AND AISLE EMERGENCY LIGHT WILL NOT ILLUMINATE. INSPECTED THE OVERHEAD & AISLE EMERGENCY LIGHTS, NO DEFECTS NOTED. OPS CHECKED GOOD IAW AMM 33-50-00-700-801-A.SDR IPXA2018032927953Bulb · inoperativeEMERGENCY LIGHT HAS THREE BULBS INOPERATIVE. REPLACED THE BULBS IAW AMM 33-51-01-2.SDR N6WA2018032803Light · inoperativeEXIT LIGHT AT THE RT OVERWING EXTERIOR HAS AN INOPERATIVE LIGHT.SDR N6WA2018032802Bulb · inoperativeEMERGENCY LIGHT HAD TWO BULBS INOPERATIVE.SDR SIMA20180328002Inverter · failedEMERGENCY LIGHTS 4 AND 5 INOPERATIVE. REMOVED AND REPLACED THE NR 5 INVERTER IAW AMM 33-50-11. OPS CHECKED GOOD.
Back to JASC 3350