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 AALA201711279031Lens · missingAIRCRAFT WAS NOT GROUNDED. CEILING EMERGENCY EXIT LIGHT BETWEEN SEAT 2A AND SEAT 2D HAS A MISSING LENS COVER. INSTALLED LENS COVER (BEZEL) PER AMM 33-50-00. OPERATIONAL CHECK GOOD.SDR AALA201711279030Lens · missingAIRCRAFT WAS NOT GROUNDED. SEAT MOUNTED EMERGENCY ESCAPE PATH LIGHT AT ROW 13ABC HAS A MISSING LENS COVER. REPLACED LENS COVER PER AMM 33-51-19. OPERATIONAL CHECK GOOD.SDR AALA20171125002Power Supply · no testEMERGENCY EXIT LIGHTS POWER SUPPLY BATTERY PACKS FAILED TO TEST. REMOVED AND REPLACED THE POWER SUPPLIES IN MID CABIN M1695, MID CABIN M1694, AFT GALLEY M1672, AND AFT GALLEY M1673. IAW AMM 33-51-06. OPERATIONAL CHECKED GOOD.SDR DALA2017112708355Battery Pack · faulted11WL EPSU FAULTING DURING EPSU SYSTEM TEST, REPLACED EPSU BATTERY 11WLSDR SWAA2017112818058Sign · unsecureFORWARD GALLEY EXIT SIGN FELL OFF. SECURED SIGN PER AMM.SDR SIMA20171125002Light · inoperativeRIGHT OVERWING EMERGENCY LIGHT INOPERATIVE. R & R THE LIGHT IAW AMM 33-50-10-000-801. OPS CHECKED GOODSDR SWAA2017112717997Light · inoperativeRIGHT EMERGENCY LIGHTS INOPERATIVE AT ROW 1. R & R THE LIGHT IAW AMM.SDR SWAA2017112717996Lens · detachedLEFT OVERWING EXIT DOOR LOWER RECTANGULAR SIGN LENS DETACHED. INSTALLED THE LENS IAW EA.SDR HALA2017112600264Battery Pack · inoperativeDURING INSPECTION, THE EPSU (13WL) FAULTED. REPLACED THE L2 DOOR BATTERY PACK.SDR DALA2017112608342Battery Pack · inoperativeDURING INSPECTION, FOUND EMERGENCY LIGHTS FROM SEATS 10 TO 16 INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE BATTERY PACK AT SIDEWALL NEXT TO SEAT 11F IAW AMM 33-51. OPS CHECKED GOOD.SDR AALA201711279018Lens · unsecureEXIT SIGN LENS AT THE L3 DOOR FOUND UNSECURE. SECURED THE EXIT SIGN.SDR MASA2017112512789Light · inoperativeO/H EMER LIGHT ROW 14 INOP. RELAMPED.SDR MASA2017112512787Flashlight · inoperativeCA'S FLASHLIGHT INOP. REPLACED FLASHLIGHT ASSY.SDR CALA2017112504215Lens · missingFWD COAT CLOSET AFT EMER EXIT LIGHT MISSING LENS COVER. REPLACED FWD COAT CLOSET AFT EMERGENCY LIGHT LENS COVER. OPS CHECKED EMERGENCY LIGHTS.SDR CALA2017112504214Battery Pack · dischargedROWS 1AB THROUGH 5AB AISLE EMERGENCY LIGHTS INOP. REMOVED AND REPLACED EMER LIGHT BATTERY PACK. OPS CKS GOOD REF AMM 33-51-06-960-805.SDR CALA2017112504212Battery Pack · dischargedFOUND FWD LEFT DOOR EMERG EXIT LIGHT INOP. REMOVED & REPLACED LEFT BATTERY PACK, OPS CHECK NORMAL.SDR CALA2017112504211Light · inoperativeAFT LEFT OVERWING EXT EMERGENCY EXIT LIGHT INOP. RE-LAMPED EMERGENCY EXIT LIGHT REF MM 33-51-01. OPS CK OK.SDR CALA2017112504210Lens · missingSEAT 15C AFT AISLE EMERGENCY LIGHT LENS IS MISSING EPL LENS MISSING IS THE RED AT ROW 15C. LIGHT IS STILL OPERATION AL AT THIS TIME. INSTALLED NEW RED EPL LENS AT SEAT 15C PER VMM 25-22-55. NO FURTHER DEFECTS.SDR MASA2017112512786Light · inoperativeROW 15 A/B EXIT SIGN BULB INOP. RELAMPED.SDR DALA2017120108405Cover · unsecureEMERGENCY FLOOR LIGHTING DAMAGED ROW 14ABC COVER PREVIOUSLY SECURED WITH TAPE, SECURED EMERGENCY LIGHT COVER AT SEAT 14C.SDR SWAA2017112718112Lens · missingAFT GALLEY EMERGENCY EXIT LIGHT COVER LENS MISSING. INSTALLED LENS PER AMM.SDR SWAA2017112717994Fuse · inoperativeAFT GALLEY EMERGENCY EXIT LIGHT FUSE INOP. R&R FUSE PER AMM.SDR AALA201711279050Power Supply · inoperativeAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHTS POWER SUPPLIES (BATTERY PACKS) FAILED TEST. REMOVED AND REPLACED POWER SUPPLIES IN MID CABIN M1695 (AALA20171125002), MID CABIN M1694 (AALA201711279049), AFT GALLEY M1672 (AALA201711279036), AND AFT GALLEY M16SDR AALA201711279049Power Supply · inoperativeAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHTS POWER SUPPLIES (BATTERY PACKS) FAILED TEST. REMOVED AND REPLACED POWER SUPPLIES IN MID CABIN M1695 (AALA20171125002), MID CABIN M1694, AFT GALLEY M1672 (AALA201711279036), AND AFT GALLEY M1673 (AALA20171127905SDR AALA201711279037Lens · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN IN THE FORWARD GALLEY NEXT TO THE TRASH BIN HAS A MISSING LENS COVER. INSTALLED LENS COVER PER AMM 33-51-03. OPERATIONAL CHECK GOOD.SDR AALA201711279036Power Supply · inoperativeAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHTS POWER SUPPLIES (BATTERY PACKS) FAILED TEST. REMOVED AND REPLACED POWER SUPPLIES IN MID CABIN M1695 (AALA20171125002), MID CABIN M1694 (AALA201711279049), AFT GALLEY M1672, AND AFT GALLEY M1673 (AALA20171127905SDR AALA201711269013Light · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT IN THE FORWARD GALLEY IS MISSING. REPLACED LIGHT ASSEMBLY PER AMM 33-51-14. OPERATIONAL CHECK GOOD.SDR FDEA201711243307Power Supply · failedEMER LT BAT 1 LO DURING PREFLIGHT. REMOVED AND REPLACED EMERGENCY EXIT LIGHTING BATTERY POWER SUPPLY IAW AMM 33_51_01_4. OPS CHECK GOOD. A/C OK FOR SERVICE. POWER SUPPLY PN 60-4411-5 SN 0299.SDR AALA201711269005Light · missingDOOR EMERGENCY EXIT LIGHT 2L MISSING. INSTALLED EXIT LIGHT IAW AMM 33-50-00.SDR AALA201711269004Lens · missingSEAT 12ABC EMERGENCY LIGHT MISSING THE LENS. REPLACED THE LENS IAW AMM 33-50-00.SDR SWAA2017112818085Cover · brokenRT OVERWING EMERGENCY EXIT LOWER LIGHT COVER BROKEN. R&R LIGHT ASSEMBLY PER MM.SDR DALA2017112608351Power Supply · inoperativeEMERGENCY CEILING LIGHTS AT ROW 35 AND 37 3 TOTAL INOPERATIVE. REMOVED AND REPLACED BATTERY PACK POWER SUPPLY IAW MM. OPERATION CHECKS GOOD.SDR AALA201711269006Bracket · damagedAIRCRAFT NOT GROUNDED. SEAT 9D EMERGENCY LIGHT BELOW SEAT CUSHION AISLE SIDE LOOSE IN MOUNTING (STICKING OUT INTO AISLE). REPAIRED EMERGENCY LIGHT BRACKET.SDR SWAA2017112717993Light · inoperativeR2 LOWER OUTSIDE EMERGENCY EXIT LIGHT INOPERATIVE. R & R THE LIGHT ASSEMBLY IAW AMM.SDR SWAA2017112717992Charger · inoperativeL2 LOWER EMERGENCY EXIT LIGHT INOPERATIVE. R & R THE BATTERY CHARGER IAW AMM.SDR SWAA2017112717991Charger · inoperativeL2 LOWER OUTSIDE EMERGENCY EXIT LIGHT INOPERATIVE. R & R THE BATTERY CHARGER IAW AMM.SDR SWAA2017112717990Charger · inoperativeL2 UPPER EMERGENCY EXIT LIGHT INOPERATIVE. R & R THE BATTERY CHARGER IAW AMM.SDR I5EA201711270001Power Supply · inoperativeSEVERAL EMERGENCY LIGHTS OUT IN CABIN. REMOVED AND REPLACED BATTERY POWER SUPPLIES AT STA 960R, S/N 37656, AND STA. 969L, S/N 15962. OPERATIONAL TEST GOOD IAW AMM 33-51-51.SDR DALA2017112608286Battery Pack · inoperativeEMERGENCY LIGHT INOPERATIVE AT SEAT 32 CEILING. REPLACED BATTERY PACK IAW AMM 33-53. CHECKED NORMAL.SDR FDEA201711243304Power Supply · failedDURING A POST FLIGHT, FOUND THE R1 DOOR SLIDE EXTERIOR EMERGENCY LIGHT INOPERATIVE. REPLACED THE POWER SUPPLY IAW AMM 33-51-07-2, PAR 5,6. OPS CHECKED GOOD. ACFT OK FOR SERVICE.SDR CALA2017112404203Battery · faultyCIDS EMERGENCY SYSTEM FAILED THE 2 SERVICE CHECK, BATTERY FAILED FWD LT AND EPSU EMERGENCY L AND EPSU EMER R. REPLACED EPSU BATTERIES AT (10WL), (11WL), AND (12WL) PER MM33- 51-38-400-002, OPS CHECKS GOOD.SDR CALA2017112404199Lens · damagedEMERGENCY LIGHT LENS BEHIND THE L1 CLOSET IS DAMAGED. INSTALLED A NEW LENS. OPS CHECKED GOOD.SDR CALA2017112404197Power Supply · inoperativeEMERGENCY LIGHT AT SEAT ROWS 7 - 12 & 32 - 37 INOPERATIVE. REMOVED & REPLACED THE EMERGENCY LIGHT POWER SUPPLIES AT M1672 & M1676. OP CHECKED GOOD IAW AMM 33-51-06-960-806.SDR YENA201711240960Battery Pack · no testDURING A WEEKLY CHECK, FOUND EPSU BATTERY AT 15WL FAILING TO TEST. R & R EPSU BATTERY IAW AMM 33-51-38. OPS CHECKED GOOD. EPSU OK FOR SERVICE.SDR SWAA2017112818111Cover · missingRT EMERGENCY LIGHT LENS COVER MISSING BETWEEN ROW 4 AND ROW 6. REINSTALLED COVERS IAW AMM.SDR SWAA2017112818110Lens · missingR2 LOWER EXIT SIGN MISSING DIRECTIONAL ARROW. R&R LENS PER AMM.SDR SWAA2017112818092Lens · missingL2 LOWER EXIT SIGN MISSING DIRECTIONAL ARROW. R&R LENS PER AMM.SDR SWAA2017112818081Cover · missingLT EMERGENCY LIGHT LENS COVER MISSING BETWEEN ROW 18 AND ROW 19. REINSTALLED COVERS IAW AMM.SDR SWAA2017112818065Light · inoperativeL2 DOOR EMERGENCY EXTERIOR LIGHT INOP. RELAMPED LIGHT PER AMM.SDR DALA2017112708352Cover · missingTHE EXIT SIGN IN THE FIRST CLASS AISLE IS MISSING THE COVER. MAINTENANCE INSTALLED A NEW COVER. OK FOR SERVICE.
Back to JASC 3350