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 DALA2018062704250Battery Pack · inoperativeL2 AND R2 EMERGENCY DOOR EXTERIOR LIGHTS WERE INOPERATIVE. THE BATTERY PACK WAS FOUND BAD. REPLACED THE BATTERY PACK, AND REPLACED THE LAMPS . SYSTEM OPS NORMAL.SDR UIEA2018062801285Light · inoperativeEMERGENCY LIGHT FLOOR LIGHTS FAILED OPS CHECK, LOCATION BETWEEN L2 AND R2 DOORS. REMOVED AND REPLACED EMERGENCY LIGHT ASSEMBLY L2 AND R2 DOORS PER AMM TASKS 33-51-12-022-020 AND 33-51-12-422-021.SDR SIMA20180626002Battery · dischargedNR 4 EMERGENCY LIGHT BATTERY INOP. REMOVED AND REPLACED NR 4 EMERGENCY LIGHT BATTERY IAW 33-50-04 OPS CHECK GOOD PER AMM 33-50-00.SDR SIMA20180626003Battery · dischargedCREW REPORTED THAT EMERGENCY LIGHTS WOULD NOT TURN OFF. FOUND ALL FOUR EMERGENCY LIGHT BATTERIES TO HAVE NO CHARGE. REMOVED AND REPLACED NR 1 BATTERY IAW AMM 33-50-04. OPS CHECK GOOD PER AMM 33-50-00.SDR SIMA20180626004Battery · dischargedNR 3 EMERGENCY LIGHT BATTERY INOP. REMOVED AND REPLACED NR 3 EMERGENCY LIGHT BATTERY IAW AMM 33-50-04. OPS CHECK GOOD PER AMM 33-50-00.SDR SIMA20180626005Battery · dischargedNR 2 EMERGENCY LIGHT BATTERY INOP. REMOVED AND REPLACED NR 2 EMERGENCY BATTERY IAW AMM 33-50-04. OPS CHECK GOOD PER AMM 33-50-00.SDR SIMA20180626007Inverter · inoperativeRT OVERWING EXIT IDENTIFIER INOP. REMOVED AND REPLACED NR 5 INVERTER ASSY, OPERATIONAL CHECK GOOD.SDR IPXA2018062631103Light · inoperativeLS EMER EXIT LIGHT OUT ON PDC FOUND. RELAMPED AND OPS CHECK NORM PER AMM 33-27-05.SDR IPXA2018062631112Power Supply · failedINTERIOR EMERGENCY LIGHT TEST FAILED EMERGENCY BAT 1 L0 MESSAGE APPEARED DURING ASE NO: 17 CHECK. REPLACED THE EMERGENCY LIGHTING BATTERY POWER SUPPLY PER AMM 33-51-01 OPS CHECK GOOD ESR: 33-51-10-01 ITEM 008.SDR SWAA2018062723132Housing · brokenCENTER CABIN OVERHEAD EXIT SIGN HOUSING BROKEN. R&R SIGN HOUSING PER AMM.SDR SWAA2018062723125Lens · missingEXIT ROW EMERGENCY EXIT SIGN COVER MISSING. INSTALLED LENS PER SIP.SDR SWAA2018062723110Lens · out of positionR2 DOOR EMERGENCY EXIT LIGHT LENS OUT OF POSITION. REPAIRED LENS IAW AMM & SIP.SDR SWAA2018062723098Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1674. R&R BATTERY PER AMM.SDR SWAA2018062723097Battery Pack · dischargedFORWARD RT SECTION OF EMERGENCY LIGHTS INOP. R&R BATTERY PACK PER AMM.SDR SWAA2018062723096Battery Pack · dischargedAFT RT SECTION OF EMERGENCY LIGHTS INOP. R&R BATTERY PACK PER AMM.SDR DALA2018062704229Power Supply · inoperativeL2 DOOR EMERGENCY EXIT LIGHT SIGN INOP. REPLACED EMERGENCY LIGHT POWER SUPPLY AND BATTERY PER AMM 33-51-07, OPS OK.SDR UIEA2018062601253Light · inoperative3 EMERGENCY LIGHT FLOOR LIGHTS FAILED OPS CHECK, LOCATION BETWEEN L2 AND R2 DOORS. REMOVED AND REPLACED EMERGENCY LIGHT ASSEMBLY BETWEEN L2 AND R2 DOORS PER AMM TASKS 33-51-12-022-020 AND 33-51-12-422-021.SDR DALA2018062804259Lens · crackedCRACKED EMERGENCY LIGHT LENS AT THE AFT GALLEY. REMOVED AND REPLACED THE EMERGENCY LIGHT IAW WDM 33-51. OPS CHECKED NORMAL.SDR AALA201806287001Power Supply · no testEMERGENCY LIGHT POWER SUPPLY ABOVE THE R1 DOOR, FAILED TO TEST. REPLACED THE POWER SUPPLY M33094 IAW MM 33-51-06. OPS CHECKED GOOD.SDR AALA201806286005Power Supply · no testEMERGENCY LIGHT POWER SUPPLY, ABOVE THE L3 DOOR FAILED TO TEST. REPLACED THE POWER SUPPLY M33406 IAW MM 33-51-06. OPS CHECKED GOOD.SDR AALA201806286004Power Supply · no testEMERGENCY LIGHT POWER SUPPLY ABOVE THE L1 DOOR FAILED TO TEST. REPLACED THE POWER SUPPLY. OPS CHECKED GOOD IAW MM 33-51-06.SDR AALA201806269026Lens · missingAIRCRAFT WAS NOT GROUNDED. DOOR 3L EMERGENCY EXIT LIGHT MISSING. REPLACED 3L EMERGENCY EXIT LIGHT LENS PER AMM 33-51-01. OPERATIONS CHECK GOOD.SDR AALA201806279012Battery · faultedAIRCRAFT WAS NOT GROUNDED: 13 WL FAULT ON EMERGENCY POWER SUPPLY UNIT BATTERY TEST. MAINTENANCE REPLACED 13 WL BATTERY PER AMM 33-51-38 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201806269038Power Supply · inoperativeAIRCRAFT WAS NOT GROUNDED: DURING JOB CARD 2735 BATTERY POWER RESTORATION TEST FOUND DOOR 4R FORWARD BATTERY PACK, WOULD NOT PASS TEST. MAINTENANCE REPLACED BATTERY PACK (EMERGENCY POWER SUPPLY UNIT) PER AMM 33-51-06 AND PERFORMED SATISFACTORY OPERATIONAL CHECSDR AALA201806269037Power Supply · inoperativeAIRCRAFT WAS NOT GROUNDED: DURING JOB CARD 2735 BATTERY POWER RESTORATION TEST FOUND DOOR 1L FORWARD BATTERY PACK, WOULD NOT PASS TEST. MAINTENANCE REPLACED BATTERY PACK (EMERGENCY POWER SUPPLY UNIT) PER AMM 33-51-06 AND PERFORMED SATISFACTORY OPERATIONAL CHECSDR SWAA2018062623083Sign · looseRT REAR GALLEY DOOR PLASTIC EXIT SIGN COVER AFT OF EXIT LOOSE. R&R SIGN ASSEMBLY PER AMM.SDR SWAA2018062623058Cover · missingR1 DOOR EMERGENCY EXIT LIGHT COVER MISSING. R&R LIGHT BASE ASSEMBLY IAW AMM.SDR DALA2018062604217Sign · brokenEXIT SIGN BROKEN. REPLACED THE EXIT SIGN, OPS CHECKED NORMAL.SDR DALA2018062604214Lens · brokenBROKEN EMERGENCY LIGHT LENS . REPLACED THE LENS IAW CMM 25-31.SDR DALA2018062604205Battery Pack · dischargedOVERWING EXIT DOOR EMERGENCY CEILING LIGHT FAILED TO TEST. MAINTENANCE FOUND B5-120 BATTERY PACK TO BE BAD. BATTERY PACK WAS REPLACED PER AMM 33-51. OPERATIONAL CHECK WAS GOOD.SDR SIMA20180625001Bulb · inoperativePASSENGER DOOR EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE BULB IAW AMM 33-50-06. OPS CHECKED GOOD.SDR DALA2018062504173Battery · dischargedTAIL CAT WALK CEILING LIGHTS INOP. REMOVED AND REPLACED 'D' CELL BATTERIES TWO IN AFT LAV RIGHT. OPERATIONAL CHECK OK IAW AMM 33-50.SDR SWAA2018062723099Battery Pack · dischargedL2 DOOR EXIT LIGHT INOP AT LOCATION M1673. R&R BATTERY PACK IAW AMM.SDR HALA2018062600310Light · unsecureAFT GALLEY FLOOR EMERGENCY LIGHT STRIP NOT SECURE TAPE NOT HOLDING IT DOWN KEEPS LIFTING. RE-SECURED EMERGENCY LIGHT STRIP AS REQUIRED OK TO CONTINUE.SDR HALA2018062600308Light · missingAFT GALLEY MISSING APPROX 4" OF EMERGENCY LIGHT PATH. REPLACED AFT GALLEY EMERGENCY ESCAPE PATH LIGHTING STRIPS AS REQUIRED. REF AMM 33-52. OPS GOOD.SDR ASAA2018062425192Sign · unsecureFA REPORTS EXIT SIGN AT ROW 16DEF FELL OFF. GROUNDED - YES. REINSTALLED ROW EXIT SIGN REF AMM 33-51-01. MADE ADJUSTMENTS AND OPS CKS GOOD.SDR AALA201806269039Battery · dischargedAIRCRAFT WAS NOT GROUNDED: BITE TEST OF EMERGENCY POWER SUPPLY UNIT EMERGENCY LIGHT FAILED ON MESSAGE BATTERY FAULT ON 15 WL. MAINTENANCE REPLACED BATTERY AT 15WL AND PERFORMED SATISFACTORY OPERATIONAL CHECK AND BITE TEST PER AMM 33-50-00.SDR HALA2018062500201Light · missingAFT GALLEY MISSING APPROXIMATELY 4 INCHES OF THE EMERGENCY LIGHT PATH STRIP. REPLACED AFT GALLEY EMERGENCY ESCAPE PATH LIGHTING STRIPS.SDR HALA2018062500200Light · unsecureAFT GALLEY FLOOR EMERGENCY LIGHT STRIP NOT SECURE, KEEPS LIFTING. RE-SECURED EMERGENCY LIGHT STRIP.SDR DALA2018062604210Lens · damagedFOUND THE EMERGENCY LIGHT COVER DAMAGED. REPLACED THE LENS.SDR SWAA2018062523047Charger · inoperativeR2 DOOR EXTERIOR EMERGENCY LIGHT INOP. R&R CHARGER PER AMM.SDR SWAA2018062523046Charger · inoperativeL1 DOOR EXTERIOR EMERGENCY LIGHT INOP. R&R CHARGER PER AMM.SDR SWAA2018062523045Battery Pack · dischargedR2 DOOR EXTERIOR EMERGENCY LIGHT INOP. R&R BATTERY PACK PER AMM.SDR SWAA2018062522978Battery Pack · dischargedL1 DOOR EXTERIOR EMERGENCY LIGHT INOP. R&R BATTERY PACK PER AMM.SDR DALA2018062504201Battery Pack · inoperativeEMERGENCY LIGHT BATTERY PACK B5-27 IS INOP. REMOVED AND REPLACED EMERGENCY LIGHT BATTERY PACK B5-27 IAW AMM 33-53-00. OPS CHECK GOOD.SDR F3LA2018062500359Power Supply · failedEPSU 10WL FAILED EPSU TEST. REMOVED AND REPLACED EPSU ASSEMBLY 10WL IAW AMM 33-51-38 PAGE BLOCK 401. OPERATIONAL CHECK GOOD.SDR ASAA2018062505169Lamp · inoperativeEMERGENCY LIGHT EXIT SIGN, L1 DOOR HAD SEVERAL LAMPS INOPERATIVE. ACFT GROUNDED. REPLACED THE LAMPS AND TESTED IAW AMM 33-51-01-960-801. OPS NORMAL.SDR ASAA2018062505168Lamp · inoperativeEXTERIOR EMERGENCY LIGHT, SLIDE LIGHT AT THE L2 DOOR WERE INOPERATIVE. ACFT GROUNDED. REPLACED THE LAMPS AND TESTED IAW AMM 33-51-04-960-801. OPS NORMAL..SDR DALA2018062504198Battery Pack · faultedFORWARD LEFT EPSU BATTERY FAULTED. REMOVED AND REPLACED THE BATTERY PACK IAW MM.SDR AALA201806259005Light · inoperativeEMERGENCY LIGHT AT THE R3 DOOR WAS INOPERATIVE. REPLACED EMERGENCY LIGHT IAW AMM 33-51-04.
Back to JASC 3350