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 SWAA2018021919854Battery Pack · no testEMERGENCY LIGHT BATTERY PACK FAILED A CAPACITY CHECK AT M01670. R & R THE BATTERY PACK IAW AMM.SDR SWAA2018021919853Battery Pack · no testEMERGENCY LIGHT BATTERY PACK FAILED A CAPACITY CHECK AT M01669. R & R THE BATTERY PACK IAW AMM.SDR SWAA2018021919852Battery Pack · no testEMERGENCY LIGHT BATTERY PACK FAILED A CAPACITY CHECK AT M01668. R & R THE BATTERY PACK IAW AMM.SDR SWAA2018021919832Lamp · inoperativeR1 DOOR EXTERIOR EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS IAW MM.SDR SWAA2018021919826Battery Pack · no testEMERGENCY LIGHT BATTERY PACK FAILED A CAPACITY CHECK AT M01672. R & R THE BATTERY PACK IAW AMM.SDR AALA201802199069Bracket · brokenEMERGENCY LIGHT BROKEN OFF, UNDER SEAT 9D. MAINTENANCE REPLACED THE MOUNTING BRACKET AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201802199034Battery · dischargedFLASHLIGHT LED NOT FLASHING AFT FLIGHT ATTENDANT SEAT. REPLACED FLASHLITE BATTERY. OPERATIONS CHECK NORMAL PER MM 25-60-00SDR UIEA2018021500226Light · inoperativeEMERGENCY LIGHT INOPERATIVE AT ROW 12D. REMOVED AND REPLACED THE EMERGENCY LIGHT ASSY IAW AMM 33-51-10. OPS CHECKED NORMAL.SDR DALA2018021600960Contact · damagedDURING INSPECTION, FOUND THE LEFT OVERWING EMERGENCY LIGHT INOPERATIVE. MAINTENANCE INSTALLED A NEW CONTACT AND BULB. OPS CHECKED GOOD IAW AMM 33-50.SDR DALA2018021500956Fuse · failedDURING INSPECTION, FOUND THE RT AFT OVERWING EMERGENCY LIGHT INOPERATIVE. MAINTENANCE REPLACED THE FUSE IAW AMM 33-51.SDR DALA2018021500948Light · detachedFA REPORTED THE EMERGENCY LIGHT AT SEAT 40D HANGING LOOSE. REPLACED THE EMERGENCY LIGHT HOUSING IAW AMM 33-51.SDR IPXA2018021626571Bulb · inoperativeEMERGENCY LIGHT HAS FOUR BULBS INOPERATIVE. REPLACED THE BULBS IAW AMM 33-51-01-2.SDR HALA2018021600044Battery Pack · inoperativeR1, EMERGENCY LIGHTS INOPERATIVE. EXTERIOR EMERGENCY LIGHTING SYSTEM . REMOVED AND REPLACED THE RT OVERWING EMERGENCY LIGHT BATTERY PACK IAW 33-51-09 OPS CHECKED GOOD.SDR MASA2018021512983Lamp · inoperativeROW 5 CEILING EMERGENCY FLOOD LIGHT INOPERATIVE. REPLACED THE LAMPS.SDR DALA2018021600944Bulb · burned outLLCR EMERGENCY LIGHTS THE BULBS ARE BURNED OUT. REPLACED THE BULBS, SYSTEM OPERATION IS NORMAL.SDR SIMA20180215003Bulb · inoperativeCEILING AISLE EMERGENCY LIGHT NR 4 INOPERATIVE. REMOVED AND REPLACED THE BULB IAW AMM 33-50-08. OPS CHECKED OK.SDR SIMA20180215002Connector · disconnectedLEFT OVERWING EMERGENCY EXIT SIGN INOPERATIVE. FOUND THE ELECTRICAL CONNECTOR DISCONNECTED. CONNECTED AND SECURED THE CONNECTOR IAW AMM 33-50-14. OPS CHECKED OK.SDR SIMA20180215005Battery Pack · inoperativeSEVERAL EMERGENCY LIGHTS FOUND INOPERATIVE, LT AND RT EXTERNAL OVERWING. REMOVED AND REPLACED THE NR 4 BATTERY, PERFOMED AN OPS CHECK IAW 33-700-17. OPS CHECKED GOOD.SDR DALA2018021500938Light · inoperativeCEILING EXIT SIGN INOP AT 26 ABC-DEF. RELAMPED EXIT SIGN AT 26ABC-DEF CEILING REF AMM 33-51. CKS OK.SDR DALA2018021500932Light · inoperativeCOCKPIT OVERHEAD AND FIRST CLASS OVERHEAD EMERGENCY LIGHTS INOP. RE LAMPED IAW MM 33-50 AND ALL LIGHTS OPS CHECK GOOD.SDR DALA2018021500930Battery · dischargedFWD GALLEY EMERGENCY LIGHTS INOP. R&R BATTERIES IN FORWARD GALLEY LOC B5-23 PER AMM 33-53 OP CKS GOOD OK FOR SVC.SDR DALA2018021500906Lamp · inoperativeDURING A SERVICE CHECK, FOUND THE TAIL CONE EMERGENCY LIGHT INOPERATIVE. TROUBLESHOT THE EMERGENCY LIGHT IAW AMM 33-51. CLEANED AND REPLACED THE LAMPS. OPS CHECKED GOOD.SDR SWAA2018030620239Lens · crackedLEFT OVERHEAD BIN EMERGENCY LIGHT LENS CRACKED AT ROW 14. R & R THE LENS IAW AMM.SDR AALA20180215006Light · missingL1 HANDLE ILLUMINATION EMERGENCY LIGHT MISSING. REPLACED LIGHT ASSY.SDR SWAA2018022019868Lens · crackedLT EMERGENCY LIGHT LENS COVER CRACKED BETWEEN ROW 8 TO ROW 15. R&R COVER IAW AMM.SDR AALA20180214009Power Supply · defectiveR4 DOOR EMERGENCY LIGHT POWER SUPPLY WAS FOUND DEFECTIVE. REMOVED AND REPLACED THE POWER SUPPLY IAW AMM 33-51-06. OPS CHECKED NORMAL.SDR SWAA2018021919858Battery Pack · no testBATTERY PACK M1669 FAILED AN EMERGENCY LIGHT CAPACITY CHECK. R & R THE BATTERY PACK IAW AMM.SDR SWAA2018021919829Battery Pack · no testBATTERY PACK M1672 FAILED EMERGENCY LIGHT CAPACITY CHECK. R & R THE BATTERY PACK IAW AMM.SDR SWAA2018021919816Lamp · inoperativeRIGHT EMERGENCY EXIT WINDOW LIGHT INOPERATIVE. REPLACED THE LAMPS IAW AMM.SDR SWAA2018021919814Lamp · inoperativeL1 DOOR EXTERNAL EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS IAW AMM.SDR SWAA2018021919797Lamp · inoperativeRIGHT FORWARD OUTSIDE EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS IAW AMM.SDR AALA20180215007Light · inoperativeL4 DOOR HANDLE EMERGENCY LIGHT INOPERATIVE, CHECKED AND REPLACED THE LIGHT ASSY IAW AMM 33-51-01, OPS CHECKED OK.SDR AALA20180215004Light · crackedSEAT 7A EMERGENCY LIGHT CRACKED. REMOVED AND REPLACED THE EMERGENCY LIGHT ASSY AND TESTED IAW AMM 33-60-98.SDR AALA20180214001Light · inoperativeSEAT38B MOUNTED EMERGENCY LIGHT INOPERATIVE. MAINTNENANCE REPLACED THE EMERGENCY LIGHT ASSEMBLY IAW AMM 33-51-10 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201802199022Sign · damagedEXIT SIGN AT AFT GALLEY RT SIDE IS DAMAGED. REPLACED THE SIGN ASSEMBLY IAW AMM 33-51-01 . OPS CHECKED OK.SDR AALA201802199021Sign · damagedEXIT SIGN AT THE LEFT AFT OVERWING EXIT DOOR, DAMAGED. REPLACED THE SIGN ASSEMBLY IAW AMM 33-51-01 . OPS CHECKED OK.SDR AALA201802199019Lens · missingSEAT 10G EMERGENCY LIGHT LENS MISSING. REPLACED THE SIGN IAW AMM 33-51-01. OK FOR SERVICE.SDR AALA201802199018Lens · missingCREW FOUND THE EMERGENCY LIGHT LENS MISSING AT THE R2 DOOR. REPLACED THE LENS IAW AMM 33-51-01. OK FOR SERVICE.SDR AALA201802199017Light · inoperativeSEAT 38B MOUNTED EMERGENCY LIGHT INOPERATIVE. REPLACED THE EMERGENCY LIGHT ASSY IAW AMM 33-51-10, OPS OK.SDR DALA2018021500978Light · inoperativeEMERGENCY LIGHT INOPERATIVE AT SEAT 20 DEF. REPLACED THE LIGHT.SDR CALA2018021600614Bulb · inoperativeDURING AN A CHECK, FOUND SEAT 34D, 11D, AND 47D EMERGENCY LIGHTS INOPERATIVE. REPLACED THE BULBS.SDR AALA201802159042Lens · missingMAIN ENTRY DOOR EMERGENCY LIGHT LENS MISSING. MAINTNENANCE REPLACED THE LENS AND PERFORMED A SATISFACTORY OPERATIONAL CHECK IAW AMM 33-50-00.SDR AALA201802159022Lens · missingSEAT 25C MOUNTED EMERGENCY EXIT LIGHT LENS MISSING. REPLACED LIGHT LENS.SDR HALA2018021500043Sign · malfunctionedEXIT SIGN AT DOOR 3L WAS STROBING, NOW IT'S ORANGE. RESET CIDS AMM 23-35-00, OPS CHECK GOOD OK FOR SERVICE.SDR HALA2018021500030Sign · malfunctionedEXIT SIGN AT DOOR 3L WAS STROBING AND NOW IS ORANGE. RESET CIDS PER AMM 23-35-00.SDR SWAA2018021519788Lens · crackedAFT GALLEY CENTER EMERGENCY LIGHT LENS DETACHED. R & R THE LIGHT ASSEMBLY IAW AMM.SDR SIMA20180214002Light · inoperativeSEAT 12A OVERHEAD EMERGENCY LIGHT INOPERATIVE. R & R THE EMERGENCY LIGHT IAW AMM 33-50-07-000-801-A, AND 33-50-07-400-801-A, OPS CHECKED GOOD.SDR DALA2018021400899Battery Pack · inoperativeROWS 1 - 4, OVERHEAD EMERGENCY LIGHTS FOUND INOPERATIVE. REMOVED AND REPLACED THE BATTERY PACK IAW AMM 33-53.SDR KCSA201802141024Light · inoperativeUPPER DECK ATTENDANTS PANEL, EMERGENCY LIGHT SWITCH DOES NOT ILLUMINATE WHEN ACTUATED.SDR E07A201802140006Battery Pack · failedEMERGENCY LIGHTS STAYS ON IN ARM POSITION OR FLASHES ON/OFF IN ARM AND ON.
Back to JASC 3350