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 AALA201706089030Lens · missingR2 MISSING AN EXIT SIGN LENS. REPLACED EXIT SIGN LENS.SDR AALA201706089029Lens · brokenL2 DOOR MISSING AN EXIT SIGN LENS. REPLACED EXIT SIGN LENS.SDR AALA201706089028Lens · brokenEMERGENCY LIGHT LENS AT THE R2 LAVATORY FELL OFF. REINSTALLED LIGHT LENS COVER.SDR AALA20170607002Cover · brokenEMERGENCY EXIT LIGHT COVER AT THE L4 DOOR IS BROKEN. REPLACED EXIT LIGHT ASSEMBLY IAW AMM 33-51-00.SDR ASOA201706074043Sign · inoperativeTHE CREW REPORTED THAT THE EMERGENCY EXIT SIGN ABOVE THE FA SEAT WAS INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE AFFECTED EXIT SIGN, OPERATIONALLY TESTED WITH NO DEFECTS AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR GTIA2017060701964Light · malfunctionedL2 DOOR EMERGENCY LIGHT DOES NOT TURN OFF. POWERED DOWN AIRCRAFT AND REESTABLISHED AIRCRAFT POWER FROM THE APU IAW AMM 24-41-00-861-002-A01. PERFORMED OPERATIONAL TEST OF THE EMERGENCY LIGHTS IAW AMM 33-51-00-710-001-A AND OPERATIONAL TESTED GOOD. NO FURTHER SDR DALA2017060804557Sign · inoperativeEMERGENCY EXIT SIGNS INOPERATIVE. LENS COVER IS MISSING. INSTALLED SIGN. OPERATIONAL CHECKED NORMAL.SDR MASA2017060712358Light · inoperativeEMERGENCY FLOOD LIGHT AT ROW 20 INOPERATIVE.SDR IPXA2017060717997Battery Pack · failedINSPECTION TYPE: C10, EMERGENCY LIGHT BATTERY PACK DEEP CYCLING FAILURE. REPLACED THE BATTERY PACK.SDR SWAA2017060714199Lens · brokenR2 DOOR EMERGENCY EXIT SIGN LENS BROKEN. R&R LENS PER AMM.SDR AALA201706079005Lens · brokenDURING SERVICE CHECK, FOUND 1R DOOR EXIT SIGN MARKER COVER BROKEN. REPLACED LOWER R1 CABIN WALL MOUNTED EXIT SIGN IAW AMM 33-51-13. AIRCRAFT WAS GROUNDED.SDR SWAA2017061214269Sign · brokenOVERHEAD EMERGENCY EXIT SIGN BROKEN. R&R SIGN ASSEMBLY PER AMM.SDR SWAA2017061214256Lens · defectiveRT AFT EMERGENCY EXIT SIGN LENS MISSING DIRECTIONAL ARROW. R&R LENS PER AMM.SDR SWAA2017061214255Lens · missingLT AFT EMERGENCY EXIT SIGN LENS MISSING DIRECTIONAL ARROW. R&R LENS PER AMM.SDR AALA20170608014Power Supply · inoperativeEMERGENCY EXIT SIGN AT R3 DOOR IS INOPERATIVE. REMOVED AND REPLACED POWER SUPPLY M33404 IAW AMM 33-50-00. OPERATIONAL CHECKED GOOD.SDR AALA20170608013Power Supply · inoperativeEMERGENCY EXIT SIGN AT L2 DOOR IS INOPERATIVE. REMOVED AND REPLACED POWER SUPPLY M33096 IAW AMM 33-50-00. OPERATIONAL CHECKED GOOD.SDR AALA20170608012Power Supply · inoperativeEMERGENCY EXIT CEILING LIGHT BY R4 DOOR IS INOPERATIVE. REMOVED AND REPLACED POWER SUPPLY M33408 IAW AMM 33-50-00. OPERATIONAL CHECKED GOOD.SDR AALA20170608011Power Supply · inoperativeEMERGENCY EXIT SIGN BY R2 DOOR IS INOPERATIVE. REMOVED AND REPLACED POWER SUPPLY M33097 IAW AMM 33-50-00. OPERATIONAL CHECKED GOOD.SDR AALA20170608010Power Supply · inoperativeEMERGENCY EXIT CEILING LIGHT AT L3 DOOR IS INOPERATIVE. REMOVED AND REPLACED POWER SUPPLY M33406 IAW AMM 33-50-00. OPERATIONAL CHECKED GOOD.SDR AALA20170608008Power Supply · inoperativeEMERGENCY EXIT SIGN AT THE L1 DOOR IS INOPERATIVE. REMOVED AND REPLACED POWER SUPPLY M33424 IAW AMM 33-50-00. OPERATIONAL CHECKED GOOD.SDR AALA20170608002Power Supply · inoperativeEMERGENCY EXIT SIGN AT THE L4 DOOR IS INOPERATIVE. REMOVED AND REPLACED POWER SUPPLY M33407 IAW AMM 33-50-00. OPERATIONAL CHECKED GOOD.SDR SWAA2017060814226Light · inoperativeRT OVERWING EMERGENCY EXIT LIGHT INOP. RELAMPED LIGHT PER AMM.SDR SWAA2017060814220Sign · brokenMID CABIN AISLE OVERHEAD EMERGENCY EXIT SIGN MOUNT BROKEN. R&R SIGN PER AMM.SDR SWAA2017060814216Sign · brokenOVERHEAD EMERGENCY EXIT SIGN BROKEN. R&R SIGN ASSEMBLY PER AMM.SDR IPXA2017060617984Battery Pack · dischargedEMERGENCY 1 BATTERY LOW ILLUMINATED. R & R THE BATTERY IAW MM 33-51-01-400-802. OPS CHECKED NORMAL.SDR AALA20170608001Light · inoperativeBULL NOSE EMERGENCY LIGHT AT ROW 31ABC IS INOPERATIVE. REMOVED AND REPLACED LIGHT ASSEMBLY IAW AMM 33-51-05. OPERATIONAL CHECKED GOOD.SDR AALA201706079024Cover · missingTHE AIRCRAFT WAS NOT GROUNDED. FLOOR LEVEL EXIT LIGHT COVER MISSING AT FORWARD CABIN DOOR AREA. REMOVED AND REPLACED LIGHT ASSEMBLY AT FORWARD GALLEY FLOOR. OPS CHECKED GOOD. REF 33-53-01.SDR AALA201706079023Lens · brokenTHE AIRCRAFT WAS NOT GROUNDED. FWD GALLEY BULKHEAD LT VERTICAL EMERGENCY PATH LIGHT LENS COVER BROKEN. REPLACED FWD GALLEY BULKHEAD LT PROXIMITY LIGHT PER MM 33-51-05. TESTS GOOD.SDR AALA201706079022Light · brokenTHE AIRCRAFT WAS NOT GROUNDED. FWD GALLEY RIGHT SIDE EXIT LIGHT BROKE. REMOVED AND REPLACED FWD GALLEY RIGHT SIDE EXIT LIGHT PER AMM 31-51-01 TEST OPS GOOD.SDR AALA201706079020Light · damagedTHE AIRCRAFT WAS NOT GROUNDED. WHILE ACCOMPLISHING A-CHECK, FOUND EMERGENCY EXIT LIGHT ASSEMBLY AND LENS DAMAGED AT DOOR R4. REPLACED EMERGENCY EXIT LIGHT ASSEMBLY AND LENS AT DOOR R4 IAW MM 33-51-14.SDR AALA201706079019Lens · missingTHE AIRCRAFT WAS NOT GROUNDED. WHILE ACCOMPLISHING A-CHECK FOUND EMERGENCY LIGHT LENS MISSING AT SEAT 6E. REPLACED MISSING EMERGENCY LIGHT LENS AT SEAT 6E IAW MM 33-51-11.SDR R61A201706060401Battery · malfunctionedLAST AND 3RD FROM LAST OVERHEAD EMERGENCY LIGHTS ARE OUT. EMERGENCY SIGN/LIGHT OVER R2 DOOR IS OUT. R&R EMERGENCY LIGHT #4 BATTERY IAW AMM 33-50-01. OPS CHECK GOOD.SDR HNAA2017060900201Bulb · inoperativeFIRST AND 14TH EMERGENCY LIGHTS INOPERATIVE. R & R THE BULBS.SDR AALA20170606003Power Supply · inoperativeTHE AIRCRAFT WAS NOT GROUNDED. DOOR R2 EMERGENCY POWER SUPPLY INOPERATIVE. DOOR R2 EMERGENCY POWER SUPPLY REPLACED IAW AMM 33-51-06, TEST OK, CHECKED OK FOR SERVICE.SDR AALA201706089001Battery · no testEMERGENCY POWER SUPPLY UNIT 11WL SHOWS BATTERY FAULT. REPLACED BATTERY AT 11WL IAW AMM 33-51-38.SDR AALA201706089022Lens · missingEMERGENCY LIGHT LENS AT THE LOWER R1 & R2 DOORS MISSING. INSTALLED NEW LENSES.SDR AALA201706089020Lens · brokenLENS BROKEN. REPLACED THE BROKEN EMERGENCY LIGHT LENS AT ROW 22L.SDR AALA201706079015Switch · inoperativeAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT OFF/ARM/ON SWITCH MECHANISM IS INOPERATIVE. CAGING SPRING FELL OFF. REINSTALLED AND SECURED COCKPIT EMERGENCY LIGHT SWITCH GUARD. OPERATIONAL CHECK GOOD.SDR SIMA20170606002Lamp · inoperativeSERVICE DOOR EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE LAMP IAW AMM 33-50-10-000-801-A, & 33-50-10-400-801-A. OPS CHECKED GOOD.SDR SIMA20170606004Battery Pack · dischargedEMERGENCY LIGHTS INOPERATIVE. BATTERY DEAD. R & R EPSU BATTERY PACKS 3 AND 4 IAW MM 33-51-17. OPS CHECKED GOOD.SDR SIMA20170606005Battery Pack · dischargedEMERGENCY LIGHTS INOPERATIVE. BATTERY DEAD. REMOVED AND REPLACED EPSU BATTERY PACKS 1 AND 2 IAW MM 33-51-17. OPS CHECKED GOOD.SDR N6WA2017060601Light · inoperativeOVERHEAD EMERGENCY FLOODLIGHT OUT AT ROW 6. R & R THE EMERGENCY LIGHT IAW AMM 33-51-09.SDR SWAA2017060814231Light · inoperativeLT OVERWING LOWER ILLUMINATED EMERGENCY LIGHT INOP. RELAMPED LIGHT PER AMM.SDR SCNA20170605088Battery Pack · no testFWD LT & RT, MID LT & RTH, AFT LT & RT EMERGENCY LIGHT BATTERIES FAILED A FUNCTIONAL CHECK. REMOVED AND REPLACED THE BATTERY PACKS. OPS CHECKED GOOD.SDR AALA201706089011Lens · brokenPLASTIC EXIT MARKER AT THE 2R DOOR BROKEN OFF. REPLACED LENS ASSEMBLY.SDR AALA201706079003Lens · unsecureAIRCRAFT WAS NOT GROUNDED. DOOR 4R ARMED LIGHT, WHITE LENS COVER MISSING. RESECURED LIGHT LENS COVER AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201706079002Lens · unsecureR1 DOOR CABIN PRESSURIZED LIGHT RED LENS MISSING. SECURED LENS AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR SWAA2017060714201Sign · detachedR1 DOOR EXIT SIDEWALL SIGN DETACHED. R&R LIGHT ASSEMBLY IAW MM.SDR SWAA2017060714200Light · inoperativeLT OVERWING EMERGENCY EXIT LIGHT INOP. RELAMPED LIGHT PER AMM.SDR RAIA201706050001Bulb · inoperativeMAIN DOOR EXTERIOR FLOOD LIGHT NR 1 LOCATED ON BOTTOM OF PLUG DOOR HINGE IS INOPERATIVE. R & R THE BULB, OPS CHECKED GOOD.
Back to JASC 3350