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 AALA20170602003Indicator · brokenAIRCRAFT WAS IN BASE MAINTENANCE. EMERGENCY EXIT AFT FLOOR PROXIMITY INDICATOR BY THE L3 DOOR IS BROKEN. REMOVED AND REPLACED EXIT INDICATOR IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20170601001Light · detachedTHE AIRCRAFT WAS GROUNDED. AFT LEFT EMERGENCY EXIT LIGHT FELL OFF. REPLACED LIGHT ASSY IAW AMM 33-51-01. OPS CHK NML.SDR DALA2017060104437Light · inoperativeEMERGENCY ESCAPE PATH CABIN LIGHT AT POSITION 12B AND 23H INOPERATIVE. DEFERRED PER MEL 33-51-01B-AMS REPLACED EMERGENCY LIGHTS AT 12B AND 23H.SDR DALA2017060104432Lens · missingCOVER FOR EMERGENCY PATHWAY LIGHT AT DOOR 1L MISSING. INSTALLED RED LENS COVER.SDR DALA2017060104431Circuit Breaker · malfunctionedEMERGENCY LIGHTS INTERMITTENTLY ON AND OFF BEFORE TAKEOFF AND LANDING. T/S PER SRM 33-51-06 RESET C/B ON P11 PANEL AND OPS CHECK PER AMM 33-51.SDR AALA20170601003Light · inoperativeWHITE FWD EMERGENCY LIGHT INOPERATIVE AT SEAT 3E. REPLACED EMERGENCY LIGHT ASSY IAW AMM 33-51-00. OK FOR SERVICESDR CALA2017060201650Sign · brokenEXIT SIGNS STOPPERS FOUND BROKEN. REPLACED THE EXIT SIGN STOPPERS AND OP TESTED NORMAL IAW SRM 51-40-02, REV 74, AMM 33-51-01-060-802, REV 80, & AMM 33-51-00-710-802, REV 80.SDR AALA201706019015Light · looseEMERGENCY LIGHT AT ROW 17 IS LOOSE. SECURED THE LIGHT IAW AMM 33-51-15. OPERATIONAL CHECKED GOOD.SDR AALA201706019029Lens · looseL1 DOOR EMERGENCY EXIT LIGHT LENS NOT SECURE. REPLACED THE LENS.SDR AALA201706019027Lens · missingFORWARD GALLEY EMERGENCY LIGHT LENS MISSING ON R1 DOOR. REPLACED THE LENS.SDR SWAA2017060114090Lens · looseMID CABIN CEILING EXIT LIGHT LENS LOOSE. SECURED THE LENS IAW MM.SDR MASA2017053112341Battery Pack · dischargedFWD FACING MID CABIN EXIT SIGN INOPERATIVE. CHARGED THE BATTERIES.SDR MASA2017053112340Battery Pack · dischargedROW 13 MID LEVEL EXIT SIGNS INOPERATIVE. CHARGED THE BATTERIES.SDR SWAA2017062114549Sign · inoperativeRT OVERWING LOWER EMERGENCY EXIT DOOR SIGN LIGHT INOP. R&R SIGN IAW AMM.SDR SWAA2017062014522Lamp · inoperativeLEFT EMERGENCY STOWBIN BULLNOSE LIGHT INOPERATIVE AT ROW 7. REPLACED THE LAMP IAW AMM.SDR AALA20170602004Indicator · brokenAIRCRAFT WAS IN BASE MAINTENANCE. EMERGENCY EXIT IDENTIFIER AT THE R4 DOOR FORWARD POSITION HAS A BROKEN LENS COVER. REMOVED AND REPLACED INDICATOR (LENS COVER) IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA201705319035Light · unsecureTHE AIRCRAFT WAS NOT GROUNDED. RIGHT AFT DOOR EMERGENCY LIGHT COVER WILL NOT STAY IN PLACE. REPLACED RT AFT DOOR EMERGENCY LIGHT ASSEMBLY AND WORKS NML. IAW MM 33-51-01.SDR AALA201705319034Sign · unsecureTHE AIRCRAFT WAS NOT GROUNDED. EXIT SIGN AT DOOR 4R CAME OFF DOOR. REPLACE EXIT SIGN IAW AMM 33-51-01.SDR DALA2017053104433Epsu · faultedDURING COMPLETION OF WORK CARD 0591-0115 FAULTED EMERGENCY LIGHT/EPSU 19WL. REPLACED 19WL.SDR AALA201705319019Lens · missingAFT GALLEY EMERGENCY EXIT LIGHT LENS MISSING. INSTALLED A NEW LENS.SDR SWAA2017060114108Battery · inoperativeL2 DOOR EMERGENCY EXIT LIGHT INOPERATIVE. R & R THE BATTERY IAW MM.SDR SWAA2017060114105Lens · missingRIGHT OVERWING EXIT LIGHT LENS MISSING. INSTALLED A NEW LENS IAW MM.SDR SWAA2017060114104Lens · looseMID CABIN CEILING EMERGENCY EXIT LIGHT LENS LOOSE. REINSTALLED THE LENS IAW MM.SDR SWAA2017060114101Battery · inoperativeL2 DOOR EXTERIOR EMERGENCY EXIT LIGHT INOPERATIVE. R & R THE BATTERY IAW MM.SDR SWAA2017060114093Lens · brokenLEFT OVERWING EXIT LIGHT LENS BROKEN. R & R THE LENS IAW MM.SDR SWAA2017060114092Lens · missingRIGHT OVERWING EXIT LIGHT LENS MISSING. REPLACED THE LENS IAW MM.SDR DALA2017053104409Sign · loose15D EXIT SIGN LOOSE. RESECURED EXIT SIGN.SDR AALA201705319025Lens · brokenR2 DOOR EXIT SIGN LENS BROKEN. REPLACED THE LENS IAW GPM 02-01-2. OK FOR SERVICE.SDR AALA201705319018Lens · missingROW 8 RIGHT EMERGENCY EXIT LIGHT PLASTIC LENS ON SEAT MISSING. REPLACED THE LENS. OK FOR SERVICE.SDR AALA201705319017Lens · missingL2 DOOR EMERGENCY EXIT LIGHT LENS MISSING.SDR AALA201705319011Housing · detached24C EMERGENCY LIGHT HOUSING DETACHED. INSTALLED EMERGENCY LIGHT HOUSING AT 24C.SDR RAIA201705300001Lens · crackedSERVICE DOOR EMERGENCY LIGHT LENS CRACKED. R & R THE LENS. OPS CHECKED GOOD.SDR DALA2017053104394Light · inoperativeON SVC CK FOUND EXTERIOR EMERG LIGHTS INOP AT LT OVERWING, L4 AND R1 DOORS INOP.SDR DALA2017053104393Light · inoperativeBOTH EXTERNAL EMERGENCY LIGHTS OUT ABOVE ADF ANTENNA PLACARD RT SIDE. RELAMPED CKS GOOD REF AMM 33-51.SDR DALA2017053104392Light · inoperativeEXTERNAL EMERGENCY LIGHTS OUT BOTH AT LT SIDE AT TE FLAP. RELAMPED CKS GOOD REF AMM 33-51.SDR ASAA2017053020919Battery Pack · failedEMERGENCY EXIT LIGHTS ABOVE SEAT ROWS 1 - 11ABC FOUND INOPERATIVE. ACFT GROUNDED. REMOVED AND REPLACED THE BATTERY PACK, OPS NORMAL IAW AMM 33-51-06-960-805.SDR DALA2017053104389Battery · dischargedCEILING EMERGENCY LIGHTS OUT AT SEATS 16, 17, 18, 19, 20, 26, 27, 28, 29, AND 30. REPLACED BATTERIES AT POWER UNITS SN-22713 AND SN-27406. REFERENCE AMM 33-53-00-401. OPS CHECK OK. PN'S ON FOUR 41B004AD07G3 BATTERIES.SDR MASA3017053012338Sign · inoperativeEMERGENCY EXIT SIGNS WILL NOT STAY ON. RESET THE SYSTEM.SDR REXA2017053000639Light · inoperativeDURING LC-1 CHECK, FOUND CEILING EMERGENCY LIGHT INOPERATIVE AT ROW 10. REMOVED AND REPLACED CEILING EMERGENCY LIGHT ROW 10 BULB IAW AMM 33-51-16. OPS CHECKED GOOD.SDR DALA2017053104523Light · missingLENS FOR MID GALLEY EMER PATH LIGHT MISSING. INSTALLED LENS AT MID GALLEY EMER PATH LIGHT. OPS CHECK OK, REF AMM 33-50.SDR AALA201705309046Lens · missingMISSING LENS ON THE R1 DOOR EMERGENCY EXIT LIGHT. REPLACED R1 DOOR EMERGENCY EXIT LIGHT PER AMM 33-51-13.SDR ASOA201705291634Relay · brokenEMERGENCY LIGHTS COME ON WHEN IN THE ARM POSITION. REMOVED AND REPLACED THE RELAY K135 PCB5 (JB11) IAW ESPM 20-39-00, AND AMM 24-06-11, OPS CHECKED GOOD.SDR AALA201706029046Lens · missingAIRCRAFT NOT GROUNDED. PAX SEAT 1C ESCAPE PATH LIGHT MISSING. REPLACED MISSING COVER AT 1C.SDR AALA201705309058Sign · detachedEXIT SIGN COVER AT THE L4 DOOR FELL OFF. DOES NOT STAY IN PLACE. REMOVED AND REPLACED EXIT SIGN IAW AMM 33-51-01, OPS CHECKED OKAY.SDR ASOA201705295080Light · intermittentPILOT REPORTED EMERGENCY EXIT LIGHT NR 3 INOPERATIVE. MX PERFORMED OPERATIONAL CHECK, CHECKED GOOD. ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR SWAA2017060114096Lens · looseL1 DOOR EMERGENCY LIGHT LENS LOOSE. SECURED THE LENS IAW MM.SDR HALA2017053000183Light · unsecureMID GALLEY EMERGENCY LIGHTING SYSTEM ON THE FLOOR UNSECURE. SECURED THE LIGHT.SDR 29GA2017053100002Lamp · inoperativeEMERGENCY LIGHT IN GALLEY NOT SHOWING ARMED ON THE GROUND. REPLACED THE LAMP. OPERATIONAL CHECKED GOOD.SDR AALA201705319008Battery Pack · inoperativeFORWARD EMERGENCY EXIT SIGN AFT OF COCKPIT DOOR AND R1 DOOR IS INOPERATIVE. REMOVED AND REPLACED CHARGER ASSEMBLY AND EMERGENCY BATTERY IAW AMM 33-51-07. OPERATIONAL CHECKED GOOD.SDR AALA201705309056Battery Pack · inoperativeSEAT MOUNTED AND OVERHEAD AISLE EMERGENCY EXIT LIGHTS IN ROWS 11H THROUGH 31H ARE INOPERATIVE. REMOVED AND REPLACED BATTERY PACK AT ROW 24HJ IAW AMM 33-51-07. OPERATIONAL CHECKED GOOD.
Back to JASC 3350