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 DALA2017022201501Lens · detachedDURING INSPECTION, FOUND EMERGENCY LIGHT LENS DETACHED FROM THE WALL. SECURED THE LENS. OK FOR SERVICE.SDR DALA2017022301497Lens · looseEMERGENCY SEAT MOUNTED LIGHT DAMAGED. SECURED EMERGENCY LIGHT LENS IAW AMM 33-50. OPS CHECKED GOOD. OK FOR SERVICE.SDR AALA201702229003Light · damagedSEAT MOUNTED EMERGENCY LIGHT HOLDER DAMAGED SEAT ROW 17 LEFT. REPLACED EMERGENCY LIGHT HOUSING.SDR AALA201702229002Lens · damagedPLASTIC EMERGENCY EXT LIGHT COVER CAME OFF AT THE L1 DOOR. REPLACED THE DAMAGED LENS.SDR SWAA2017022212011Cover · missingLT NEAR AFT LAVATORY EMERGENCY EXIT SIGN LIGHT COVER MISSING. R&R COVER IAW MM & SIP.SDR SIMA20170221003Inverter · inoperativeEMERGENCY LIGHT/SIGN JUST ABOVE THE SERVICE DOOR IS INOP. R&R N R2 EMERGENCY LIGHT INVERTER, OPC GOOD, IAW AMM 30-50-11.SDR SIMA20170221004Light · inoperativeRT EXTERNAL AFT EMERGENCY LT INOP. REMOVED AND REPLACED RT EXTERNAL AFT EMERGENCY LT LAMP IAW AMM 33-50-10-000-801-A AND 33-50-10-400-801-A. OPC GOOD AT THIS TIME.SDR HALA2017022100042Light · unsecureEMERGENCY LIGHT NEAR 3H IS LIFTING UP. SECURED LIGHT. OK FOR SERVICE.SDR DALA2017022201469Sign · unsecureEXIT SIGN OVER DOOR 2R FELL OFF. RE-INSTALLED EXIT SIGN, A/C OK FOR SERVICE PER AMM 33-24-00.SDR DALA2017022201466Power Supply · inoperativeEMER EXTERIOR LITE AT DR4R IS OUT. REPLACED EMER EXIT SLIDE LT PWR SUPPLY PER AMM 33-51, THEN CHECKED & OK FOR SERVICE.SDR IPXA2017022114294Power Supply · inoperativeDURING EMERGENCY POWER TEST, BATTERY 1 LOW ALERT. R & R EMERGENCY LIGHT POWER SUPPLY IAW AMM 33-51-01-400-802. PERFORMED AN OPS CHECK IAW AMM 33-50-00-700-802. OPS CHECKED GOOD.SDR FDEA201702210622Battery Pack · no testEMERGENCY LIGHT TEST FAILED IAW SERVICE CHECK. TROUBLESHOT IAW TSM 33-51-00 FIG 107, FOUND POWER SUPPLY 29WL FAILING PRESS TO TEST, REMOVED AND REPLACED THE BATTER PACK IAW AMM 33-51-14-04, OPS CHECKED GOOD IAW AMM 33-51-00-05.SDR KCSA201702211010Light · inoperativeUPPER DECK EMERGENCY LIGHTS BOTH L- AND R- AT DOOR CENTER AFT INOP. NO TEST OR ON.SDR KCSA201702211009Light · illuminatedUPPER DECK EMERGENCY LIGHTS AT UPPER DECK DOORS AND CENTER CEILING DROP DOWN STAY ON WITH POWER OFF AND SWITCH OFF.SDR KCSA201702211008Light · inoperativeUPPER DECK EMERGENCY LIGHTS CENTER BETWEEN DOORS AND BELOW BEACON DO NOT TEST.SDR KCSA201702211007Light · inoperativeUPPER DECK R - DOOR FWD EMERGENCY LIGHT IN DOOR INOP.SDR KCSA201702211006Light · inoperativeUPPER DECK L - DOOR FWD EMERGENCY LIGHT IN DOOR INOP.SDR KCSA201702211005Light · inoperativeMAIN DECK CARGO EMERGENCY LIGHT AT L1 DOOR INOP.SDR MASA2017022112621Lamp · inoperativeONE LAMP INOPERATIVE AT THE RT OVERWING EMERGENCY EXIT SIGN. REPLACED THE LAMPS.SDR DALA2017022101389Light · inoperativeDURING A LINE CHECK, MAINTENANCE FOUND THAT THE RIGHT WING EXTERIOR EMERGENCY FLOOD LIGHT WAS INOPERATIVE. MAINTENANCE REPLACED THE LIGHT ASSEMBLY AND PERFORMED A SATISFACTORY FUNCTIONAL CHECK.SDR HALA2017022100084Light · unsecureL2 DOOR JUMPSEAT EMERGENCY LIGHT NOT SECURED. SECURED LIGHT STRIP.SDR SWAA2017022712079Lens · looseFORWARD EMERGENCY EXIT SIGN LENS LOOSE. SECURED THE LENS IAW EA.SDR AALA20170223013Battery Pack · dischargedAIRCRAFT WAS NOT GROUNDED. SEAT MOUNTED EMERGENCY ESCAPE PATH LIGHTS ON SEATS 16DEF THROUGH 25DEF FAILED TEST. REMOVED AND REPLACED BATTERY PACK OVER SEAT 19D IAW AMM 33-51-07. OPERATIONAL CHECK GOOD.SDR AALA20170223011Battery Pack · dischargedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGNS AT L1/R1 DOORS AND SEAT MOUNTED EMERGENCY ESCAPE PATH LIGHTS IN FIRST CLASS FAILED TEST. REMOVED AND REPLACED BATTERY PACK AT L1 DOOR IAW AMM 33-51-07. OPERATIONAL CHECK GOOD.SDR AALA20170222039Plug · missingAIRCRAFT WAS IN BASE MAINTENANCE. EMERGENCY EXIT AISLE SIGN AT L3 DOOR IS MISSING THE INBOARD DECORATIVE PLUG. REMOVED AND REPLACED PLUG IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20170222036Plate · missingAIRCRAFT WAS IN BASE MAINTENANCE. EMERGENCY EXIT AISLE SIGN AT R2 DOOR IS MISSING THE OUTBOARD INDEX PLATE. REMOVED AND REPLACED PLATE IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20170222035Plug · missingAIRCRAFT WAS IN BASE MAINTENANCE. EMERGENCY EXIT AISLE SIGN AT L2 DOOR IS MISSING THE INBOARD DECORATIVE PLUG. REMOVED AND REPLACED PLUG IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR SWAA2017022312050Fuse · blownRT BULLNOSE EMERGENCY LIGHT INOP BETWEEN ROWS 8 TO ROW 9. R&R FUSE PER AMM.SDR SWAA2017022312045Lens · brokenL1 DOOR EXIT SIGN LENS COVER BROKEN. R&R COVER PER AMM.SDR R61A201702200172Light · missingCREW REPORTED THAT A SIX INCH STRIP OF THE EMERGENCY LIGHT STRIP WAS MISSING AT SEAT 2A. INSTALLED THE LIGHT STRIP IAW AMM AND OPS CHECKED GOOD.SDR SWAA2017022211924Light · inoperativeRIGHT AFT EMERGENCY EXIT SIDEWALL LIGHT INOPERATIVE. R & R THE LIGHT IAW MM.SDR AALA20170222027Light · damagedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT IN THE FORWARD HALLWAY ON THE G2 GALLEY WALL IS DAMAGED. REMOVED AND REPLACED LIGHT ASSEMBLY IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20170222026Portable Light · faultyAIRCRAFT WAS NOT GROUNDED. EMERGENCY PORTABLE LIGHT AT L1 DOOR IS ON WHILE IN THE OFF POSITION. REMOVED AND REPLACED LIGHT IAW AMM 33-53-00. OPERATIONAL CHECK GOOD.SDR AALA20170222022Lens · detachedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN BY R4 DOOR HAS A DETACHED LENS COVER. REPLACED EXIT SIGN IAW AMM 33-50-00. OPERATIONAL CHECK GOOD.SDR SIMA20170220002Charger · inoperativeLT OVERWING EMERGENCY LIGHT INOP. R&R BATTERY CHARGER NR 4 IAW AMM 33-50-04. R&R BATTERY PACK NR 4 IAW AMM 33-50-04. OPS CK OF EMERGENCY LIGHTS GOOD. NO FURTHUR DEFECTS NOTED. EMERGENCY LIGHTING BATTERY P/N 2013-1A S/N 68896SDR ASAA2017022019885Lens · brokenFWD ENTRY FLOOR LIGHT BY L1 DOOR LENS BROKEN. ACFT GROUNDED. REPLACED THE LENS.SDR ASAA2017022019884Lamp · inoperativeL2 DOOR SLIDE EMERGENCY LIGHT INOPERATIVE. ACFT GROUNDED. REPLACED THE LAMPS IAW AMM 33-51-04. OPS CHECKED GOOD.SDR A6WA2017022244809Light · inoperativePRIOR TO FIRST FLIGHT OF THE DAY, CREW REPORTED THAT THE EMERGENCY LIGHTS DID NOT WORK AFT OF ROW 8. ROW 9 THROUGH 12 ARE NOT WORKING.SDR SIMA20170220003Charger · inoperativeNR 2 AND 3 EMERGENCY LIGHTS AND AFT GALLEY EMERGENCY EXIT SIGN INOPERATIVE. REMOVED AND REPLACED NR 2 EMERGENCY LIGHT BATTERY AND CHARGER IAW W/C 33-700-19. OPS CHECKED GOOD IAW W/C 33-700-17.SDR SIMA20170220001Warning Light · false activationDURING FLT EMERGENCY LIGHTS ON CAUTION ON EICAS. PERFORMED OPERATIONAL TEST OF EMERGENCY LIGHTING IAW AMM33-50-00. OPS CHECKED GOODSDR AALA201702219015Lens · missingSEAT ROW 8 LEFT RED EMERGENCY LIGHT LENS MISSING. REPLACED THE LENS. AIRCRAFT GROUNDED.SDR AALA201702219014Fixture · detachedSEAT 21C EMERGENCY LIGHT FIXTURE DETACHED FROM SEAT. SECURED THE FIXTURE.SDR AALA201702219012Lens · detachedEMERGENCY LIGHT LENS AT 8C IS OFF. REPLACED THE LENS.SDR AALA201702219011Light · brokenEMERGENCY SEAT EXIT ROW 10C LIGHT BROKEN. REMOVED AND REPLACED THE EMERGENCY LIGHT.SDR AALA201702219003Lens · missingEMERGENCY EXIT MARKER AT THE R1 DOOR MISSING THE LENS. INSTALLED THE LENS.SDR AALA20170220007Light · brokenAIRCRAFT IN BASE MAINTENANCE. EMERGENCY EXIT FLOOR PROXIMITY LIGHT ASSEMBLY RIGHT FORWARD G3 GALLEY IS BROKEN. REMOVED AND REPLACED LIGHT ASSEMBLY IAW AMM 33-51-05. OPERATIONAL CHECK GOOD.SDR CALA2017022000439Power Supply · inoperativeBATTERY EMERG POWER SUPPLY ON RT INOP. REPLACED BATTERY EMERG POWER SUPPLY IAW AMM 33-51-38-000-001-A, AND 33-51-38-400-001-A. OPERATIONAL TEST OK.SDR CALA2017022000437Battery · dischargedINTERIOR AND EXTERIOR EMERG LIGHTS DO NOT OPERATE AT DOOR 1R. REPLACED DOOR 1 RIGHT EMERGENCY BATTERY.SDR CALA2017022000436Power Supply · inoperativeEMERGENCY LIGHTS ON LEFT SIDE ROW 21 INOP. R&R POWER SUPPLY IAW AMM33-51-06-960-806. OPS CK OK.SDR CALA2017022000435Light · inoperativeL2 DOOR EMERGENCY ESCAPE SLIDE LIGHT INOP. RELAMPED L2 DOOR ESCAPE SLIDE LIGHT. OP CHK GOOD. REF AMM 33-51-04.
Back to JASC 3350