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 ASOA201804134021Control Module · inoperativeTHE CREW REPORTED THAT THE EMERGENCY LIGHTS WOULD NOT COME ON WITH THE F/A CONTROL PANEL. MAINTENANCE REMOVED AND REPLACED THE FLIGHT ATTENDANT CONTROL MODULE, OPS CHECKED WITH NO DEFECTS, AND THE AIRCRAFT WAS RETURNED TO SERVICE.SDR SWAA2018041621231Light · inoperativeOVERHEAD AFT R2 DOOR EMERGENCY LIGHT LAMP INOP. RELAMPED LAMP IAW AMM.SDR SWAA2018041621228Sign · missingR2 DOOR EMERGENCY EXIT SIGN MISSING. INSTALLED SIGN PER AMM.SDR SWAA2018041621223Battery Pack · failedEMERGENCY EXIT LIGHT BATTERY PACK FAILED CAPACITY TEST AT M1668. R&R BATTERY PACK PER AMM.SDR SWAA2018041621222Battery Pack · failedEMERGENCY EXIT LIGHT BATTERY PACK FAILED CAPACITY TEST AT M10744. R&R BATTERY PACK PER AMM.SDR SWAA2018041621221Battery Pack · failedEMERGENCY EXIT LIGHT BATTERY PACK FAILED CAPACITY TEST AT M10746. R&R BATTERY PACK PER AMM.SDR SWAA2018041621220Battery Pack · failedEMERGENCY EXIT LIGHT BATTERY PACK FAILED CAPACITY TEST AT M01675. R&R BATTERY PACK PER AMM.SDR SWAA2018041621219Battery Pack · failedEMERGENCY EXIT LIGHT BATTERY PACK FAILED CAPACITY TEST AT M01674. R&R BATTERY PACK PER AMM.SDR SWAA2018041621201Light · inoperativeEXTERIOR EMERGENCY LIGHT INOP BEHIND LT FLAP. RELAMPED LIGHT PER AMM.SDR SWAA2018041621199Light · inoperativeRT EMERGENCY LIGHT INOP AT ROW 13. RELAMPED LIGHT IAW AMM.SDR SWAA2018041621175Mount · brokenCENTER CABIN CEILING EMERGENCY EXIT LIGHT HOUSING MOUNTS BROKEN. R & R THE LIGHT ASSEMBLY IAW AMM.SDR DALA2018041602486Housing · damagedSEAT 29B MOUNTED EMERGENCY LIGHT DAMAGED. REPLACED THE LIGHT HOUSING. THE SYSTEM OPS NORMAL.SDR SIMA2018041160009Light · inoperativeLEFT AFT EMERGENCY EXTERIOR LIGHT INOPERATIVE. REMOVED AND REPLACED THE LIGHT IAW AMM 33-50-10. OPS CHECKED GOOD IAW 33-50-00.SDR SIMA2018041600010Lamp · inoperativeSERVICED DOOR EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE LAMP IAW AMM 33-50-06-000-801-A, AND 33-50-06-400-801-A. OPS CHECKED GOOD.SDR CALA2018041601174Power Supply · inoperativeLEFT EPSU BATTERY IS DISCHARGED 110WL2. REMOVED AND REPLACED THE LT OVERWING EMERGENCY LIGHT BATTERY AND POWER SUPPLY IAW IAW AMM 33-51-38-000-001-A, 33-51-38-400-001-A, 33-51- 38-000-002A, AND 33-51-38-400-002A. OPS TESTED GOOD IAW 33-51-00-710-001-A.SDR IPXA2018041328512Lamp · inoperativeLAVATORY EMERGENCY LIGHT IS BURNED OUT IN THE DIM MODE. REPLACED THE LAMPS IAW AMM 33-51-21-0401. OPS CHECKED GOOD.SDR SIMA201804130001Cradle · inoperativeFLASHLIGHT IN BACK OF CABIN NOT CHARGING. REMOVED AND REPLACED THE FLASHLIGHT CRADLE IAW AMM 33-50-16, OPS CHECKED GOOD.SDR UIEA2018041800730Lens · detachedEMERGENCY LIGHT FOUND BROKEN, LENS WILL NOT STAY ON. SECURED THE LENS AT SEAT 19L IAW AMM 20-60-00, OPS CHECKED GOOD.SDR AALA201804189033Lens · missingEXIT SIGN AT ROW 15F WAS MISSING THE LENS, ON THE BOTTOM. MAINTENANCE INSTALLED THE EXIT SIGN LENS AND PERFORMED A SATISFACTORY OPS CHECK.SDR DALA2018041802619Lens · looseRED EMERGENCY LIGHT LENS LOOSE. SECURED THE LENS IAW AMM 33-51. OK FOR SERVICE.SDR AALA201804139011Panel · detachedCLEANERS REPORTED A PANEL LAYING ON THE FLOOR ROW 14DEF. SECURED THE EMERGENCY LIGHT P/S PANEL DOOR IAW AMM 33-51-38. OK FOR SERVICE.SDR SWAA2018041621232Battery Pack · dischargedL1 DOOR EMERGENCY GROUND ILLUMINATION LIGHT INOP. R&R BATTERY PACK PER AMM.SDR SWAA2018041621215Charger · inoperativeL1 DOOR EMERGENCY GROUND ILLUMINATION LIGHT INOP. R&R CHARGER PER AMM.SDR SWAA2018041621160Lens · missingEMERGENCY EXIT LIGHT LENS MISSING. REPLACED THE LENS IAW SIP.SDR DALA2018041602483Lens · detachedRIGHT OVERWING EXIT EMERGENCY LIGHT LENS WILL NOT STAY ON. REPLACED THE LENS AND BASE PLATE. SYSTEM OPS NORMAL.SDR AALA201804169014Light · damagedAIRCRAFT IN BASE MAINTENANCE. THE EMERGENCY LIGHT AND RED LENS MISSING FROM SEAT 14D. REPLACED THE LIGHT AND LENS.SDR AALA201804169009Lens · missingAIRCRAFT IN BASE MAINTENANCE. THE EMERGENCY LIGHT AND RED LENS MISSING FROM SEAT 14D. REPLACED THE LIGHT AND LENS.SDR IPXA2018041328523Battery Pack · no testEMERGENCY LIGHTS DO NOT TEST. REPLACED THE POWER SUPPLY BATTERY IAW MM 33-51-14-0401, PARA 3D, & E4. OPS CHECKED NORMAL.SDR AALA201804139012Battery · inoperativeLEFT EMERGENCY EXIT DOOR LIGHT BATTERY INOPERATIVE. REPLACED THE BATTERY PACK IAW AMM 33-51-38-400-002-A. OPS CHECKED GOOD.SDR IPXA2018041228508Bulb · inoperativeEMERGENCY LIGHT HAS FOUR BULBS INOPERATIVE. REPLACED THE BULBS IAW 33-51-01-2.SDR SIMA2018041310Light · inoperativeFLOOR EMERGENCY LIGHTS AT THE EMERGENCY EXIT ROW INOPERATIVE. REMOVED AND REPLACED THE LIGHTS, OPS CHECKED GOOD IAW AMM 33-50-12.SDR DALA2018041302415Bulb · inoperativeDURING LINE CHECK, THE SEAT MOUNTED EMERGENCY LIGHT AT ROW 13 INOPERATIVE. INSTALLED A NEW BULB IAW MM 33-51. OPS CHECKED GOOD.SDR DALA2018041302414Fuse · failedALL EMERGENCY LIGHTS AFT OF OVERWING EXIT INOPERATIVE. FOUND THE FUSE BLOWN IN FWD BATTERY PACK B5-211. REPLACED THE FUSE AND OPS CHECKED GOOD IAW MM 35-50.SDR DALA2018041202405Light · inoperativeFIRST CLASS EMERGENCY CEILING LIGHTS NOT WORKING. RESET EMERGENCY LIGHTING SYSTEM IAW AMM 33-53. LIGHTS WORK OK.SDR MASA2018041213132Light · inoperativeROW 20 CEILING EMER FLOOD LT INOP. REPLACED BULB.SDR DALA2018041202398Light · inoperativeLLCR EXIT IDENTIFIER SIGNS INOPERATIVE. REPLACED BULBS. SYSTEM OPERATION IS NORMAL.SDR SCNA20180412079Battery Pack · dischargedR2 DOOR AND AFT RIGHT 3 OVERHEAD BIN EMER LIGHTS INOP. R&R BATTERY PACK FOR R AFT EMER LIGHTS. OPS CHECK GOOD. OK FOR SERVICE.SDR CALA2018041201152Battery Pack · failedALL EMERGENCY LIGHTS FROM FLT DECK TO ROW 14 CAME ON MID FLIGHT. FOUND THE BATTERY PACK FAILED AT LOCATION M1675. REPLACED THE BATTERY PACK IAW 33-51-06-960. TESTED NORMAL IAW MM 33-51-00-710.SDR DALA2018041202381Power Supply · failedTHE 1L DOOR EMERGENCY EXIT LIGHT WAS NOTED TO BE INOPERATIVE. MAINTENANCE FOUND THAT THE POWER SUPPLY FOR THE DOOR SIGN HAD FAILED AND THEY REPLACED PS B5-123 AND BATTERY PER AMM 33-51. OPERATIONAL CHECK WAS GOOD.SDR REXA2018041100282Light · inoperativeRIGHT FWD OVERWING EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE EMERGENCY LIGHT IAW AMM 33-51-15, OPS CHECKED GOOD.SDR AALA201804139002Housing · brokenPLASTIC EMERGENCY LIGHT HOUSING AT SEAT ROW 23L IS BROKEN. REPLACED THE EMERGENCY LIGHT HOUSING IAW CMM 25-22-52.SDR SWAA2018041621227Cover · looseR2 DOOR LOWER EXIT LIGHT COVER LOOSE. SECURED COVER PER AMM.SDR SWAA2018041621177Lens · brokenRIGHT EMERGENCY EXIT ROW LIGHT LENS BROKEN. R & R THE LENS IAW SIP.SDR AALA20180412004Light · inoperativeCOCKPIT EMERGENCY EXIT LIGHT INOPERATIVE. INSTALLED A SERVICEABLE EMERGENCY LIGHT IAW AMM 33-51-01.SDR 2DYA201804160001Battery Pack · dischargedDURING INSPECTION, AN EMERGENCY LIGHT DID NOT ILLUMINATE DURING THE PRESS TO TEST CHECK. ON TROUBLESHOOTING IT WAS DETERMINED THE FAILURE WAS DUE TO A WEAK BATTERY. REMOVED AND REPLACED THE BATTERY PACK IAW AMM 25-65-17 AND OPS CHECKED GOOD. NO FURTHER ISSUESSDR AALA201804129007Shroud · delaminatedSEAT 18C AND 20C EMERGENCY LIGHT SHROUDS DAMAGED. REPLACED THE EMERGENCY LIGHT SHROUD IAW CMM 25-22-52.SDR DALA2018041202401Light · inoperativeDURING ETOPS SERVICE CHECK FOUND ALL EMERGENCY LIGHTS IN LLCR INOPERATIVE. ALL LIGHTS REPLACED. SYSTEM OPERATION IS NORMAL.SDR SWAA2018041221149Battery Pack · failedEMERGENCY BATTERY PACK FAILED CAPACITY CHECK AT LOCATION M01675. R&R BATTERY PACK AMM.SDR SWAA0112040121147Cover · unsecureOVERWING CEILING EMERGENCY EXIT SIGN COVER CAME OFF. SECURED COVER IAW SIP.SDR SWAA2018041221130Battery Pack · inoperativeEMERGENCY BATTERY PACK BASE FASTENER SOCKET INOP. R&R BATTERY PACK BASE PER AMM.
Back to JASC 3350