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 AALA202010289005Battery · no testAIRCRAFT WAS GROUNDED. REPORTS OF EMERGENCY LIGHTING WELLS BATTERY UNITS 30 AND 23 NOT REPORTING ON THE CONFIGURATION PAGE. REPLACED WIRELESS CONTROL UNIT (AALA202010279025) AND BATTERY (AALA202010289005) AT NR 30. REPLACED WIRELESS CONTROL UNIT (AALA202010SDR AALA202010279025Control Unit · no testAIRCRAFT WAS GROUNDED. REPORTS OF EMERGENCY LIGHTING WELLS BATTERY UNITS 30 AND 23 NOT REPORTING ON THE CONFIGURATION PAGE. REPLACED WIRELESS CONTROL UNIT (AALA202010279025) AND BATTERY (AALA202010289005) AT NR 30. REPLACED WIRELESS CONTROL UNIT (AALA202010SDR SWAA2020092818036Light · inoperativeOVERHEAD BIN BULLNOSE EMERGENCY LIGHT OUT AT 20 ABC. RELAMPED 20ABC AREA LIGHT. OPS CHECKS GOOD, PER MM 33-51-03.SDR SWAA2020092818034Power Supply · inoperativeAFT SERVICE DOOR INTERIOR OVERHEAD EMERGENCY LIGHT OUT. REMOVED AND REPLACED POWER SUPPLY AND BATTERY PACK, IAW AMM 33-51-06. OPS CHECKED NORMAL.SDR SWAA2020092818756Battery Pack · inoperativeAFT SERVICE DOOR INTERIOR OVERHEAD EMERGENCY LIGHT OUT. REMOVED AND REPLACED POWER SUPPLY AND BATTERY PACK, IAW AMM 33-51-06. OPS CHECKED NORMAL.SDR SWAA2020092818757Battery Pack · inoperativeAFT LAV FWD WALL EXTERIOR SURFACE EMERGENCY LIGHT OUT. REMOVED AND REPLACED POWER SUPPLY AND BATTERY PACK, IAW AMM 33-51-06. OPS CHECKED NORMAL.SDR SWAA2020092818035Power Supply · inoperativeAFT LAV FWD WALL EXTERIOR SURFACE EMERGENCY LIGHT OUT. REMOVED AND REPLACED POWER SUPPLY AND BATTERY PACK, IAW AMM 33-51-06. OPS CHECKED NORMAL.SDR SWAA2020092215405Sign · damagedFWD LOWERED CEILING CLOSE OUT PANEL EXIT SIGN ASSY IS DAMAGED. REMOVED AND REPLACED FWD LOWERED CEILING CLOSEOUT PANEL EXIT SIGN ASSY, IAW AMM 33-51-01-960-802 STEP 3 C (5) (6). 57887U 11SEP20 5279C 11SEP20 INSP 267 9-11-20. OPS CHECK REQUIRED 5279C 11SEP20SDR AALA2020091429008Fuse · inoperativeAIRCRAFT WAS GROUNDED: RT OVERWING ESCAPE GROUND ILLUMINATION LIGHT INOPERATIVE. REPLACED POWER SUPPLY FUSE. OPERATIONS CHECK NORMAL, PER AMM 33-51-06.SDR AALA2020091419003Lens · detachedAIRCRAFT NOT GROUNDED- R1 DOOR, EXIT SIGN/LIGHT COVER FELL OFF. REINSTALLED PLASTIC COVER/LENS PER AMM 33-51-16.SDR R61A202009110626Power Supply · inoperativeEMERGENCY LIGHT CENTER AFT AISLE EMERGENCY EXIT ABOVE L2 DOOR INOP. R&R EMERGENCY LIGHT POWER UNIT NR 3, IAW AMM 33-50-01.SDR WX0A2020091173569Epsu · failedEMERGENCY LIGHTS CHECK FAULTS ESPU 11WL LOCATION. REPLACED BATTERY ON ESPU 11WL LOCATION, IAW MM 33-51-38-000-002-A AND MM 33-51-38-400-002-A. OPS CHECKED GOOD, IAW MM 33-51-00-710-001-A.SDR 2020F00371Battery Pack · dischargedEMERGENCY BATTERY PACK FAILED WHILE PERFORMING SCHEDULED MAINTENANCE.SDR MASA2020091091570Bulb · inoperativeSERVICE DOOR EXIT SIGN 1 BULB INOPERABLE. PLACED ON MEL.SDR REXA2020009160647Light · burned outRT EXTERIOR AFT PASSENGER EMERGENCY EXIT LIGHT INOP. REPLACED RT EXTERIOR AFT PASSENGER EMERGENCY EXIT LIGHT BULB, IAW CRJ 900 AMM 33-51-15. OPS CHECK GOOD.SDR SWAA2020091414805Cover · looseEMERGENCY EXIT LIGHT COVER IN FORWARD GALLEY FELL OFF. RESECURED EMERGENCY EXIT LIGHT COVER IN FWD GALLEY, PER SIP.SDR SWAA2020091415362Bulb · inoperativeLT OVERWING EMERGENCY LIGHT INOPERABLE. REMOVED AND REPLACED THE LT OVERWING EMERGENCY LIGHT BULB, PER AMM 33-51-04.SDR SWAA2020091414908Battery Pack · inoperativeEMERGENCY LIGHTS ON ROW 7 A/B/C AND 9 A/B/C INOPERABLE. REMOVED & REPLACED BATTERY AT LOC M2335. OPS CK GOOD, REF AMM 33-51-06 AT ROWS 7 A/B/C, 9 A/B/C, & .14 A/B/CSDR AALA2020091109001Power Supply · inoperativeAIRCRAFT WAS GROUNDED: L2 DOOR EMERGENCY LIGHT BATTERY PACK M33096 WILL NOT CHARGE. REMOVED AND REPLACED EMERGENCY LIGHT POWER SUPPLY M33096 ON DOOR L2, PER AMM 33-51-06.SDR WX0A2020091173568Epsu · failedPERFORMED EPSU SYS TEST, RECEIVED MESSAGE "BAT/EPSU ( 11WL ) EMER L". REMOVED AND REPLACED EPSU BATTERY, IAW AMM 33-51-38. OPS CHECK GOODSDR DALA2020091103035Cover · detachedFLIGHT ATTENDANT REPORTS LEFT OVERWING EXIT SIGN COVER FELL OFF DURING TURBULENCE. REINSTALLED SIGN. SYSTEM OPERATION IS NORMAL.SDR SWAA2020091015204Lens · looseOVERWING EMERGENCY EXIT AT CEILING LENS NOT SECURE. INSTALLED LENS AS REQUIRED, AS PER AMM 33-51-01. OPS CHECK OF LIGHT IS NORMAL.SDR AALA202009109002Power Supply · inoperativeAIRCRAFT WAS GROUNDED (SHORT TERM STORAGE): R2 DOOR EMERGENCY LIGHT BATTERY PACK M33097 WILL NOT CHARGE. REMOVED AND REPLACED EMERGENCY LIGHT POWER SUPPLY M33097 ON DOOR R2, IAW AMM 33-51-06.SDR SIMA202009109002Circuit Card · malfunctionedEMERG LT BATT FAULT ADVISORY. EMERGENCY LIGHTS COME ON WHEN POWERING GROUND SERVICE. C/A-FOUND FWD 2 EMERGENCY PACKS GOING INTO TEST MODE ON POWER UP. REMOVED AND REPLACED I/O CARD SPDA J11, IAW AMM CH 24-61-05. OPS CHECK OK, IAW AMM CH 33-50-00..SDR SIMA202009109001Flashlight · inoperativeFLIGHT ATTENDANT 1 FLASHLIGHT INOPERATIVE. C/A-RAR FWD FLIGHT ATTENDANT FLASHLIGHT, IAW AMM 33-51-01.SDR MASA2020090910569Charger · inoperativeROW 14 LT/RT FLOOR EXIT SIGNS INOPERABLE. REPLACED NR 2 BATTERY/CHARGER PACK.SDR FDEA202009092156Holder · damagedMDIS 996, 33-50, 7681, 09SEP20, MEM, FACT, U. ON PREFLIGHT, DISCOVERED EMERGENCY LIGHTS FOR L1 DOOR, BOTH INTERIOR AND EXTERIOR, INOPERABLE. R/I 09SEP20 06:37 MEM U. REASON CODE: FAILED OPS CK & REPLACED WITH SERVICEABLE UNIT, OFF MPN: 2013-1A POS: 1 SRL: SDR AALA202009099028Battery · failedAIRCRAFT WAS NOT GROUNDED: EMERGENCY POWER SUPPLY UNIT BATTERIES FAILED IN POSITION 15WL. REMOVED AND REPLACED EMERGENCY POWER SUPPLY UNIT BATTERY'S POSITION 15WL PER AMM 33-51-38.SDR AALA202009099027Battery · failedAIRCRAFT WAS NOT GROUNDED: EMERGENCY POWER SUPPLY UNIT BATTERIES FAILED IN POSITION 12WL. REMOVED AND REPLACED EMERGENCY POWER SUPPLY UNIT BATTERY'S POSITION 12WL PER AMM 33-51-38.SDR AALA202009099026Fuse · failedAIRCRAFT IN BASE MAINTENANCE: EMERGENCY FLOOR PROXIMITY LIGHTS INOPERATIVE ON 1ST CLASS SEATS. BLOWN FUSE AT BATTERY PACK M02816. REPLACED FUSE AT BATTERY PACK MO2816.SDR AALA202009099025Fuse · failedAIRCRAFT IN BASE MAINTENANCE: AFT EMERGENCY FLOOR PROXIMITY LIGHTS ARE INOPERATIVE. BLOWN FUSE AT BATTERY PACK M1672. REPLACED FUSE AT BATTERY PACK M1672.SDR AALA202009099020Battery · failedAIRCRAFT WAS NOT GROUNDED: EMERGENCY POWER SUPPLY UNIT BATTERIES FAILED IN POSITION 10WL. REMOVED AND REPLACED EMERGENCY POWER SUPPLY UNIT BATTERY'S POSITION 10WL PER AMM 33-51-38.SDR MASA2020090910567Battery Pack · inoperativeRT AFT EXTERNAL EMERGENCY LIGHT INOPERABLE. REPLACED AFT BATTERY PACK.SDR MASA2020090910566Battery Pack · inoperativeLT AFT EXTERNAL EMERGENCY LIGHT INOPERABLE. REPLACED AFT BATTERY PACK.SDR MASA2020090910565Battery Pack · inoperativeLT AFT EXTERNAL EMERGENCY LIGHT INOPERABLE. REPLACED AFT BATTERY PACK.SDR AALA2020091109003Cover · detachedAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHT COVER (CEILING) BY OVERWING EXIT FELL OFF. REINSTALLED EXIT SIGN LENS BY OVERWING EXIT, PER AMM 33-51-01.SDR DALA2020091103045Power Supply · inoperativeSHIP 3165, INOP EMERGENCY POWER SUPPLY UNIT 10WL FWD GALLEY AREA. CORRECTIVE ACTION: REPLACED EMERGENCY POWER SUPPLY UNIT 10WL FWD GALLEY AREA.SDR SWAA2020091014763Lens · missingOVERHEAD EXIT SIGN MISSING MID CABIN OVER CENTER AISLE. INSTALLED LENS PER M/M 33-51-01.SDR DALA2020091093021Lens · missingDURING INSPECTION FOUND CLEAR RECTANGLE EMERGENCY LIGHT LENS NEAR FLOOR MISSING BETWEEN DR3L AND DR3R AT DR2L AND BETWEEN DR1L AND DR1R. REPLACED MISSING CLEAR LIGHT LENS AS REQUIRED AT ALL DOORS WAYS.SDR AALA202009099019Sign · detachedAIRCRAFT WAS NOT GROUNDED: CEILING EXIT SIGN OVER WING EXIT MID CABIN DETACHED. SECURED MID CABIN EXIT SIGN.SDR DALA2020090902999Power Supply · faultedSHIP 3504 EPSU 102WL3 FAULT 335F001. CORRECTIVE ACTION: REPLACED EPSU 102WL3 REF A350 AMM 33-51.SDR SIMA202009098004Lamp · inoperativeGALLEY EMERGENCY LIGHT INOPERABLE. C/A R & R GALLEY EMERGENCY LIGHT LAMP, IAW EMB AMM 33-50-09-000-801-A AND 33-50-09-400-801-A. OPC GOOD.SDR SWAA2020091114589Lens · missingEMERGENCY AISLE LIGHT ABOVE 17DEF LENS MISSING. INTERIOR EMERGENCY EXIT LT SYS, EMERGENCY AISLE LIGHTS.SDR SWAA2020090914645Battery Pack · inoperativeFWD ENTRY OVERHEAD EMERGENCY LIGHTS NOT ILLUMANATED. R&R FWD LT OVERHEAD EMERGENCY BATTERY PACK, PER AMM 33-51-06.SDR DALA2020090982987Battery Pack · inoperativeCEILING EMERGENCY LIGHTS ARE INOPERATIVE AT 43FED, 45FED AND 40CBA. CORRECTIVE ACTION: REPLACED BATTERY PACK. SYSTEM OPERATION IS NORMAL.SDR SWAA2020092415024Lens · crackedCRACK SIDEWALL PANEL 242YAW LENS EXIT LIGHT AT PASSENGER CABIN (1 EA). REPLACED SIDEWALL PANEL 242YAW LENS EXIT LIGHT AT PASSENGER CABIN, IAW B737-700 AMM 33-51-01-960-802.SDR SWAA2020090914556Light · looseEXIT SIGN INSTALLED IN CEILING AT MID-CABIN HAS BECOME LOOSE. RESECURED LIGHT ASSY, PER AMM 33-51-01.SDR AALA2020090989003Lens · missingAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT ROW LIGHT LENS (RED) IS MISSING AT SEAT POSITION 11 RIGHT. INSTALLED EMERGENCY EXIT ROW LIGHT LENS (RED) AT SEAT POSITION 11 RIGHT AND TEST NORMAL AS PER AMM 33-51-18.SDR AALA2020090969015Battery · no testAIRCRAFT WAS NOT GROUNDED: OPERATIONAL TEST OF EMERGENCY LIGHTS DURING PS CHECK SHOWING FAULT BATTERY EMERGENCY POWER SUPPLY UNIT (11WL). REMOVED AND REPLACED LH EMERGENCY POWER SUPPLY UNIT BATTERY UNIT AT 11WL PER AMM 33-51-38.SDR AALA202009089004Power Supply · no testAIRCRAFT NOT GROUNDED - EPSU (EMERGENCY POWER SUPPLY UNIT) TEST FAILED, BATTERY PACK 10WL. REMOVED AND REPLACED EPSU 10WL PER AMM 33-51-38, OPERATIONAL CHECK GOOD, EPSU TEST PASSED.
Back to JASC 3350