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 SWAA2019121639598Light · inoperativeR/H EMERGENCY EXIT LIGHT ABOVE AISLE INOP AT ROW 14. / REPAIRED LIGHT PER AMM.SDR ASAA2019121633605Sign · detachedEXIT SIGN FELL OFF MID CABIN. GROUNDED - YES. REINSTALLED EXIT SIGN ON MID CABIN AS REQUIRED. NO FURTHER DEFECTS NOTED.SDR AALA201912169017Battery · no testAIRCRAFT IN BASE VISIT: MAINTENANCE REPORTS UPON INSPECTION OF EMERGENCY LIGHTS SYSTEM. FOUND ROW 13D-18D INOP. REMOVED AND REPLACED WIRELESS EMERGENCY LIGHT SYSTEM CONTROL BATTERY AT SEAT 18D IAW AMM B787 33-51-0-02. OPS CHECK OK FOR SERVICE.SDR ASOA2019121633069Sign · inoperativeDURING C CHECK INSPECTION FOUND EMERGENCY EXIT SIGN ABOVE FORWARD F/A SEAT INOPERATIVE. MAINTENANCE REPLACED THE EMERGENCY EXIT SIGN. OPERATIONAL CHECKS WERE GOOD.SDR ASOA2019121633068Inverter · inoperativeDURING C CHECK INSPECTION FOUND #1 INVERTER FOR EMERGENCY LIGHTS INOPERATIVE. MAINTENANCE REPLACED #1 EMERGENCY LIGHT INVERTER, OPERATIONAL CHECKS WERE GOOD.SDR QXEA2019121600460Guard · looseFOWARD FA EMER LIGHT COVER ON PANEL BETWEEN JUMPSEAT AND MCD IS ABOUT TO FALL OFF. REMOVED FROM SERVICE. INSTALLED NEW GUARD ON FORWARD FA EMERGENCY LIGHT SWITCH. OPS CHECKS GOOD. A/C OK FOR CONTINUED SERVICE. AIRCRAFT RETURNED TO SERVICE.SDR DALA2019121407326Lens · detachedEMERGENCY EXIT COVER DIFFUSER LENS DETACHED, RE-SECURED COVERSDR 29GA2019121600001Button · malfunctionedFLIGHT 0067, EMERGENCY LIGHT WILL NOT TURN OFF FROM FA PANEL. EXERCISED FA PANEL PUSH BUTTON SWITCH, OPS CHECKED NORMAL IAW MM 33-50-00-00-2.SDR MASA2019121312177Power Supply · inoperativeROW 18 OVHD EMER LIGHT INOP
REPLACED POWER SUPPLYSDR MASA2019121312176Battery Pack · dischargedROW 12 EMERGENCY EXIT SIGNS INOPERATIVE. REPLACED THE NR 5 BATTERY PACK.SDR 2020F00130Battery · dischargedDOOR 2L WIRELESS EMERGENCY LIGHT SYSTEM CONTROL UNIT BATTERY FOUND DEGRADED.SDR SWAA2019122639938Light · inoperativeR1 DOOR FORWARD ESCAPE SLIDE LIGHT L730 INOP. / R&R LIGHT L730 IN M2816 IAW AMM.SDR SWAA2019122639901Fuse · inoperativeR1 DOOR FORWARD ESCAPE SLIDE LIGHT L730 INOP. R&R FUSE IN M2816 IAW AMM.SDR SWAA2019121739753Battery Pack · inoperativeBATTERY PACK POWER SUPPLY M1670 HAD INOP EMERGENCY LIGHTS. / R&R BATTERY PACK IAW AMM.SDR SWAA2019121739752Power Supply · inoperativeEMERGENCY EXIT LIGHTS ASSOCIATED WITH BATTERY PACK POWER SUPPLY M1669 INOP. / R&R POWER SUPPLY IAW AMM.SDR SWAA2019121739735Power Supply · inoperativeBATTERY PACK POWER SUPPLY M1670 HAD INOP EMERGENCY LIGHTS. / R&R POWER SUPPLY M1670 IAW AMM.SDR SWAA2019121739734Battery Pack · inoperativeEMERGENCY EXIT LIGHTS ASSOCIATED WITH BATTERY PACK POWER SUPPLY M1669 INOP. / R&R BATTERY PACK M1669 IAW AMM.SDR SWAA2019121639682Battery · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1675. / R&R BATTERY PER AMM.SDR SWAA2019121639681Battery · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1674. / R&R BATTERY PER AMM.SDR SWAA2019121639610Battery · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1672. / R&R BATTERY PER AMM.SDR SWAA2019121639599Light · brokenFORWARD ENTRY DOOR EMERGENCY LIGHT COVER BROKEN OFF. / R&R LIGHT PER AMM.SDR DALA2019121637359Light · detachedSHIP 5801 SEAT MOUNTED EMERGENCY LIGHT AT SEAT 37DEF NO LONGER MOUNTED. CORRECTIVE ACTION: REPLACED EMERGENCY LIGHT HOUSING AT SEAT 37 DEF PER B757 AMM 33-51. CKS GOOD. (6751239)SDR DALA2019121627358Light · inoperativeSHIP 6709 EMER LIGHT AT L1 DOOR INOP. CORRECTIVE ACTION: REPLACED LIGHT ASSY. PER WDM 33-50 (B757) OPS CHECKED GOOD. (6720922)SDR YENA2019121620704Battery Pack · no testFT # 2752, SJU-TPA. DURING TASK CARD EXTERNAL EMERGENCY LIGHT OPERATIONAL TEST FOUND EXTERNAL LIGHTS LEFT FWD AND AFT INOP. ( EXTERNAL EMERGENCY-OPS NOT CONDUCTED AT NIGHT ); RESISTANCE FLUCTUATION BET P0753 TO LIGHT P3324 REF WM: 33-50-50, CLEANED CONNECTOR PSDR YENA2019121620703Battery Pack · no testFT # 2752, SJU-TPA. DURING TASK CARD EXTERNAL EMERGENCY LIGHT OPERATIONAL TEST FOUND EXTERNAL LIGHTS LEFT FWD AND AFT INOP. ( EXTERNAL EMERGENCY-OPS NOT CONDUCTED AT NIGHT ); RESISTANCE FLUCTUATION BET P0753 TO LIGHT P3324 REF WM: 33-50-50, CLEANED CONNECTOR PSDR YENA2019121620702Light · malfunctionedFT # 1479, DCA-FLL. AFT GALLEY EMERGENCY LIGHTS ILLUMINATED WITH SWITCH IN "ARMED" POSITION- WOULD NOT REST; RESET EMERGENCY LIGHT SWITCH AND OPS CHECK PER M/M 33-50-00. OPS CHECK GOOD.SDR DALA2019121327296Holder · brokenRED EMERGENCY LIGHT AT 12C HOLDER BROKEN, REPLACED HOLDER LIGHTSDR QXEA2019121300458Sign · looseILLUMINATED EXIT SIGN ADJACENT TO THE TYPE 2/3 EMERGENCY EXIT DOOR SIGN IS LOOSE. LIGHT STILL ILLUMINATES PROPERLY. REMOVED FROM SERVICE. REPLACED LOWER FORWARD EMERGENCY EXIT DOOR SIGN AT TYPE 2/3 EMER DOOR IAW Q400 AMM 33-51-06-000-801/400-801. OPS TEST PASSSDR AALA201912139011Connector · damagedAIRCRAFT WAS NOT GROUNDED: ROW 24 AND 25 LEFT AISLE EMERGENCY LIGHTS INOPERABLE. MAINTENANCE REPLACED 7260VC SIDEWALL CONNECTION TO SEATS HARNESS AND PEFORMED SATISFACTORY OPERATIONAL CHECK PER AWM 33-51-08.SDR SIMA201912132002Charger · inoperativeLH EXTERNAL EMERGENCY LIGHT FORWARD OF LEADING EDGE WING ROOT, COCKPIT CEILING FLOOD EMERGENCY LIGHT AND AISLE #1 CEILING EMERGENCY LIGHT ARE INOP.-C/A-T/S USING WM 33-50-50. REMOVED AND REPLACED #1 EMERGENCY LIGHTS POWER SUPPLY IAW AMM 33-50-04. ALL EMERGENCYSDR UIEA2019121396039Lamp · inoperativeMAIN DECK L1 DOOR - CEILING EMERGENCY LIGHT INOP. (<P>RELAMPED L1 MAIN DECK DOOR CEILING LIGHT IAW B747 AMM 33-51-07-962-001, OPS CHECK GOOD.</P>)SDR DALA2019121307274Light · inoperativeEMER LIGHT RED AFT GALLEY INOP RELAMPED NO HELP REPLACED LIGHY ASSY OPS CK GOOD OK FOR SVC (6009673)SDR CALA2019121302203Battery · discharged''A'' ZONE CTR SEAT R/H EMERGENCY LIGHT BATTERY LOW CAPACITY.REF N ON ROUTINE NO.9495732, ORIGINATED BY EMP V905305 SPEC NO.777-33- 3-7019SDR CALA2019121302202Battery · discharged''C'' ZONE CTR SEAT EMERGENCY LIGHT BATTERY LOW CAPACITY REF NON R OUTINE NO.9495731,ORIGINATED BY EMP V905305 SPEC NO.B777-33-3-70 19SDR CALA2019121302200Lamp · inoperativeLH ROW 21, EMERGENCY EXIT DOOR, FWD EMERGENCY THRESHOLD LIGHT, IS INOP RELAMPED, OP CHECKS GOOD REF AMM TASK 33-51-00-710-801SDR CALA2019121302198Lamp · inoperativeRH ROW 21 EMERGENCY EXIT DOOR, AFT EMERGENCY THRESHOLD LIGHT, IS INOP RELAMPED, OP CHECKS GOOD REF AMM TASK 33-51-00-710-801SDR CALA2019121302197Fuse · blownMIDDLE LH EXTERIOR OVERWING EMERGENCY EXIT LIGHT IS INOP RELAMPED L6, NO HELP, ALL OTHER LIGHTS FROM BATTERY PACK M1670 CHECK GOOD, NO FUSES IN STOCK AT LAS NO TIME TO TS FURTHER. DISPATCH DESK: 92 NAME: - APPROVED NO PARTS IN LAS SUSPECT FUSE. FOUND FUSE, RSDR CALA2019121302193Battery Pack · dischargedB777-33-3-7019, FOUND DR 3R EMER PWR SUPPLY (M33404) FAILED CAPACITY CHECK, REFER TO NR LP 9130153 DR 3R EMER LT PWR SUPPLY (M33404) BATTERY PACK REPLACED AND TESTED NORMAL AS PER AMM33-51-06.SDR CALA2019121302192Battery · dischargedB777-33-3-7019, FOUND DR 1R EMER LT PWR SUPPLY (M33094) FAILED CAPACITY CHECK, REFER TO NR LP 9130154 DR 1R EMER LT PWR SUPPLY (M33094) BATTERY PACK REPLACED AND TESTED NORMAL AS PER AMM33-51-06.SDR CALA2019121302191Battery Pack · dischargedB777-33-3-7019, FOUND DR 4R EMER PWR SUPPLY (M33409) FAILED CAPACITY CHECK. REFER NR LP 9130152 DR 4R EMER LT PWR SUPPLY (M33409) BATTERY PACK REPLACED AND TESTED NORMAL AS PER AMM 33-51-06.SDR DALA2019121307272Lamp · inoperativeSHIP 3823 L2 SLIDE LIGHT OUT .CORRECTIVE ACTION: RELAMPED PER B737 AMM 33-51. OPS NORMAL. (6077095)SDR DALA2019121207259Battery Pack · corroded(LOG 6324970) DURING INSEPTION FOUND EMERGENCY LIGHTS ON SEAT ROWS 23 THRU 33 INOPERATIVE. REPLACED BATTERY PACK AND POWER SUPPLY M1672 PER B737 AMM 33-51. OPS CKS GOOD.SDR MASA2019121212175Lamp · inoperativeSERVICE DOOR EMERGENCY EXIT SIGN HAS 2 BULBS INOP- RELAMPEDSDR 2019FA0000404Screw · brokenL2 DOOR EMERGENCY EXIT LIGHT LOWER SCREW BROKEN.SDR 2DYA20200106001Battery Pack · failedEMERGENCY LIGHT FOUND INOP DURING OPS CHECK OF L/H OVERWING SLIDE SYSTEM. REMOVED AND REPLACED L/H OVERWING SLIDE BATTERY PACK IAW B767 AMM 33-51-07. OPS CHECK NORMAL. NOTE: AIRCRAFT WAS IN MAINTENANCE CHECK AT THE TIME THE ISSUE WAS FOUND. FAA PMI HAS BESDR DALA2019121817412Sign · damaged(AIRCRAFT 7103, L/P 1397727) FOUND 2 EA EMERGENCY EXIT IDENTIFIER INSTALLATION HOLES TOO SMALL. CORRECTIVE ACTION: REMOVED AND REPLACED 2 EA EMERGENCY EXIT IDENTIFIER.SDR SWAA2019121739701Battery Pack · inoperativeR1 DOOR EMERGENCY LIGHT INOP. / R&R BATTERY PACK IAW AMM.SDR SWAA2019121739700Light · dirtyPHOTO LUMINESCENT TRACK LIGHTING NEEDED CLEANING. / CLEANED LIGHTING IAW AMM.SDR SWAA2019121639694Sign · incorrectL2 DOOR EXIT SIGN LENS COVER HAD ARROW POINTING IN WRONG DIRECTION. / R&R EXIT SIGN ASSEMBLY IAW AMM.SDR SWAA2019121639630Bulb · burned outFORWARD LAV LOWER EXIT SIGN HAD BURNED OUT BULB. / R&R BULBS PER AMM.
Back to JASC 3350