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 UIEA2017021700196Lamp · inoperativePASSENGER CABIN DOOR EMERGENCY LIGHT INOPERATIVE AT DOOR 2L, 2R, AND 39JL. TROUBLESHOT, AND REPLACED THE LAMPS. OPS CHECKED GOOD IAW WDM 33-51-12.SDR VNAA2017071000004Light · inoperativeCABIN FLOOR LEVEL EMERGENCY FLOODLIGHTS INOPERABLE. REMOVED AND REPLACED EMERGENCY FLOODLIGHTS.SDR SIMA20170216003Bulb · inoperativeLT AFT OVERWING EMRGENCY LIGHT IS INOPERATIVE. REMOVED AND REPLACED THE BULB IAW AMM 33-50-10. OP CHECKED GOOD IAW AMM 33-50-00.SDR SWAA2017022312028Lens · crackedRT OVERHEAD BIN BULLNOSE EMERGENCY LIGHT LENS CRACKED AT ROW 6. R&R LENS PER SIP.SDR SWAA2017022312027Lens · crackedLT OVERHEAD BIN BULLNOSE EMERGENCY LIGHT LENS CRACKED AT ROW 8. R&R LENS PER SIP.SDR SWAA2017022311921Lens · crackedRT OVERHEAD BIN BULLNOSE EMERGENCY LIGHT LENS CRACKED AT ROW 14. R&R LENS PER SIP.SDR SWAA2017022212026Lens · crackedLT OVERHEAD BIN BULLNOSE EMERGENCY LIGHT LENS CRACKED AT ROW 5. R&R LENS PER SIP.SDR SWAA2017022212024Battery Pack · failedEMERGENCY LIGHTING BATTERY PACK FAILED CAPACITY TEST AT LOCATION M01672. R&R BATTERY PACK PER AMM & DWG.SDR SWAA2017022212023Battery Pack · failedEMERGENCY LIGHTING BATTERY PACK FAILED CAPACITY TEST AT LOCATION M01670. R&R BATTERY PACK PER AMM & DWG.SDR SWAA2017022211973Sign · inoperativeL1 DOOR FORWARD EMERGENCY EXIT SIGN INOPERATIVE. R& R THE SIGN IAW AMM.SDR SWAA2017022211972Battery Pack · no testLEFT EMERGENCY LIGHT AFT BATTERY PACK FAILED CAPACITY CHECK. R & R THE BATTERY PACK IAW MM.SDR SWAA2017022211970Sign · brokenL1 DOOR LOWER EMERGENCY EXIT SIGN BROKEN. R & R THE SIGN IAW AMM.SDR SWAA2017022211949Lamp · inoperativeLEFT OVERWING EXIT LIGHT INOPERATIVE AT ROW 11. REPLACED THE LAMPS IAW AMM.SDR SWAA2017022211942Battery Pack · no testEMERGENCY LIGHT BATTERY PACK FAILED THE CAPACITY TEST. R & R THE BATTERY PACK IAW AMM & DWG.SDR AALA20170220024Module · inoperativeAIRCRAFT WAS GROUNDED. EMERGENCY EXIT LIGHTS INOPERATIVE ON ALL DOORS AND ALL SEATS IN FIRST CLASS AND COACH. REMOVED AND REPLACED FOUR BATTERY PACKS AND THREE CONTROL MODULES AT M10798, M10799, M10800 AND M10801 IAW AMM 33-51-07. OPERATIONAL CHECK GOOD. REF: SDR AALA20170220023Module · inoperativeAIRCRAFT WAS GROUNDED. EMERGENCY EXIT LIGHTS INOPERATIVE ON ALL DOORS AND ALL SEATS IN FIRST CLASS AND COACH. REMOVED AND REPLACED FOUR BATTERY PACKS AND THREE CONTROL MODULES AT M10798, M10799, M10800 AND M10801 IAW AMM 33-51-07. OPERATIONAL CHECK GOOD. REF: SDR AALA20170220022Module · inoperativeAIRCRAFT WAS GROUNDED. EMERGENCY EXIT LIGHTS INOPERATIVE ON ALL DOORS AND ALL SEATS IN FIRST CLASS AND COACH. REMOVED AND REPLACED FOUR BATTERY PACKS AND THREE CONTROL MODULES AT M10798, M10799, M10800 AND M10801 IAW AMM 33-51-07. OPERATIONAL CHECK GOOD. REF: SDR AALA20170220021Battery Pack · dischargedAIRCRAFT WAS GROUNDED. EMERGENCY EXIT LIGHTS INOPERATIVE ON ALL DOORS AND ALL SEATS IN FIRST CLASS AND COACH. REMOVED AND REPLACED FOUR BATTERY PACKS AND THREE CONTROL MODULES AT M10798, M10799, M10800 AND M10801 IAW AMM 33-51-07. OPERATIONAL CHECK GOOD. REF: SDR AALA20170220020Battery Pack · dischargedAIRCRAFT WAS GROUNDED. EMERGENCY EXIT LIGHTS INOPERATIVE ON ALL DOORS AND ALL SEATS IN FIRST CLASS AND COACH. REMOVED AND REPLACED FOUR BATTERY PACKS AND THREE CONTROL MODULES AT M10798, M10799, M10800 AND M10801 IAW AMM 33-51-07. OPERATIONAL CHECK GOOD. REF: SDR AALA20170220019Battery Pack · dischargedAIRCRAFT WAS GROUNDED. EMERGENCY EXIT LIGHTS INOPERATIVE ON ALL DOORS AND ALL SEATS IN FIRST CLASS AND COACH. REMOVED AND REPLACED FOUR BATTERY PACKS AND THREE CONTROL MODULES AT M10798, M10799, M10800 AND M10801 IAW AMM 33-51-07. OPERATIONAL CHECK GOOD. REF: SDR AALA20170220018Battery Pack · dischargedAIRCRAFT WAS GROUNDED. EMERGENCY EXIT LIGHTS INOPERATIVE ON ALL DOORS AND ALL SEATS IN FIRST CLASS AND COACH. REMOVED AND REPLACED FOUR BATTERY PACKS AND THREE CONTROL MODULES AT M10798, M10799, M10800 AND M10801 IAW AMM 33-51-07. OPERATIONAL CHECK GOOD. REF: SDR AALA20170220016Lens · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT FLOODLIGHT L9005 AT FORWARD GALLEY WALL HAS A MISSING LENS COVER. REPLACED LENS COVER IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20170217019Light · brokenAIRCRAFT WAS NOT GROUNDED. SEAT MOUNTED ESCAPE PATH LIGHT AT SEAT 20J HAS BROKEN TABS. REMOVED AND REPLACED LIGHT ASSEMBLY L793 IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20170217017Lens · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT AT L1 DOOR HAS A MISSING LENS COVER. ITEM DEFERRED. REPLACED EXIT LIGHT ASSEMBLY IAW AMM 33-51-02. OPERATIONAL CHECK GOOD.SDR AALA20170217014Lens · looseAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT IN THE FORWARD GALLEY AISLE HAS A LOOSE LENS COVER. REMOVED AND REPLACED LIGHT ASSEMBLY IAW AMM 33-51-14. OPERATIONAL CHECK GOOD.SDR DALA2017021700030Battery Pack · no testDURING EPSU BATTERY CAPACITY CHECK, THE BATTERY PACKS FAILED. REPLACED THE BATTERY PACKS.SDR CALA2017021700371Battery · malfunctionedL3 DOOR: EXIT SIGN FOUND DIM. THE BATTERY PACK & CHARGER WERE REPLACED. OPS TESTED NORMAL IAW AMM 33-51-06.SDR CALA2017021700370Battery Pack · no testEMERGENCY LIGHT FAILED OPS TEST. TROUBLESHOOTING FOUND BATTERY PACK EQ M1208 CANNOT CHARGE. THE BATTERY PACK WAS REPLACED AND OPS CHECKED NORMAL IAW AMM 33-51-07.SDR CALA2017021700369Battery Pack · no testEMERGENCY LIGHT FAILED OPS TEST, TROUBLESHOOTING FOUND BATTERY PACK EQ M1208 CANNOT CHARGE. BATTERY PACK REPLACED AND OPS CHECKED NORMAL IAW AMM 33-51-07.SDR CALA2017021700368Battery Pack · no testEMERGENCY LIGHT OP TEST TROUBLESHOOTING FOUND BATTERY PACK EQ M1210 CANNOT CHARGE. THE BATTERY PACK WAS REPLACED AND OP TEST RESULT NORMAL AS PER AMM 33-51-07.SDR CALA2017021700367Light · no testSEATS 25DEF AND 40DEF EMERGENCY LIGHT INOPERATIVE. THE EMERGENCY LIGHT WAS REPLACED AND INSTALLATION TEST NORMAL IAW AMM 33-51-10.SDR AALA20170217016Lens · missingAISLE EMERGENCY EXIT LIGHT HAS A MISSING LENS COVER. INSTALLED THE LENS IAW AMM 25-63-00. OPS CHECKED GOOD.SDR AALA20170217013Battery · inoperativeFLIGHT ATTENDANT EMERGENCY FLASHLIGHT AT CENTER JUMPSEAT IN GALLEY 4 IS INOPERATIVE. REMOVED AND REPLACED THE BATTERY IAW AMM 25-64-01. OPS CHECKED GOOD.SDR AALA20170217012Battery Pack · no testEMERGENCY POWER SUPPLY UNIT BATTERY FAILED CIDS TEST. REMOVED AND REPLACED THE BATTERY PACK IAW 33-51-38. OPS CHECKED GOOD.SDR AALA20170217006Charger · failedEMERGENCY EXIT LIGHTS LEFT AFT COACH ARE INOPERATIVE. REMOVED AND REPLACED BATTERY ASSEMBLY M733 IAW AMM 33-51-07 AND CHARGER IAW AMM 33-51-07. OPS CHECKED GOOD.SDR AALA20170216020Battery Pack · failedEMERGENCY EXIT LIGHTS LEFT AFT COACH ARE INOPERATIVE. REMOVED AND REPLACED BATTERY PACK ASSEMBLY M733 IAW AMM 33-51-07 AND CHARGER IAW AMM 33-51-07. OPS CHECKED GOOD.SDR DALA2017021701350Light · disconnectedEMERGENCY FLOOR LIGHTING DAMAGED OR INOPERATIVE / LOCATIONS:203. FOUND EMERGENCY LIGHT DISCONNECTED RECONNECTED SAME OPS CHECK GOOD OK FOR SVC.SDR IPXA2017021614108Lamp · inoperativeLAVATORY EMERGENCY EXIT LIGHT IS BURNED OUT. REPLACED THE LAMP IAW MM 33-51-21.SDR REXA2017021600245Battery Pack · dischargedEMERGENCY LIGHTS WILL NOT TURN ON. TRIED FROM FLIGHT DECK AND FA STATION. CHARGED THE BATTERY PACKS , AND OPS CHECKED GOOD IAW AMM 33-51-00.SDR AALA201702179003Lens · missingEXIT LIGHT LENS AT THE R4 DOOR FOUND MISSING. SECURED THE LENS.SDR AALA201702179001Lens · looseEXIT LIGHT COVER NEAR THE L1 DOOR CAME LOOSE. INSTALLED A NEW LENS.SDR MASA2017021612610Light · inoperative18 D/F AISLE EMER LIGHT INOP. PLACED ON MEL.SDR JJBA20170216011Battery · dischargedEMERGENCY LIGHTS INOPERATIVE. R&R PS1 AND PS2 EMERGENCY BATTERIES OPS CHECK SAT.SDR SWAA2017022212008Spring · brokenAFT EMERGENCY EXIT LIGHT COVER SPRING BROKEN. R & R THE SPRING CMM.SDR SWAA2017022212003Battery Pack · inoperativeL1 DOOR EXTERIOR EMERGENCY LIGHT AFT INOPERATIVE. R & R BATTERY PACK IAW WDM.SDR SWAA2017022211999Battery Pack · no testEMERGENCY LIGHT BATTERY PACK FAILED A CAPACITY TEST AT LOCATION M1668. R & R THE BATTERY PACK IAW AMM AND DWG.SDR SWAA2017022211969Fuse · inoperativeLEFT OVERWING AFT EMERGENCY EXIT SIDEWALL LIGHT INOPERATIVE. R & R FUSE IAW MM.SDR SWAA2017022211940Lamp · inoperativeLEFT OVERWING EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMP IAW AMM.SDR SWAA2017022211939Lamp · inoperativeRIGHT OVERWING EMERGENCY EXTERIOR LIGHT INOPERATIVE. REPLACED THE LAMP IAW MM.SDR DALA2017021701432Power Supply · inoperativeEMERGENCY LIGHT FROM ROW 32 BACK REMAIN ON IN ARM POSITION. FOUND BAD POWER SUPPLY FOR LIGHTS. REPLACED BATTERY AND POWER SUPPLY B5-237 PER MM.
Back to JASC 3350