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 CALA2017081802770Light · looseEMERGENCY LIGHTING FLOOR STRIP LOOSE BY SEAT 2E. REPLACED SOCKET ASSY. OPS CHECK PROVES NORMAL.SDR CALA2017081802768Power Supply · inoperativeSEATS 21AB AND 22AB LOWER EXIT SIGN INOP. REPLACED M1559 EMERGENCY LIGHTS POWER SUPPLY, REF WDM 33-51-14. OPS CK OK.SDR CALA2017081802767Battery Pack · dischargedM/D L3 DOOR 2EA EMER LT POWER PACK (M33406) FOUND LOW CAPACITY. REPLACED THE M/D L3 DOOR EMER LT POWER PACK M33406 AND OPERATION AL TEST CARRY OUT, FOUND NORMAL AS PER AMM 33-51-06-960-802 REV80 .SDR CALA2017081802766Battery Pack · dischargedM/D L3 DOOR EMER LT POWER PACK (M33400) FOUND LOW CAPACITY. REPLACED THE M/D L3 DOOR EMER LT POWER PACK M33400 AND OPERATION AL TEST CARRY OUT FOUND NORMAL AS PER AMM33-51-06-960-802 REV 80 .SDR CALA2017081802765Battery Pack · dischargedR1 DOOR EMERGENCY LIGHT BATTERY PACK CAPACITY FOUND LOW (M33094). REPLACED THE CABIN R1 DOOR EMERGENCY LIGHT BATTERY PACK M33094 AND OPERATIONAL TEST CARRIED OUT, FOUND NORMAL AS PER AMM 33-51- 06-960-802 REV 80.SDR CALA2017081802764Battery Pack · dischargedL1 DOOR EMERGENCY LT BATTERY PACK CAPACITY FOUND LOW (M33424). REPLACED THE CABIN L1 DOOR EMERGENCY LT BATTERY PACK M33424 AND OPERATIONAL TEST CARRIED OUT, FOUND NORMAL AS PER AMM 33-51-06-9 60-802 REV 80.SDR CALA2017081802763Battery Pack · dischargedL2 DOOR EMERGENCY LT BATTERY PACK CAPACITY FOUND LOW (M33099). REPLACED THE L2 DOOR EMERGENCY LT BATTERY PACK (M33099) AND OPERATIONAL TEST CARRIED OUT, FOUND NORMAL AS PER AMM 33-51-06-9 60-802 REV 80.SDR CALA2017081802762Light · brokenLLAR ENTRY DOOR FWD EMERGENCY LT FOUND BROKEN. REPLACED THE CABIN LLAR ENTRY DOOR FWD AREA EMERGENCY LT AND OPERATIONAL TEST CARRIED OUT, FOUND NORMAL AS PER AMM 33-51-05-9 60-802 REV 80.SDR CALA2017081802761Light · brokenZONE A & ZONE B PARTITION EMERGENCY LIGHT (TOTAL 4EA) FOUND BROKEN. REPLACED CABIN ZONE A & ZONE B PARTITION AREA EMERGENCY LIGHTS (TOTAL 4EA) AND OPERATIONAL TEST CARRIED OUT, FOUND NORMAL AS PER AMM 33-51-05-960-802 REV 80.SDR CALA2017081802760Battery Pack · dischargedM/D R4 DOOR 1EA EMER LT POWER PACK (M33409) FOUND LOW CAPACITY. REPLACED THE M/D R4 DOOR EMER LT POWER PACK M33409 AND CARRY OUT OPERATIONAL TEST FOUND NORMAL AS PER AMM 33-51-06-960-802 REV 80 .SDR CALA2017081802759Battery Pack · dischargedM/D R3 DOOR 1EA EMER LT POWER PACK (M33401) FOUND LOW CAPACITY. REPLACED THE M/D R3 DOOR EMER LT POWER PACK AND CARRIED OUT OPERATIONAL TEST, FOUND NORMAL AS PER AMM 33-51-06-960-802 REV80.SDR CALA2017081802758Light · brokenDOOR 4 GALLEY AREA 3EA EMERGENCY LIGHT FOUND BROKEN. REPLACED THE CABIN DOOR 4 GALLEY A4 AREA 3EA EMERGENCY LIGHT AND OP TEST CARRIED OUT, FOUND NORMAL AS PER AMM 33-51-05-960-802 REV80.SDR CALA2017081802757Sign · brokenM/D R3 DOOR AFT 1EA EXIT IDENTIFIER FOUND BROKEN. REPLACED THE CABIN R3 DOOR AFTER 1EA EXIT SKIN AND OP TEST CARRIED OUT, FOUND NORMAL AS PER AMM 33-51-01-960-802 REV80.SDR CALA2017081802756Light · brokenLAV 3A-LC RT AFTER EMERGENCY LIGHT FOUND BROKEN. REPLACED THE CABIN LAV 3A-LC RT AFTER EMERGENCY LIGHT AND OP TEST CARRIED OUT, FOUND NORMAL AS PER AMM 33-51-05-960-802 REV80.SDR CALA2017081802755Battery Pack · dischargedR2 DOOR EMERGENCY LT BATTERY PACK CAPACITY FOUND LOW (M33098). REPLACED THE CABIN R2 DOOR EMERGENCY LT BATTERY PACK M33098 AND OPERATIONAL TEST CARRIED OUT, FOUND NORMAL AS PER AMM 33-51-06-9 60-802 REV80.SDR CALA2017081802753Battery Pack · dischargedFOUND SEAT EEL LIGHTS DIM 33ABC-43ABC. REPLACED BATTERY PACK W6009. EFFECTED LIGHTS NOW BRIGHT. CHECKED SAFETY AND SECURITY AND VERIFIED OPERATION.SDR CALA2017081802752Light · inoperativeRT UPPER DECK EMERGENCY EXIT DOOR INTERNAL AFT LIGHT INOP. RT UPPER DECK EMERGENCY EXIT DOOR INTERNAL AFT LIGHT RELAMP. OPS CHECK GOOD REF 33-51-00. CHECKED SAFETY AND SECURITY AND VERIFIED OPERATION.SDR CALA2017081802776Sign · looseEMERGENCY EXIT SIGN ABOVE DOOR 2L FELL OFF. RESECURED EXIT SIGN.SDR CALA2017081802775Light · inoperativeSEAT 4D EMERGENCY LIGHTS INOP BOTH SIDES REPLACED SEAT 4D LIGHT ASSY. OP CKS GOOD.SDR CALA2017081802769Light · inoperativeON CHK FOUND EMER LT AT R1 INOP. EMER LT AT R1 RELAMP AND TEST OKAY IAW AMM 33-51-00.SDR CALA2017081802782Light · inoperativeL2 DOOR EXTERIOR EMERGENCY LIGHT IS INOP. REPLACED BULB OPS CHECK OK.SDR CALA2017081802779Lamp · inoperativeL1 DOOR SLIDE LIGHT INOPERATIVE. REMOVED AND REPLACED THE LAMP IAW AMM 33-51-06.SDR CALA2017081802777Sign · detachedEMERGENCY EXIT SIGN ABOVE THE L2 DOOR FELL OFF, ADJUSTED TABS AND SECURED THE SIGN.SDR CALA2017081802742Light · inoperativeOVERHEAD INTERIOR EMERGENCY LIGHT INOPERATIVE, ROW 7 CBA. REPLACED LIGHT ASSY. OPS CHECKED NORMAL.SDR MASA2017081812551Light · inoperativeROW 13 OVERHEAD EMERGENCY LIGHT INOPERATIVE.SDR DALA2017081806299Battery Pack · inoperativeEMERGENCY LIGHTS ROWS 22-25 CELING INOPERATIVE. R & R THE BATTERIES IN B5104. OPS CHECKED GOOD.SDR DALA2017081806288Light · damagedEMERGENCY FLOOR LIGHTING DAMAGED.SDR A6WA2017081845204Light · inoperativeEMERGENCY LIGHT BETWEEN ROWS 5-8 INOPERATIVE.SDR YENA201708180665Lens · brokenEMERGENCY EXIT LIGHT LENS AT SEAT 11C IS BROKEN. REPLACED THE LENS, OK FOR SERVICE.SDR SWAA2017102317259Lens · missingL1 DOOR LOWER EXIT LIGHT COVER MISSING. INSTALLED LENS PER MM.SDR AALA201708189028Light · brokenTHE AIRCRAFT WAS NOT GROUNDED. EXIT SIGN OVER AFT ENTRY DOOR IS BROKEN. REPLACED LIGHT ASSEMBLY (EXIT) AT L-2 DOOR PER AMM 52-20-00 OK FOR SVC.SDR AALA201708219071Lens · crackedEMERGENCY LIGHT IN THE AFT GALLEY HAS A CRACKED LENS. REMOVED AND REPLACED LIGHT ASSEMBLY IAW AMM 33-51-01. OPERATIONAL CHECKED GOOD.SDR AALA201708219070Lens · crackedEMERGENCY LIGHT IN THE LEFT FIRST CLASS GALLEY HAS A CRACKED LENS COVER. REMOVED AND REPLACED EMERGENCY LIGHT IAW AMM 33-51-05 AND WDM 33-51-11. OPERATIONAL CHECKED GOOD.SDR AALA201708219059Light · brokenAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT AT THE FORWARD RIGHT OVERWING EXIT IS BROKEN. REPLACED LIGHT ASSEMBLY PER AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA201708219048Lens · looseAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT AT THE RIGHT AFT GALLEY HAS A LOOSE LENS COVER. ADJUSTED LENS COVER PER AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA201708219047Lens · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT BY THE R4 DOOR HAS A MISSING LENS COVER. INSTALLED LENS COVER. OPERATIONAL CHECK GOOD.SDR DALA2017081806338Lamp · inoperativeLOWER CREW REST VERTICAL EXIT SIGN IS INOPERATIVE. REPLACED THE LAMPS. SIGN OPS CHECKED NORMAL.SDR DALA2017081806337Lamp · inoperativeLOWER CREW REST HORIZONTAL EXIT SIGN IS INOPERATIVE. REPLACED THE LAMPS. OPS CHECKED NORMAL.SDR AALA201708189007Relay · faultyEMERGENCY OVERHEAD EXIT LIGHTS WILL NOT ILLUMINATE IN AIRCRAFT CABIN. REMOVED AND REPLACED RELAY 8W AND WARNING CONTROL BOARD PER AMM 20-15-00.SDR SWAA2017082215854Cover · looseEMERGENCY EXIT SIGN COVER LOOSE. SECURED THE COVER IAW AMM.SDR AALA20170817007Light · damagedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT IDENTIFIER FORWARD GALLEY BY THE R1 DOOR IS DAMAGED. REMOVED AND REPLACED EXIT LIGHT ASSEMBLY PER AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR QXEA2017082100527Battery Pack · no testNR 2 EMERGENCY LIGHT BATTERY FAILED A 10 MINUTE CHECK. REPLACED POWER SUPPLY BATTERY PACK IAW AMM 33-51-01-000-801. CHECKED GOOD.SDR DALA2017081806312Power Supply · inoperativeL1 DOOR UPPER EMERGENCY LIGHT INOPERATIVE. R & R THE POWER SUPPLY AND BATTERY.SDR AALA201708189030Lens · missingRIGHT AFT SERVICE DOOR EMERGENCY EXIT LIGHT IS MISSING THE LENS. REPLACED LENS ASSY IAW MM 33-51-01.SDR AALA201708189029Sign · brokenAFT LEFT EMERGENCY EXIT SIGN BROKEN AT THE L2 DOOR. REPLACED THE SIGN IAW 33-51-14.SDR AALA201708189027Lens · brokenLEFT AFT ENTRY DOOR EMERGENCY LIGHT LENS BROKEN. REPLACED THE LENS, IAW MM 33-51-00. OK FOR SERVICE.SDR SWAA2017081715803Lens · missingRIGHT EMERGENCY EXIT LOWER LIGHT LENS MISSING. R & R THE LENS ASSEMBLY IAW MM.SDR SWAA2017081815795Battery Pack · no testEMERGENCY BATTERY PACK FAILED CAPACITY CHECK AT LOCATION M01673. R & R THE BATTERY PACK IAW AMM.SDR SIMA20170817002Bulb · inoperativeROW 17 EMERGENCY CEILING LIGHT INOPERATIVE. REMOVED AND REPLACED THE BULB IAW AMM 33-50-08-000-801-A, AND 33-50-08-400-801-A. OPS CHECKED GOOD.SDR SIMA20170817003Charger · inoperativeRIGHT OVERWING EMERGENCY LIGHTS INOPERATIVE. R & R THE BATTERY AND CHARGER IAW W/C 33-700-19. OPS CHECKED GOOD.
Back to JASC 3350