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 AALA201806189031Power Supply · no testDURING EMERGENCY POWER SUPPLY UNIT TEST, A FAULT MESSAGE FOR THE EPSU 11WL EXT L. REPLACED THE POWER SUPPLY IAW AMM 33-51-38. OPS CHECKED GOOD. OK FOR SERVICE.SDR AALA201806189029Lens · brokenR4 DOOR EMERGENCY EXIT LIGHT LENS BROKEN. REPLACED THE LENS IAW AMM 33-51-13.SDR YENA201806185255Power Supply · failedPOWER SUPPLY 10WL FAULTED. REMOVED & REPLACED THE POWER SUPPLY IAW AMM 33-51-38.SDR DALA2018061854044Power Supply · inoperativeDURING A SERVICE CHECK, FOUND THE LOWER WING EMERGENCY EXIT LIGHT TO BE INOPERATIVE. MAINTENANCE DISCOVERED A BAD POWER SUPPLY B5-119 AND REPLACED IT. OPS CHECKED GOOD IAW AMM 33-51-03, AND WDM 33-51-12.SDR DALA2018061604036Battery · dischargedBOTH AFT OVERWING UPPER EXIT LIGHTS INOP. REPLACED BATTERIES AT B5105 REF AMM 33-53. OPS CHECK GOOD.SDR IPXA2018061530689Battery Pack · dischargedEMERGENCY LIGHT BATTERY 1 LOW, EMERGENCY LIGHT SYSTEM. REMOVED & REPLACED EMERGENCY POWER SUPPLY. OPS CHECKED GOOD.SDR DALA2018061954069Battery · inoperativeEMERGENCY LIGHTS ROWS 35-41 WERE INOPERATIVE. MAINTENANCE REPLACED THE BATTERY. SYSTEM OPERATION IS NORMAL.SDR DALA2018061954068Light · looseEMERGENCY SEAT MOUNTED LIGHTING AT 26B IS INOPERATIVE. FOUND HARDWARE MISSING AND REPLACED. SYSTEM OPERATION IS NORMAL.SDR DALA2018061954067Light · looseEMERGENCY FLOOR LIGHTS WERE INOPERATIVE AT 39B. FOUND ATTACHING HARDWARE LOOSE AND SECURED. SYSTEM OPERATION IS NORMAL.SDR SWAA2018061822876Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1675. R&R BATTERY PER AMM.SDR SWAA2018061822875Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1673. R&R BATTERY PER AMM.SDR SWAA2018061822874Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1674. R&R BATTERY PER AMM.SDR SWAA2018061822873Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1670. R&R BATTERY PER AMM.SDR SWAA2018061822872Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1669. R&R BATTERY PER AMM.SDR SWAA2018061822870Battery Pack · failedRT EMERGENCY LIGHTING BATTERY PACKS IN AFT GALLEY FAILED THE CAPACITY TEST. R&R BATTERY PACK PER AMM.SDR SWAA2018061822867Battery Pack · failedRT BATTERY PACKS FAILED CAPACITY CHECK. R&R BATTERY PACKS PER AMM.SDR SWAA2018061822860Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1672. R&R BATTERY PER AMM.SDR SWAA2018061822849Battery Pack · failedLT EMERGENCY LIGHTING BATTERY PACK FAILED CAPACITY TEST ROW 17. R&R BATTERY PACK PER AMM.SDR SWAA2018061822848Battery Pack · failedLT EMERGENCY LIGHTING BATTERY PACKS IN AFT GALLEY FAILED THE CAPACITY TEST. R&R BATTERY PACK PER AMM.SDR SWAA2018061822847Battery Pack · failedFORWARD RT BATTERY PACK FAILED CAPACITY CHECK. R&R BATTERY PACK PER AMM.SDR SWAA2018061822846Battery Pack · failedLT AFT BATTERY PACKS FAILED CAPACITY CHECK. R&R BATTERY PACKS PER AMM.SDR SWAA2018061822803Light · inoperativeR1 DOOR EXTERIOR SLIDE LIGHT INOP. RELAMPED LIGHT IAW MM.SDR SWAA2018061822795Lens · missingR1 DOOR EMERGENCY EXIT LIGHT MISSING ARROW. INSTALLED LIGHT LENS PER AMM.SDR AALA201806179002Battery · dischargedAIRCRAFT WAS NOT GROUNDED. EMERGENCY POWER SUPPLY UNIT 12WL BATTERY INOPERATIVE. REPLACED EMERGENCY POWER SUPPLY UNIT (12WL) BATTERY PER AMM 33-55-00. SYSTEM OPERATIONS CHECKS GOOD.SDR AALA201806179001Light · illuminatedAIRCRAFT WAS NOT GROUNDED. DOOR 3L EMERGENCY EXIT LIGHT ILLUMINATED. ACCOMPLISHED SATISFACTORY CIDS RESET. ALL EMERGENCY EXIT LIGHTS TEST OK PER AMM 23-13-00.SDR DALA2018061604034Battery · dischargedCATWALK EMERGENCY LIGHT INOP. REPLACED BATTERIES AT B5-28. CHECKS GOOD. REF AMM 33-53.SDR AALA201806159019Light · looseAIRCRAFT WAS NOT GROUNDED: EXIT PATH LIGHTING ON FLOOR NEAR SEAT 17C LOOSE. MAINTENANCE REPLACED EMERGENCY LIGHT BRACKET AS REQUIRED AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR SIMA20180614002Light · inoperativeRT EXTERNAL OVERWING EMERGENCY LIGHT WILL NOT ILLUMINATE. R&R RT EXTERNAL OVERWING EMERGENCY LIGHT ASSY IAW AMM 33-50-10 OPS CK GOOD.SDR SIMA20180614001Light · inoperativeDURING PS-1 CHECK FOUND CEILING EMERGENCY FLOOD LIGHT TO BE INOP AT ROW 16. R&R CEILING EMERGENCY FLOOD LIGHT BULB IAW AMM 33-51-09. OPS CHECK GOOD.SDR FDEA201806141491Power Supply · inoperativeDURING PREFLIGHT OF SUPERNUMERARY AREA FOUND 2 EMERGENCY EXIT LIGHT INOP. R&R L1 POWER SUPPLE "M33093". P/N D717-02-001. S/N 157327. CHECKS OK REF MM 33-51-06-2. OK TO CONT.SDR KCSA201806141148Light · inoperativeUPPER DECK AND STAIRWELL EMERGENCY LIGHTS AT STA 350, 490, 500, AND 540 INOP.SDR SWAA2018072523788Light · brokenPASSENGER CABIN SIDEWALL EMERGENCY EXIT LIGHT ASSEMBLY BROKEN. R&R LIGHT IAW AMM.SDR SWAA2018072523787Lens · crackedAFT LAV EMERGENCY EXIT LIGHT LENS CRACKED. R&R LENS IAW AMM.SDR UIEA2018061801183Battery Pack · dischargedEMERGENCY FLOOR LIGHT FWD OF 20F INOP. R&R LT FLOOR LIGHT BATTERY PACK. OPS CHECK GOOD PER AMM 33-51-07.SDR DALA2018061944065Lens · missingL1 DOOR ENTRANCE LOWER EMERGENCY EXIT LENS MISSING, INSTALLED A LENSSDR AALA201806159008Power Supply · no testEMERGENCY POWER SUPPLY 13WL FAILED A CIDS TEST. REPLACED THE POWER SUPPLY IAW 33-51-38.SDR DALA2018061404028Light · looseSEAT 40 D EMERGENCY LIGHT CASE LOOSE. RPLD LIGHT CASE AT 40D - OP CK GOOD. REF AMM 33-51.SDR DALA2018061404025Light · inoperative1 SEAT MOUNTED EMER LIGHT INOP AT ROW 18D. REMOVED & REPLACED SEAT MOUNTED ASSY.SDR PNSA2018061302Relay · reads highEMERGENCY LIGHTS UNARMED CWP LIGHT ILLUMINATED WHEN EMER LIGHT SWITCH IS IN THE ARMED POSITION, EMERGENCY LIGHTS IN CABIN ON/OFF INTERMITTENTLY IN THIS CONDITION. FOUND RELAY 16LN OHMS READING HIGH, REMOVED AND REPLACED RELAY, OPS CHECK GOOD.SDR ASAA2018061325049Lens · detachedEMERGENCY EXIT LIGHT FELL OFF. GROUNDED - YES. RESECURED LIGHT LENS.SDR SWAA2018061422765Battery Pack · failedAFT RT SIDE BATTERY PACK IN AFT GALLEY FAILED CAPACITY TEST. R&R BATTERY PACK PER AMM.SDR SWAA2018061422764Housing · damagedPASSENGER CABIN FORWARD LAVATORY EMERGENCY LIGHT HOUSING DAMAGED ON AFT WALL LOWER AREA NEAR L1 DOOR. R&R LIGHT HOUSING IAW AMM.SDR SWAA2018061422758Cover · missingRT OVERWING EMERGENCY DOOR EXIT SIGN MISSING RED ARROW ON SIGN. INSTALLED SIGN IAW AMM.SDR SWAA2018061422753Light · inoperativeL2 DOOR EMERGENCY SLIDE LIGHT INOP. RELAMPED LIGHT PER AMM.SDR AALA201806149013Lens · missingEXIT LIGHT ABOVE THE AFT SERVICE DOOR, THE LENS WAS MISSING. INSTALLED A NEW LENS. OK FOR SERVICE.SDR F3LA2018061400356Battery Pack · inoperativeEPSU 10WL FORWARD LEFT, FAILED TO TEST. REMOVED AND REPLACED THE BATTERY PACK IAW AMM 33-51-38 PB 401. OPS CHECKED GOOD.SDR YENA201806143248Lens · detachedEXIT ROW EMERGENCY LIGHT AT 1C, LENS DETACHED. SECURED THE LENS IAW AMM 33-51-19.SDR DALA2018061403995Charger · inoperativeFIRST CLASS AND FWD GALLEY EMERGENCY LIGHTS INOP. R&R FWD BATTERY CHARGER PER AMM 33-50. OPS CHK GOOD.SDR DALA2018061303985Lens · missingLT FWD OVERWING EXIT EMER EXIT IDENTIFIER LENS MISSING. REMOVED & REPLACED EXIT IDENTIFIER ASSY OPS CHECK GOOD.SDR MASA2018061313321Light · inoperativeROW 17 OVERHEAD EMER FLOOD LIGHT INOP. PLACED ON MEL.
Back to JASC 3350