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 AALA201705059005Battery Pack · no testL2 DOOR OVERHEAD EMERGENCY EXIT SIGN FAILED TO TEST. FULLY CHARGED BATTERY PACKS IAW AMM TASK 33-51-06. ALL LIGHTS CHECKED GOOD. AIRCRAFT WAS GROUNDED.SDR AALA201705059004Battery Pack · no testBATTERY PACKS M1673 AND N1672 FAILED TO TEST. . REPLACED THE BATTERY PACKS. AIRCRAFT WAS GROUNDED.SDR AALA201705059003Battery Pack · no testM1671 EMERGENCY LIGHT BATTERY PACK FAILED TO TEST. REPLACED THE BATTERY PACK IAW AMM 33-51-06. AIRCRAFT WAS GROUNDED.SDR AALA201705059002Battery Pack · no testEMERGENCY LIGHT BATTERY PACK FAILED TO TEST. REPLACED THE BATTERY PACK M1695 IAW AMM 33-51-06. AIRCRAFT WAS GROUNDED.SDR AALA201705059001Battery Pack · dischargedL1 DOOR UPPER AND LOWER EMERGENCY LIGHT EXIT SIGNS FAILED. FULLY CHARGED BATTERY PACKS IAW AMM TASK 33-51-06. ALL LIGHTS CHECKED GOOD. AIRCRAFT WAS GROUNDED.SDR AALA20170503013Sign · brokenR2 DOOR EXIT SIGN BROKEN, REPLACED THE SIGN ASSY IAW AMM 33-51-01. REPLACED EXIT SIGN ASSY IAW AMM 33-51-01.SDR AALA20170503004Lens · missingAIRCRAFT WAS NOT GROUNDED. SIDEWALL EMERGENCY EXIT LIGHT LEFT FORWARD OVERWING HAS A MISSING LENS COVER. INSTALLED LENS COVER IAW AMM 33-51-11. OPERATIONAL CHECK GOOD.SDR SWAA2017050413574Battery · dischargedRT OVERWING EMERGENCY LIGHT INOP. R&R BATTERY PER AMM.SDR SWAA2017050413568Light · inoperativeFORWARD ENTRY DOOR EXTERIOR FUSELAGE EMERGENCY EXIT LIGHT INOP. R&R LIGHT PER AMM.SDR SWAA2017050413561Lens · missingMID CABIN OVERHEAD EXIT SIGN LENS MISSING. REINSTALLED LENS PER SIP.SDR DALA2017050403558Socket · defectiveCABIN EMERGENCY LIGHT WILL NOT ILLUMINATE AT 16E REPLACED LIGHT SOCKET ASSEMBLY. SYSTEM OPERATION IS NORMAL.SDR SIMA20170502001Connector · unsecureAFT EMERGENCY FLOOR LIGHTING INOPERATIVE. SECURED INVERTER CONNECTOR. OPS CHECKED GOOD IAW AMM 33-50-11.SDR AALA201705039003Light · brokenAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT PATH LIGHTING LENS IS BROKEN AT LAVATORY L. REPLACED EMERGENCY PROXIMITY LIGHT PER AMM 33-51-18.SDR AALA201705039002Light · brokenAIRCRAFT WAS NOT GROUNDED. DOOR R1 EMERGENCY EXIT SIGN IS BROKEN OFF LOWER FASTENER. REPLACED R1 DOOR EMERGENCY EXIT LIGHT ASSEMBLY PER AMM 33-51-13.SDR AALA201705039001Power Supply · inoperativeAIRCRAFT WAS GROUNDED. EMERGENCY EXIT LIGHTS ILLUMINATED OVER ALL DOORS EXITS AND OVER WINGS UPON POWER TRANSFER (STAY ON WHEN TURNED OFF). MAINTENANCE FOUND EMERGENCY POWER SUPPLY UNIT FORWARD L (10WL) AT FAULT. REPLACED 10WL POWER SUPPLY PER AMM 33-51-38.SDR AALA201705039019Light · damagedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT AT SEAT 11D IS DAMAGED. REMOVED AND REPLACED LIGHT ASSEMBLY IAW ESO 41072 AND CMM 25-29-95. OPERATIONAL CHECK GOOD.SDR AALA201705039016Light · unsecureAIRCRAFT WAS NOT GROUNDED. EMERGENCY ESCAPE PATH FLOOR LIGHTS AT ROWS 18 AND 19 ARE COMING UP. RESECURED CARPET AND FLOOR TRACK. OPERATIONAL CHECK GOOD.SDR AALA201705039039Lens · missingLOWER EXIT LENS AT THE L4 DOOR 4L MISSING. REPLACED EXIT LIGHT THE. CHECKED GOOD.SDR AALA201705039037Lens · brokenSEAT MOUNTED EMERGENCY LIGHT COVER BROKEN AT SEAT 12L.SDR FDEA201705021333Lamp · inoperativeRT AFT EMERGENCY EXIT LIGHT INOPERATIVE. REPLACED THE LAMP AND OPS CHECKED GOOD IAW AMM 33-51-00-5. ACFT OK FOR SERVICE.SDR HNAA2017042500146Bulb · inoperativeGREEN LIGHT ON EMERGENCY LIGHT SWITCH AT FLIGHT ATTENDANT PANEL INOPERATIVE. R & R THE BULB.SDR HNAA2017042500145Bulb · inoperativeEMERGENCY LIGHTS INOPERATIVE. R & R THE BULBS.SDR HNAA2017042500144Connector · not seatedCOCKPIT STAIR EMERGENCY EXIT LIGHT WILL NOT ILLUMINATE. RESEATED THE CONNECTOR ON THE EMERGENCY LIGHT.SDR HNAA2017042500142Inverter · inoperativeSEAT 12A LT SIDE MAIN EMERGENCY EXIT LIGHT WILL NOT ILLUMINATE. REMOVED AND INSTALLED A NEW INVERTER IAW AMM 33-50-11-04.SDR DALA2017050303540Sign · looseEXIT SIGN AT 1LT DOOR LOOSE. 1L EXIT SIGN SECURED.SDR JJBA20170502002Battery Pack · dischargedALL EMERGENCY LIGHT BATTERIES DRAINED. R & R THE BATTERY PACKS. CHECK SATISFACTORY, NO DEFECTS NOTED.SDR DALA2017050203581Lens · missingDURING INSPECTION, FOUND EMERGENCY EXIT COVER DIFFUSER LENS MISSING. MAINTENANCE INSTALLED THE LENS. OPS NORMAL.SDR AALA201705049026Lens · detachedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN OUTSIDE THE COCKPIT DOOR ON THE CEILING HAS A DETACHED LENS COVER. INSTALLED LENS COVER. OPERATIONAL CHECK GOOD.SDR SWAA2017050413575Light · inoperativeLT EMERGENCY EXIT CEILING LIGHT INOP. R&R LIGHT ASSEMBLY PER MM.SDR SWAA2017050413569Light · out of positionCENTER EMERGENCY OVERHEAD LIGHT OUT OF POSITION. REPOSITIONED LIGHT PER AMM.SDR SWAA2017050413565Charger · brokenFORWARD RT BATTERY CHARGER NUT PLATE BROKEN. R&R CHARGER PER AMM.SDR SWAA2017050413564Battery · failedFORWARD RT BATTERY FAILED TIME TEST. R&R BATTERY PER AMM.SDR SWAA2017050413563Battery · failedRT CENTER BATTERY FAILED TIME TEST. R&R BATTERY PER AMM.SDR DALA2017050303560Socket · looseEMERGENCY ESCAPE PATH MARKER AT SEAT 37HJ IS INOPERATIVE. MAINTENANCE FOUND A SOCKET LOOSE AND LAMPS AND LENS MISSING AND REPLACED. SYSTEM OPERATION IS NORMAL.SDR AALA201705039034Lens · missingL1 DOOR EXIT LIGHT LENS MISSING. REPLACED L1 DOOR LIGHT LENS.SDR FDEA201705011302Battery Pack · no testRH EMERGENCY EXIT LIGHTS NOT TESTING. REMOVED AND REPLACED THE M730 POWER SUPPLY BATTERY PACK IAW AMM 33-51-07-2, OPS CHECKED GOODSDR SWAA2017050313556Lens · brokenRIGHT FORWARD GALLEY FLOOR EXIT LIGHT LENS BROKEN. R & R THE LENS IAW MM.SDR SWAA2017050313553Lens · detachedEMERGENCY EXIT LIGHT LENS FELL OFF. SECURED THE LENS IAW AMM.SDR SWAA2017050313543Light · inoperativeRIGHT STORAGE BIN EMERGENCY LIGHT INOPERATIVE BETWEEN ROWS 12 AND 16. REPAIRED THE LIGHT PER MM.SDR AALA201705029043Light · inoperativeAIRCRAFT WAS NOT GROUNDED. EMERGENCY ESCAPE PATH AISLE LIGHT AT SEAT 7J IS INOPERATIVE. REMOVED AND REPLACED LIGHT ASSEMBLY IAW AMM 33-51-05. OPERATIONAL CHECK GOOD.SDR AALA201705029039Lens · detachedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN OUTSIDE THE COCKPIT DOOR ON THE CEILING HAS A DETACHED LENS COVER. INSTALLED LENS COVER. OPERATIONAL CHECK GOOD.SDR AALA201705029036Lens · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY LIGHT LENS MISSING OUTSIDE OF LAV L53. INSTALLED EMERGENCY LIGHT LENS AT LAV L53.SDR DALA2017050200165Lens · damagedEMERGENCY EXIT COVER DIFFUSER LENS DAMAGED AT LOC 605. REPLACED EMERGENCY EXIT LENS AT LOC 605.SDR SWAA2017050213491Bulb · inoperativeRIGHT FORWARD OVERWING EMERGENCY EXIT LIGHT INOPERATIVE. R & R THE BULB IAW AMM.SDR AALA201705029033Lens · crackedR4 DOOR EMERGENCY LIGHT LENS CRACKED. REPLACED LENS AS REQUIREDSDR AALA201705029032Bezel · detachedSMALL EXIT SIGN LIGHT BEZEL AFT LEFT DOOR DETACHED. REPLACED AFT RIGHT DOOR EXIT LIGHT BEZEL.SDR AALA201705029029Bulb · inoperativeEMERCENCY LIGHT AT 11D HAS BAD BULB. REPLACED THE BULB.SDR AALA201705029028Lens · brokenROW 14A LOWER EMERGENCY EXIT LIGHT COVER PLASTIC TAB BROKEN. REPLACED EMERGENCY LIGHT LENS AT SEAT 14A.SDR MASA2017050112764Light · inoperativeROW 6 EMERGENCY CEILING LIGHT INOP. PLACED ON MEL.SDR MASA2017050112763Light · inoperativeAFT CEILING FLOOD LIGHT INOPERATIVE. REPLACED BULB.
Back to JASC 3350