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 SWAA2017030712376Cover · missingAFT GALLEY EMERGENCY EXIT SIDEWALL LIGHT COVER MISSING. REPLACED THE COVER IAW SIP.SDR SWAA2017030712368Bulb · inoperativeLEFT OVERWING EMERGENCY LIGHT BULB INOPERATIVE. R & R THE BULB IAW AMM.SDR SWAA2017030712356Lamp · inoperativeLEFT WING EMERGENCY EXIT HATCH EXTERIOR BULB INOPERATIVE. R & R THE LAMP IAW AMM.SDR SWAA2017030712355Lens · looseLEFT CENTER EXIT SIGN LENS LOOSE. SECURED THE LENS IAW SIP.SDR HALA2017030400046Sign · detachedEXIT SIGN ABOVE MID GALLEY, LEFT SIDE DETACHED, ATTACHED AND SECURED THE EXIT SIGN. OK FOR SERVICESDR YENA201703040158Power Supply · no testOPS TEST FAILED SHOWING EPSU (13WL) AFT LT AND EPSU (12WL) EXT RT. R & R THE EPSU 12WL IAW AMM 33-51-38, OPS TESTED OK.SDR YENA201703040157Power Supply · failedOPS TEST FAILED SHOWING EPSU (13WL) AFT LEFT AND EPSU (12WL) EXT RT. R & R EPSU 13WL IAW AMM 33-51-38, OPS TESTED OK.SDR CALA2017030400528Light · no testEPSU BATTERY AFT LEFT FAILED DURING EMERGENCY LIGHTS OPS CHECK 33-51-38. OPS CHECKED THE EMERGENCY LIGHTS IN THE CABIN AND LIGHTS OP CHECKED GOOD IAW MM 33-51-00-710-001-A.SDR AALA20170306009Light · inoperativeEMERGENCY EXIT SIGN BLUE LIGHT AT L4 DOOR IS INOPERATIVE. RELOADED CONFIGURATION DATABASE AT THE CABIN SYSTEM CONTROL PANEL. OPERATIONAL CHECKED GOOD.SDR AALA201703059006Lens · brokenBROKEN EMERGENCY EXIT LIGHT LENS NEAR LAVATORY L37. REPLACED THE LENS AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR DALA2017030601798Sign · detachedDURING INSPECTION, FOUND THE EMERGENCY EXIT LIGHT ON CEILING DETACHED. SECURED THE EXIT SIGN. OPS CHECKED GOOD.SDR REXA2017030400316Light · damagedSEVERAL SECTIONS OF THE FLOOR EMERGENCY LIGHTS WERE DAMAGED. REPLACED THE LIGHTS, OPS CHECKED GOOD. IAW VCMM 33-60-13.SDR DALA2017030501777Battery Pack · inoperativeCOCKPIT AND GALLEY OVERHEAD EMERGENCY LIGHTS INOPERATIVE. R & R THE BATTERIES IAW AMM 33-53-00.SDR DALA2017030501773Lamp · inoperativeSEAT MOUNTED EMERGENCY LIGHTS WERE INOPERATIVE AT 13ED, 17ED AND 19ED. REPLACED THE LAMPS. CHECKED GOOD IAW AMM 33-53. OK FOR SERVICE.SDR AALA201703059004Lens · damagedL2 CABIN ENTRY DOOR EMERGENCY EXIT LIGHT LENS DAMAGED. REPLACED THE LENS.SDR AALA201703059003Lens · missingR4 DOOR EXIT LIGHT LENS IS MISSING. INSTALLED A NEW LENS.SDR AALA201703059002Lens · missingSEAT ROW 18ABC, EMERGENCY LIGHT LENS MISSING. REPLACED THE LENS.SDR AALA201703059001Lens · missingAFT LEFT EMERGENCY LIGHT LENS MISSING. REPLACED THE LENS.SDR CALA2017030500534Light · brokenB777-33-3-6019 PER M/D LLAR DOOR FWD AREA 1EA LWR EMER LT FOUND BROKEN. REPLACED THE M/D LLAR DOOR FWD AREA 1EA EMERGENCY LT ASSY AND OP TEST CARRIED OUT FOUND NORMAL AS PER AMM 33-51-05-960-802 REV79.SDR CALA2017030500533Light · inoperativeB777-33-3-6019 M/D A4 GALLEY TTL 4EA LWR EMER LIGHTS FOUND INOP. REPLACED THE M/D A4 GALLEY AREA TOTAL 4EA LWR EMERGENCY LT ASSY AND OP TEST CARRIED OUT, FOUND NORMAL AS PER AMM 33-51-05-960-80 2 REV 79.SDR CALA2017030500532Light · inoperativeB777-33-3-6019 M/D M2 GALLEY LT 1EA LWR EMER LT FOUND INOP. REPLACED THE M/D M2 GALLEY LT 1EA LWR EMERGENCY LT ASSY AND OP TEST CARRIED OUT FOUND NORMAL AS PER AMM 33-51-05-960-802 REV 79.SDR CALA2017030500531Light · damagedB777-33-3-6019 PER M/D ''B'' ZONE PARTITION L & R 2EA LWR EMER LIGHTS FOUND BROKEN. REPLACED THE CABIN ZONE ''B'' PARTITION LT & RT SIDE LOWER EMERGENCY LT ASSY AND OP TEST CARRIED OUT FOUND NORMAL AS PER AMM 33-51-05-960-802 REV 79.SDR CALA2017030500530Light · damagedB777-33-3-6019 PER M/D ''A'' ZONE PARTITION RT 1EA LWR EMER LT FOUND BROKEN. REPLACED THE M/D ZONE ''A'' PARTITION RT 1EA EMERGENCY LT ASSY AND OP TEST CARRIED OUT FOUND NORMAL AS PER AMM 33-51-05-960-802 REV 79.SDR CALA2017030400529Battery Pack · inoperativeDURING EMERGENCY LIGHT TEST, AN EPSU UNIT MESSAGE DISPLAYED. REMOVED AND REPLACED EMERGENCY LIGHT BATTERY. OPS CHECKED GOOD IAW AMM 33-51-39.SDR CALA2017030400527Light · unsecureEMERGENCY LIGHT DOES NOT TURN ON 21C. THE LIGHT IS HANGING DOWN. SECURED THE EMERGENCY LIGHT.SDR CALA2017030400526Lamp · inoperativeEMERGENCY EXIT LIGHT INOPERATIVE. OVERHEAD BIN BULLNOSE BETWEEN ROWS 3EF AND 4EF. REPLACED THE LAMPS. OPS CHECKED GOOD.SDR CALA2017030400524Battery Pack · dischargedSEAT 4ABC TO 11ABC EMERGENCY LIGHT WOULD NOT TEST. CHARGED THE BATTERY PACKS. OPS CHECKED NORMAL.SDR CALA2017030400523Lamp · inoperativeLEFT AFT OVERWING EMERGENCY EXIT EXT SLIDE LIGHT INOPERATIVE. REPLACED THE LAMPS IAW AMM 33-51-06. OPS CHECKED NORMAL.SDR CALA2017030400522Light · inoperativeL4 DOOR EXT SLIDE LIGHT INOPERATIVE. REMOVED AND REPLACED THE LIGHT ASSY IAW AMM 33-51-06. OPS CHECKED NORMAL.SDR CNMA201704280001Battery Pack · dischargedEMERGENCY LIGHTS ROW 8 & ROW 29-35 RIGHT SIDE UNSERVICEABLE. REPLACED THE BATTERY PACK. OPS CHECKED NORMAL IAW MM 33-51.SDR SWAA2017031712532Lens · missingEMERGENCY LIGHT LENS MISSING AT ROW 5 DEF. INSTALLED THE LENS IAW MM.SDR RAIA201703030001Battery · dischargedRT EMERGENCY DOOR FLOOD LIGHT NR 22 IS INOP. R&R RT EMERGENCY DOOR FLOOD LIGHT NR 22 BATTERY, OPS CHECK GOOD.SDR RAIA201703080001Battery · dischargedLT EMERGENCY DOOR FLOOD LIGHT NR 21 IS INOP. R&R LT EMERGENCY DOOR FLOOD LIGHT NR 21 BATTERY OPS CHECK GOOD.SDR AALA201703079014Light · damagedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT 1186 AT R1 DOOR IS DAMAGED. REMOVED AND REPLACED EXIT LIGHT ASSEMBLY IAW AMM 33-51-14. OPERATIONAL CHECK GOOD.SDR SWAA2017030712387Battery Pack · no testEMERGENCY LIGHT BATTERY PACK FAILED CAPACITY TEST AT LOCATION M01673. R & R THE BATTERY PACK IAW MM AND DWG.SDR SWAA2017030712386Battery Pack · no testEMERGENCY LIGHT BATTERY PACK FAILED CAPACITY TEST AT LOCATION M01669. R & R THE BATTERY PACK IAW MM AND DWG.SDR SWAA2017030712385Battery Pack · no testEMERGENCY LIGHT BATTERY PACK FAILED CAPACITY TEST AT LOCATION M01674. R & R THE BATTERY PACK IAW MM AND DWG.SDR SWAA2017030712384Battery Pack · no testEMERGENCY LIGHT BATTERY PACK FAILED CAPACITY TEST AT LOCATION M01668. R & R THE BATTERY PACK IAW MM AND DWG.SDR SWAA2017030712371Lens · unsecureFORWARD ENTRY LOWER EMERGENCY LIGHT LENS LOOSE. SECURED THE LENS IAW AMM.SDR SWAA2017030712363Battery Pack · no testEMERGENCY LIGHT BATTERY PACK FAILED CAPACITY TEST AT LOCATION M01670. R & R THE BATTERY PACK IAW MM AND DWG.SDR SWAA2017030612348Cover · unsecureL1 DOOR EXIT LIGHT COVER CAME OFF. R&R LIGHT PER AMM.SDR AALA20170306017Lens · missingEMERGENCY EXIT LIGHT BY R1 DOOR HAS A MISSING LENS COVER. REPLACED THE LENS IAW AMM 33-51-00. OPERATIONAL CHECKED GOOD.SDR AALA20170306016Lens · brokenEMERGENCY EXIT LIGHT AT THE L4 DOOR HAS A BROKEN LENS COVER. REMOVED AND REPLACED THE SIGN IAW AMM 33-51-01. OPERATIONAL CHECKED GOOD.SDR AALA20170306011Sign · looseOVERHEAD EMERGENCY EXIT SIGN AT RIGHT AISLE ROW 24 IS LOOSE. SECURED THE SIGN IAW 33-51-01. OPERATIONAL CHECKED GOOD.SDR AALA20170306010Sign · looseOVERHEAD EMERGENCY EXIT SIGN AT LEFT AISLE ROW 24 IS LOOSE. SECURED THE SIGN IAW 33-51-01. OPERATIONAL CHECKED GOOD.SDR AALA20170306004Lens · missingCEILING EMERGENCY EXIT LIGHT LEFT SIDE ROW 14 HAS A MISSING LENS. REPLACED THE LENS IAW AMM 33-53-00. OPERATIONAL CHECKED GOOD.SDR AALA20170306003Battery · no testCEILING EMERGENCY EXIT LIGHTS AT ROWS 18-21 AND ROWS 28-30 FAILED TEST. REMOVED AND REPLACED TWO BATTERY ASSEMBLIES IAW AMM 33-53-00. OPERATIONAL CHECK GOOD. AIRCRAFT WAS GROUNDED.SDR AALA20170306002Battery · no testCEILING EMERGENCY EXIT LIGHTS IN ROWS 18-21 AND ROWS 28-30 FAILED TEST. REMOVED AND REPLACED TWO BATTERY ASSEMBLIES IAW AMM 33-53-00. OPERATIONAL CHECKED GOOD. AIRCRAFT WAS GROUNDED.SDR AALA20170304002Battery · no testCEILING EMERGENCY EXIT LIGHTS AT ROWS 8-11, FAILED TEST. REMOVED AND REPLACED THE BATTERY ASSEMBLY B5-101 IAW AMM 33-53-00. OPS CHECKED GOOD. AIRCRAFT GROUNDED.SDR AALA20170303020Light · brokenSEAT MOUNTED EMERGENCY LIGHT AT SEAT 7J IS BROKEN. REPLACED THE LIGHT ASSEMBLY IAW AMM 33-51-00. OPS CHECKED GOOD.
Back to JASC 3350