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 MASA2017110912752Light · inoperativeLEFT FWD EXTERNAL EMERGENCY LIGHT INOPERATIVE.SDR MASA2017110912751Lamp · inoperativeLEFT EMERGENCY EXIT DOOR, EXIT SIGN INOPERATIVE. REPLACED THE LAMPS.SDR UIEA2017110902206Light · inoperativeEMERGENCY LIGHTS INOPERATIVE AT ROW 1. REMOVED AND REPLACED THE LIGHT ASSY IAW AMM 33-51-10, OPS CHECKED GOOD. OK FOR SERVICE.SDR SWAA2017111517841Light · damagedRIGHT OVERHEAD BIN BULLNOSE EMERGENCY LIGHT DAMAGED AT ROW 8. R & R THE LIGHT IAW AMM.SDR SWAA2017111517833Lens · crackedRIGHT EMERGENCY EXIT LIGHT LENS CRACKED BETWEEN ROWS 21 TO 25. R & R THE LENS IAW AMM.SDR SWAA2017111517829Battery · no testEMERGENCY LIGHT BATTERY FAILED A CAPACITY TEST AT LOCATION M01675. R & R THE BATTERY IAW AMM.SDR SWAA2017111517828Battery · no testEMERGENCY LIGHT BATTERY FAILED A CAPACITY TEST AT LOCATION M01673. R & R THE BATTERY IAW AMM.SDR SWAA2017111517827Battery · no testEMERGENCY LIGHT BATTERY FAILED A CAPACITY TEST AT LOCATION M01672. R & R THE BATTERY IAW AMM.SDR SWAA2017111517782Lens · missingLEFT OVERHEAD BIN BULLNOSE EMERGENCY LIGHT LENS MISSING BETWEEN ROW 11 TO ROW 12. INSTALLED A LENS IAW AMM.SDR SWAA2017111517770Battery · no testEMERGENCY LIGHT BATTERY FAILED A CAPACITY TEST AT LOCATION M01669. R & R THE BATTERY IAW AMM.SDR SWAA2017111517766Lens · detachedRIGHT OVERWING EMERGENCY SIGN LIGHT LENS FELL OFF. R & R THE SIGN IAW AMM.SDR SWAA2017111517709Lens · crackedLEFT EMERGENCY LIGHT LENS CRACKED BETWEEN ROWS 16 TO 19. R & R THE LENS IAW AMM.SDR SWAA2017111317743Light · inoperativeRT EMERGENCY LIGHT INOP AT ROW 11. RELAMPED LIGHT IAW AMM.SDR SWAA2017111317697Lens · detachedLEFT FORWARD EMERGENCY EXIT LIGHT LENS FELL OFF. REPLACED THE LIGHT ASSEMBLY IAW AMM.SDR DALA2017110908081Lens · missingEMERGENCY EXIT DIFFUSER LENS MISSING ABOVE ROW 29.SDR A6WA2017110945405Inverter · inoperativeDURING AN ACCEPTANCE CHECK, CREW REPORTED THE RIGHT OVERWING EXIT EMERGENCY SIGN WAS INOPERATIVE. REMOVED AND REPLACED THE NR 3 EMERGENCY LIGHTS INVERTER IAW AMM 33-51-07, OPS CHECKED GOOD.SDR AALA201711109027Lens · missingTHE AIRCRAFT WAS NOT GROUNDED. LENS MISSING FROM EXIT IDENTIFIER ON G4B COMP 578. REPLACED LENS ON L1190. EPL CHECKS GOOD PER AMM 33-51-01.SDR AALA201711109022Mount · brokenTHE AIRCRAFT WAS NOT GROUNDED. L3 DOOR EXIT SIGN CROSS BAR BROKEN. REPLACED L3 DOOR EXIT SIGN MOUNT PER MM 20-11-00. OK FOR SERVICE.SDR AALA201711109021Lens · missingTHE AIRCRAFT WAS NOT GROUNDED. L AFT EMER EXIT LIGHT MISSING, ITS THE VERTICAL ONE BY THE DOOR. REINSTALLED EM EXIT LIGHT LENS OPS CKS OK PER MM 25-60.SDR AALA201711109020Lens · missingTHE AIRCRAFT WAS NOT GROUNDED. AFT ENTRY EXIT DOOR LENS LIGHT IS MISSING. REINSTALLED THE MISSING LENS COVER, ABOVE THE AFT, LEFT DOOR AS PER STANDARD PRACTICE.SDR FDEA201711083189Cover · broken1R ENTRY DOOR, SIDE EXIT LIGHT COVER BROKEN OFF. REMOVED AND REPLACED BROKEN EMERGENCY EXIT LIGHT IAW AMM 33-51-01-2. OPS CHECKED GOOD AT THIS TIME. A/C OK FOR SERVICE. (EXIT INDICATOR ASSY, GOODRICH P/N 702409-1001)SDR SIMA20171108006Power Supply · inoperativeBOTH OVERWING EMERGENCY LIGHTS INOPERATIVE. REMOVED AND REPLACED THE POWER SUPPLY IAW AMM 33-50-04. OPS GOOD.SDR SIMA20171108004Light · inoperativeAFT EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE EMERGENCY LIGHT IAW AMM 33-50-12. OPS CHECKED GOOD.SDR SIMA20171108005Light · inoperativeAFT AISLE EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE EMERGENCY LIGHT IAW AMM 33-50-08. OPS CHECKED GOOD.SDR AALA201711099016Lens · damagedSEATS 9C, EMERGENCY LIGHT LENS DAMAGED. REPLACED THE LENS.SDR AALA201711099015Lens · missingEMERGENCY LIGHT LENS ROW 1 DF MISSING. REPLACED THE LENS IAW AMM.SDR AALA201711099008Lens · missingCENTER AISLE EMERGENCY. LIGHT LENS MISSING AT ROW 15. REPLACED THE LENS.SDR AALA201711099002Lens · detachedL2 DOOR EMERGENCY LIGHT LENS FELL OFF. INSTALLED A NEW LENS IAW AMM.SDR AALA201711099001Lens · missingEMERGENCY LIGHT ON SEAT 8C WAS MISSING THE LENS. REPLACED THE EMERGENCY LIGHT ASSEMBLY AT SEAT 8C. OPS CHECKED GOOD IAW AMM.SDR JJBA20171108008Lamp · inoperativeEMERGENCY LIGHT AT THE CABIN DOOR INOPERATIVE. REPLACED THE LAMPS. OPS CHECKED CHECKED GOOD.SDR MASA2017110812749Light · inoperativeROW 23 CEILING LEVEL EMERGENCY FLOOD LIGHT INOPERATIVE.SDR DALA2017110808005Light · inoperativeSEAT 19DEF EMERGENCY LIGHT INOPERATIVE. REPLACED THE LIGHT ASSY IAW AMM 33-53.SDR MASA2017110812747Sign · intermittentFWD WINDSCREEN FWD FACING EMERGENCY SIGN INTERMITTENT.SDR MASA2017110812746Light · inoperativeCENTER CABIN OVERHEAD EMERGENCY LIGHT INOPERATIVE.SDR AALA201711149019Battery · faultyTHE AIRCRAFT WAS NOT GROUNDED. *AHM ALERT* CLASS 30 - REMOTE WELS CONTROL UNIT CONFIGURATION DOES NOT AGREE WITH OTHER WIRELESS EMERG LIGHTING SYS CONTROL UNITS. REMOVED AND REPLACED CLASS 30 WELS CONTROL UNIT (AALA201711109016) AND BATTERY PER AMM 33-51-07.SDR AALA201711149018Battery · faultyTHE AIRCRAFT WAS NOT GROUNDED. **AHM ALERT** CLASS 02 - DOOR 1 RT REMOTE WELS CONTROL UNIT CONFIGURATION DOES NOT AGREE WITH OTHER WIRELESS EMERG LIGHTING SYS CONTROL UNITS. REMOVED AND REPLACED CLASS 2 WELS CONTROL UNIT (AALA201711109014) AND BATTERY PER AMSDR AALA201711109019Control Unit · faultyTHE AIRCRAFT WAS NOT GROUNDED. **AHM ALERT** CLASS 31 - REMOTE WELS CONTROL UNIT CONFIGURATION DOES NOT AGREE WITH OTHER WIRELESS EMERG LIGHTING SYS CONTROL UNITS. REMOVED AND REPLACED WIRELESS CONTROL UNIT AT THE L4 DOOR PER AMM 33-51-07. OPERATIONAL CHECK SDR AALA201711109018Warning System · false activationTHE AIRCRAFT WAS NOT GROUNDED. **AHM ALERT** CLASS 27 - DOOR 3 LT AFT SEAT REMOTE WELS CONTROL UNIT CONFIGURATION DOES NOT AGREE WITH OTHER WIRELESS EMERG LIGHTING SYS CONTROL UNITS. WITH FAULT CODE 33-12127. PERFORMED FIM 33-50-F1-P0A-421A-A WITH NO FAULTS SDR AALA201711109017Warning System · false activationTHE AIRCRAFT WAS NOT GROUNDED. **AHM ALERT** CLASS 25 - DR 2 AND 3 LT MID SEAT RMT WELS CNTRL UNIT CONFIGURATION DOES NOT AGREE WITH OTHER WIRELESS EMERG LIGHTING SYS CONTROL UNITS. WITH FAULT CODE 33-12125. PERFORMED FIM 33-50-F1-N8A-421A-A WITH NO FAULTS SDR AALA201711109016Control Unit · faultyTHE AIRCRAFT WAS NOT GROUNDED. **AHM ALERT** CLASS 30 - REMOTE WELS CONTROL UNIT CONFIGURATION DOES NOT AGREE WITH OTHER WIRELESS EMERG LIGHTING SYS CONTROL UNITS. REMOVED AND REPLACED CLASS 30 WELS CONTROL UNIT AND BATTERY (AALA201711149019) PER AMM 33-51-0SDR AALA201711109015Control Unit · faultyTHE AIRCRAFT WAS NOT GROUNDED. **AHM ALERT** CLASS 07 - DOOR 4 LT REMOTE WELS CONTROL UNIT CONFIGURATION DOES NOT AGREE WITH OTHER WIRELESS EMERG LIGHTING SYS CONTROL UNITS. REMOVED AND REPLACED WIRELESS EMERGENCY LIGHTING SYSTEM CONTROL UNIT AT THE L4 DOOR PSDR AALA201711109014Control Unit · faultyTHE AIRCRAFT WAS NOT GROUNDED. **AHM ALERT** CLASS 02 - DOOR 1 RT REMOTE WELS CONTROL UNIT CONFIGURATION DOES NOT AGREE WITH OTHER WIRELESS EMERG LIGHTING SYS CONTROL UNITS. REMOVED AND REPLACED CLASS 2 WELS CONTROL UNIT AND BATTERY (AALA201711149018) PER AMSDR SWAA2017111317760Light · inoperativeR1 DOOR EXTERIOR EMERGENCY LIGHT INOP. RELAMPED LIGHT PER AMM.SDR SWAA2017111317756Light · inoperativePASSENGER CABIN OVER WING EXIT CENTER CEILING EMERGENCY LIGHT INOP. RELAMPED LIGHT PER AMM.SDR SWAA2017111317730Light · inoperativeLT OVER WING EXIT EXTERIOR LIGHT INOP. RELAMPED LIGHT PER AMM.SDR SWAA2017111317712Sign · looseCENTER EMERGENCY EXIT SIGN LOOSE. R & R THE SIGN ASSEMBLY IAW MM.SDR AALA201711089043Power Supply · no testEMERGENCY EXIT LIGHTS POWER SUPPLY M33094 BY THE R1 DOOR IS INOPERATIVE. REMOVED AND REPLACED THE POWER SUPPLY IAW AMM 33-51-06. OPS CHECKED GOOD.SDR AALA201711089042Power Supply · no testEMERGENCY EXIT LIGHTS POWER SUPPLY M33096 BY THE L2 DOOR IS INOPERATIVE. REMOVED AND REPLACED THE POWER SUPPLY IAW AMM 33-51-06. OPS CHECKED GOOD.SDR AALA201711089041Power Supply · no testEMERGENCY EXIT LIGHTS POWER SUPPLY M33424 BY THE L1 DOOR IS INOPERATIVE. REMOVED AND REPLACED THE POWER SUPPLY IAW AMM 33-51-06. OPS CHECKED GOOD.SDR AALA201711089040Power Supply · no testEMERGENCY LIGHTS POWER SUPPLY M33408 BY THE R4 DOOR IS INOPERATIVE. REMOVED AND REPLACED THE POWER SUPPLY IAW AMM 33-51-06. OPS CHECKED GOOD.
Back to JASC 3350