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 AALA20170420001Battery Pack · dischargedFOUND SEAT MOUNTED ESCAPE PATH LIGHTING SYSTEM INOP FROM 21DEF TO 31DEF, REPLACED BATTERY PACK. NO FURTHER FAULTS NOTED. OPS CHECK GOOD. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA201704209001Light · brokenROW 20R AISLE EMERGENCY LIGHT BROKEN. REPLACED SEAT MOUNTED LIGHT AT SEAT 20 RIGHT.SDR REXA2017041900525Sign · inoperativeFOUND LIGHTED EXIT SIGN FLOOR LEVEL AT MAIN ENTRANCE ON LEFT, INOPERATIVE. REMOVED AND REPLACED THE SIGN IAW AMM 33-51-10. OPS CHECKED GOOD.SDR BJNA20170419004Power Supply · inoperativeDURING EMERGENCY LIGHT TEST FOUND FWD LT EMERGENCY OVERHEAD BIN LIGHTS INOP. TROUBLESHOOTING WAS PERFORMED TO BATTERY POWER ASSY. REMOVED AND REPLACED LT FWD EMERGENCY BATTERY POWER SUPPLY ASSY ACCORDING AMM 33-51-51.SDR QXEA2017041900277Light · looseSEVERAL AREAS OF EMERGENCY LIGHT STRIPS ARE LOOSE IN THE MCD ENTRANCE AREA. REPAIRED AS REQUIRED.SDR DALA2017041903183Light · malfunctionedDURING LANDING, FLIGHT ATTENDANT REPORTED THE EMERGENCY LIGHTS CAME ON BRIEFLY, TWICE. MAINTENANCE PERFORMED AN OPS CHECK IAW FIM 33-50-00 810-801. IAW THE FIM IT WAS AN INTERMITTENT FAULT. NO PREVIOUS HISTORY, OK FOR SERVICE.SDR YENA201704190288Power Supply · inoperativeROW 19 EMERGENCY LIGHT INOPERATIVE. R & R THE POWER SUPPLY UNIT IAW AMM 33-51-00, OPS CHECKED OK.SDR JJBA20170419011Bulb · inoperativeCEILING EMERGENCY LIGHT INOPERATIVE. R & R THE BULBS. OPS CHECKED SAT.SDR YENA201704190287Power Supply · no testEPSU (12WL) FAILED CAPACITY CHECK IAW T/C 33-51-00-710-003. R & R THE EPSU IAW AMM 33-51-38. OPS CHECKED GOOD.SDR SIMA20170418005Light · dimFORWARD FLOOR EMERG LIGHT STRIP DIM. REMOVED AND REPLACED FORWARD FLOOR EMERG LIGHT STRIP IAW AMM 32-50-12; OPS CK GOOD.SDR SIMA20170418003Lamp · inoperativeRIGHT WING EMERGENCY LIGHT INOPERATIVE. R & R RIGHT EMERGENCY LAMP IAW AMM 33-50-10. OPS CHECKED GOOD.SDR SIMA20170418002Lamp · dimMAIN DOOR EMERGENCY LIGHT DIM. R & R DOOR EMERGENCY LAMP IAW AMM 33-50-10.OPS CHECKED GOOD.SDR CALA2017042101059Light · inoperativeSEAT 36D EMERGENCY LIGHT INOPERATIVE. SEAT 36D EMERGENCY LIGHT REPLACED & FUNCTIONAL TESTED GOOD IAW AMM 33-51-00-710-801, REV.79.SDR AALA201704209004Light · crackedCRACKED LOWER EMERGENCY LIGHT AT R4 DOOR. REPLACED EMERGENCY LIGHT ASSEMBLY IAW MM 33-51-13.SDR AALA201704209003Light · crackedCRACKED LOWER EMERGENCY LIGHT AT L1 DOOR. REPLACED EMERGENCY LIGHT ASSEMBLY BY L1 DOOR IAW MM 33-51-13.SDR SWAA2017042113289Light · brokenR1 DOOR EXIT LIGHT BROKEN. R & R EXIT LIGHT ASSY IAW MM.SDR AALA201704199019Cover · missingEMERGENCY EXIT LIGHT COVER FOR THE AFT SERVICE ENTRY DOOR IS MISSING. REPLACED ALL LIGHT ASSEMBLY AND PERFORMED TEST REQUIRED IAW AMM 33-51-00.OPS CHECK NORMAL. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA201704199018Cover · unsecureFWD GALLEY A/C RIGHT EMERGENCY EXIT LIGHT COVER NEEDS RESECURING. REMOVED & REPLACED LIGHT ASSY IAW MM 33-51-01 OPS CKS NORMAL. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA20170418006Light · crackedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT FLOOR PROXIMITY AISLE LIGHT AT SEAT 21HJ IS CRACKED. REMOVED AND REPLACED LIGHT ASSEMBLY IAW AMM 33-51-09. OPERATIONAL CHECK GOOD.SDR AALA201704209013Lens · detachedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN AT L4 DOOR HAS A DETACHED LENS COVER. REATTACHED LENS COVER . OPERATIONAL CHECK GOOD.SDR AALA201704199010Lens · detachedEMERGENCY LIGHT AT THE L4 DOOR HAS A DETACHED LENS COVER. REINSTALLED LENS COVER IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR SWAA2017042013270Battery Pack · failedINTERIOR EMERGENCY LIGHTS FAILED CAPACITY TEST AT LOCATION M1674. R&R BATTERY PACK PER MM.SDR SWAA2017042013269Battery Pack · failedINTERIOR EMERGENCY LIGHTS FAILED CAPACITY TEST AT LOCATION M1675. R&R BATTERY PACK PER MM.SDR SWAA2017042013265Battery Pack · failedINTERIOR EMERGENCY LIGHTS FAILED CAPACITY TEST AT LOCATION M1672. R&R BATTERY PACK PER MM.SDR SWAA2017042013257Light · inoperativeLT OVER WING EMERGENCY EXIT LIGHT BULB INOP. R&R BULB IAW AMM.SDR SWAA2017042013256Light · inoperativeAFT ENTRY EMERGENCY EXIT LIGHT BULB INOP. R&R BULB IAW AMM.SDR U2RA201704180001Light · inoperativeEXTERIOR EMERGENCY LIGHT AT R3 DOOR IS INOPERATIVE. REPLACED LAMP AT EXTERNAL EMERGENCY LIGHT AT R3 DOOR PER MM 33-51-06.SDR IPXA2017041816252Switch · inoperativeEMERGENCY LIGHT SWITCH ON OVERHEAD PANEL DOES NOT STAY ON WITH SWITCH COVER CLOSED. R & R GUARDED SWITCH COVER IAW AMM 33-51-08SDR SWAA2017041913244Cover · looseFORWARD GALLEY SERVICE DOOR EMERGENCY EXIT SIGN COVER LOOSE. SECURED THE COVER IAW SIP.SDR YENA201704180289Power Supply · failedFOUND NO COMM BETWEEN CID'S & EPSU. R & R THE EPSU (10WL) IAW AMM 33-51-38. OPS CHECKED GOOD.SDR DALA2017041903184Cover · detachedEMERGENCY LIGHT COVER CAME OFF FROM CEILING. SECURED EMERGENCY LIGHT COVER IAW AMM 33-51. CHECKED NORMAL.SDR MASA2017041812748Light · inoperativeOVERHEAD EMER LIGHT AT R0W 17 INOP. REPLACED BULB.SDR FDEA201704181229Battery Pack · dischargedFOUND ON PREDEPARTURE CHECK, 2 EA EMERGENCY EXIT SIGNS AND RT EXTERIOR LIGHT NOT TESTING. REMOVED AND REPLACED M730 POWER SUPPLY BATTERY PACK PER AMM 33-51-07-2, OPS CHECKS NORMAL.SDR AALA20170418007Light · brokenDURING NORMAL CABIN WALKAROUND FOUND SEAT MOUNTED EMERGENCY WHITE LED LIGHT ASSY AND LENS BROKEN AT SEAT 5D. THE LIGHT WAS REPLACED IAW AMM 33-50-00.SDR SWAA2017042513348Light · inoperativeRIGHT BULLNOSE MOUNTED EMERGENCY LIGHT INOPERATIVE AT ROW 24. R & R LIGHT HOUSING PER AMM.SDR HNAA2017042100133Light · inoperativeRIGHT OTBD AFT EMERGENCY LIGHT INOPERATIVE,SDR AALA20170417006Battery Pack · dischargedDURING PS CHECK FOUND F/C RT SEAT-MOUNTED EMERGENCY LIGHTS INOP. REMOVED & REPLACED BATTERY PACK ASSY IAW AMM 33-51-06. OPS CK FOUND NORMAL REF FIM 33-51-00. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA201704199017Lens · missingEMER EXIT LIGHT ON GALLEY BULKHEAD INSIDE AFT LEFT GALLEY DOOR IS MISSING ITS LENS COVER. REPLACED LIGHT ASSY IAW AMM 33-51-14. OPS CKS NORMAL. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA201704199016Light · brokenFOUND AFT RT FWD OF GALLEY EMERGENCY LT ASSY BROKEN. REPLACED EMERGENCY LT ASSY PER M/M 33-31-01, LT ASSY OPS TEST OK. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA201704199015Retaining Clip · brokenLIGHT COVER MISSING JUST AFT OF GALLEY NEAR THE FLOOR. PLASTIC RETAINING CLIP FOUND TO BE BROKEN ON RT FWD EMERGENCY EXIT (GALLEY) LIGHT. REMOVED & REPLACED RT FWD EMERGENCY EXIT LIGHT IAW AMM 33-51-21 AND WDM 33-51-21. OPS CHK GOOD. THE AIRCRAFT WAS NOT GROUNSDR AALA201704199014Lens · brokenEMERGENCY FLOOR LIGHT ACROSS FROM 1R COVER BROKEN. REPLACED EMERGENCY LIGHT COVER LENS ON BOTTOM OF CLOSET 373 ACROSS R1 DOOR REF MM 33-50-00 OPS CHK GOOD . THE AIRCRAFT WAS NOT GROUNDED.SDR AALA201704199013Guard · brokenEMERGENCY LIGHTS GUARDED SWITCH ON THE OVERHEAD PANEL WIRE BROKEN. REPLACED EMERGENCY LIGHTS SWITCH GUARD PER IPC 33-51-51-01A AND TESTED OK IAW AMM 33-51-00. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA201704199012Light · inoperativeFWD EMERGENCY LIGHT AT SEAT 9D INOP. REMOVED AND REPLACED FWD EMERGENCY LIGHT AT SEAT 9D IAW CMM 25-02-67 ESO 21376. OPS CKD OK. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA201704189023Lens · brokenR1 DOOR EMERGENCY LIGHT LENS COVER BROKEN. INSTALLED R1 DOOR EMERGENCY LIGHT LENS IAW MM 33-51-13. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR SWAA2017042013267Sign · unsecureFORWARD ENTRY DOOR EXIT SIGN CAME OFF. R&R LIGHT ASSEMBLY IAW MM.SDR DALA2017041903253Battery Pack · dischargedDURING INSPECTION FOUND EMERGENCY LIGHTS TEST FOUND L1 DOOR INTERIOR EXIT LIGHT INOPERATIVE. MAINTENANCE REMOVED AND REPLACED L1 DOOR POWER SUPPLY BATTERY PACK PER AMM 33-51-06 EMERGENCY LIGHTS OPS TEST GOOD.SDR SIMA20170417002Light · inoperativeRT OVER WING EMERGENCY LAMP INOP. RELAMPED IAW AMM 33-50-10 OPS CHECK GOOD.SDR AALA20170417004Battery · dischargedEMERGENCY CEILING LIGHTS INOP FROM ROW 13 TO 16. REMOVED & REPLACED BATT PACK. EMERGENCY LIGHTS OP CHK OK. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA201704189014Power Supply · failedL3, & R3 DOOR EMERGENCY LIGHTS INOPERATIVE, & ROWS SEATS 21L, 22L,22R, 23L, EMERGENCY LIGHTS INOPERATIVE. REMOVED AND REPLACED EMERGENCY POWER SUPPLY UNIT (12WL).SDR AALA201704189013Lens · brokenDOOR FRAME LINING AFT RIGHT EMERGENCY LIGHT LENS BROKEN IN THE AFT GALLEY AREA. REPLACED EMERGENCY LIGHT LENS.
Back to JASC 3350