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 SWAA2017092016475Sign · detachedMID CABIN OVERWING EXIT SIGN FELL OFF. SECURED SIGN PER SIP.SDR AALA201709189045Pin · shearedEMERGENCY EXIT SIGN BY THE L3 DOOR HAS SHEARED SUPPORT BRACKET MOUNT PINS. ACCOMPLISHED PERMANENT REPAIRED IAW DWG 33-51-01-1, AND AMM 33-51-01. OPS CHECKED GOOD.SDR SWAA2017091916452Light · inoperativeRT EMERGENCY AREA LIGHT INOP AT ROW 18. RELAMPED LIGHT PER AMM.SDR SWAA2017091916446Sign · brokenRT OVERWING EXIT SIGN BROKEN. R&R SIGN PER MM.SDR SWAA2017091916439Lens · brokenR1 DOOR LOWER EMERGENCY LIGHT LENS BROKEN. R&R LIGHT ASSEMBLY PER MM.SDR SWAA2017091916438Cover · unsecureFORWARD OVERWING EMERGENCY EXIT SIGN COVER FELL OFF. INSTALLED SIGN PER AMM.SDR YENA201709150773Battery Pack · no testEMERGENCY LIGHT BATTERY FAILED A CAPACITY TEST. R & R THE BATT IAW AMM 33-51-38, AND OPS CHECKED GOOD.SDR YENA201709150772Battery Pack · no testEMERGENCY LIGHT BATTERY FAILED A CAPACITY TEST. R & R THE BATTERY IAW AMM 33-51-38, OPS CHECKED GOOD.SDR DALA2017091806961Light · brokenEMERGENCY SEAT MOUNTED LIGHT DAMAGED, REPLACED THE EMERGENCY LIGHT.SDR AALA201709189005Light · brokenEMERGENCY STAND BY LIGHT IN LAVATORY L34 BROKEN. REPLACED THE EMERGENCY LIGHT. AIRCRAFT WAS GROUNDED.SDR AALA201709189035Power Supply · no testAFT EMERGENCY POWER UNIT NOT TESTING. REPLACED POWER UNIT IAW AMM.SDR AALA201709189019Lens · missing12C FLOOR LEVEL EMERGENCY LIGHT LENS MISSING. REPLACED THE LENS IAW AMM.SDR AALA201709189015Battery Pack · faultedDURING EMERGENCY POWER SUPPLY UNIT OPERATIONAL CHECK, RECEIVED A FAULT MESSAGE. REMOVED AND REPLACED THE EPSU BATTERY IAW AMM.SDR AALA201709189014Lens · brokenSEAT 22C EMERGENCY LIGHT LENS BROKEN. REPLACED THE LIGHT ASSY IAW AMM.SDR AALA201709189013Lens · missingSEAT 22R MOUNTED EMERGENCY LIGHT LENS MISSING. REPLACED THE LIGHT ASSY IAW AMM.SDR REXA2017091501004Charger · inoperativeAFT INTERIOR AND EXTERIOR EMERGENCY LIGHTS INOPERATIVE. REMOVED AND REPLACED BOTH BATTERY PACKS AND BATTERY CHARGER NR 5 IAW AMM 33-51-17.SDR JJBA20170915025Light · inoperativeGALLEY THRESHOLD EXIT LIGHT INOPERATIVE. R & R THE LIGHT ASSY. OPS CHECKED GOOD.SDR DALA2017091806933Cover · unsecureEMERGENCY EXIT SIGN COVER LOOSE. INSTALLED EXIT SIGN. OPS CHECKED GOOD.SDR MASA2017091512632Battery Pack · inoperativeEMERGENCY EXIT LIGHTS ROW 13 AND 14 INOPERATIVE. R & R THE BATTERY PACK AND CHARGER.SDR CALA2017091503203Battery Pack · inoperativeLAST 4 AREA EMERGENCY LIGHTS INOPERATIVE. REMOVED AND REPLACED THE BATTERY PACK IAW AMM 33-51-06. OPS CHECKED GOOD.SDR CALA2017091503202Charger · inoperativeFIRST THREE FWD RIGHT OVERHEAD EMERGENCY LIGHTS FOUND INOPERATIVE. REMOVED AND REPLACED THE CHARGER AND BATTERY IAW AMM 33-51-06. OPS CHECKED GOOD.SDR CALA2017091503201Battery Pack · no testEMERGENCY LIGHTS FAILED TO TEST. REMOVED AND REPLACED THE BATTERY PACK ABOVE ROW 29 DEF IAW AMM 33-51-06. OPS CHECKED GOOD.SDR CALA2017091503200Lens · crackedEMERGENCY SIGN LENS AT THE L1 DOOR FELL OFF AND CRACKED. REPLACED THE SIGN LENS IAW AMM 25-00-00. NO DEFECTS NOTED. OPS CHECKED GOOD.SDR CALA2017091503199Bulb · burned outL1 DOOR HAS TWO OUT OF SIX EMERGENCY LIGHT BULBS BURNED OUT. REPLACED THE BULBS. OPS CHECKED NORMAL.SDR CALA2017091503196Bulb · inoperativeL3 DOOR EXTERIOR EMERGENCY LIGHT FOUND INOPERATIVE. REMOVED AND REPLACED THE BULB IAW AMM 33-51-06, OPS CHECKED GOOD.SDR CALA2017091503193Light · missingEMERGENCY LIGHT MISSING AT ROW 26 ABC. REPLACED THE EMERGENCY LIGHT ASSY. OPS CHECKED GOOD.SDR CALA2017091503187Lens · missingLENS IS MISSING FROM EMERGENCY LIGHT ON CEILING AT RT AISLE NEAR THE MIDDLE CROSS AISLE. REPLACED THE LENS.SDR CALA2017091503186Bulb · inoperativeEMERGENCY LIGHTS DISARMED LIGHT BULB INOPERATIVE. REPLACED THE BULB. OPS NORMAL.SDR CALA2017091503185Cover · missingDURING A CHECK, FOUND THE L3 DOOR CEILING EMERGENCY LIGHT COVER MISSING. COVER INSTALLED.SDR CALA2017091503184Cover · missingL1 DOOR JUMPSEAT EMERGENCY LIGHT COVER MISSING.SDR CALA2017091503182Cover · damagedSEATS 2E AND 1D EMERGENCY LIGHT, COVER IS DAMAGE. REMOVED AND REPLACED EMERGENCY LIGHT AT SEATS 2E AND 1 D IAW AMM 33-51-06-00A-520A-A.SDR CALA2017091503210Lamp · abnormalL2 SLIDE LIGHT INOPERATIVE. REPLACED THE LAMPS, OPS CHECKED CHECKED NORMAL.SDR CALA2017091503206Power Supply · malfunctionedCABIN EMERGENCY LIGHTS, OPS CHECK FAILED. FAULTED EPSU BATTERY EMERGENCY LIGHT RESET SYS, OPS CHECKED OK IAW AMM 33-51-38,SDR CALA2017091503189Lamp · inoperativeEMERGENCY LIGHT AT RIGHT AFT LOWER FUSELEAGE IS INOPERATIVE. REPLACED THE LAMP, TESTED OK.SDR CALA2017091503188Lamp · inoperativeEMERGENCY LIGHT AT LEFT CEILING ROW 24 WAS INOPERATIVE. REPLACED THE LAMP. OPS CHECKED OK.SDR CALA2017091503183Light · detachedFLOOR EMERGENCY LIGHT AT THE R2 DOOR WAS KNOCKED OFF THE MOUNTING. REINSTALLED THE LIGHT. OPS CHECKED GOOD.SDR CALA2017091503207Light · missingSEAT 29C EMERGENCY LIGHT MISSING. INSTALLED THE EMERGENCY LIGHT. OPS CHECKED GOOD.SDR CALA2017091503205Lens · brokenSEAT 24C EMERGENCY LIGHT FLOOR LEVEL LENS FOUND BROKEN. REPLACED THE LENS.SDR CALA2017091503204Lens · missingEMERGENCY EXIT LIGHT LENS MISSING IN 1ST CLASS. INSTALLED THE LENS. LIGHT OPS CHECKED OK.SDR DALA2017091506910Lens · damagedDURING INSPECTION, FOUND THE EMERGENCY EXIT LIGHT DIFFUSER LENS DAMAGED. MAINTENANCE INSTALLED A NEW LENS ASSY. ACFT OK FOR SERVICE.SDR DALA2017091506908Battery Pack · inoperativeEMERGENCY LIGHTS BATTERY PACK B5-23 INOPERATIVE. REPLACED THE BATTERY PACK IAW AMM 33-53-00.SDR DALA2017091506909Light · inoperativeAFT STAIR FLOOD LIGHTS LEFT AND RIGHT DO NOT COME ON. REPLACED THE LEFT & RIGHT AFT STAIR FLOOD LIGHT ASSY.SDR AALA201709189027Sign · brokenEMERGENCY EXIT SIGN AND COVER BROKEN AT R1 DOOR, FLOOR AREA. REPLACED EMERGENCY EXIT SIGN IAW AMM 33-51-13. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201709189024Battery Pack · no testEMERGENCY POWER SUPPL BATTETY PACK 11WL, WILL NOT PASS THE TEST. REPLACED EMERGENCY LIGHTING BATTERY PACK IAW AMM 33-51-38.SDR SWAA2017091816389Lens · crackedL1 DOOR LOWER EMERGENCY EXIT SIGN LENS CRACKED. R&R SIGN PER AMM.SDR SWAA2017091816366Lens · unsecureL1 DOOR EMERGENCY EXIT SIGN LENS FELL OFF. R&R SIGN BASE ASSEMBLY PER MM.SDR AALA201709159023Battery · failedBATTERY FAULT ESPU FAILED A CHECK. REPLACED THE BATTERIES. THE AIRCRAFT WAS GROUNDED.SDR CALA2017091503164Charger · no testR3 DOOR FWD CEILING EMERGENCY LIGHT FOUND DIM. THE CHARGER WAS REPLACED AND TESTED NORMAL IAW AMM 33-51-06.SDR CALA2017091503163Charger · no testL2 DOOR AREA EMERGENCY LIGHT FOUND DIM. THE CHARGER WAS REPLACED AND TESTED NORMAL IAW AMM 33-51-06.SDR CALA2017091503162Charger · no testL4 DOOR CEILING EMERGENCY LIGHT FOUND DIM. LIGHT BATTERY CHARGER REPLACED AND TESTED NORMAL IAW AMM 33-51-06
Back to JASC 3350