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 SIMA2019120230001Sign · inoperativeDURING PS-1 CHECK FOUND AFT CEILING EMERGENCY EXIT SIGN LIGHT INOP-C/A-REMOVED AND REPLACED EMERGENCY CEILING LIGHT IAW AMM 33-50-15 OPC GOOD. EMERGENCY LIGHT STRIP P/N 8150-2SDR SWAA2019120239290Battery Pack · dischargedR1 DOOR EMERGENCY LIGHTS INOP. / R&R BATTERY PACK M2816 IAW AMM.SDR AALA2019120219004Sign · brokenAIRCRAFT WAS NOT GROUNDED: EXIT EMERGENCY SIGN L3 DOOR AFT WAS BROKEN. MAINTENANCE REPLACED DOOR SIGN LIGHT ASSEMBLY PER AMM 33-51-01.SDR N6WA2019120231Light · loosePHOTOLUMINESCENT STRIP LOOSE @ RH EXIT ROW. REATTACHED PHOTOLUMINOUS STRIP AT EXIT ROW IAW CRJ 700 AMM 25-25-01
PART.SDR DALA2019120216989Sign · missingR1 EMERGENCY EXIT DOOR LOWER IDENTIFIER MISSING, INSTALLED NEW EXIT LIGHT LENS P/N F1003450-01 ON R1 DOORSDR R61A201912021343Power Supply · inoperative6 OVERHEAD EMERGENCY LIGHTS R2 EXIT ONE FLOOD LIGHTS INOP. EMERGENCY LIGHT BATTERY FAULT CA MESSAGE. R&R RH AFT EMERGENCY LIGHT POWER UNIT IAW AMM 33-50-01.SDR SWAA2019120239286Light · inoperativeR/H FLOOR PATH LIGHTING AT ROW 1, FIRST 2 INCHES LIGHT UP BUT REST WERE DARK UNTIL ROW 2. / R&R LIGHT STRIP PER AMM.SDR SWAA2019120239279Lens · incorrectL2 DOOR EMERGENCY LIGHT LENS ON EXTERIOR OF LAV WALL HAD WRONG ARROW. / R&R LENS IAW SIP.SDR 2020F00198Sign · damagedL3 AFT EMERGENCY 'EXIT' SIGN LIGHT ASSBLY DAMAGED -- WON'T HOLD LENSSDR MASA2019113012163Bulb · inoperativeMID CABIN EXIT SIGN 1 BULB INOP. PLACED ON MEL.SDR 2020F00050Battery Pack · inoperativeR/H WING, OVERWING EXTERIOR EMERGENCY LIGHTS INOP. REMOVED AND REPLACED POWER SUPPLY M731 IAW MM 33-51-07. OPS CHECK GOOD. IAW MM 33-51-00.SDR R61A201912201414Sign · malfunctioned** WHILE AIRCRAFT WAS OUT OF SERVICE FOR HEAVY CHECK** FWD AND AFT SERVICE DOOR EMERGENCY EXIT SIGN NOT COMPLETELY ILLUMINATED. REPLACED FWD AND AFT SERVICE DOOR EMERGENCY EXIT SIGN IAW AMM 33-50-15. AIRCRAT REMAINS OUT OF SERVICE FOR HEAVY CHECK COMPLETION.SDR DALA2019120317024Lens · detached(AIRCRAFT 5651, L/P 5373064) LENS COVER ON DOORS LITE FWD PANEL IS OFF. CORRECTIVE ACTION: REINSTALLED LENS COVER ON GEAR DOORS IND. TESTS GOOD. REF B757 AMM 33-16.SDR SIMA201912029003Lamp · inoperativeDURING PS-1 CHECK, FOUND LH OVERWING EXTERNAL EMERGENCY LIGHT INOP-C/A-REMOVED AND REPLACED OVERWING EXTERNAL EMERGENCY LIGHT LAMP IAW AMM 33-50-10. OPERATIONAL CHECK GOOD. NO DEFECTS NOTED AT THIS TIME.SDR SIMA201912029002Battery Pack · inoperativeFWD SERVICE DOOR (R1) EMERGENCY EXIT LAMP AND LIGHT INOP-C/A-FOUND FWD SERVICE DOOR (R1) EMERGENCY EXIT LAMP AND LIGHT INOP, REMOVED AND REPLACED #1 ELPU IAW AMM 33-50-01, NO FURTHER DEFECTS NOTED, OPERATIONAL TESTS GOOD.SDR SIMA201912029001Power Supply · inoperativeAFT PAX DOOR (L2) EMERGENCY EXIT LAMP NEAR BOTTOM INOP-C/A-FOUND AFT PAX DOOR EMERGENCY EXIT IDENTIFIER INOP. REMOVED AND REPLACED POWER SUPPLY IAW AMM 33-50-01. OPC CHK GOOD NO FURTHER DEFECTS NOTEDSDR SWAA2019120239289Battery Pack · dischargedAFT RH EMERGENCY LIGHT BATTERY AT M1672 INOP. / R&R BATTERY PACK IAW AMM.SDR SWAA2019120239288Battery Pack · dischargedAFT L/H EMERGENCY LIGHT BATTERY AT M1673 INOP. / R&R BATTERY PACK IAW AMM.SDR DALA2019120236999Lens · missingDURING INSPECTION FOUND MID CABIN EMERGENCY EXIT LIGHT LENSE COVER MISSING. RE-SECURED MID CABIN EMERGENCY EXIT LIGHT COVER AS REQUIRED. A/C OK FOR SERVICE.SDR DALA2019120216992Fuse · failedSHIP 5811 EMER LIGHTS INOP ROWS 46-49. CORRECTIVE ACTION: REPLACED FUSE POWER SUPPLY M737 REF B757 WDM 33-51-22 AND B757 AMM 33-51-07-962-017-002. OPS GOOD. (6363255)SDR SWAA2019120239293Light · inoperativeR2 DOOR SLIDE LIGHT INOP. / RELAMPED LIGHT PER AMM.SDR WX0A2019120273440Battery Pack · inoperativeDURING EMERGENCY LIGHT TEST FOUND EMERGENCY LIGHT BATTERY PACK 11WL INOP. / "SDR WX0A2019120273443Cover · detachedEXIT SIGN LOWER FELL OFF NEAR L1 DOOR / R/R EXIT LIGHT COVER PER AMM 33-51-13. NO OTHER DEFECTS NOTED AT THIS TIME."SDR WX0A2019120273438Light · looseSMALL PIECE OF EMERGENCY EXIT LIGHT STRIP CAME LOOSE AT 2C / REATTACHED STRIP REF AMM 25-28-00"SDR MASA2019112912162Light · inoperativeROW 1 ESCAPE PATH LIGHTING INOP. REPLACED STRIP LIGHTSDR 2019FA0000386Lamp · inoperativeL4 DOOR LOWER EXIT EMERGENCY LIGHT, HAS A COUPLE BULBS INOP. RELAMPED LIGHT ASSY IAW MM 33-51-09. OPS CHECK GOOD.SDR SWAA2019112939215Lamp · inoperativeL/H LOWER FUSELAGE AFT FLAP EMERGENCY EXIT LIGHT INOP/ RELAMPED LIGHT PER AMM.SDR SWAA2019121739708Lens · crackedFORWARD GALLEY AREA EMERGENCY SIGN LENS CRACKED. / R&R LENS IAW CMM.SDR DALA2019120497051Battery Pack · inoperativeEMERGENCY LIGHTS IN LOWER CREW REST INOP. REPLACED LLCR EMERGENCY LIGHT POWER SUPPLY BATTERY. LIGHTS ALL OK EXCEPT UPPER L.H + UPPER R.H BUCK LIGHTS INOP. PSU'S NOT SECURED + INOP LIGHTS REMOVED. REFERENCE SERVICE CHECK AMDS CARD 0520-8787. WIP REPLACED UPPER SDR CALA2019120302133Battery · failedDURING TEST FND ESPU BATT 13WL LOW VOLTAGE. REPLACED 13WL ESPU BATTERY PACK AND PERFORMED BITE TEST OF ESPU THE RESULT FND ''SATIS'' AS PER AMM 33-51-38-000-002 REV.103, AMM 33-51-38-400-002 REV103 AMM 33-51-00-710-001 REV.103.SDR CALA2019120302132Battery · failedDURING TEST FND ESPU BATT 12WL LOW VOLTAGE REF ROUTINE NO. 9491373 - ORIGINATED BY EMP V924351, SPEC NO.A3NB-33-3-6012 PERFORMED BY EMP V924351, PERFORMED REPLACEMENT OF 12WL ESPU BATT PACK AND PERFORMED BITE TEST OF ESPU THE RESULT FND ''SATIS'' AS PER AMM 33SDR CALA2019120302131Battery · failedCAB ESPU 10WL BATTERY FOUND LOW VOLTAGE REF ROUTINE NO.9490827 - ORIGINATED BY EMP V905504, SPEC NO.A3NB-24-3-6062. PERFORMED BY EMP V924351, REPLACED 10WL ESPU BATT PACK AND PERFORMED BITE TEST OF ESPU THE RESULT FND ''SATIS'' AS PER AMM 33 -51-38-000-002 REVSDR CALA2019120302130Battery · failedDURING TEST FND ESPU BATT 11WL LOW VOLTAGE REF ROUTINE NO. 9491372 - ORIGINATED BY EMP V924351 , SPEC NO.A3NB-33-3-6012. PERFORMED BY EMP V924351,REPLACED 11WL ESPU BATT PACK AND PERFORMED BITE TEST OF ESPU THE RESULT FND ''SATIS'' AS PER AMM 33 -51-38-000-002SDR DALA2019120317012Battery Pack · looseL1 F/A SEAT BATTERY PACK LOOSE IN SUPPLY. SCREWS NEED TO BE ENGAGED. ENGAGED L1 EMERGENCY BATTERY PACK. SYSTEM OPERATION IS NORMAL.SDR DALA2019120317011Battery Pack · not reportedAIRCRAFT DUE EMERGENCY LIGHTS POWER SUPPLY BATTERY REPLACEMENT. REPLACED 18 EMERGENCY LIGHTS POWER SUPPLY BATTERIES. SYSTEM OPERATION IS NORMAL.SDR AALA2019120299009Power Supply · inoperativeAIRCRAFT WAS GROUNDED: MAINTENANCE REPORTS WHEN PERFORMING EPSU TEST BAT / EPSU 12WL FAULT. REPLACED EPSU ASSY AT 10WL & OPS TESTED GOOD. NO FAULTS IAW AMM 33-51-38.SDR QXEA2019120200436Light · looseRUBBER STRIP PEELING UP NEXT TO INTERNAL BAG DOOR. REMOVED FROM SERVICE. SEALED ALONG EMERGENCY EXIT LIGHT STRIP NEXT TO INTERNAL BAG DOOR. NO OTHER DEFECTS. RETURNED TO SERVICE.SDR SIMA201912028001Power Supply · inoperativeFOUND OVERWING EMERGENCY LIGHTS INOP.-C/A-REMOVED AND REPLACED #4 EMERGENCY LIGHTING POWER SUPPLY AND BATTERY IAW WORKCARD 33-700-19, OPS CHK GOOD. WORKCARD 33-700-17. EMERGENCY LIGHTING BATTERY P/N 2013-1A S/N 82530SDR SIMA201911298002Lamp · inoperativeROW 12 B/C OVERHEAD EMERGENCY LIGHT INOP-C/A-RAR ROW 12 B/C OVERHEAD EMERGENCY LIGHT LAMP IAW EMB AMM 33-50-07-000-801-A AND 33-50-07-400-801-A. OPS CHECK GOOD. ENDSDR SWAA2019112939221Battery Pack · no testBATTERY PACKS AT POSITIONS M1673 FAILED CAPACITY CHECK. / R&R BATTERY PACK PER AMM.SDR SWAA2019112939220Battery Pack · no testBATTERY PACKS AT POSITIONS M1668 FAILED CAPACITY CHECK. / R&R BATTERY PACK PER AMM.SDR SWAA2019112939219Battery Pack · no testBATTERY PACKS AT POSITIONS M1672 FAILED CAPACITY CHECK. / R&R BATTERY PACK PER AMM.SDR SWAA2019112939218Battery Pack · no testBATTERY PACKS AT POSITIONS M1675 FAILED CAPACITY CHECK. / R&R BATTERY PACK PER AMM.SDR SWAA2019112939210Sign · looseFORWARD GALLEY EMERGENCY EXIT SIGN LOOSE. / REINSTALLED FORWARD ENTRY DOOR EMERGENCY EXIT SIGN PER AMM.SDR DALA2019112806954Power Supply · inoperativeRIGHT WALL MOUNT EMERGENCY EXIT SIGN WILL NOT ILLUMINATE, REPLACED EMERG POWER SUPPLY UNIT 14WLSDR SWAA2019122639929Light · brokenBROKEN STRIP PHOTOLUMINESCENT FLOOR PROXIMITY LIGHTING AT CENTER SECTION. / R&R PHOTOLUMINESCENT FLOOR PROXIMITY LIGHT IAW AMM.SDR DALA2019120627080Light · cracked(AIRCRAFT 7103, L/P 1378450) FLOOR PROX EMER LTS FOUND CRACKED AT EXTERIOR OF OFCR, OFAR AND GLY. CORRECTIVE ACTION: FLOOR PROX EMER LTS REMOVED AND REPLACED AND OPS TEST CARRIED OUT AS PER B777 AMM 33-51-05.SDR SWAA2019120339306Light · damagedEMERGENCY EXIT LIGHT ON G-4 GALLEY DAMAGED. / R&R LIGHT PER AMM.SDR DALA2019120317013Charger · inoperativeON WALK AROUND FOUND AFT GALLEY EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY CHARGER AND BATTERY PACK UNDER F/A JUMP SEAT. SYSTEM OPERATION IS NORMAL.SDR QXEA2019120200437Light · looseEMERG LIGHTING STRIP BY MAIN CABIN DOOR LOOSE. REMOVED FROM SERVICE. RESECURRED EMERG LIGHTING STRIP BY MCD. NO FURTHER DEFECTS NOTED. RETURNED TO SERVICE.
Back to JASC 3350