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 SWAA2018092625540Battery Pack · dischargedLT SERVICE DOOR EXTERIOR EMERGENCY LIGHT INOP. R&R BATTERY PACK PER AMM.SDR AALA201808159003Light · brokenR1 DOOR EMERGENCY EXIT LIGHT BROKEN OFF. REPLACED R1 DOOR EMERGENCY WALL LIGHT. OPERATIONS NORMAL IAW AMM 33-51-13 AND AWM 33-51-03.SDR AALA201808139019Light · inoperativeSEAT 8L EMERGENCY LIGHT WAS INOPERATIVE. REPLACED EMERGENCY LIGHT. OPS OK IAW AMM 33-51-19.SDR AALA2018130811001Light · damagedLAVATORY H THRESHOLD LIGHT ADJACENT BOTTOM RIGHT CORNER WAS DAMAGED, HANGING BY WIRES. REPLACED THE EMERGENCY LIGHT IAW MM 33-51-19-000-003-A. CHECKED NORMAL. OK FOR SERVICESDR AALA201808139027Light · inoperativeFORWARD LAVATORY A EMERGENCY LIGHT INOPERATIVE. THE AIRCRAFT WAS GROUNDED. REPLACED FORWARD LAVATORY EMERGENCY LIGHT IAW AMM 33-24-02 . OPS NORMAL.SDR SIMA2018081311001Lamp · inoperativeDURING A PS-2 CHECK, FOUND THE COCKPIT EMERGENCY LIGHT TO BE INOPERATIVE. REMOVED AND REPLACED THE LAMPS IAW AMM 33-50-05-000-801-A AMM 33-50-05-400-801-A. OPS CHECKED GOOD. NO FURTHUR DEFECTS NOTED.SDR SWAA2018081324222Battery Pack · dischargedFORWARD CABIN EMERGENCY LIGHTS INOP AT LOCATION M1674. R&R BATTERY PACK PER AMM.SDR SWAA2018081324203Light · inoperativeR2 DOOR EMERGENCY EXIT LIGHT INOP. RELAMPED LIGHT IAW AMM.SDR SWAA2018081324199Light · inoperativeLT BULLNOSE EMERGENCY LIGHT INOP AT ROW 12. RELAMPED LIGHT PER AMM.SDR HNAA2018081300195Light · inoperativeEMERGENCY FLOOD LIGHT ON SERVICE DOOR WAS INOPERATIVE. R & R THE EMERGENCY FLOOD LIGHT ASSEMBLY. OPS CHECKED GOOD.SDR HNAA2018081300193Light · damagedRIGHT EMERGENCY LIGHT WAS INOPERATIVE. INSPECTED AND FOUND THE BULB MOVED INSIDE THE ASSEMBLY. R & R LIGHT ASSY IAW AMM 33-50-10-000-801-A SECTION M AND 33-50-10-400-801-A, SECTION L . OPS CHECKED GOOD.SDR MASA2018081113473Battery · inoperativeSERVICE DOOR EMERGENCY EXIT SIGN WAS INOPERATIVE. REPLACED THE BATTERY.SDR SIMA2018081005005Light · inoperativeFOUND FWD RT EXTERNAL EMERGENCY LIGHT IN-OP.-C/A-COMPLETE: REMOVED AND REPLACED FWD RT EXTERNAL EMERGENCY LIGHT BULB IAW AMM 33-50-10. OPS CHECK GOOD.SDR A8ZR20180921001Light · defectiveRT FWD EMERGENCY EXIT DOOR, LT & RT UNDER WING EMERGENCY EXIT DOOR BETA LIGHTS P/N 1971001 FAILED BRIGHTNESS CHECK REF TASK CARD 3350/02 AND REPLACED REF AMM 33-51-00 REV 38.SDR SWAA2018091725279Light · inflt separationL1 DOORWAY LOWER FORWARD EMERGENCY EXIT SIGN BULB INOP. R&R SIGN PER AMM.SDR SWAA2018090424783Light · inoperativeL1 DOORWAY UPPER EDGE EMERGENCY EXIT LIGHT BULB INOP. R&R BULB IAW AMM.SDR SWAA2018090424782Light · inoperativeLT LOWER FORWARD OVERWING EMERGENCY EXIT SIGN BULB INOP. R&R BULB IAW AMM.SDR REXA201808150698Bulb · inoperativePAX DOOR EXTERNAL EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE BULB IAW AMM 33-51-15. OPS TESTED GOOD IAW AMM 33-51-15-710-801.SDR REXA201808150697Light · wornSEVERAL EMERGENCY LIGHT STRIPS WERE WORN THROGHOUT THE CABIN. REPLACED IAW AMM 33-51-01-400-801, STEP A.SDR DALA2018081435085Lens · damagedEMERGENCY EXIT COVER DIFFUSER LENS DAMAGED OR MISSING. REATTACHED EMERGENCY EXIT COVER AT DOOR 1R AS REQUIRED.SDR AALA2018081439039Light · looseL2 DOOR EMERGENCY LIGHT WAS LOOSE FROM WALL. MAINTENANCE REPLACED THE EMERGENCY LIGHT IAW AMM 33-51-16 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA2018081439036Cover · missingEMERGENCY LIGHT ASSEMBLY COVER AT 2R WAS MISSING. MAINTENANCE REPLACED EMERGENCY LIGHT ASSEMBLY COVER AND PERFORMED SATISFACTORY OPERATIONAL CHECKED IAW AMM 33-51-00.SDR AALA2018081439035Bulb · missingAIRCRAFT IN BASE MAINTENANCE: ABOVE MID CABIN EXIT SIGN, FOWARD FACING LIGHT BULBS, MISSING. REPLACED MISSING LIGHT BULBS AND PERFORMED SATISFACTORY OPERATIONAL CHECKS PER AMM 33-51-16.SDR AALA2018081439034Lens · crackedR1 DOOR EMERGENCY LIGHT LENS WAS CRACKED. MAINTENANCE REPLACED LENS IAW AMM 33-50-00 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR SWAA2018081324226Battery Pack · failedBATTERY PACKS FAILED CAPACITY CHECK AT LOCATION M1673. R&R BATTERY PACK PER AMM.SDR SWAA2018081324225Battery Pack · failedBATTERY PACKS FAILED CAPACITY CHECK AT LOCATION M1672. R&R BATTERY PACK PER AMM.SDR SWAA2018081324224Battery Pack · failedBATTERY PACKS FAILED CAPACITY CHECK AT LOCATION M1670. R&R BATTERY PACK PER AMM.SDR SWAA2018081324191Battery Pack · failedBATTERY PACKS FAILED CAPACITY CHECK AT LOCATION M1668. R&R BATTERY PACK PER AMM.SDR DALA2018081205012Unknown · unknownFWR LT AND RT EXIT EMERGENCY LIGHTS OVER WING INOPERATIVE. CYCLED SYSTEM POWER AND EMERGENCY LIGHTS OPS CHECK GOOD ON SEVERAL ATTEMPTS IAW MM 33-51.SDR MASA2018081013471Lamp · inoperativeROW 16 CEILING EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS.SDR XMXR20191211003Battery Pack · failedEMERGENCY LIGHTS STAYS ON IN ARM POSITION OR FLASHES ON/OFF IN ARM AND ON. REPLACED BATTERY PACK.SDR SWAA2018082024449Cover · crackedLT LOWER EXIT LIGHT COVER CRACKED AT ROW 11. R&R COVER IAW AMM.SDR AALA2018081539006Power Supply · defectiveTHE AIRCRAFT WAS NOT GROUNDED. FOUND 8 ROWS OF SEAT/ FLOOR EMERGENCY LIGHTS INOPERATIVE. FOUND EMERGENCY POWER SUPPLY UNIT (14WL) BAD. REPLACED EPSU PER AMM 33-51-38. OPERATIONS CHECK NORMAL.SDR DALA201808135049Lens · damagedEMERGENCY LIGHT DAMAGED IN THE AFT GALLEY, POSITION A113. REPLACED EMERGENCY LIGHT LENS.SDR SWAA2018081324221Battery Pack · dischargedL1 DOOR EMERGENCY LIGHT ABOVE DOOR INOP. R&R BATTERY PACK IAW AMMSDR SWAA2018081324220Charger · inoperativeAFT CABIN EMERGENCY EXIT LIGHTS INOP. R&R BATTERY CHARGER IAW AMM.SDR SWAA2018081324211Light · inoperativeRT OVERHEAD OVERWING EMERGENCY EXIT LIGHT INOP. R&R LAMP PER AMM.SDR IPXA2018081092624Power Supply · inoperativeEMERGENCY LIGHT BATTERY PACK 1 LOW, LIGHT ILLUMINATED WHILE PERFORMING AN EMERGENCY LIGHT TEST. FAULT ISOLATION PROCEDURE 33-51-02-00, FIG 104. BL.1.2 AND 6. INSTALLED SERVICEABLE EMERGENCY LIGHTING BATTERY POWER SUPPLY IAW AMM 33-51-01-4.SDR SWAA2018081024174Circuit Breaker · faultyRT AFT EMERGENCY BATTERY CHANGER CIRCUIT BREAKER POPPED. R&R CIRCUIT BREAKER PER MM.SDR MASA2018080913468Lamp · inoperativeFOURTH OVERHEAD EMERGENCY LIGHT WAS INOPERATIVE. REPLACED THE LAMPS.SDR SWAA2018080924146Lens · crackedRT AFT EXTERIOR EMERGENCY LIGHT LENS CRACKED. R&R LENS ASSEMBLY PER SIP.SDR YENA201808138309Battery Pack · failedDURING AN EMERGENCY LIGHTS TEST. EPSU BATTERY FWD FAILED. REPLACED THE EPSU 10WL BATTERY. EMERGENCY LIGHTS SYS TESTED GOOD.SDR DALA2018081094982Spring · brokenEMERGENCY LIGHT SWITCH GUARD WAS BROKEN. FOUND THE SPRING BROKEN ON THE SWITCH GUARD. REPLACED THE GUARD.SDR R61A2018081080850Battery Pack · inoperativeEMERGENCY LIGHT INOPERATIVE. R & R THE BATTERY PACK IAW AMM 33-50-01.SDR SIMA201808098002Light · damagedFWD RIGHT EMERGENCY LIGHT STRIP WAS DAMAGED. REMOVED AND REPLACED THE LIGHT STRIP IAW MM 33-50-21.SDR MASA2018080813469Battery Pack · dischargedPAX DOOR FLOOR EXIT EMERGENCY LIGHT INOPERATIVE. ALLOWED BATTERIES TO CHARGESDR SWAA2018080924152Light · inoperativeRT OVERWING EXTERNAL EMERGENCY LIGHT INOP. RELAMPED LIGHT PER AMM.SDR SWAA2018080824122Light · inoperativeL1 DOOR EXTERNAL EMERGENCY LIGHT INOP. R&R BULB PER MM.SDR SWAA2018081324228Battery Pack · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1672. R&R BATTERY PACK PER AMM.SDR SWAA2018081324227Battery Pack · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1673. R&R BATTERY PACK PER AMM.
Back to JASC 3350