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 MASA2017080412512Light · inoperativeROW 18 CEILING LEVEL EMERGENCY FLOOD LIGHT INOP. RELAMPED.SDR MASA2017080412511Light · inoperativeROW 9 CEILING LEVEL EMER FLOOD LIGHT INOP. RELAMPED.SDR ASOA201708047011Battery Pack · dischargedA/C WAS FOUND WITH A EMERGENCY LIGHT INOP IN THE GALLEY AREA. MAINTAINED REMOVED AND REPLACED NR 2 BATTERY PACK ASSY, OPS CHECK WAS GOOD IAW AMM 33-50-04 AND IPC 33-50-04. A/C RERELEASED BACK TO SERVICE.SDR DALA2017081706281Battery Pack · dischargedEXIT SIGN ABOVE AFT STAIRWAY DOOR INOP. REPLACED EMERGENCY LIGHTS BATTERY PACK AND CHARGER BASE.SDR SWAA2017081515704Lens · brokenFORWARD ENTRY LIGHT EGRESS LENS BROKEN. R&R LIGHT IAW AMM.SDR SWAA2017081115578Battery Pack · dischargedRT EMERGENCY LIGHTS INOP BETWEEN ROW 6 TO ROW 11. R&R BATTERY PACK IAW MM.SDR SWAA2017081115543Battery Pack · dischargedLT EMERGENCY LIGHTS INOP BETWEEN ROW 6 TO ROW 11. R&R BATTERY PACK IAW MM.SDR SWAA2017080915563Battery Pack · failedEMERGENCY LIGHT BATTERY PACK FAILED CAPACITY TEST AT LOCATION M01674. R&R BATTERY PACK PER AMM AND DWG.SDR AALA201708089040Light · damagedTHE AIRCRAFT WAS NOT GROUNDED. AFT RIGHT CABIN ENTRY DOOR EMERGENCY EXIT LIGHT DAMAGED. REMOVED & REPLACED LIGHT ASSY. OPS CHECKED MM 33-51-00.SDR AALA201708089021Battery Pack · dischargedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHTS AT 4R DOOR INOPERATIVE. REPLACED BATTERY PACK AT STATION 1634 PER 33-51-07. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201708089004Cover · missingAIRCRAFT WAS NOT GROUNDED. 4L DOOR EXIT SIGN COVER IS MISSING. REPLACED EXIT SIGN COVER PER AMM 33-51-01.SDR AALA201708089003Battery Pack · dischargedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHTS AT 4L DOOR INOPERATIVE. REPLACED BATTERY PACK AT STATION 1634 PER 33-51-07. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201708089001Sign · brokenAIRCRAFT WAS NOT GROUNDED. L2 DOOR LOWER EMERGENCY EXIT SIGN IS BROKEN OFF LOWER FASTENER. REPLACED L4 DOOR EMERGENCY EXIT LIGHT PER MM 33-51-13-000-001.SDR AALA201708079007Lens · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY LIGHT LENS MISSING BELOW VCR FIRST CLASS RT SIDE. INSTALLED EMERGENCY LIGHT LENS PER AMM 33-51-05. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201708079005Sign · unsecureAIRCRAFT WAS NOT GROUNDED. AFT L4 EXIT SIGN BROKEN. RE-SECURED EXIT SIGN PER AMM 33-51-00. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201708079003Cover · unsecureAIRCRAFT WAS NOT GROUNDED. R2 FLOOR LEVEL EXIT SIGN COVER IS OFF. INSTALLED EMERGENCY EXIT LIGHT LENS COVER IAW AMM 33-51-01.SDR SWAA2017080715514Battery Pack · malfunctionedFORWARD RIGHT EMERGENCY LIGHT CHARGER CIRCUIT BREAKER TRIPPED. R & R THE BATTERY PACK IAW AMM.SDR SWAA2017080715513Battery Pack · malfunctionedFORWARD LEFT EMERGENCY LIGHT CHARGER CIRCUIT BREAKER TRIPPED. R & R THE BATTERY PACK IAW AMM.SDR DALA2017080406015Battery Pack · inoperativeEXTERIOR EMERGENCY ILLUMINATION SYSTEM MALFUNCTIONED. ON ARRIVAL FOUND OVERWING EMERGENCY LIGHTS ON. REPLACED BATTERY PACK AND POWER SUPPLY, B5-125, IAW AMM 33-51-06. EMERGENCY LIGHT SYS OPS NORMAL.SDR DALA2017080305990Battery Pack · inoperativeFOUND LAST THREE EMERGENCY AISLE WAY LIGHTS OUT, AND R3 DOOR EXIT LIGHT OUT, FOUND DURING EMERGENCY LIGHT CHECK. R & R THE M736 BATTERY PACK IAW AMM 33-51-07-902-001. OPS CHECKED GOOD.SDR AALA201708049017Lens · missingL4 DOOR EXIT LIGHT COVER IS MISSING. FABRICATED TEMPORARY REPLACEMENT AND INSTALLED IAW EA 272249. REMOVED AND REPLACED LENS IAW AMM 33-51-10. OPS CHECKED GOOD.SDR AALA201708049018Lens · missingAIRCRAFT WAS NOT GROUNDED. CENTER AISLE FORWARD EXIT LOCATOR LENS COVER MISSING FOR OVERWING EXIT. REPLACED OVERWING EXIT LENS COVER.SDR AALA201708049004Lens · missingAIRCRAFT WAS NOT GROUNDED. L4 DOOR EMERGENCY EXIT LIGHT MISSING LENS COVER. REPLACED LENS COVER PER AMM 33-51-13. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR N6WA2017080301Light · unsecureEXIT LIGHT STRIP AT 18C FOUND LOOSE. SECURED THE LIGHT STRIP COVER IAW AMM 33-51-01.SDR AALA201708049016Bulb · inoperativeLIGHT BULBS INOPERATIVE AT THE R2 DOOR EMERGENCY SIGN. REPLACED THE LAMPS IAW AMM 33-51-00.0.SDR AALA201708049015Bulb · inoperativeLIGHT BULBS INOPERATIVE AT EMERGENCY EXIT OVERWING. REPLACED THE LAMPS IAW AMM 33-51-00.SDR FDEA201708032104Lens · crackedRIGHT DOOR EMERGENCY EXIT LIGHT COVER BROKEN FOUND DURING POST FLIGHT. REPLACED THET SIGN IAW AMM 33-51-01-2. OPS CHECKED GOOD. ACFT OK FOR SERVICE.SDR SIMA20170802001Light · brokenLEFT EMERGENCY LIGHT FOUND BROKEN. R & R THE EMERGENCY LIGHT IAW AMM 33-50-12.SDR SIMA20170802003Light · inoperativeEMERGENCY LIGHT FAILED TO ILLUMINATE. R & R THE EMERGENCY LIGHT IAW AMM 33-50-12.SDR FDEA201708022098Battery Pack · failedLEVEL 1 EMERGENCY LIGHT BATTERY 1 LOW ILLUMINATED DURING PREFLIGHT. REMOVED AND REPLACED EMERGENCY LIGHT BATTERY IAW AMM 33-51-01. OPS CHECKED GOOD. ACFT OKAY FOR SERVICE.SDR SWAA2017080815561Light · inoperativeAFT SERVICE DOOR HEADER PANEL EMERGENCY EXIT LIGHT BULB INOP. R&R LIGHT PER AMM.SDR SWAA2017080915531Sign · unsecureRT LOWER EMERGENCY EXIT SIGN LIGHT FELL OFF. R&R LIGHT ASSEMBLY PER MM.SDR CALA2017080802523Charger · inoperativeEXTERIOR EMERGENCY LIGHT SECOND TO THE LAST LIGHT ON LT SIDE INOPERATIVE. REMOVED AND REPLACED THE BATTERY PACK AND CHARGER M738 IAW AMM 33-51-07. OPS NORMAL.SDR ASOA201708025097Battery Pack · inoperativeDURING MX INSPECTION, THE EMERGENCY LIGHTS WERE DISCOVERED INOPERATIVE. MX REMOVED AND REPLACED THE NR 3 EMERGENCY LIGHT BATTERY PACK. OPS CHECKED GOOD. ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR AALA201708079002Flashlight · inoperativeAIRCRAFT WAS NOT GROUNDED. RIGHT HAND MID GALLEY FLIGHT ATTENDANT FLASHLIGHT INOPERATIVE. REPLACED RIGHT HAND MID GALLEY FLASHLIGHT PER AMM 25-64-00. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR DALA2017080206016Battery Pack · inoperativePASSENGER SEAT EMERGENCY EXIT LIGHTS OUT AT ROW 26 TO 37. R & R THE BATTERY CHARGER AND BATTERY PACK AT M9102 IAW AMM 33-51, OPS CHECKED GOOD.SDR AALA201708049023Cover · damagedTHE AIRCRAFT WAS NOT GROUNDED. FAR RIGHT DOOR EMERG EXIT LIGHT COVER DAMAGED. THE EXIT LIGHT WAS PLACED ON NEF DEFERRAL 3320E. 4R EMERGENCY EXIT LIGHT STILL OPERATED NORMALLY. REPLACED R4 DOOR EMERGENCY EXIT LIGHT LENS COVER . OPERATIONAL CHECK GOOD.SDR AALA20170802006Cover · missingTHE AIRCRAFT WAS NOT GROUNDED. CREW REPORTED RIGHT FWD OVERWING EMERGENCY LIGHT ASSY LIGHT COVER MISSING. REPLACED RIGHT FWD OVERWING EMERGENCY LIGHT ASSY IAW AMM 33-51-01. OPS CHECKS NORMAL.SDR AALA201708049025Battery · dischargedAIRCRAFT WAS NOT GROUNDED. FIRST CLASS SEAT MOUNTED EMERGENCY LIGHTS ARE INOPERATIVE. REMOVED AND REPLACED BATTERY AND CHARGER (AALA20170802004) IAW AMM 33-51-07. SYSTEM CHECKS GOOD.SDR AALA201708049021Light · inoperativeAIRCRAFT IN BASE MAINTENANCE. FLIGHT DECK DOOR EMERGENCY LIGHT DID NOT CYCLE PROPERLY DURING TEST. REPLACED EMERGENCY LIGHT PER AMM 33-51-01-022-029.SDR AALA201708049005Lens · unsecureEXIT LIGHT COVER WILL NOT STAY IN PLACE AT LEFT FORWARD WINDOW EXIT. REMOVED AND REPLACED THE LENS AMM 33-50-00. OPS CHECKED GOOD.SDR R61A201708020570Power Unit · inoperativeCOCKPIT EMERGENCY LIGHT INOP. R&R EMERGENCY LIGHT POWER UNIT NR 1 IAW AMM 33-50-01. OPS CHECK GOOD.SDR CALA2017080402464Light · inoperativeDOOR 1 RT EXT EMERG LIGHT INOP. RELAMPED R1 DOOR EXT EMERGENCY LIGHT, OPS NORMAL.SDR AALA201708049006Light · brokenAIRCRAFT WAS NOT GROUNDED. FOUND R1 DOOR EMERGENCY EXIT HOLDER BROKEN. REPLACED R1 DOOR EMERGENCY EXIT LIGHT PER AMM 33-51-13. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR IPXA2017080220076Light · inoperativeEXTERIOR EMERGENCY LIGHT INOP. RELAMPED SAME AND CKS PER AMM 33-51-16-96-001.SDR IPXA2017080320088Power Supply · inoperativeDURING PREFLIGHT LVL 1 "EMER LT BATT 1 LO" ILLUMINATED AFTER EMERGENCY LIGHTS TEST. R&R BATTERY SUPPLY IAW AMM 33-51-01-401.SDR SWAA2017080415511Light · brokenFWD ENTRY LOWER LIGHT ASSY BROKEN. R & R THE LIGHT ASSY IAW MM.SDR SWAA2017080415510Lamp · inoperativeR1 DOOR EMERGENCY EXIT LIGHT INOPERATIVE. REPLACED THE LAMPS IAW MM.SDR SWAA2017080415509Lamp · inoperativeRIGHT OVERWING EMERGENCY EXIT LIGHT INOPERATIVE. REPLACED THE LAMPS IAW MM.SDR AALA201708039014Lens · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY SIGN 4R MISSING. REPLACED 4R DOOR EMERGENCY EXIT SIGN LENS.
Back to JASC 3350