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 DALA2017061904848Lens · misinstalledEMERGENCY EXIT DIFFUSER LENS MISINSTALLED. INSTALLED EXIT SIGN PROPERLY.SDR DALA2017061904847Lens · misinstalledEMERGENCY EXIT DIFFUSER LENS DAMAGED. INSTALLED EXIT SIGN PROPERLY.SDR DALA2017061904846Cover · damagedEMERGENCY LIGHT COVERS DAMAGED AT SEAT ROW 1 AND 2. REPLACED THE COVERS.SDR AALA201706199037Lens · missingL2 DOOR EMERGENCY LIGHT LENS MISSING. INSTALLED A NEW LENS.SDR SWAA2017061914453Light · brokenLT FORWARD EMERGENCY EXIT LIGHT LENS COVER BROKEN. R&R LIGHT ASSEMBLY PER AMM.SDR DALA2017061904840Lens · damagedEMERGENCY EXIT COVER DIFFUSER LENS DAMAGED. REPLACED THE LENS. CHECKED OK.SDR DALA2017061904839Battery Pack · inoperativeEXIT SIGN IN FLIGHT DECK OVERHEAD INOPERATIVE. REPLACED THE BATTERIES. OPS CHECKED OK.SDR AALA20170617001Battery Pack · no testWHILE ACCOMPLISHING SIC2904 FOR OPERATIONAL TEST OF EMERGENCY LIGHTS, FOUND FIRST CLASS SEAT MOUNTED EMERGENCY LIGHTS OUT & R1 DOOR EXIT SIGN OUT. TROUBLESHOT AND FOUND BATTERY PACK FWD CABIN EMERGENCY CHARGER FWD INOPERATIVE. REPLACED THE BATTERY PACK IAW MMSDR ASAA2017061721110Lens · missingAFT GALLEY THRESHOLD AREA, EXIT INDICATOR LIGHT LENS MISSING. ACFT GROUNDED. INSTALLED EXIT INDICATOR LIGHT LENS IAW AMM 33-51-01.SDR AALA201706199028Battery · no testDURING EMERGENCY POWER SUPPLY (16WL) OPERATIONAL CHECK, FOUND FAULT ON THE BATTERY AT 3R. REPLACED BATTERY IAW AMM 33-51-38.SDR YENA201706170498Lamp · inoperativeLT & RT OVERWING SIDEWALL EXIT SIGNS HAVE NUMEROUS BULBS INOPERATIVE. REPLACED THE LAMPS IAW AMM 33-51-15. OPS CHECKED GOOD.SDR SIMA20170617001Lamp · inoperativeSERVICE DOOR EXTERNAL EMERGENCY LIGHT INOPERATIVE IAW PS-1 INSPECTION. R & R THE LAMP IAW AMM 33-50-10. OPS CHECKED GOOD.SDR DALA2017061804800Battery Pack · dischargedTAIL CONE ESCAPE LIGHTS INOP. REPLACED BATTERY PACKS IAW AMM 33-53.SDR DALA2017061804799Light · inoperativeEMERGENCY LIGHTS ON CATWALK INOP. RELAMPED LIGHT ASSY 2EA. LOCATIONS, CATWALK PER AMM 33-52. CHECKS OK.SDR MASA2017061712388Lamp · inoperativePAX DOOR EMERGENCY LIGHT HAD ONE BULB INOPERATIVE. REPLACED THE LAMPS.SDR CALA2017061701858Lens · missingFOUND CEILING AREA EMERGENCY LIGHT LENS MISSING AT 35C, & 37E. THE LENS WAS REPLACED AND CHECKED OK.SDR CALA2017061701857Light · inoperativeDURING CHECK, FOUND TWO SEAT MOUNTED EMERGENCY LIGHTS WITH A SINGLE BULB ILLUMINATED AT 1E AN D 10E SEAT. REPLACED THE LIGHT ASSY AND THE EMERGENCY LIGHTS TESTED OK IAW AMM 33-51-01, AND AMM 33-51-05.SDR CALA2017061701856Lamp · inoperativeDURING CHECK FOUND TWO EMERGENCY LIGHTS NOT ILLUMINATED AT THE L2 AND L3 DOOR. REPLACED THE LAMPS AND TESTED OK IAW AMM 33-51-00.SDR CALA2017061701855Lamp · inoperativeEXTERNAL EMERGENCY LIGHT AT THE L3 DOOR INOPERATIVE. REPLACED THE LAMPS, OPS CHECKED OK.SDR CALA2017061701853Lamp · inoperativeR1 & R4 EXTERIOR EMERGENCY LIGHTS INOPERATIVE DURING TEST. REPLACED THE LAMPS IAW 33-51-04-960. OPS CHECKED GOOD.SDR CALA2017061701852Power Supply · faultySEATS 33 THRU 43 KJH EMERGENCY LIGHTS ARE VERY DIM. POWER SUPPLY REPLACED AND EMERGENCY LIGHTS TESTED GOOD IAW AMM 33- 51-04-902-001-002.SDR ASAA2017061621119Sign · detachedOVERWING EXIT SIGN CAME OFF ROW 17ABC. ACFT GROUNDED. REPLACED THE OVERWING EXIT SIGN AT ROW 17ABC IAW AMM 33-51-01-960-802. OPS CHECKED GOOD.SDR SIMA20170616004Charger · failedALL EMERGENCY LIGHTS THAT ARE POWER BY EMERGENCY BATTERY NR 1 DO NOT TURN ON. REMOVED AND REPLACED EMERGENCY BATTERY AND CHARGER IAW WC 33-700-19SDR SWAA2017062114552Light · inoperativeLT LOWER EMERGENCY EXIT LIGHT INOP. R&R LAMP IAW AMM.SDR SWAA2017062114551Light · brokenG4 GALLEY EXIT LIGHT ASSEMBLY BROKEN. R&R LIGHT ASSEMBLY IAW AMM.SDR SWAA2017062014523Lamp · inoperativeL1 DOOR EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMP IAW AMM.SDR SWAA2017062014489Cover · brokenL1 DOOR LOWER "EXIT" LIGHT COVER BROKEN. R&R COVER IAW AMM.SDR SWAA2017062014485Lens · crackedRT OUTER WING EXIT DOOR LOWER EXIT LIGHT LENS ASSEMBLY CRACKED. R&R LIGHT ASSEMBLY PER AMM.SDR AALA201706199068Lens · missingTHE AIRCRAFT IS NOT GROUNDED. EMER EXIT LENS COVER MISSING AT 1R DOOR. REPLACED EMERGENCY EXIT LENS ASSY 1R DOOR IAW AMM 33-51-01.SDR AALA201706199067Cover · unsecureTHE AIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT COVER AFT ENTRY DOOR NEEDS RE-SECURING. REPLACED EMERGENCY EXIT LIGHT ASSEMBLY CHECKS OK PER MM-33-51-01.SDR AALA201706199060Lens · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT OVERHEAD AISLE ADJACENT TO SEAT 37BC HAS A MISSING LENS COVER. INSTALLED LENS COVER IAW AMM 33-51-04. OPERATIONAL CHECK GOOD.SDR AALA201706199058Lens · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT OVERHEAD AISLE ADJACENT TO SEAT 23BC HAS A MISSING LENS COVER. INSTALLED LENS COVER IAW AMM 33-51-04. OPERATIONAL CHECK GOOD.SDR AALA201706199054Lens · missingEXIT LENS IN AFT GALLEY IS MISSING. INSTALLED NEW LENS AND CHECKED OK.SDR AALA201706199038Lens · missingSEAT 1C EMERGENCY LIGHT LENS MISSING. REPLACED THE EMERGENCY LIGHT LENS.SDR AALA201706199019Sign · unsecureR4 DOOR EMERGENCY EXIT SIGN LOOSE IN BRACKET. SECURED THE SIGN AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK IAW AMM 33-51-13.SDR AALA201706199017Battery · no testLEFT AFT BATTERY FAILED EMERGENCY LIGHT TEST. REPLACED THE BATTERY IAW AMM 33-51-38.SDR N6WA2017061603Light · inoperativeAFT CABIN OVERHEAD EMERGENCY EXIT LIGHT INOPERATIVE.SDR N6WA2017061601Lamp · inoperativeOVERHEAD EMERGENCY EXIT FLOOD LIGHT INOPERATIVE AT ROW 16. REPLACED THE LAMPS IAW AMM 33-51-09SDR SIMA20170616001Lamp · inoperativeMAIN DOOR EMERGENCY LIGHT INOPERATIVE. R & R SIDE HINGED MAIN DOOR EXTERNAL EMERGENCY LAMP IAW AMM 33-50-10-000-801-A/33-50-10-400-801-A, OPS CHECKED GOODSDR SIMA20170616002Inverter · inoperativeLAST 3 FLOOR EMERGENCY LIGHT STRIPS INOPERATIVE. REMOVED AND REPLACED THE EMERGENCY LIGHT INVERTER IAW AMM 33-50-11, OP CHECKED GOODSDR 29GA2017061800002Unknown · malfunctionedFLIGHT 0115 BIM/FLL. EMERGENCY EXIT LIGHTS REMAIN ILLUMINATED AFTER ENGINE SHUT DOWN. RESET EMERGENCY EXIT LIGHTS IAW AMM 33-50-10. OPS CHECK NORMAL.SDR DALA2017061604756Battery Pack · inoperativeLEFT & RIGHT AFT OVERWING EXIT IDENTIFIER LIGHTS INOPERATIVE. REPLACED THE BATTERY PACK IAW AMM IAW 33-53. OPS CHECKED GOOD.SDR DALA2017061604755Lamp · inoperativeRT FWD OVERWING EXIT SIGN INOPERATIVE. REPLACED THE LAMPS IAW AMM 33-50. OPS CHECKED GOOD.SDR SIMA20170615010Holder · crackedNR 1 LT FLOOR EMERGENCY LIGHT STRIP HOLDER CRACKED. REMOVED AND REPLACED THE EMERGENCY LIGHT HOLDER IAW AMM 33-50-12.SDR SIMA20170615016Light · crackedNR 1 RT EMERGENCY LIGHT STRIP CRACKED. REMOVED AND REPLACED THE EMERGENCY LIGHT IAW AMM 33-50-12.SDR SIMA20170615011Light · crackedLEFT NR 6 PROXIMITY LIGHT EXTRUSION CRACKED. REMOVED AND REPLACED THE LIGHT IAW AMM 33-50-12.SDR SIMA20170615014Holder · crackedNR 2 LT FLOOR LIGHT STRIP HOLDER CRACKED. REMOVED AND REPLACED THE NR 2 EMERGENCY LIGHT HOLDER IAW AMM 33-50-12.SDR SWAA2017062614600Fuse · inoperativeRIGHT OVERWING EXIT LOCATOR SIGN L1365 INOPERATIVE. R & R THE FUSE IAW AMM.SDR SWAA2017061914448Cover · unsecureMID CABIN OVERHEAD EMERGENCY EXIT LIGHT COVER FELL OFF AT ROW 15. SECURED COVER PER AMM.SDR JJBA20170615011Battery Pack · dischargedEMERGENCY LIGHTS INOPERATIVE. SWITCH WAS FOUND IN THE ARM POSITION. R & R THE BATTERY PACK, OPS CHECKED SAT.
Back to JASC 3350