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 AALA201803169024Lens · missingR1 DOOR EMERGENCY EXIT LIGHT COVER MISSING. MAINTENANCE REPLACED THE EMERGENCY LIGHT HOUSING AND LENS. PERFORMED SATISFACTORY OPERATIONAL CHECK IAW AMM 33-51-14.SDR AALA201803169014Housing · damagedR1 DOOR EMERGENCY EXIT LIGHT LENS MISSING. MAINTENANCE REPLACED THE EMERGENCY LIGHT HOUSING AND LENS, AND PERFORMED A SATISFACTORY OPERATIONAL CHECK IAW AMM 33-51-14.SDR AALA20180315005Light · inoperativeSEAT 24H, EMERGENCY LIGHT INOPERATIVE. MAINTENANCE REPLACED THE SEAT MOUNTED EMERGENCY LIGHT ASSEMBLY IAW AMM 33-51-10, AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR RAIA201803150001Bulb · inoperativeRIGHT EMERGENCY DOOR FLOOD LIGHT IS INOPERATIVE. R & R THE FLOOD LIGHT BULB, OPS CHECKED GOOD.SDR REXA2018031500193Bulb · inoperativeTWO LIGHT BULBS IN THE LEFT EMERGENCY DOOR EXIT SIGN BURNED OUT. REPLACED THE BULBS IAW AMM 33-51-05, AND PERFORMED AN OPS TEST OF THE EMERGENCY LIGHTS IAW AMM 33-51-00. OPS TESTS PASSED, ACFT OK FOR SERVICE.SDR REXA2018031500191Sign · inoperativeMID CABIN CEILING EMERGENCY LIGHT INOPERATIVE. PERFORMED AN OPS CHECK OF THE MID CABIN EMERGENCY EXIT SIGN IAW AMM 33-51-00. OPS CHECKED GOOD. ACFT OK FOR SERVICE.SDR AALA201803169007Battery · inoperativeAFT FLIGHT ATTENDANT BREAKAWAY FLASHLIGHT INOPERATIVE. REPLACED AFT FORWARD FLIGHT ATTENDANTS FLASHLIGHT BATTERY. OPS CHECKED GOOD.SDR QXEA2018031600090Light · inoperativeFA REPORTED A 2.5 - 3 FOOT SECTION OF THE EMERGENCY LIGHT STRIP ON THE FLOOR JUST AFT OF THE BULKHEAD DID NOT CHARGE. REMOVED FROM SERVICE. REMOVED THE LT FORWARD SECTION EMERGENCY LIGHT IAW AMM 33-50-21-000-801. INSTALLED A NEW LIGHT IAW AMM 33-50-21-400-80SDR QXEA2018031600089Light · obstructedFORWARD GALLEY DOOR WILL NOT OPEN FULLY. FOUND FWD GALLEY LWR DOOR CONTACTING FLOOR LIGHT STRIP. REMOVED THE LIGHT STRIP AND FOUND EXCESSIVE FLOOR TAPE ATTACHED. APPLIED THE CORRECT FLOOR TAPE AND INSTALLED, SECURED WET FLOOR.SDR DALA2018031601728Light · intermittentR2 DOOR SLIDE LIGHT WILL NOT ILLUMINATE. CYCLED THE ARM / DISARM LEVER. DOOR LIGHT OPS NORMAL.SDR UIEA2018031500411Battery · inoperativeUPPER DECK EMERGENCY EXIT LIGHTS AT THE LT DOOR INOPERATIVE, AND ROW 7, FACING AFT CENTER AISLE, AND ROW 9 FACING FWD CENTER AISLE INOPERATIVE. REMOVED AND REPLACED THE BATTERY IAW AMM 33-51-04, OPS CHECKED GOOD.SDR AALA201803169010Battery · dischargedEMERGENCY LIGHTING NOT ALL WORKING. RESET EMEGENCY LIGHT SWITCHES AND ALLOWED AIRCRAFT TO CHARGE OVERNIGHT.SDR CALA2018031600925Power Supply · inoperativeEMERGENCY LIGHT INOPERATIVE FROM ROWS 22 TO 38. R & R THE POWER SUPPLY & BATTERY CHARGER IAW MM 33-51-06, & WDM 33-51-13. OPS CHECKED GOOD, OK TO CONTINUE.SDR AALA20180316003Battery Pack · faultedDURING CIDS FUNCTIONAL CHECK, THE AFT CABIN EMERGENCY LIGHT BATTERY PACK FAULTED. REPLACED THE BATTERY PACK IAW AMM 33-51-38.SDR SWAA2018031920515Charger · inoperativeLT OVERWING EXIT DOOR LOWER INTERIOR EMERGENCY LIGHT INOP. R&R CHARGER ASSEMBLY PER AMM.SDR SWAA2018031920514Battery Pack · dischargedLT OVERWING EXIT DOOR LOWER EXTERIOR EMERGENCY LIGHT INOP. R&R BATTERY PACK PER AMM.SDR SWAA2018031920513Charger · inoperativeLT OVERWING EXIT DOOR LOWER EXTERIOR EMERGENCY LIGHT INOP. R&R CHARGER ASSEMBLY PER AMM.SDR SWAA2018031920512Battery Pack · failedCABIN EMERGENCY LIGHTING BATTERY PACK FAILED CAPACITY TEST AT LOCATION M01670. R&R BATTERY PACK PER AMM AND DWG.SDR SWAA2018031920511Battery Pack · failedCABIN EMERGENCY LIGHTING BATTERY PACK FAILED CAPACITY TEST AT LOCATION M01673. R&R BATTERY PACK PER AMM AND DWG.SDR SWAA2018031920510Battery Pack · failedCABIN EMERGENCY LIGHTING BATTERY PACK FAILED CAPACITY TEST AT LOCATION M01675. R&R BATTERY PACK PER AMM AND DWG.SDR SWAA2018031920509Battery Pack · failedCABIN EMERGENCY LIGHTING BATTERY PACK FAILED CAPACITY TEST AT LOCATION M01672. R&R BATTERY PACK PER AMM AND DWG.SDR SWAA2018031920508Battery Pack · failedFORWARD RT BATTERY PACK FAILED CAPACITY CHECK. R&R BATTERY PACK PER AMM.SDR SWAA2018031920502Light · inoperativeLEFT AFT EXTERNAL EMERGENCY LIGHT INOPERATIVE. R & R THE LIGHT IAW AMM.SDR SWAA2018031920499Battery Pack · no testMID CABIN OVERWING EXIT RT BATTERY PACK FAILED A CAPACITY CHECK. R & R THE BATTERY PACK IAW AMM.SDR SWAA2018031920481Bulb · inoperativeLEFT EMERGENCY EXIT BULLNOSE LIGHT INOPERATIVE AT ROW 14. R & R THE BULB IAW AMM.SDR SWAA2018031920474Lamp · inoperativeR2 DOOR EXTERIOR EMERGENCY EXIT LIGHT INOPERATIVE. REPLACED THE LAMP IAW AMM.SDR SWAA2018031920473Battery Pack · no testCABIN EMERGENCY LIGHT BATTERY PACK FAILED A CAPACITY TEST AT M01669. R & R THE BATTERY PACK IAW AMM AND DWG.SDR SWAA2018031920469Light · missingLEFT AFT GALLEY FLOOR AISLE EMERGENCY LIGHT STRIP MISSING. INSTALLED A NEW EMERGENCY LIGHT STRIP IAW DWG.SDR SWAA2018031920467Battery Pack · inoperativeLEFT OVERWING EXIT DOOR LOWER INTERIOR EMERGENCY LIGHT INOPERATIVE. R & R THE BATTERY PACK IAW AMM.SDR YENA201803140133Power Supply · failedAFT EXIT SIGNS OVER THE DOORS WILL NOT ILLUMINATE WHILE THE ACFT IS ON THE GROUND. REMOVED AND REPLACED EMERGENCY POWER SUPPLY UNIT AT 13WL IAW AMM 33-51-38. OPS CHECKED GOOD.SDR AALA201803169003Sign · missingEXIT SIGN MISSING, AFT OF PASSNEGER DOOR NEXT TO TRASH CAN IN GALLEY RIGHT OF GALLEY DOOR. REPLACED THE EXIT SIGN AND LENS IAW 33-51-01.SDR YENA201803140131Battery Pack · no testEPSU BATTERY 10WL FAILED AN EMERGENCY LIGHT TEST. R & R THE BATTERY IAW AMM 33-51-38, SYSTEM OPS CHECKED GOOD.SDR IPXA2018031427449Bulb · inoperativeEMERGENCY LIGHT HAS THREE INOPERATIVE BULBS. R & R THE BULBS IAW AMM 33-51-01.SDR AALA201803169012Lens · detachedFORWARD ENTRY AREA, EMERGENCY LIGHT LENS DETACHED AND WOULD NOT STAY ON. INSTALLED THE EMERGENCY LIGHT LENS, OK FOR SERVICE IAW AMM 33-51-01.SDR AALA201803159010Lens · missingEMERGENCY EXIT LIGHT AT THE R4 DOOR WAS INOPERATIVE. INSTALLED A MISSING LENS. OPS CHECKED NORMAL.SDR AALA201803159028Lens · missingAIRCRAFT WAS GROUNDED: EMERGENCY LIGHT LENS MISSING AT SEAT 10C. MAINTENANCE INSTALLED LENS AS REQUIRED PER CMM 33-50-57 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201803159027Lens · missingAIRCRAFT WAS GROUNDED: EMERGENCY LIGHT LENS MISSING AT SEAT 1C. MAINTENANCE INSTALLED LENS AS REQUIRED PER CMM 33-50-57 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201803159001Light · inoperativeAIRCRAFT WAS NOT GROUNDED: SEAT 24H EMERGENCY ESCAPE PATH LIGHT INOPERABLE. MAINTENANCE REPLACED SEAT MOUNTED EMERGENCY LIGHT ASSEMBLY PER AMM 33-51-10 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR HALA2018031500102Unknown · unknownEMERGENCY LIGHTS IN ZONE E WERE ON WITH SWITCH OFF OR ON. PERFORMED AN OPS CHECK OF THE EMERGENCY LIGHTS AT ZONE E, NO DEFECTS NOTE, OK FOR SERVICE.SDR SWAA2018031520447Light · wornFORWARD LEFT EMERGENCY LIGHT STRIP WORN, LARGE GAP BETWEEN INBOARD SIDE OF FORWARD LT WINDSCREEN. R & R THE LIGHT STRIP IAW DWG.SDR AALA201803159003Sign · detachedABOVE THE R4 DOOR, THE EXIT SIGN DETACHED. SECURED THE EXIT SIGN IAW AMM 33-24-00.SDR DALA2018031501721Light · inoperativeEMERGENCY LIGHT DAMAGED OR INOPERATIVE. SECURED THE EMERGENCY LIGHT.SDR SIMA20180314008Battery · dischargedLT AND RT OVERWING EMERGENCY LIGHTS INOP. R&R NR 4 EMERGENCY BATTERY IAW WORK CARDS 33-700-19 AND 33-700-17 OPS CHECK GOOD AT THIS TIME END.SDR CALA2018031400915Battery · no testFWD EMERGENCY LIGHT POWER SUPPLY FAILED A TEST. REMOVED AND REPLACED THE BATTERY PACK IAW AMM 33-51-38-40 0-002-A. TESTED OK.SDR RAIA201803130001Light · inoperativePAX DOOR EMERGENCY LIGHT INOPERATIVE. R & R THE LIGHT ASSEMBLY. OPS CHECKED GOOD.SDR AALA201803169032Battery Pack · inoperativeEMERGENCY LIGHT DIM AND INOPERATIVE WHEN TESTED. REPLACED THE BATTERY PACKS IN FWD AND AFT GALLEY AREAS. OPS CHECKED GOOD IAW AMM 33-60-98.SDR AALA201803169031Battery Pack · inoperativeEMERGENCY LIGHTS DIM THEN INOPERATIVE. REPLACED THE BATTERY PACKS ABOVE ROW 21, IAW AMM 33-60-98. THE AIRCRAFT WAS GROUNDED.SDR AALA201803159004Sign · missingEMERGENCY SIGN MISSING FROM 4G CEILING PANEL IAW AMM 33-24-00. INSTALLED A NEW SIGN PANEL. OPS TESTED NORMAL IAW AMM 33-24-00, AND SWPM 20-72-24.SDR AALA20180314008Battery Pack · inoperativeEMERGENCY LIGHTS DIM THEN INOPERATIVE. REPLACED THE BATTERY PACKS ABOVE ROW 21, IAW AMM 33-60-98. THE AIRCRAFT WAS GROUNDED.SDR AALA20180314006Battery · inoperativeEMERGENCY LIGHT DIM AND INOPERATIVE WHEN TESTED. REPLACED THE EMERGENCY LIGHT BATTERY PACKS IN THE FWD AND AFT GALLEY AREAS. OPS CHECKED GOOD IAW AMM 33-60-98.
Back to JASC 3350