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 CALA2017061201812Cover · detachedAFT EMERGENCY EXIT COVER FELL OFF. SECURED LIGHT COVER ,LIGHT CKD OKSDR CALA2017061201809Sign · detachedEMERGENCY EXIT SIGN IS HANGING AT ROW 21DEF. INSTALLED THE SIGN AND OPS CHECKED NORMAL.SDR CALA2017061201818Charger · inoperativeEMERGENCY LIGHTING INOPERATIVE AT ROWS 8 - 14ABC. REMOVED AND REPLACED THE BATTERY CHARGER ASSY AT ROW 8ABC IAW AMM 33-51-06-960-806, OPS NORMAL.SDR CALA2017061201817Fuse · inoperativeRED EMERGENCY EXIT LIGHTS DO NOT COME ON BY OVERWING EXITS. REPLACED FOUR FUSES IN POWER SUPPLY LOCATED JUST FORWARD OF LEFT FWD OVERWING EXIT DOOR. REPLACED 3 EMERGENCY LIGHT ASSEMBLIES AT ROW 15, 20 AND 21 LEFT SIDE. PERFORMED EMERGENCY LIGHTING OPERATIONALSDR CALA2017061201816Battery · dischargedAFT CABIN CEILING EMERGENCY EXIT SIGN DID NOT ILLUMINATE DURING TEST MODE. CHARGED EMERGENCY EXIT SIGN POWER SOURCE. OP CHECKED GOOD. ACFT OK FOR CONTINUED SERVICE.SDR CALA2017061201806Light · inoperativeSEATS 16F AND 31D EMERGENCY LIGHTS INOPERATIVE. REPLACED THE LIGHTS IAW DMC-B787-A-33-51-06-00A-520A-A, AND DMC-B787-A-3 3-51-06-00A-720A-A. CHECKED OK.SDR MASA2017061212371Bulb · inoperativeLOWER EXIT SIGN ROW 18LT HAD ONE BULB INOPERATIVE.SDR AALA201706129023Lens · brokenL2 DOOR EXIT SIGN COVER BROKEN. REMOVED AND REPLACED THE COVER.SDR AALA201706139003Light · unsecureR1 DOOR EMERGENCY LIGHT, LOWER LEFT EXIT SIGN, NOT SECURE. REPLACED EMERGENCY EXIT LIGHT IAW AMM 33-51-13.SDR DALA2017061304733Lens · detachedEMERGENCY LIGHT AT BOTTOM OF SEAT 14D IS BROKEN. ATTACHED THE EMERGENCY LIGHT LENS. CHECKED GOOD.SDR AALA201706129001Battery · no testEMERGENCY LIGHTS DO NOT PASS, FAULTING 10WL BATTERY. REPLACED FORWARD LEFT 10WL EMERGENCY LIGHT BATTERY PER AMM 33-51-38. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR SWAA2017061414358Fuse · blownLT OVERWING EXTERIOR EMERGENCY EXIT LIGHT INOP. R&R FUSE PER MM.SDR SWAA2017061414341Cover · looseLT AFT LAV DOOR EMERGENCY LENS COVER LOOSE. SECURED COVER PER MM.SDR HNAA2017061400202Bulb · burned outEMERGENCY EXIT LIGHT AT ROW 9 IS INOPERATIVE. R & R THE BULB.SDR AALA201706129033Lens · missingR4 DOOR EXIT LIGHT LENS MISSING. INSTALLED A NEW LENS. OK FOR SERVICE.SDR DALA2017061304685Sign · unsecureDURING INSPECTION, FOUND EMERGENCY EXIT SIGNS INOPERATIVE. MAINTENANCE SECURED EXIT SIGN IAW AMM 33-51. OK FOR SERVICE.SDR AALA201706129030Lens · missingEMERGENCY AISLE LIGHT 3C WHITE LENS MISSING. REPLACED EMERGENCY LIGHT AT SEAT 3C.SDR AALA201706129025Lens · missingEMERGENCY EXIT LIGHT LENS MISSING SEAT 1A. REPLACED EXIT LIGHT LENS IAW AMM 33-51-00.SDR AALA201706129016Light · brokenEMERGENCY EXIT LIGHT SIDE OF SEAT 12C OFF THE SEAT. REMOVED AND REPLACED HOUSING SEAT 12C EMERGENCY EXIT LIGHT.SDR AALA201706129043Light · detachedEMERGENCY LIGHT AT ROW 17 IS COMING UP. SECURED THE LIGHT IAW AMM 33-51-15-201. OPERATIONAL CHECKED GOOD.SDR QXEA2017061300415Lamp · inoperativeFWD F/A'S EMERGENCY LIGHT SWITCH INOPERATIVE. REPLACED THE LAMP.SDR AALA201706139019Lens · missingEMERGENCY LIGHT LENS COVER MISSING OVER THE R1 DOOR. REPLACED THE LENS ASSY IAW AMM 33-51-01. OPS CHECKED NORMAL. OK FOR SERVICE.SDR AALA201706139018Sign · missingEMERGENCY EXIT SIGN COVER MISSING AT 15DEF. REPLACED THE SIGN COVER, OK FOR SERVICE.SDR AALA20170613001Sign · damagedDOOR EMERGENCY EXIT SIGN DAMAGED AT LEFT REAR SERVICE DOOR. REPLACED AFT LEFT DOOR EXIT EMERGENCY SIGN ASSEMBLY IAW MM 33-51-01, TESTED OK.SDR SWAA2017061314334Power Supply · inoperativeR2 DOOR EXTERNAL EMERGENCY SLIDE LIGHT INOP. R&R POWER SUPPLY PER AMM.SDR SWAA2017061314332Battery · dischargedRT FORWARD EMERGENCY LIGHT INOP. R&R BATTERY PER AMM.SDR SWAA2017061314312Sign · looseLT OVERWING EXIT SIGN LOOSE. SECURED SIGN PER MM.SDR DALA2017061204654Lamp · inoperativeROW 32D EMERENCY LIGHT INOPERATIVE. R & R THE LAMPS IAW MM 33-53. CHECKED NORMAL.SDR AALA201706129062Lens · missingEMERGNECY EXIT SIGN COVER MISSING AT 15DEF. INSTALLED A NEW SIGN, OK FOR SERVICE.SDR AALA201706129061Lens · brokenF/A REPORTED THE L2 DOOR EMERGENCY LIGHT LENS, ON SIDEWALL, BROKEN OFF. REPLACED THE SIDEWALL EXIT SIGN ASSY IAW AMM 33-51-01, OPS CHECKED GOOD. OK FOR SERVICE.SDR ASAA2017061121013Battery Pack · no testEMERGENCY LIGHTS ROWS 17 - 26DEF FAILED TO STAY ON FOR 15 MINUTES DURING TEST. ACFT GROUNDED. THE BATTERY PACK M1671 WAS REMOVED AND REPLACED IAW AMM 33-51-06-960-805, AND WDM 33-51-14. OPS CHECKED GOOD.SDR ASAA2017061121012Battery Pack · failedDURING TC 78233000 ACCOMPLISHMENT, FOUND THE EMERGENCY EXIT LIGHTS AROUND L2 DOOR, INTERIOR AND EXTERIOR, INOPERATIVE. ACFT GROUNDED. REMOVED AND REPLACED THE BATTERY PACK IAW AMM 33-51-06-960-805. OPS CHECKED GOOD.SDR QXEA2017061200410Light · missingIN MCD ENTRYWAY, MISSING A PART OF THE EMERGENCY LIGHTING STRIP. INSTALLED AND SEALED MISSING LIGHTNING STRIP AS NECESSARY.SDR MASA2017061112369Light · inoperativeROW 15 EMERGENCY FLOOD LIGHT INOPERATIVE.SDR IPXA2017061218116Battery Pack · inoperativeUPPER DECK EMERGENCY LIGHTS INOPERATIVE. REPLACED THE BATTERY PACK IAW AMM 33-51-04-902-001-001, REV 89.01, AND TESTED SATISFACTORY.SDR IPXA2017061118107Battery Pack · inoperativeEMERGNECY LIGHTS SYSTEM INOPERATIVE. REMOVED AND REPLACED THE BATTERY PACK IAW MM 33-5- 01-400-802. OPS CHECKED NORMAL IAW 33-51-01-700-802.SDR DALA2017061204629Lamp · inoperativeL3 DOOR, LEFT OUTSIDE EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS.SDR AALA201706129046Light · inoperativeAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIDEWALL LIGHT AT SEAT 21J IS BURNT OUT. **SUPPLEMENTAL - 06/16/17 - RE-LAMPED SIDEWALL LIGHT IAW AMM 33-21-00. OPERATIONAL CHECK GOOD. (CLOSED)SDR AALA201706129039Lens · missingAIRCRAFT WAS NOT GROUNDED. LEFT AFT FLIGHT ATTENDANT EVACUATION LIGHT HAS A MISSING LENS COVER. **SUPPLEMENTAL - 06/17/17 - INSTALLED LENS COVER IAW AMM 33-50-51. OPERATIONAL CHECK GOOD. (CLOSED)SDR DALA2017061204711Light · inoperative1CD EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE LIGHT IAW MM. OPERATION CHECKED GOOD.SDR DALA2017061204686Charger · inoperativeDURING INSPECTION, FOUND CENTER OVERHEAD LIGHT EMERGENCY EXIT SIGN LIGHT INOPERATIVE. MAINTENANCE REMOVED AND REPLACED BATTERY CHARGER AT ROW 23 ALONG WITH BATTERY IAW AMM 33-51. EMERGENCY EXIT SIGN OPS CHECKED NORMAL.SDR ASOA201706105086Inverter · inoperativeDURING MX INSPECTION, THE EMERGENCY LIGHTS FROM ROWS 3 TO 7 WAS FOUND INOPERATIVE. MX REMOVED AND REPLACED THE INVERTER NR 3. OPERATIONAL CHECKED GOOD. ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR ASOA201706105085Battery Pack · inoperativeDURING MX INSPECTION, THE MAIN CABIN DOOR, EXIT, OVERHEAD ROW 3, AND FWD LEFT WING EMERGENCY LIGHTS WERE FOUND INOPERATIVE. MX REMOVED AND REPLACED THE NR 1 EMERGENCY LIGHT BATTERY. OPERATIONAL CHECKED GOOD. ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR AALA201706119002Power Supply · no testPOWER SUPPLY UNIT OVER THE L2 DOOR, FAULT LIGHT ILLUMINATED. REPLACED POWER SUPPLY IAW AMM 33-51-38.SDR FDEA201706101610Lens · looseEMERGENCY LIGHT LENS CAME LOOSE. LT SIDE OF THE L1 DOOR. REMOVED AND REPLACED THE EMERGENCY LIGHT ASSY IAW AMM 33-50-00-2. EMERGENCY LIGHTS TESTED GOOD, OK FOR SERVICE.SDR AALA201706129047Lens · detachedEMERGENCY EXIT SIGN BY THE LEFT MAIN CABIN WINDOW HAS A DETACHED LENS. ATTACHED THE LENS. OPERATIONAL CHECKED GOOD.SDR SWAA2017061314311Sign · looseFORWARD LAV EMERGENCY EXIT SIGN LOOSE. SECURED SIGN PER SIP.SDR SWAA2017061214287Lens · brokenLT OVERHEAD EMERGENCY LIGHT LENS BROKEN AT ROW 12. R&R LENS PER AMM.SDR SWAA2017061214278Lens · brokenRT OVERHEAD EMERGENCY LIGHT LENS BROKEN BETWEEN ROW 10 TO ROW 14. R&R LENS PER AMM.SDR AALA201706129015Lens · detachedROW 12 LEFT EMERGENCY EXI LIGHT DANGLING. SECURED EMERGENCY LIGHT EXIT ROW 12.
Back to JASC 3350