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 SWAA2020012840829Light · inoperativeL1 DOOR EMERGENCY LIGHT INOP. R&R LIGHT ASSEMBLY IAW AMM.SDR AALA202001289009Battery Pack · inoperativeAIRCRAFT NOT GROUNDED: EMERGENCY LIGHT. TEST FAILED EPSU INT LOAD EMER L. REMOVED AND REPLACED THE BATTERY PACK 13WL IAW AMM 33-51-38.SDR QXEA2020012800054Light · damagedFORWARD LENGTH OF PHOTOLUMINESCENT STRIP IS DAMAGED. REMOVED FROM SERVICE. REPLACED DAMAGED PHOTOLUMINESCENT STRIP IAW E175 AMM 33-50-21-000-001-A AND TASK 33-50-21-400-801-A. RETURNED TO SERVICE.SDR SWAA2020012840820Charger · inoperativeREPLACE EMERGENCY BATTERY PACK FROM ASSEMBLY M1676 (INOP LIGHTS). / REMOVED AND REPLACED BATTERY AND BATTERY CHARGER M1676 IAW AMM 33-51-06-960-805. OPS CHECK GOOD.SDR SWAA2020012874819Charger · inoperativeEXTERIOR EMERGENCY LIGHT R1 DOOR INOP (REPLACE BATTERY). / REMOVED AND REPLACED BATTERY AND BATTERY CHARGER M2816 IAW AMM 33-51-06-960-805. OPS CHECK GOOD.SDR SWAA2020012840810Battery · inoperativeEMERGENCY BATTERY PACK FROM ASSEMBLY M1676, LIGHTS INOPERATIVE. REMOVED AND REPLACED BATTERY AND BATTERY CHARGER M1676 IAW AMM 33-51-06-960-805. OPS CHECKED GOOD.SDR SWAA2020012874793Battery · inoperativeEXTERIOR EMERGENCY LIGHT R1 DOOR INOPERATIVE. REMOVED AND REPLACED THE BATTERY AND BATTERY CHARGER M2816 IAW AMM 33-51-06-960-805. OPS CHECKED GOOD.SDR REXA2020012760054Battery · malfunctionedEMERGENCY LIGHTS FLICKERING ON AND OFF IN AFT CABIN
REMOVED AND REPLACED EMERGENCY BATTERY AT POSITION PS-35 IAS CRJ900 MM CH 33-51-17 ALL CHECKS GOODSDR N6WA20200127601Light · inoperativeEMERG CEILING LIGHT AT 3RD. DEFERRED 3RD OVERHEAD EMERGENCY LIGHT ON DMI 70066852 PER MEL 33-51-01B-2A CAT C AUTH BY MXCSDR SIMA202001276003Battery Pack · inoperativeAFT SERVICE DOOR FLOOR EXIT SIGN NOT ILLUMINATING DURING PS-1 INSPECTION-C/A-FOUND TO BE #4 EMERGENCY BATTERY PER WM 33-50-50 REMOVED AND REPLACED #4 EMERGENCY BATTERY IAW EMB-175 AMM 33-50-01 OPC GOODSDR SIMA202001276002Light · inoperativeFOUND PHOTO LUMINESCENT FLOOR EMERGENCY LIGHT STRIP OUT AT ZONE 226.-C/A-REMOVED AND REPLACED PHOTO LUMINESCENT EMERGENCY LIGHT STRIP AT ZONE 226 IAW ERJ 175 AMM 33-50-21. NO FURTHER DEFECTS NOTED.SDR WX0A202001273461Battery Pack · no testEMERGENCY LIGHTS ESPU FAILED AN OPS CHECK. REPLACED THE BATTERY PACKS.SDR DALA2020012700600Battery Pack · inoperativeON S/C FOUND ROWS 31-36 EMERGENCY LIGHTS INOP. RMVD & RPLCD AFT CABIN AISLE EMERGENCY LIGHT BATTERY PACK WITH REF TO MD88 AMM 33-53. OPS CHECK GOOD. OK FOR SERVICE. (LP6468136)SDR DALA2020012700598Battery Pack · inoperativeOVERHEAD EMERGENCY LIGHTS AT ROWS 16-20 INOP. REPLACED BATTERIES IN BATTERY PACK - TESTS AND OPS CHECKS GOOD. (LP6484606)SDR SWAA2020030442130Battery · inoperativeM2335 BATTERY INOP. / REPLACED M2335 BATTERY AND PERFORMED SATISFACTORY / INSTALLATION TEST OF SERVICEABLE REPLACEMENT / BATTERY PER AMM 33-51-06-960-805.SDR SWAA2020013140927Sign · unsecureOVERHEAD EXIT SIGN AT MID-AIRCRAFT WAS HANGING BY WIRES. FOUND ONE BRACKET AND PLACED IT ON LOGBOOK. SECURED LIGHTS PER AMM.SDR SWAA2020013040906Light · inoperativeAFT LAV FORWARD SIDE OF FORWARD WALL EMERGENCY EXIT LIGHT INOPERATIVE. R&R LIGHT IAW AMM.SDR QXEA2020012900066Light · loosePIECE OF EMERGENCY LIGHTING FLOOR TRACK STRIP PULLED UP. REMOVED FROM SERVICE. REINSTALLED EMERGENCY LIGHTING FLOOR TRACK STRIP, REF Q400 AMM TASK 33-51-16-400-801SDR REXA2020012950052Light · missingFWD GALLEY EMERGENCY LIGHT MISSING
INSTALLED GALLEY EMERGENCY LIGHT IAW CRJ 900 AMM 33-51-01, ALL CHECKS GOOD.SDR YENA2020012950068Battery · no testWHILE PREFORMING TASKCARD A320-33-51-00-710-003 FIN 12WL BATTERY FAIL DURING BATTERY CAPACITY TEST; R & R EPSU BATTERY IAW AMM 33-51-38. BITE TEST OKAY.SDR YENA2020012950067Battery · no testWHILE PREFORMING TASKCARD A320-33-51-00-710-003 FIN 11WL BATTERY FAIL DURING BATTERY CAPACITY TEST; R & R EPSU BATTERY IAW AMM 33-51-38. BITE TEST OKAY.SDR YENA2020012950066Battery · no testEMER LT BAT CAPACITY TEST FAIL; PER T/C A320-33-51-00-710-003 R & R EMER LT BAT AS REQ MM 33-51-00.SDR YENA2020012925065Battery · no testEMER LT BAT CAPACITY TEST FAIL; PER T/C A320-33-51-00-710-003 R & R EMER LT BAT AS REQ MM 33-51-00.SDR YENA202001285064Battery · no testEMER LT BAT CAPACITY TEST FAIL; PER T/C A320-33-51-00-710-003 R & R EMER LT BAT AS REQ MM 33-51-00.SDR AALA2020012879009Battery Pack · no testAIRCRAFT WAS NOT GROUNDED: EMERGENCY POWER SUPPLY UNIT SYSTEM TEST FAILED. MAINTENANCE REPLACED BATTERY PACK AT 12WL PER AMM 33-51-38.SDR R61A2020012850112Sign · inoperativeR2 DOOR EXIT IDENTIFIED SIGN INOP. R&R R2 DOOR EMERGENCY EXIST SIGN.SDR R61A2020012850109Battery · inoperativeR2 BOTTOM EXIT SIGN, GALLEY EMERGENCY CEILING LIGHT OUT. FERRIED TO MIA, THEN TO CMH. R&R ELPU #1 PER MM 33-50-01. R&R L2 R2 DOOR EXIT IDENTIFIER SIGN PER MM 33-50-15. R&R EPLU #4 PER MM 33-50-01. R&R ELPU #3 PER MM 33-50-01. OPS CHECK SATISFACTORY. OFF PART SDR SCNA202001285001Power Supply · inoperativeRT EMERGENCY OVERWING LIGHT INOPERATIVE. A NEW BULB, NO FIX . R & R THE M1671 BATTERY POWER SUPPLY CHARGER IAW AMM 33-51-06. OK FOR SERVICE.SDR AALA202001289033Battery · dischargedEPAS BATTERY DEAD AT DOOR L3. REPLACED DOOR L3 EPAS BATTERY IAW AMM 52-12-19-000=802.SDR MYWA202001280284Ballast · inoperativeFWD L/H EMERGENCY EXIT WALL LIGHT INOP. REFERENCE LOG PAGE 255569.SDR QXEA2020012700049Light · damagedFORWARD LEFT HAND SECTION OF PHOTOLUMINESCENT STRIP FROM BULKHEAD TO SEAT 2A DAMAGED. REPLACED DAMAGED PHOTOLUMINESCENT STRIP IAW E175 AMM 33-50-21-000-001-A AND TASK 33-50-21-400-801-A. RETURNED TO SERVICE.SDR QXEA2020012700048Light · damagedFORWARD LENGTH OF PHOTOLUMINESCENT STRIP IS DAMAGED. DEFERRED UNDER MEL 33-50-21A. MEL CLEARED BY REPLACING DAMAGED PHOTOLUMINESCENT STRIP IAW E175 AMM 33-50-21-000-001-A AND TASK 33-50-21-400-801-A. CLEAR MEL. RETURNED TO SERVICE.SDR AALA202001279014Battery · no testAIRCRAFT WAS GROUNDED: EMERGENCY LIGHT POWER UNIT INOPERATIVE AT DOOR 2R. MAINTENANCE REPLACED EMERGENCY LIGHT POWER UNIT BATTERY PER AMM 33-55-01.SDR SIMA202001275003Switch · brokenFOUND EMERGENCY LIGHT TOGGLE SWITCH BROKEN.-C/A-REMOVED AND REPLACED EMERGENCY LIGHTNING PANEL IAW EMB 145 AMM 20-13-00 PERFORMED OPS CHECK REF EMB 145 AMM 33-50-00 AND 33-11-00 OPS CHECK GOOD A/C OK FOR SERVICESDR WX0A202001273460Battery Pack · no testESPU TEST FAILS ON OPERATIONAL CHECK. / REPLACED BATTERY ON ESPU.SDR JJBA202001275007Lamp · inoperativeMAIN DOOR HINGE EXTERNAL EMERGENCY LIGHT INOPERATIVE. R&R MCD EMERGENCY LIGHT LAMP. OPS CHECK SAT.SDR MASA2020012500035Bulb · inoperativeLT OWING FLR EXIT SIGN ONE BULB INOP. PLACED ON MELSDR FDEA2020031740223Battery · dischargedMDIS 790 33-50 3426 24JAN20 GSO FACT U L1 DOOR EXTERIOR EMERGENCY LIGHT AND L1 DOOR INTERIOR EXIT SIGN WON'T ILLUMINATE WHEN EMERGENCY LIGHTS ARE TESTED. R/I 24JAN20 05:26 GSO U REASON CODE : PREMATURE REMOVAL/INSTALLATION OFF MPN: 2013-SDR SWAA2020021370818Housing · damagedEMERGENCY EXIT STRIP LIGHTING COVER LOOSE/OFF. ROW 6 L/H SIDE LENS MISSING 26975 BULL NOSE / INSTALLED LENS HOUSING ASSEMBLY PER MM.SDR SWAA202002137769Housing · damagedEMERGENCY EXIT STRIP LIGHTING COVER LOOSE/OFF. ROW 6 L/H SIDE LENS MISSING 26975 BULL NOSE / INSTALLED LENS HOUSING ASSEMBLY PER MM.SDR YENA2020012840063Lens · crackedFT # 1251, HPN-RSW. LEFT LOWER EXTERNAL EMERGENCY EGRESS LIGHT LENS APPEARED CRACKED ( EXTERNAL EMERGENCY-OPS NOT CONDUCTED AT NIGHT ); R & R LH LOWER EMERGENCY LIGHT COVER ASSY PER E190 AMM 33-50-25. THIS CLEARS MDDR. MX-4 UPDATED. PLACARD REMOVED.SDR YENA2020012840062Battery · no testIAW TASK CARD A320-33-51-00-710-003, PERFORMED TEST 2 FAILED FOR BATTERY. EPSW BATTERY CAP EMER R/L FAIL. R & R LT AND RT EMERGENCY BATTERY PACKS. BOTH TESTED GOOD IAW AMM 33-51-38.SDR YENA2020012840061Battery · no testIAW TASK CARD A320-33-51-00-710-003 PERFORMED TEST 2 FAILED FOR THE BATTERY. EPSW BATTERY CAP EMER R/L FAILED. R & R LT AND RT EMERG BATT PACKS. BOTH TESTED GOOD IAW AMM 33-51-38.SDR YENA2020012840060Battery · no testBATTERY 15WL RQ REPLACE POST TEST FAIL. R & R BATT 15WL IAW AMM 33-51-38. EPSU TESTED GOOD.SDR YENA2020012840059Battery · no testBATTERY 11WL REQ REPLACE POST TEST FAIL. R & R BATT 11WL IAW AMM 33-51-38 EPSU TESTED GOOD.SDR YENA2020012840058Battery · no testWHILE PERFORMING TASK CARD A320-33-51-00-710-003 - CHECK OF THE BATTERY CPACITY. 12WL EMERGENCY BATTERY FAILED TEST. R & R EMERGENCY BATTERY 12WL IAW MM 33-51-38.SDR SWAA2020012874817Fuse · inoperativeEMERGENCY LIGHT ON CEILING IN FORWARD GALLEY AND LIGHT NEXT TO FORWARD JUMPSEAT INOP. REMOVED AND REPLACED BATTERY PACK AND FUSES FOR EMERGENCY LIGHT POWER SUPPLY M01675 PER AMM 33-51-06.SDR SWAA2020012874805Battery Pack · inoperativeEMERGENCY EXIT LIGHTS IN FORWARD ENTRY DOORWAY INOP. REMOVED AND REPLACED BATTERY PACK M1674 PER MM 33-51-06-960-805 OPERATIONAL CHECK OF EMERGENCY LIGHTS GOOD PER MM 33-51-00-720-801.SDR SWAA2020012874804Battery Pack · inoperativeRH SERVICE DOOR EMERGENCY ESCAPE SLIDE LIGHT INOP. / BATTERY PACK M1674 REPLACED AND OPERATIONAL CHECK PERFORMED ON DEFECT NO U110075SDR SWAA2020012874800Battery Pack · inoperativeEMERGENCY BATTERY PACK M1673 WILL NOT CHARGE. REMOVED, INSTALLED AND PERFORMED OPS CK OF EMERGENCY BATTERY PACK M1673 IAW AMM 33-51-06-960-805. OPS CHECKED GOOD.
Back to JASC 3350