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 P5CA2017061200180Power Supply · malfunctionedFOUND THE EMERGENCY LIGHT POWER SUPPLY BATTERY ASSY FUNCTION BAD IAW AMM 33-51-04-002-009-001 & 33-51-04-402-012-00, REV 89. REPLACED THE POWER SUPPLY AND CHECKED NORMAL IAW AMM 33-51-04-402-012-001, REV 89, STEP D. PERFORMED EMERGENCY POWER SUPPLY TEST AND SDR AALA201706129058Cover · missingEXIT SIGN COVER MISSING FROM SERVICE DOOR 1 RIGHT. REMOVED AND REPLACED R1 DOOR EMERGENCY EXIT SIGN LIGHT ASSY IAW MM 33-51-01, OPS CHECKED GOOD.SDR AALA201706129057Cover · detachedEXIT LIGHT COVER FROM FIRST CLASS GALLEY MISSING. REPLACED THE LIGHT ASSEMBLY IAW MM 33-51-01. CHECKED NORMAL.SDR AALA201706129056Lens · brokenLENS ON OVERHEAD EMERGENCY EXIT AT ROW 23 LEFT AND 25 RIGHT BROKEN. REMOVED AND REPLACED LENS IAW AMM 33-51-00, GOOD FOR SERVICE.SDR ASAA2017061021031Cover · missingR2 DOOR EMERGENCY LIGHT COVER MISSING. ACFT GROUNDED. REINSTALLED EMERGENCY LIGHT COVER.SDR SIMA20170610001Cradle · brokenAFT FLASHLIGHT CRADLE BROKEN. REMOVED AND REPLACED THE AFT FLASHLIGHT CRADLE IAW AMM 33-50-16-000-801-A, AND 33-50-16-400-801-A. OPS CHECKED GOOD.SDR REXA2017061000697Bulb · inoperativeEMERGENCY FLOOD LIGHT AT THE FLOOR LEVER, MAIN CABIN DOOR HAS BULBS INOPERATIVE. REMOVED AND REPLACED THE BULBS IAW AMM33-51-05. OPS CHECKED GOOD.SDR MASA2017061023568Light · inoperativeROW 18 CEILING EMERGENCY LIGHT INOPERATIVE. REPLACED BULB.SDR MASA2017061012366Light · inoperativeROW 11 CEILING EMERG FLOOD LIGHT INOP. PLACED ON MEL.SDR AALA201706119007Lens · crackedCRACKED R1 DOOR EMERGENCY EXIT SIGN COVER.. INSTALLED NEW A LENS IAW AMM 33-51-00. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201706139023Lens · crackedCRACKED EMERGENCY LIGHT LENS. REPLACED THE LIGHT ASSEMBLY IAW AMM 33-51-00.SDR AALA201706119006Lens · crackedCRACKED EMERGENCY LIGHTS LENS AT LAVATORY D. REPLACED THE LIGHT ASSEMBLY IAW AMM 33-51-00.SDR AALA201706129045Lens · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT ON THE LEFT SIDE MID GALLEY WALL HAS A MISSING LENS. REPLACED LENS IAW AMM 33-15-05. OPERATIONAL CHECKED GOOD.SDR AALA201706129044Lens · missingSEAT MOUNTED EMERGENCY LIGHT AT SEAT 13B HAS A MISSING CLEAR LENS. INSTALLED THE LENS IAW AMM 33-51-10. OPERATIONAL CHECKED GOOD.SDR AALA201706129042Lens · detachedEMERGENCY LIGHT AT THE R1 DOOR HAS A DETACHED LENS. ATTACHED THE LENS . OPERATIONAL CHECKED GOOD.SDR SWAA2017061314318Battery · dischargedR2 DOOR EMERGENCY LIGHT INOP. R&R BATTERY IAW AMM.SDR SWAA2017061314315Light · inoperativeRT EXTERIOR LOWER FUSELAGE EMERGENCY LIGHT INOP. RELAMPED LIGHT PER AMM.SDR SWAA2017061314308Light · inoperativeLT OVERWING EXIT EMERGENCY LIGHT ON AFT SIDE OF DOOR LIGHT ASSEMBLY INOP. RELAMPED LIGHT PER AMM.SDR R61A201706090402Battery · inoperativeCOCKPIT EMERGENCY LIGHT DOES NOT COME ON. R & R EMERGENCY BATTERY IN FWD GALLEY ABOVE R1 DOOR IAW AMM 33-50-01. OPS CHECKED GOOD.SDR AALA201706119001Lens · crackedCRACKED MAIN CABIN FORWARD LOWER CEILING PANEL 228 ARC EXIT LIGHT LENS COVER. REPLACED EXIT MARKING SIGN LENS COVER PER E190 AMM 33-50-17.SDR DALA2017061204657Lamp · inoperativeEXIT LIGHTS INOPERATIVE. REPLACED THE LAMPS, CHECKED OK.SDR SWAA2017061214260Light · inoperativeR2 DOOR EXTERIOR EMERGENCY LIGHT INOP. RELAMPED LIGHT IAW AMM & SIP.SDR AALA201706129029Lens · missingEXIT LIGHT ON SEAT 10C IN MID CABIN EXIT ROW IS MISSING ITS LENS. INSTALLED A NEW LENS.SDR AALA201706129027Bracket · bentSEAT 9D EMERGENCY LIGHT BRACKET BENT. REPLACED THE BRACKET.SDR AALA201706129026Lens · missingEMERGENCY LIGHT LENS MISSING AT SEAT 9D. REPLACED MISSING LENS.SDR AALA201706129024Lens · missingROW 19C EMERGENCY LIGHT LENS MISSING. REMOVED AND REPLACED THE EMERGENCY LIGHT IAW AMM 33-25-00.SDR AALA201706129055Cover · detachedCOVER TO AFT RT EMERGENCY EXIT LIGHT FELL OFF. REMOVED AND REPLACED EMERGENCY EXIT LIGHT ASSY. OPS CHECKED GOOD IAW AMM 33-51-01. THE AIRCRAFT WAS GROUNDED.SDR SIMA20170609002Battery Pack · disconnectedEMERGENCY LIGHT POWER SUPPLY INOPERATIVE. INSPECTED THE POWER SUPPLY AND FOUND THE BATTERY TO HAVE BECOME DISSCONNECTED. CONNECTED THE BATTERY, AND OPS CHECKED GOOD. WORK DONE IAW AMM 33-50-04-400-802-A. NO FURTHER DEFECTS NOTED AT THIS TIME.SDR AALA201706129040Lens · missingEMERGENCY EXIT LIGHT AT SEAT 1E AFT INBOARD SIDE HAS A MISSING LENS. INSTALLED LENS IAW AMM 33-15-05. OPERATIONAL CHECKED GOOD.SDR SWAA2017061214238Cover · looseRT OVERWING EXIT LIGHT COVER LOOSE. SECURED COVER ASSEMBLY IAW AMM.SDR SWAA2017061214237Sign · brokenOVERWING EMERGENCY EXIT SIGN BROKEN. R&R SIGN PER SIP.SDR SWAA2017061214235Sign · unsecureL1 DOOR EXIT SIGN LENS FELL OFF. R&R SIGN IAW AMM.SDR DALA2017061204638Sign · inoperativeEMERGENCY EXIT SIGNS INOPERATIVE. SECURED EMERGENCY EXIT SIGN. OK FOR SERVICE IAW AMM 33-24.SDR F3LA2017061200178Power Supply · no testEPSU SYS TEST FAILED. RESET EPSU (13WL). OPS TESTED NORMAL IAW AMM 23-73-00-740-01.SDR N6WA2017060902Light · inoperativeOVER WING EMERGENCY LIGHT INOPERATIVE. R & R THE CEILING EMERGENCY LIGHT IAW AMM 33-51-09. OPS CHECKED GOOD.SDR DALA2017061004619Powerpack · inoperativeSEAT MOUNTED EMERGENCY LIGHTS AT ROW 20-21 AND 24-25 INOP, REPLACED 13WL POWER PACK.SDR MASA2017060912365Light · inoperativeROW 23 EMER OVERHEAD FLOODLIGHT INOP. PLACE ON MEL.SDR CALA2017060901785Power Supply · inoperativeEMERGENCY LIGHTS FAIL OPS CHECK. REF AMM33-51-38, REPLACED LEFT WING EMERGENCY BATTERY SUPPLY. TESTED GOOD.SDR CALA2017060901780Light · inoperativeRT FWD OVERWING EXIT DOOR EXTERIOR EMERGENCY LIGHT INOP. RELAMPED RT FWD OVERWING EXIT EXTERIOR EMERGENCY LIGHT PER AMM 33-51-04-960-801. OPS CKS GOOD.SDR CALA2017060901775Sign · looseEXIT ROW SIGN ABOVE AISLE MID AIRCRAFT POSITION FELL OUT REINSTALLED BOTH SIGN HALFS. OK FOR SERVICE.SDR CALA2017060901781Sign · unsecureOVERHEAD EMERGENCY EXIT SIGN FELL OFF ROW 25 ISLE SECURED. OPS CK OK.SDR CALA2017060901777Lens · missingEMERGENCY EXIT LIGHT COVER NEAR LEFT AFT LAV MISSING. REPLACED COVER.SDR CALA2017060901776Light · inoperativeEEL LIGHT INOP AT SEAT 2B. REPLACED FWD LIGHT ASSEMBLY ON SEAT 2B.SDR CALA2017060901771Light · inoperativeSLIDE LITE BULB BURNED OUT DOOR 1R. RELAMPED SLIDE ARMED LIGHT IAW AMM CH 33-51-00. OPS CHECK GOOD.SDR CALA2017060901770Socket · dirtyEXT EMER SLIDE LIGHT DOOR R3 INOP, RELAMP NO HELP. CLEANED SOCKET AND RELAMPED R3 DOOR SLIDE LIGHT IAW AMM 33-51-06 . OPS CHK GOOD.SDR CALA2017060901769Socket · dirtyEXT EMER SLIDE LIGHT DOOR L3 INOP, RELAMP NO HELP. CLEANED SOCKET AND RELAMPED L3 DOOR SLIDE LIGHT IAW AMM 33-51-06 . OPS CHK GOOD.SDR CALA2017060901768Light · unsecureEMERGENCY FLOOR LIGHT STRIP CAME OFF. SECURED LT STRIP. OPS NML.SDR CALA2017060901767Lens · missing2 EA CEILING EMERG LIGHT LENS COVERS MISSING IN AFT PAX COMP. REPLACED LENS COVERS.SDR CALA2017060901766Lens · crackedEXT EMERG LIGHT SMALL LENS CRACKED LOC. LT JUST AFT OF IB FLAP T/E REPLACED LENS ASSY.SDR CALA2017060901765Lens · missingEMERGENCY CEILING LIGHT FIRST CLASS GALLEY MISSING COVER. REPLACED LENS COVER.
Back to JASC 3350