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 CALA2017021000320Lens · missingEMERGENCY EXIT SIGN BY R2 DOOR MISSING. REPLACED MISSING LENS OPS CHECKED GOOD.SDR CALA2017021000318Sign · missingL2 DOOR EXIT SIGN IS MISSING. INSTALLED NEW EMERGENCY EXIT SIGN.SDR CALA2017021000317Lens · missingEMERGENCY LIGHT LENS COVER MISSING OVER 1B, SECURED THE EMERGENCY LIGHT LENS COVER AT SEAT 1BSDR JJBA20170210009Lamp · inoperativeEMERGENCY LIGHT OVER MAIN CABIN DOOR IS DIM. REPLACED THE LAMPS. OPS CHECKED GOOD.SDR R61A201702090180Cap · missingWHILE IN HEAVY CHECK, MAINTENANCE FOUND RIGHT NR 2 EMERGENCY LIGHT END CAP MISSING. MAINTENANCE INSTALLED END CAP IAW AMM AND OPS CHECKED GOOD.SDR R61A201702090179Light · inoperativeWHILE IN HEAVY CHECK, MAINTENANCE FOUND RIGHT NR 1 EMERGENCY LIGHT STRIP INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE EMERGENCY LIGHT IAW AMM AND OPS CHECKED GOOD.SDR SWAA2017022712087Lens · brokenGALLEY EMERGENCY EXIT LIGHT LENS BROKEN. R & R LIGHT IAW AMM.SDR SWAA2017022312052Sign · brokenFORWARD GALLEY AREA EMERGENCY EXIT SIGN ASSEMBLY BROKEN. R&R SIGN ASSEMBLY IAW AMM.SDR SWAA2017022212014Cover · missingR2 DOOR EMERGENCY EXIT LIGHT COVER MISSING. R&R LIGHT BASE PER MM.SDR SWAA2017021411855Cover · unsecureMID-CABIN CEILING EXIT LIGHT LENS COVER FELL OFF. REINSTALLED COVER IAW SIP.SDR HALA2017021000020Sign · looseL3 DOOR EXIT SIGN LOOSE. SECURED THE SIGN.SDR SWAA2017021311840Battery Pack · no testEMERGENCY LIGHT BATTERY PACKS FAILED CAPACITY CHECK AT LOCATION M1669. R & R THE BATTERY PACK IAW MM.SDR SWAA2017021311839Battery Pack · no testEMERGENCY LIGHT BATTERY PACKS FAILED CAPACITY CHECK AT LOCATION M1675. R & R THE BATTERY PACK IAW MM.SDR SWAA2017021311838Battery Pack · no testEMERGENCY LIGHT BATTERY PACKS FAILED CAPACITY CHECK AT LOCATION M1672. R & R THE BATTERY PACK IAW MM.SDR SWAA2017021311830Lens · missingRIGHT EMERGENCY EXIT LIGHT LENS COVER MISSING AT ROW 12. REPLACED THE LENS IAW AMM.SDR SWAA2017021311816Light · inoperativeFORWARD, RIGHT EMERGENCY LIGHT INOPERATIVE AT ROW 1. R & R THE LIGHT IAW AMM.SDR SWAA2017021311801Battery Pack · no testEMERGENCY LIGHT BATTERY PACKS FAILED CAPACITY CHECK AT LOCATION M1674. R & R THE BATTERY PACK IAW MM.SDR DALA2017021001184Battery Pack · inoperativeSEAT ROW 34-35 LT OVERHEAD EMERGENCY LIGHTS INOPERATIVE. REMOVED AND REPLACED THE BATTERY PACK IAW AMM 33-51-07. OPS CHECKED OK.SDR AALA201702109005Light · detachedFLIGHT ATTENDANT REPORTED EMERGENCY BULL NOSE LIGHT HANGING DOWN AT 33C. MAINTENANCE SECURED THE LIGHT AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA20170213019Lens · detachedEMERGENCY EXIT SIGN AT THE R2 DOOR HAS A DETACHED LENS COVER. INSTALLED THE LENS. OPS CHECKED GOOD.SDR AALA20170213007Lens · missingEMERGENCY EXIT SIGN OVER LEFT AFT DOOR HAS A MISSING LENS COVER. REINSTALLED LENS IAW AMM 33-51-04. OPS CHECKED GOOD.SDR AALA20170212010Battery Pack · failedEMERGENCY LIGHT POWER SUPPLY UNIT AT 11WL FAILED TEST. REMOVED AND REPLACED THE BATTERY PACK IAW AMM 33-51-38. OPS CHECKED GOOD.SDR CALA2017021000309Battery Pack · faultyEMERGENCY LIGHT BATTERY PACK AT RT AFT EXIT DOOR NOT HOLDING CHARGE. REMOVED AND REPLACED EMERGENCY LIGHT BATTERY PACK AT RIGHT HAND AFT EXIT DOOR IAW AMM 33-51-06-960-805. OPS CHECKS GOOD IAW AMM 33-51-00-710-801.SDR CALA2017021000307Battery Pack · no testFOUND BATTERY PACK RUN TIME LESS THAN 15 MINUTES. REPLACED THE BATTERY PACKS. CHECKED NORMAL IAW AMM33-51-06-960-802, 33-51- 06-960-803, 33-51-06-200-801, AND 33-51-00-7110-801.SDR CALA2017021000306Battery Pack · dischargedFOUND L2 DOOR EMERGENCY LIGHT BATTERY PACK RUN TIME LESS THAN IS 15 MIN. REPLACEDTHE BATTERY PACK AND CHECKED NORMAL IAW AMM33-51-06-960-802, AND 33-51-00-710-801.SDR CALA2017021000305Battery Pack · inoperativeDURING SYSTEM CHECK FOUND AN EMERGENCY LIGHT INOPERATIVE. REPLACED THE BATTERY AND OPS TEST FOUND NORMAL IAW AMM33-51-06-960-802, AND 33-51-00-71 0-801 REV.78.SDR AALA20170210021Sign · detachedEMERGENCY EXIT SIGN NEAR FLOOR ADJACENT TO THE FORWARD LAVATORY IS DETACHED. INSTALLED LIGHT ASSEMBLY IAW AMM 33-53-01. OPERATIONAL CHECKED GOOD. AIRCRAFT WAS GROUNDED.SDR AALA20170209005Lens · brokenEMERGENCY EXIT PROXIMITY FLOODLIGHT ON THE FORWARD GALLEY WALL HAS A BROKEN LENS COVER. REMOVED AND REPLACED THE FLOODLIGHT ASSEMBLY IAW AMM 33-51-14. OPS CHECKED GOOD.SDR AALA20170209004Battery Pack · failedEMERGENCY EXIT LIGHTS FOR LEFT AND RIGHT OVERWING EXITS FAILED TEST. REMOVED AND REPLACED THE BATTERY IAW AMM 33-53-00. OPS CHECKED GOOD.SDR AALA20170209001Light · inoperativeEMERGENCY PORTABLE LIGHT IS INOPERATIVE. REMOVED AND REPLACED THE LIGHT IAW AMM 33-53-00. OPS CHECKED GOOD.SDR C77A20170210003Fuse · failedFWD CABIN CEILING EMERGENCY LIGHT INOPERATIVE. R & R THE ELPU 2 FUSE IAW SMPE 17X-33-002, REV IR, AND OPS CHECKED IAW AMM 33-50-00, CHECKED GOOD, OK FOR SERVICE.SDR AALA201702109007Lens · detachedEMERGENCY EXIT LIGHT LENS AT THE R4 DOOR FELL OFF. REPLACED THE LENS.SDR AALA201702109006Lens · missingEMERGENCY EXIT LIGHT LENS COVER MISSING R2 DOOR. REPLACED LENS.SDR FDEA201702090493Cover · missingCOVER FOR EXIT LIGHT ON LEFT SIDE OF L1 DOOR IS MISSING, INSTALLED A NEW EMERGENCY EXIT LIGHT COVER.SDR FDEA201702090492Cover · missingCOVER FOR THE EXIT LIGHT ON THE LT SIDE OF THE L1 DOOR IS MISSING. INSTALLED THE EXIT SIGN ASSY AND COVER SMP. LIGHT CHECKED OK.SDR DALA2017020901091Battery · unsecureLEFT AND RIGHT AFT OVERWING EXIT SIGNS DO NOT TEST. RESECURED R5-212 BATTERY IN PACK, OPS CHECK NORM. A/C OK FOR SVC PER AMM 33-55.SDR SWAA2017021511889Light · inoperativeLEFT OVERWING EXIT SIDEWALL LIGHT INOPERATIVE. R & R THE LIGHT ASSEMBLY IAW AMM.SDR SWAA2017021311836Battery Pack · no testEMERGENCY LIGHT BATTERIES FAILED CAPACITY CHECK AT LOCATION M1669. R & R THE BATTERY PACK IAW AMM.SDR SWAA2017021311829Lens · looseRIGHT OVERWING EXIT SIGN LENS LOOSE. SECURED THE LENS IAW AMM.SDR SWAA2017021311827Lens · brokenFORWARD ENTRY EMERGENCY LIGHT LENS BROKEN. R & R THE LIGHT ASSEMBLY IAW MM.SDR SWAA2017021311824Battery Pack · no testFORWARD LEFT EMERGENCY BATTERY PACK FAILED CAPACITY CHECK. R & R THE BATTERY PACK IAW MM.SDR SWAA2017021311815Light · brokenL2 DOOR EMERGENCY EXIT LIGHT ASSEMBLY BROKEN. R & R THE LIGHT ASSEMBLY IAW AMM.SDR SWAA2017021311813Battery Pack · no testEMERGENCY LIGHT BATTERIES FAILED CAPACITY CHECK AT LOCATION M1672. R & R THE BATTERY PACK IAW AMM.SDR SWAA2017021311811Battery Pack · inoperativeLEFT OVERHEAD BULLNOSE EMERGENCY LIGHT, INOPERATIVE BETWEEN ROWS 10 TO 18. R & R THE BATTERY PACK IAW AMM.SDR SWAA2017021311799Light · brokenLEFT EMERGENCY EXIT HATCH, EMERGENCY LIGHT LENS BROKEN. R & R THE LIGHT ASSY IAW MM.SDR SWAA2017021311795Sign · wrong partL2 DOOR EXIT SIGN ARROW MISSING. R & R THE SIGN IAW AMM.SDR SWAA2017021311794Sign · wrong partL1 DOOR EXIT SIGN ARROW MISSING. R & R THE SIGN IAW AMM.SDR DALA2017020801180Bulb · inoperativeR2 DOOR EMERGENCY LIGHT SIGN ABOVE DOOR, ONE BULB INOPERATIVE, REPLACED THE BULB.SDR AALA20170210010Sign · detachedEMERGENCY EXIT SIGN AT R2 DOOR IS DETACHED. REPLACED EXIT SIGN LIGHT ASSEMBLY IAW AMM 33-51-00. OPERATIONAL CHECKED GOOD.SDR AALA20170210009Lens · detachedEMERGENCY EXIT LIGHT AT R2 DOOR HAS A DETACHED LENS COVER. SECURED THE LENS COVER IAW AMM 33-51-00. OPERATIONAL CHECKED GOOD.
Back to JASC 3350