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 SWAA2018053122418Light · inoperativeR2 DOOR LOWER EMERGENCY EXIT LIGHT INOP. R&R LIGHT IAW AMM.SDR SWAA2018053122405Light · inoperativeRT OVERWING EMERGENCY LOWER EXIT LIGHT INOP. R&R LIGHT IAW AMM.SDR SWAA2018053122389Lens · missingRT OVERWING EMERGENCY DOOR EXIT SIGN LIGHT LENS MISSING. R&R SIGN IAW MM.SDR SWAA2018053122388Lens · missingRT OVERWING EMERGENCY EXIT DOOR LOWER FORWARD EXIT SIGN MISSING RED ARROW. R&R SIGN IAW MM.SDR DALA201805313731Bulb · inoperativeEMERGENCY LIGHTS AT LLCR WERE INOPERATIVE. REPLACED THE BULBS. SYSTEM OPS NORMAL.SDR AALA201805319016Light · looseSEAT 16C EMERGENCY LIGHT LOOSE. MAINTENANCE SECURED THE LIGHT AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR SIMA201805310001Light · inoperativeNR 6 FLOOR EMERGENCY LIGHT WAS INOPERATIVE. R & R THE EMERGENCY LIGHT IAW AMM 33-50-12. OPS CHECKED GOOD.SDR SIMA201805310002Fuse · inoperativeLEFT EXTERNAL WING TO FUSELAGE EMERGENCY LIGHT INOPERATIVE. R & R THE FUSE F1 ON BATTERY CHARGER NR 1 IAW CMM 25-60-03. OPS CHECKED GOOD.SDR MASA2018053013276Light · inoperativeCEILING EMER FLOOD LIGHT INOP ROW 8. PLACED ON MEL.SDR ASOA2018F00001Inverter · inoperativeRIC FLIGHT 4126 DURING SCHEDULED MAINTENANCE INSPECTION THE EMERGENCY EXIT SIGN AT ROW 1 AND COCKPIT STEP WAS FOUND INOPERATIVE. MAINTENANCE REMOVED AND REPLACED EMERGENCY EXIT SIGN INVERTER WITH OPERATIONAL CHECK GOOD. AIRCRAFT WAS APPROVED FOR RETURN TO SESDR SWAA2018060622563Cover · brokenAFT ATTENDANT PANEL EMERGENCY LIGHT SWITCH COVER SPRING BROKEN. R&R COVER PER SIP.SDR AALA2018060649032Battery · no testEMERGENCY LIGHT POWER SUPPLY 10WL FAILED DURING AN OPERATIONAL TEST. REPLACED THE POWER SUPPLY AND BATTERY IAW AMM 333-51-38. AIRCRAFT WAS GROUNDED.SDR SWAA2018060522543Lens · crackedRT EMERGENCY AISLE LIGHT LENS CRACKED AT BIN 6. R&R LENS IAW AMM.SDR SWAA2018060522542Lens · crackedLT EMERGENCY LIGHT AISLE LENS CRACKED AT ROW 23. R&R LENS IAW AMM.SDR SWAA1955060122541Lens · crackedLT EMERGENCY LIGHT AISLE LENS CRACKED AT ROW 27. R&R LENS IAW AMM.SDR CALA2018060531379Battery Pack · dischargedFOUND THE EMERGENCY LIGHT POWER SUPPLY M33045 BATTERY PACK TO HAVE LOW CAPACITY. REPLACED THE POWER SUPPLY. OPS TESTED NORMAL IAW AMM 33-51-06-960-802, REV 82, & AMM 33-51-06-960-802, S/T 710-002, REV 82.SDR CALA2018060531378Battery · dischargedFOUND THE EMERGENCY POWER SUPPLY M33096 WITH LOW CAPACITY. REPLACED EMERGENCY POWER SUPPLY, OPS TESTED NORMAL IAW AMM 33-51-06-960-802, REV 82, & AMM 33-51-06-960-802 S/T 710-002, REV 82.SDR CALA2018060531377Battery · dischargedZONE - A - SEAT EMERGENCY LIGHT BATTERY CAPACITY WAS LOW. REPLACED THE POWER SUPPLY IAW AMM 33-51-06-960-802, REV 82, & AMM 33 -51-06-960-802 S/T 710-002, REV 82. OPS TESTED NORMAL.SDR CALA2018060531376Cover · crackedCABIN EXIT SIGN COVER WAS CRACKED AT THE L2 DOOR. REPLACED AN OPS TEST CARRIED OUT. FOUND NORMAL IAW AMM 33-51-01-960-80,2 REV 82SDR CALA2018060501375Cover · crackedCABIN EXIT SIGN COVER AT THE L4 DOOR WAS CRACKED. REPLACED THE COVER AND OPS TESTED NORMAL IAW AMM 33-51-01-960-802 REV 82SDR AALA2018060530001Battery Pack · failedCEILING EMERGENCY LIGHT BETWEEN SEATS 2H AND 3H WAS INOPERATIVE. REMOVED AND REPLACED THE M33093 POWER SUPPLY BATTERY PACK IAW AMM 33-51-06. OPS CHECKED NORMAL.SDR AALA201806041001Power Supply · no testEMERGENCY LIGHT POWER SUPPLY 10WL FAILED AN OPERATIONAL TEST. REPLACED THE POWER SUPPLY AND BATTERY IAW AMM 333-51-38.SDR AALA2018006043003Battery Pack · inoperativeCEILING EMERGENCY LIGHT INOPERATIVE AT 2H & 2L. REPLACED THE M33093 POWER SUPPLY AND BATTERY PACK IAW AMM 33-51-06. OPS CHECKED GOOD.SDR DALA201805313746Light · false activationDURING CRUISE, THE RIGHT SIDE EMERGENCY EXIT LIGHTS ILLUMINATED. AFTER AIRCRAFT POWER WAS CYCLED, PERFORMED EPSU TEST, ALL EMERGENCY LIGHTS OPERATED NORMALLY.SDR SWAA2018053122411Light · inoperativeRT OVERWING EMERGENCY EXTERIOR LIGHT INOP. R&R BULB PER AMM.SDR SWAA2018053122393Light · inoperativeLT OVERWING EMERGENCY EXTERIOR LIGHT INOP. R&R BULB PER AMM.SDR DALA201805313730Light · inoperativeEMERGENCY LIGHT WAS INOPERATIVE AT SEAT 38F. REPLACED THE SHROUD. SYSTEM OPERATION IS NORMAL.SDR AALA2018053130002Power Supply · no testG3 GALLEY/CLOSET EMERGENCY LIGHTS INOPERATIVE. REPLACED THE M33093 POWER SUPPLY AND BATTERY PACK IAW AMM 33-51-06, PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA2018053109008Lens · brokenRED EMERGENCY LIGHT LENS IN THE FORWARD GALLEY BROKE OFF. REPLACED THE LENS.SDR SWAA2018053022379Battery · dischargedLT EXIT ROW EMERGENCY LIGHTS INOP. R&R BATTERY PER MM.SDR SWAA2018053022352Charger · inoperativeLT EXIT ROW EMERGENCY LIGHTS INOP. R&R BATTERY CHARGER PER MM.SDR N6WA201805302901Bulb · inoperativeCEILING EMERGENCY LIGHT WAS INOPERATIVE AT ROW 6. R & R THE BULB IAW AMM 33-51-09, OPS CHECKED GOOD.SDR SIMA2018053029004Power Supply · not reportedREMOVED AND REPLACED THE POWER SUPPLY IAW AMM 33-50-04. OPS CHECKED GOOD. ACFT OK FOR SERVICE.SDR SIMA2018053029001Light · inoperativeMULTIPLE EMERGENCY LIGHTS WERE INOPERATIVE. TROUBLESHOT IAW WM 33-50-50. R & R THE NR 1 AND 4 BATTERIES AND CHARGER IAW W/C 33-700-19. R & R THE NR 6 INVERTER IAW 33-50-11. PERFORMED AN OPS CHECK OF THE EMERGENCY LIGHTS IAW W/C 33-700-17. OPS CHECKED GOOD. SDR SIMA2018053029003Light · inoperativeICU PANEL CABIN AND CABIN EMERGENCY LIGHTS WERE BURNED OUT. R & R THE CABIN AND CABIN EMERGENCY LIGHTS IAW AMM 20-13-04.SDR MASA2018052913268Light · inoperativeAFT CABIN CEILING FLOOD LIGHT INOP. REPLACED BULB.SDR KCSA201805291134Light · inoperativeUPPER DECK EMERGENCY LIGHT AT STA 450 CEILING WILL NOT LIGHT UP.SDR MASA2018052913267Battery Pack · dischargedFWD FUSELAGE EMERG EXIT SIGN WILL NOT ILLUMINATE. ALLOWED BATTERIES TIME TO CHARGESDR ASOA201805292009Charger · no testBATTERY CHARGER NR 4 FAILED AN OPS CHECK IAW TC 700-33-900-701-A01. MAINTENANCE REMOVED AND REPLACED THE BATTERY CHARGER IAW AMM 33-51-17. AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR DALA2018052903622Power Supply · inoperativeONE EMERGENCY LIGHT IN THE TAIL WAS INOPERATIVE. REMOVED AND REPLACED THE POWER SUPPLY B5-239.SDR YENA201805290220Battery Pack · failedEMERGENCY LIGHTS FAILED TO TEST. REMOVED AND REPLACED THE BATTERY ASSY AT 13WL IAW 33-51-11.SDR DALA2018052903616Lamp · inoperativeEMERGENCY LIGHTS WERE INOPERATIVE AT 1CD. REPLACED THE LAMP. OPS CHECKED GOOD.SDR AALA2018060529004Battery Pack · faultedEMERGENCY LIGHT REMAINED ON ALL THE TIME. REMOVED AND REPLACED THE BATTERY PACK IAW AMM 33-51-06. OPS CHECKED NORMAL. OK FOR SERVICE. THE AIRCRAFT WAS GROUNDED.SDR DALA2018060103767Lamp · inoperativeSLIDE INDICATOR LIGHT INOPERATIVE. REPLACED THE LAMPS IAW AMM 25-56, CHECKED OK.SDR SWAA2018053122394Light · inoperativeAFT GALLEY DOORWAY EMERGENCY LIGHT, BELOW EXIT SIGN BULB INOP. RELAMPED LAMP PER AMM.SDR AALA2018053109002Light · inoperativeR2 DOOR CEILING EMERGENCY LIGHT INOPERATIVE. REPLACED THE LIGHT IAW AMM 33-51-00.SDR AALA201805299030Lens · missingAIRCRAFT WAS NOT GROUNDED: DOOR 3R LIGHT COVER, FOR EXIT MISSING. MAINTENANCE REPLACED 3R EMERGENCY EXIT LIGHT LENS AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR SWAA2018053022250Battery Pack · dischargedLT AISLE EMERGENCY LIGHTS INOP AT ROW 17. R&R BATTERY PACK IAW MM.SDR ASAA2018052824820Sign · detachedROW 16 EXIT SIGN CAME OFF. GROUNDED - YES. RESECURED ROW 16 EXIT SIGN REF AMM 33-51-00. A/C OK BACK FOR SERVICE.SDR PNSA2018052801Light · not reported"ARM" BUTTON ON FA PANEL NEEDS NEW BULBS. R&R "ARM" BUTTON BULBS ON FA PANEL, OPS CHECKED GOOD.
Back to JASC 3350