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 CALA2017072102316Reflector · defectiveR2 DOOR EMERGENCY SLIDE LIGHT INOP. REPLACED LIGHT ASSY REFLECTOR. OPS CKS GOOD.SDR MASA2017072112479Light · inoperativeOVERHEAD EMERGENCY FLOOD LIGHT ROW 21 INOPERATIVE.SDR IPXA2017072119576Cover · detachedEMERGENCY EXIT SIGN COVER AT MAIN DOOR FELL OFF. SECURED THE SIGN COVER IAW AMM 33-51-01-201, OPS CHECKED OKSDR JJBA20170720027Inverter · inoperativeAISLE EMERGENCY LIGHT INOPERATIVE. R & R THE NR 4 INVERTER.SDR AALA20170725006Power Supply · no testEMERGENCY EXIT CEILING LIGHT IN LEFT ZONE A, IS INOPERATIVE. REMOVED AND REPLACED THE POWER SUPPLY M33099 IAW AMM 33-51-06. OPS CHECKED GOOD.SDR SWAA2017072515277Lens · brokenFORWARD ENTRY EMERGENCY EXIT LIGHT LENS BROKEN. R&R LENS PER MM.SDR SWAA2017072515261Battery Pack · dischargedFORWARD RT EMERGENCY LIGHT INOP AT LOCATION M1674. R&R BATTERY PACK PER AMM.SDR DALA2017072205684Light · unsecureSEAT MOUNTED EMERGENCY LIGHTS HANGING BY WIRES AT 16D. REMOVED AND REPLACED SEAT TRIM AT SEAT 16D THAT MOUNTS EMERGENCY LIGHTS. OPS CHECK GOOD.SDR JJBA20170720024Power Supply · inoperativeCEILING EMERGENCY LIGHTS AT 1 AND 3 INOPERATIVE. R & R THE NR 3 BATTERY POWER UNIT, R & R NR 3 AND 6 EMERGENCY LIGHT BATTERY PACKS, OPS CHECKED.SDR AALA201707249034Module · not seatedSEAT MOUNTED EMERGENCY LIGHT AT SEAT 30D IS INOPERATIVE. RESEATED LIGHT MODULE IAW AMM 33-51-11. OPS CHECKED GOOD.SDR AALA201707249030Washer · missingEMERGENCY EXIT SIGN AT THE L1 DOOR HAS A MISSING WASHER. INSTALLED WASHER IAW AMM 33-51-01. OPS CHECKED GOOD.SDR AALA20170724005Washer · missingEMERGENCY EXIT SIGN AT THE L4 DOOR HAS A MISSING WASHER. INSTALLED WASHER IAW AMM 33-51-01. OPS CHECKED GOOD.SDR SWAA2017072415240Battery · no testEMERGENCY LIGHT BATTERIES FAILED CAPACITY TEST AT LOCATION M1672. R & R THE BATTERY IAW AMM AND DWG.SDR SWAA2017072415239Battery · no testEMERGENCY LIGHT BATTERIES FAILED CAPACITY TEST AT LOCATION M1673. R & R THE BATTERY IAW AMM AND DWG.SDR SWAA2017072415237Battery · no testEMERGENCY LIGHT BATTERIES FAILED A CAPACITY TEST AT LOCATION M1670. R & R THE BATTERY IAW AMM AND DWG.SDR SWAA2017072415205Cover · looseAFT GALLEY EMERGENCY EXIT LIGHT SWITCH COVER LOOSE. SECURED THE COVER IAW SIP.SDR SWAA2017072415203Guard · brokenP5 EMERGENCY LIGHT SWITCH GUARD BROKEN. R & R THE GUARD IAW SIP.SDR SWAA2017072415202Cover · brokenRIGHT EMERGENCY EXIT DOOR HANDLE COVER BROKEN. R & R THE COVER ASSEMBLY IAW AMM.SDR SWAA2017072415171Lens · detachedMID CABIN OVERHEAD EXIT SIGN CAME OFF. REINSTALLED LENS IAW AMM.SDR SWAA2017072415170Lens · missingR2 DOOR EMERGENCY EXIT LIGHT COVER LENS MISSING. INSTALLED THE LENS IAW AMM.SDR IPXA2017072419682Lens · unsecureEMERGENCY EXIT LIGHT COVER NEXT TO CREW ENTRY DOOR FELL OFF. REINSTALLED THE COVERSDR PNSA2017072402Power Supply · no testPOWER SUPPLIES 11LN AND 13LN FAILED 6 MONTH INSPECTION TASK 335102SDR AALA201707249031Lens · brokenL1 DOOR EMERGENCY EXIT SIGN LENS BROKEN. REPLACED EMERGENCY LIGHT LENS IAW AMM 33-51-13.SDR AALA201707249017Light · brokenBROKEN R1 DOOR EMERGENCY EXIT LIGHT ASSEMBLY. REPLACED LIGHT ASSEMBLY PER MM 33-51-13. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201707249005Light · brokenL4 DOOR EMERGENCY LIGHT BROKEN. REPLACED EMERGENCY LIGHT IAW AMM 33-51-13.SDR AALA201707249004Lens · brokenR1 DOOR EMERGENCY EXIT SIGN LENS BROKEN. REPLACED THE LENS IAW AMM 33-51-13.SDR AALA201707249003Lens · crackedEMERGENCY LIGHT LENS IS CRACKED, BOTTOM LEFT LAVATORY D. REPLACED THE EMERGENCY LIGHT IAW AMM 33-51-18.SDR AALA201707219007Battery Pack · failedFORWARD LEFT EMERGENCY LIGHT BATTERY PACK FAILED. REPLACED FORWARD LEFT EMERGENCY LIGHT BATTERY PACK. AIRCRAFT WAS GROUNDED.SDR AALA20170721001Light · brokenBROKEN L4 DOOR EMERGENCY EXIT LIGHT ASSEMBLY. REPLACED LIGHT ASSEMBLY IAW MM 33-51-13. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR IPXA2017072119594Lens · detachedEXIT SIGN ABOVE THE R1 DOOR FELL OFF. INSTALLED THE LENS IAW AMM 33-52-04. CHECKED NORMAL.SDR IPXA2017072019566Battery Pack · inoperativeLEFT EMERGENCY DOME LIGHT INOPERATIVE. R & R THE BATTERY PACK & CHARGER, GROUND OPS CKS GOOD IAW 33-50-00.SDR AALA201707219008Lens · brokenCEILING PANEL EXIT LIGHT LENS WAS BROKEN. REPLACED LENS. AIRCRAFT WAS GROUNDED.SDR DALA2017072105600Fuse · blownEMERGENCY LIGHT INOPERATIVE AT RIGHT ROW. FOUND BLOWN FUSE ON THE POWER SUPPLY AND REPLACED. SYSTEM OPERATION IS NORMAL.SDR AALA201707219005Switch · intermittentEMERGENCY EXIT LIGHT WILL NOT TURN OFF. CYCLED EMERGENCY LIGHT SWITCH.SDR AALA201707219004Light · intermittentEMERGENCY EXIT LIGHT AT THE R1 DOOR WAS INTERMITTENT. REMOVED AND REPLACED THE LOWER EMERGENCY LIGHT ASSEMBLY.SDR MASA2017072012476Light · inoperativeROW 18 CEILING LEVEL EMERGENCY FLOOD LIGHT INOP. PLACED ON MEL.SDR MASA2017072012475Light · inoperativeROW 6 CEIL EMER FLOOD LT INOP. PLACED ON MEL.SDR ASOA20170718008VBattery · inoperativeDURING A ROUTINE CHECK, FOUND THAT SEVERAL EMERGENCY LIGHTS WERE INOPERATIVE. MAINTENANCE REMOVED AND REPLACED BATTERIES NUMBER 3 AND 4 IAW AMM 33-50-04. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR AALA201707219011Lens · missingFOUND OVERHEAD EMERGENCY LIGHT 209WL MISSING LENS. REPLACED OVERHEAD EMERGENCY LIGHT IAW AMM 33-51-11.SDR AALA20170724013Power Supply · inoperativeAIRCRAFT WAS IN BASE MAINTENANCE. EMERGENCY EXIT LIGHTS POWER SUPPLY M33424 AT THE L1 DOOR FAILED TEST. REMOVED AND REPLACED POWER SUPPLY PER AMM 33-51-06. OPERATIONAL CHECK GOOD.SDR AALA20170724012Power Supply · inoperativeAIRCRAFT WAS IN BASE MAINTENANCE. EMERGENCY EXIT LIGHTS POWER SUPPLY M33097 AT THE R2 DOOR FAILED TEST. REMOVED AND REPLACED POWER SUPPLY PER AMM 33-51-06. OPERATIONAL CHECK GOOD.SDR AALA20170724011Power Supply · inoperativeAIRCRAFT WAS IN BASE MAINTENANCE. EMERGENCY EXIT LIGHTS POWER SUPPLY M33409 AT THE R4 DOOR FAILED TEST. REMOVED AND REPLACED POWER SUPPLY PER AMM 33-51-06. OPERATIONAL CHECK GOOD.SDR AALA20170724010Saddle · missingAIRCRAFT WAS IN BASE MAINTENANCE. EMERGENCY EXIT SIGN OVER AISLE BY THE R2 DOOR HAS 2 MISSING SADDLES. INSTALLED SADDLES PER AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR SWAA2017072515252Battery · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1673. R & R THE BATTERY IAW AMM.SDR SWAA2017072515251Battery · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1672. R & R THE BATTERY IAW AMM.SDR SWAA2017072515250Battery · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1670. R & R THE BATTERY IAW AMM.SDR SWAA2017072515249Battery · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1675. R & R THE BATTERY IAW AMM.SDR SWAA2017072515199Lens · looseRIGHT OVERWING UPPER EMERGENCY EXIT LENS LOOSE. SECURED THE LENS IAW SIP.SDR SWAA2017072515185Battery · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1669. R & R THE BATTERY IAW AMM.SDR SWAA2017072415233Lamp · inoperativeLEFT OVERWING EXIT AFT EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS IAW AMM.
Back to JASC 3350