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 AALA201701109018Housing · dislodgedEMERGENCY LIGHT HOUSING ON SEAT 17C DISLODGED AND NOT SECURE TO SEAT. REPLACED HOUSING IAW AMM 33-51-04.SDR AALA201701109017Housing · dislodgedEMERGENCY LIGHT HOUSING ON SEAT 12C DISLODGED AND NOT SECURE TO SEAT. REPLACED HOUSING IAW AMM 33-51-04.SDR AALA201701109016Housing · dislodgedEMERGENCY LIGHT HOUSING ON SEAT 11C DISLODGED AND NOT SECURE TO SEAT. REPLACED HOUSING IAW AMM 33-51-04.SDR AALA201701109014Housing · dislodgedEMERGENCY LIGHT HOUSING ON SEAT 10C IS DISLODGED AND NOT SECURE TO SEAT. REPLACED HOUSING IAW AMM 33-51-04.SDR SIMA20170109003Light · inoperativeDURING PS-1 FOUND NR 2 LT EXTERIOR EMERGENCY LIGHT INOP. R&R BULB IAW AMM 33-51-15 DID NOT FIX REF LGPG 4124628 / 1 FOR DEFERRAL. REMOVED AND REPLACED LEFT HAND WING OVER EXTERIOR EMERGENCY LIGHT IAW AMM 33-51-15. OPS CHECK GOOD. EXTERNAL EMERGENCY LIGHT P/N SDR REXA2017010900021Battery · dischargedEMERGENCY EXIT LIGHT AT ROW 5CD IS INOP. REMOVED AND REPLACED THE NR 2 EMERGENCY BATTERY PER THE AMM 33-51-17. OPERATIONAL CHECK GOOD.SDR AALA20170111031Lens · looseEMERGENCY EXIT SIGN HAS A LOOSE LENS COVER. REMOVED AND REPLACED LENS COVER IAW AMM 25-20-08. OPS CHECKED GOOD.SDR AALA20170110002Light · inoperativeAIRCRAFT NOT GROUNDED. SEAT MOUNTED EMERGENCY ESCAPE PATH RED LIGHT AT SEAT 20D IS INOPERATIVE. REPAIRED IAW AMM 33-60-98. OPERATIONAL CHECK GOOD.SDR AALA20170111028Light · inoperativeAIRCRAFT NOT GROUNDED. EMERGENCY EXIT LIGHT AT SEAT 19D IS INOPERATIVE. REMOVED AND REPLACED LIGHT ASSEMBLY IAW AMM 33-60-98. OPERATIONAL CHECK GOOD.SDR SWAA2017011111097Cover · brokenR1 DOOR EMERGENCY EXIT LIGHT COVER BROKEN. R&R LIGHT ASSEMBLY IAW AMM.SDR AALA201701109013Lens · missingAIRCRAFT WAS NOT GROUNDED. MISSING EMERGENCY EXIT LIGHT COVER AT 2L DOOR. MAINTENANCE REPLACED LIGHT LENS AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201701109010Cover · missingAIRCRAFT WAS NOT GROUNDED. MISSING EMERGENCY EXIT DOOR LIGHT COVER AT DOOR 4L. REPLACED LIGHT COVER AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR SWAA2017011011079Lens · brokenR1 DOOR EMERGENCY EXIT LIGHT LENS BROKEN. R&R LIGHT ASSEMBLY IAW AMM.SDR SWAA2017011011064Lens · crackedLT OVERHEAD BIN EMERGENCY LIGHT LENS COVER CRACKED AT ROW 12. R&R COVER PER AMM.SDR CALA2017010900038Light · dimAFT CREW REST CEILING EMERGENCY LT FOUND LOW VOLTAGE (P/N:S1356B37) REPLACED AFT CREW REST CEILING EMERGENCY LT AND C/O OP CHECK, FOUND ''NORMAL'' REF TO AMM 33-51-07 & AMM 33-51-00 REV.182SDR CALA2017010900058Power Supply · faultyEMERGENCY EXIT LIGHT BATTERIES FAIL CAPACITY TEST AT L FWD, LEFT OVERWING AND AFT DOOR. REPLACED EMERGENCY BATTERIES AT POSITION FWD, LEFT, AND AFT AND AFT POWER SUPPLY PER AMM 33-51-38. TEST PASSED.SDR CALA2017010900057Battery · failedEMERGENCY POWER SUPPLY 13WL BATTERY FAILED OPS CK. REPLACED BATTERY REF AMM,33-51-38-000-002 OPS CK GOOD.SDR CALA2017010900056Battery · dischargedEMER LIGHTS IN CABIN FLICKERING ON/OFF DURING TAXI OUT. CEASED PRIOR TO TAKEOFF FOUND CIDS MESSAGE EPSU UNIT FWD L. REPLACED EPSU BATTERY PER AM M 33-51-38. OPS CHECK OK AND MESSAGE CLEARED.SDR CALA2017010900055Power Supply · faultyBATTERY EMERG POWER SUPPLY FOUND INOP AT FWD LT CABIN. REPLACED BATTERY EMERG POWER SUPPLY LT FWD IAW AMM 33-51-38-000- 002A AND 33-51-38-400-002A, OPS CK GOOD.SDR CALA2017010900054Light · inoperativeLEFT OVERWING AFT EMERGENCY LIGHT INOP. RELAMPED LEFT OVERWING AFT EMERGENCY LIGHT REF AMM 33-51-04-960- 801. OPS CHECK GOOD.SDR CALA2017010900053Battery Pack · dischargedEMERGENCY EXIT ROW INTERIOR LOWER LIGHTS NOT WORKING. REMOVED AND REPLACED BATTERY PACK IN THE RT CARPET SIDE WALL CARPET RISER AREA IAW MM 33-51-06. OPS CK GOOD.SDR CALA2017010900051Fuse · blownEXTERIOR EMERGENCY LIGHTS (LT SIDE) L1, L2 AND OVERWING INOP. RELAMPED BULBS FOR EXTERIOR EMERGENCY LIGHTS AT L1, L2 AND OVERWING AS PER AMM 33-51-06. TROUBLESHOT AND FOUND BURNT FUSE AT POWER SUPPLY. REMOVED AND REPLACED FUSE WORK PERFORMED PER WDM 33-51-21, SDR CALA2017010900050Light · intermittentEMERGENCY EXIT LIGHTS ARE FLICKERING ON AND OFF WITH SWITCH IN ARMED POSITION. ACCOMPLISHED EMERGENCY LIGHT TEST REF MM33-51-00, NO FAULTS FOUNDSDR CALA2017010900049Light · malfunctionedEMERGENCY EXIT SIGN DOES NOT TURN OFF ALL CABIN EMER LITES CAME ON 10 MIN INTO FLT. RESET BY CYCLE O/H SWITCH OPERATED EMERGENCY LIGHTS AND FOUND THEM OPERATING NORMAL SUSPECT LIGHTS TURNED ON BY ACCIDENT AT ONE OF DOORS SWITCHES DURING FLIGHT.SDR CALA2017010900047Light · malfunctionedEMER LIGHTS CAME ON IN FLT WITH NONE OF THE SWITCHES IN THE ON POSITION. GROUND TEST EMER LIGHTS NORMAL REF TO AMM33-51-00-710-803.SDR CALA2017010900052Light · inoperativeBOTH BULBS BURNED OUT ON EMERGENCY LIGHTS DISARMED LIGHT. RELAMPED OPS CK OK.SDR MASA2017010912800Light · inoperativeROW 21 CEILING LEVEL EMERGENCY FLOOD LIGHT INOPERATIVE.SDR HNAA2017010900012Power Supply · inoperativeDURING AN OPS CHECK, EMERGENCY EXIT LIGHTS AT AIRSTAIR DOOR WILL NOT ILLUMINATED. REMOVED AND REPLACED THE POWER SUPPLY. OPS CHECKED GOOD IAW 33-50-03Q.SDR HNAA2017010900011Battery Pack · inoperativeEMERGENCY LIGHTS, WOULD NOT GO OUT. REMOVED AND REPLACED EMERGENCY LIGHT BATTERY PACKS . OPS CHECKED GOOD IAW 35-50-03Q.SDR SWAA2017012311382Lens · looseRIGHT SIDEWALL PANEL 232YHW, EMERGENCY LIGHT LENS LOOSE. R & R THE LENS IAW AMM.SDR SIMA20170108004Light · crackedFLOOR PROXIMITY LIGHT NR 1 IS CRACKED. REMOVED & REPLACED THE LIGHT IAW AMM 33-50-12.SDR SWAA2017011611190Light · inoperativeLT OVERHEAD BIN EMERGENCY LIGHT INOP AT ROW 6. RELAMPED LIGHT PER AMM.SDR SWAA2017011611189Light · inoperativeRT OVERHEAD BIN EMERGENCY LIGHT INOP AT ROW 8. RELAMPED LIGHT PER AMM.SDR SWAA2017011611188Light · inoperativeRT OVERHEAD BIN EMERGENCY LIGHT INOP AT ROW 7. RELAMPED LIGHT PER AMM.SDR AALA20170111017Sign · unsecureAIRCRAFT WAS GROUNDED. OVERHEAD EMERGENCY EXIT SIGN BY L3 DOOR IS FALLING OFF. SECURED LIGHT ASSEMBLY IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20170111016Bracket · missingAIRCRAFT WAS GROUNDED. SEAT-MOUNTED EMERGENCY EXIT LIGHT AND MOUNTING BRACKET AT SEAT 11C ARE MISSING. INSTALLED EXIT LIGHT ASSEMBLY (AALA20170111015) AND BRACKET IAW AMM 33-51-00. OPERATIONAL CHECK GOOD.SDR AALA20170111015Light · missingAIRCRAFT WAS GROUNDED. SEAT-MOUNTED EMERGENCY EXIT LIGHT AND MOUNTING BRACKET AT SEAT 11C ARE MISSING. INSTALLED EXIT LIGHT ASSEMBLY AND BRACKET (AALA20170111016) IAW AMM 33-51-00. OPERATIONAL CHECK GOOD.SDR AALA20170111009Sign · brokenAIRCRAFT NOT GROUNDED. EMERGENCY EXIT SIGN NEAR AFT ENTRY DOOR IS BROKEN. REMOVED AND REPLACED EXIT SIGN IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20170111003Bracket · defectiveAIRCRAFT WAS GROUNDED. EMERGENCY EXIT SIGN AT L3 DOOR DETACHED FROM MOUNT. REMOVED AND REPLACED EXIT SIGN BRACKET IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20170111002Sign · detachedAIRCRAFT NOT GROUNDED. EMERGENCY EXIT SIGN ROW 24 AISLE IS DETACHED FROM CEILING. RESECURED EXIT SIGN IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20170109002Light · brokenAIRCRAFT NOT GROUNDED. EMERGENCY EXIT IDENTIFIER LIGHT AT L2 DOOR IS BROKEN. REMOVED AND REPLACED LIGHT ASSEMBLY IAW 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20170109001Light · brokenAIRCRAFT NOT GROUNDED. EMERGENCY EXIT IDENTIFIER LIGHT AT R2 DOOR IS BROKEN. REMOVED AND REPLACED LIGHT ASSEMBLY IAW 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20170108012Light · detachedAIRCRAFT NOT GROUNDED. EMERGENCY EXIT FLOOR PROXIMITY LIGHT BY L1 DOOR IS DETACHED. REMOVED AND REPLACED LIGHT ASSEMBLY IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA201701099001Light · unsecureAIRCRAFT WAS NOT GROUNDED. SEAT 12C EMERGENCY FLOOR LIGHT HANGING LOOSE. MAINTENANCE REPLACED LIGHT ASSEMBLY PER AMM 33-50-00.SDR SWAA2017011011074Lens · brokenL1 DOOR LOWER EMERGENCY EXIT LENS BROKEN. R&R LENS PER MM.SDR SWAA2017011011069Lens · looseRT OVERWING EXIT SIGN COVER LENS LOOSE. SECURED LENS IAW SIP.SDR ASAA2017010819276Lens · detachedL1 DOOR EMERGENCY LIGHT LENS CAME OFF. ACFT GROUNDED. INSTALLED NEW LENS. OK FOR SERVICE.SDR SWAA2017010911038Lens · brokenFORWARD EMERGENCY EXIT SIGN LENS MOUNT TAB BROKEN. R&R LENS PER SIP.SDR SWAA2017010911029Lens · brokenL1 LOWER GALLEY EMERGENCY EXIT LIGHT LENS ASSEMBLY BROKEN. R&R LENS ASSEMBLY PER MM.SDR SWAA2017010911027Light · inoperativeFORWARD RT SIDE EMERGENCY LIGHT INOP. RELAMPED LIGHT IAW AMM.
Back to JASC 3350