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 CALA2017102703831Sign · looseEXIT SIGN, LEFT SIDE BY ROW 20 WILL NOT STAY UP. ADJUSTED THE EXIT SIGN BACK IN PLACE.SDR CALA2017102703830Sign · detachedSEAT 20ABC EMERGENCY EXIT SIGN DETACHED. SECURED THE SIGN.SDR CALA2017102703825Lamp · inoperativeL1 DOOR EXTERIOR EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE LAMP.SDR CALA2017102703822Light · brokenEMERGENCY LIGHT BROKEN AT SEAT 31C. REPLACED THE LIGHT ASSY, CHECKED GOOD.SDR CALA2017102703790Battery Pack · inoperativeEPSU 13WL BATTERY WILL NOT HOLD A CHARGE. REMOVED AND REPLACED THE BATTERY IAW AMM 33-51-38. PERFORMED AN OPS TEST IAW AMM 33-51-38-710-052-B. NO DEFECTS NOTED.SDR SWAA2017111517805Light · damagedFORWARD LAVATORY EMERGENCY LIGHT ASSEMBLY ON THE AFT WALL FOUND DAMAGED. R & R THE LIGHT ASSEMBLY IAW AMM.SDR SWAA2017111317713Light · damagedAFT LAV OUTBOARD EMERGENCY EXIT LIGHT DAMAGED. R&R LIGHT PER AMM.SDR AALA201711079005Battery Pack · dischargedAIRCRAFT WAS IN BASE MAINTENANCE. EMERGENCY EXIT LIGHTS BATTERY FAILED CAPACITY CHECK. REMOVED AND REPLACED POWER SUPPLY (AALA201711079003) AND BATTERY PACK. OPERATIONAL CHECK GOOD.SDR AALA201711079003Power Supply · inoperativeAIRCRAFT WAS IN BASE MAINTENANCE. EMERGENCY EXIT LIGHTS BATTERY FAILED CAPACITY CHECK. REMOVED AND REPLACED POWER SUPPLY AND BATTERY PACK (AALA201711079005). OPERATIONAL CHECK GOOD.SDR SIMA20171026002Light · inoperativePAX DOOR EMERGENCY LIGHT INOPERATIVE. R & R THE EMERGENCY LIGHT IAW AMM 33-50-10. OPS CHECKED GOOD.SDR AALA20171026004Light · brokenAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT PROXIMITY FLOODLIGHT AT THE G2 GALLEY IS BROKEN. REMOVED AND REPLACED LIGHT ASSEMBLY PER AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR UIEA2017103102144Light · inoperativeFUSELAGE EMERGENCY LIGHT IS INOP. REMOVED AND REPLACED FUSELAGE EMERGENCY LIGHT IAW AMM 33-51-00.SDR SWAA2017103017467Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1672. R&R BATTERY PER AMM.SDR SWAA2017103017466Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1675. R&R BATTERY PER AMM.SDR SWAA2017103017437Battery · no testEMERGENCY LIGHT BATTERY FAILED A CAPACITY TEST AT LOCATION M1669. R & R THE BATTERY PER AMM.SDR SIMA20171026001Battery Pack · dischargedEMERGENCY LIGHTS NR 2 AND 3 INOPERATIVE. CHARGED THE BATTERIES IAW AMM 33-50-00. OPS CHECKED GOODSDR AALA201710279039Lens · detachedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT NEXT TO THE FIRST CLASS FLIGHT ATTENDANT JUMPSEAT AND THE L1 DOOR HAS A DETACHED LENS COVER. REMOVED AND REPLACED LIGHT ASSEMBLY PER AMM 31-51-01. OPERATIONAL CHECK GOOD.SDR AALA201710279036Light · detachedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN BY THE FORWARD ENTRY DOOR LOWER WALL FELL OFF. REMOVED AND REPLACED LIGHT ASSEMBLY PER AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR SWAA2017102717413Lens · missingLT EMERGENCY AISLE BULLNOSE LIGHT LENS MISSING AT ROW 8. INSTALLED LENS PER MM.SDR AALA201710279023Lens · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY LIGHT COVER MISSING BY L38. REPLACED LENS COVER.SDR AALA201710279022Lens · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT COVER MISSING L74. REPLACED LENS COVER.SDR YENA201710260870Light · shortedDURING AN EMERGENCY LIGHTS SYSTEM TEST, THE FWD LEFT EPSU INDICATED AN INTERIOR & EXTERIOR LOAD FAULT. PERFORMED TSM 33-51-00-810-808-A, THE FWD LEFT SLIDE LIGHTS HAD SHORTED. REPLACED SLIDE EMERGENCY LIGHTS. SYS TESTED GOOD.SDR AALA201710279016Lens · missingR4 DOOR HAS A SMALL EXIT LENS MISSING. INSTALLED NEW EXIT LENS IAW AMM.SDR ASOA201710265166Light · brokenDURING SCHEDULED MX THE NR7 FLOOR EMERGENCY LIGHT PROX STRIP WAS FOUND BROKEN. MX REMOVED AND REPLACED THE NR7 LIGHT STRIP WITH OPERATIONAL CHECK GOOD. A/C WAS APPROVED FOR RETURN TO SERVICE.SDR MASA2017102612727Light · inoperative14A FLOOR LEVEL EXIT SIGN ONE BULB INOP.SDR MASA2017102612725Light · inoperativeROW 20 EMRG EXIT FLOOD LIGHT. PLACED ON MEL.SDR MASA2017102612724Battery Pack · dischargedALL EMERG LIGHTS INOP. CHARGED EMER LIGHTS BATTERY PACK. OPS TEST GOOD.SDR HALA2017102600263Light · inoperativeFOUND EMERGENCY EXIT LIGHT INOP ABOVE FLIGHT DECK DOOR. REPLACED EMERGENCY EXIT LIGHT ASSEMBLY PER AMM 33-51-01. TESTS OK.SDR SWAA2017110217486Lens · looseLT OVERHEAD BULL NOSE EMERGENCY LIGHT LENS LOOSE AT ROW 6. R&R LENS IAW AMM.SDR AALA201710279041Light · detachedAIRCRAFT WAS NOT GROUNDED. EMERGENCY ESCAPE PATH LIGHT ON BOTTOM OF SEAT 12D FELL OFF. REMOVED AND REPLACED LIGHT ASSEMBLY PER AMM 33-51-05. OPERATIONAL CHECK GOOD.SDR SWAA2017103017449Battery · failedBATTERY AT M1669 FAILED CAPACITY TEST. R&R BATTERY PER DWG.SDR SWAA2017103017446Battery Pack · failedEMERGENCY LIGHT BATTERY PACK FAILED CAPACITY CHECK AT LOCATION M01669. R&R BATTERY PACK PER AMM.SDR SWAA2017103017444Light · inoperativeRT EXTERIOR OVERWING EMERGENCY LIGHT INOP. RELAMPED LIGHT PER AMM.SDR SWAA2017103017443Light · inoperativeR2 EXTERIOR EMERGENCY LIGHT INOP. RELAMPED LIGHT PER AMM.SDR AALA20171025004Battery · dischargedAIRCRAFT WAS IN BASE MAINTENANCE. EMERGENCY EXIT LIGHTS BATTERY AND CHARGER M730 FAILED TEST. REMOVED AND REPLACED BATTERY ASSEMBLY AND CHARGER ASSEMBLY (AALA201710279002) PER AMM 33-51-07. OPERATIONAL CHECK GOOD.SDR AALA201710279038Ballast · inoperativeAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT BALLAST AT SEAT ROW 15 DEF RIGHT SIDE IS INOPERATIVE. REMOVED AND REPLACED BALLAST PER AMM 33-51-06. OPERATIONAL CHECK GOOD.SDR AALA201710279034Lens · detachedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN BY THE L2 DOOR HAS A DETACHED LENS COVER. REMOVED AND REPLACED EXIT SIGN LIGHT ASSEMBLY PER AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA201710279002Charger · failedAIRCRAFT WAS IN BASE MAINTENANCE. EMERGENCY EXIT LIGHTS BATTERY AND CHARGER M730 FAILED TEST. REMOVED AND REPLACED BATTERY ASSEMBLY (AALA20171025004) AND CHARGER ASSEMBLY PER AMM 33-51-07. OPERATIONAL CHECK GOOD.SDR AALA201710269023Light · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT IN THE FORWARD ENTRYWAY IS MISSING. REPLACED LIGHT ASSEMBLY PER AMM 33-51-02. OPERATIONAL CHECK GOOD.SDR AALA201710269007Power Supply · failedOPERATIONAL TEST OF EMERGENCY LIGHTS FAILED. REMOVED AND REPLACED EMERGENCY POWER SUPPLY UNIT.SDR SWAA2017102617394Lens · looseOVERWING EMERGENCY EXIT SIGN LENS LOOSE. SECURED LENS PER MM.SDR I5EA2017102503Battery Pack · dischargedLT ROW 6 THROUGH 9 EMERGENCY LIGHTS INOPERATIVE. REMOVED AND REPLACED BATTERY PACK AT STA. 634L, OPERATION TEST GOOD IAW AMM 33-51-51.SDR DALA2017102507782Battery Pack · dischargedBOTH AFT OVERWING EMERGENCY EXIT LIGHT INOP, INTERIOR. R&R EMER LIGHT BATTERY PACK AT STA 671R PER WDM 33-51-12, OPS CHECK GOOD.SDR DALA2017102507781Light · inoperativeROW 14 ABC OVERHEAD EMERGENCY LIGHT INOP, LT SIDE. RELAMPED EMERGENCY LIGHT AT ROW 14ABC PER WDM 33-51. A/C OK FOR SVC.SDR MASA2017102512720Bulb · inoperativeAFT GALLEY EMERGENCY SIGN BULB INOPERATIVE. REPLACED THE BULB.SDR SIMA20171024002Charger · inoperativeLAST 2 LT FLOOR PROXIMITY FLOOR LIGHTS WILL NOT ILLUMINATE WHEN EMERGENCY LIGHTS ARE ON. REMOVED AND REPLACED NR 4 EMERGENCY LIGHT BATTERY HOLDER AND CHARGER IAW AMM 33-50-04.SDR SIMA20171024001Charger · inoperativeNR 4 AND NR 5 FLOOR EMERGENCY LIGHT STRIPS INOP. REMOVED AND REPLACED NR 3 BATTERY HOLDER AND BATTERY CHARGER ASSEMBLY IAW AMM 33-50-04.SDR SWAA2017110217500Lens · crackedRT CEILING EMERGENCY LIGHT LENS CRACKED AT ROW 14. R&R LENS IAW AMM.SDR SWAA2017110217477Lens · crackedLT CEILING EMERGENCY LIGHT LENS CRACKED AT BETWEEN ROW 9 TO ROW 12. R&R LENS IAW AMM.SDR SWAA2017103017435Battery Pack · no testBATTERY PACK M1670 FAILED A CAPACITY CHECK. R & R THE BATTERY PACK IAW AMM.
Back to JASC 3350