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 REXA2018042760319Lamp · inoperativeRIGHT AFT EMERGENCY LIGHT WAS FOUND INOPERATIVE. REPLACED THE LAMPS AND OPS CHECKED SATISFACTORY IAW AMM 33-51-15.SDR SWAA2018042721436Battery · no testEMERGENCY EXIT LIGHTS BATTERY M1670 FAILED A CAPACITY TEST. R & R THE BATTERY PACK IAW MM.SDR SWAA2018042721430Lamp · inoperativeL2 DOOR EXTERIOR EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS IAW MM.SDR SWAA2018042721429Battery · no testEMERGENCY LIGHT BATTERY M1675 FAILED A CAPACITY TEST. R & R THE BATTERY IAW MM.SDR REXA2018042760316Lamp · inoperativeCEILING EMERGENCY FLOODLIGHT LAMPS 1 & 2 FOUND INOPERATIVE. REMOVED AND REPLACED THE LAMPS IAW AMM 33-51-16, OPS CHECKED GOOD.SDR REXA2018042760315Light · inoperativeSECTION OF EMERGENCY LIGHTING BY SEAT 8DC WAS FOUND INOPERATIVE. R & R THE EMERGENCY LIGHT IAW AMM 33-51-01. OPS CHECKED GOOD.SDR IPXA2018042708987Bulb · inoperativeEMERGENCY LIGHT HAS TWO INOPERATIVE BULBS. R & R THE BULBS IAW AMM 33-51-01.SDR 29GA2018042700001Light · unsecureFLIGHT ATTENDANTS REPORTED THE EMERGENCY LIGHTS BY SEAT 2A NOT SECURE. SECUCRED THE EMERGENCY LIGHT STRIP IAW AMM 33-50-20-04.SDR MASA2018042613166Lamp · inoperativeOVERHEAD EMERGENCY LIGHT INOPERATIVE AT ROW 11. REPLACED THE LAMPS.SDR ASOA201804254025Battery Pack · dischargedDURING MAINTENANCE INSPECTION NUMEROUS EMERGENCY LIGHTS WERE FOUND TO BE INOPERABLE. REMOVED AND REPLACED THE NUMBER 3 EMERGENCY LIGHT BATTERY PACK. OPERATIONALLY TESTED WITH NO DEFECTS NOTED AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR R61A201804250512Sign · inoperativeL2 EXIT ID SIGN INOP. R&R L2 DOOR EXIT ID SIGN IAW AMM 33-50-15. OPS CHECK GOOD.SDR SWAA2018043021596Battery Pack · dischargedRT AFT EMERGENCY EXIT LIGHT BATTERY INOP AT BS 952. R&R BATTERY PACK IAW MM.SDR SWAA2018043021595Battery Pack · dischargedRT EMERGENCY EXIT LIGHT BATTERY INOP AT BS 603. R&R BATTERY PACK IAW MM.SDR SWAA2018043021594Battery Pack · dischargedLT EMERGENCY EXIT LIGHT BATTERY INOP AT ROW 17. R&R BATTERY PACK IAW MM.SDR SWAA2018043021593Battery Pack · dischargedLT AFT EMERGENCY EXIT LIGHT BATTERY INOP AT BS 952. R&R BATTERY PACK IAW MM.SDR SWAA2018043021474Battery Pack · dischargedLT EMERGENCY EXIT LIGHT BATTERY INOP AT ROW 11. R&R BATTERY PACK IAW MM.SDR AALA2018050109015Lens · missingVERTICAL EMERGENCY EXIT SIGN LENS MISSING AT THE R1 DOOR. REPLACED SIGN ASSEMBLY IAW AMM 33-51-01. AIRCRAFT WAS GROUNDED.SDR DALA201804302929Sign · damagedDURING A SERVICE CHECK, FOUND ROW 27 LEFT EXIT SIGN DAMAGED. REPLACED THE EXIT SIGN IAW WDM 33-51-13.SDR DALA201804302928Cover · missingF/AS REPORTED AN EXIT SIGN WAS MISSING. INSTALLED A NEW SIGN COVER, CHECKED NORMAL. OK FOR SERVICE.SDR N6WA20180430002Light · looseFLOOR EMERGENCY LIGHT AT THE MAIN ENTRANCE WAS FOUND LOOSE.SDR REXA2018042500318Battery Pack · inoperativeOVERHEAD EMERGENCY LIGHT WAS FOUND INOPERATIVE AT THE ENTRANCE WAY. REMOVED AND REPLACED EPSU BATTERY PS35 IAW AMM 33-51-04.SDR N6WA2018042700001Lamp · inoperativeFLOOR LEVEL EXIT ROW LIGHT INOPERATIVE ON THE LEFT AND RIGHT SIDES, REPLACED THE LAMPS IAW AMM 33-52-00, OPS CHECKED GOOD.SDR AALA20180426001Lens · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT IDENTIFIER FORWARD OF SEAT 17A MISSING DECAL. REPLACED EXIT IDENTIFIER LENS PER AMM 33-51-10.SDR FDEA2018042601120Power Supply · failedEMERGENCY LIGHTS INOPERATIVE. REMOVED AND REPLACED THE POWER SUPPLY AND BATTERY 29WLI IAW AMM 33-51-14-04-09. OPS CHECKED GOOD.SDR R61A20180426513Battery Pack · inoperativeEMERGENCY LIGHT IN CENTER OF CABIN INOPERATIVE. R & R THE BATTERY PACK IAW AMM 33-50-01. OPS CHECKED GOOD.SDR SWAA2018042621426Light · unsecureEMERGENCY LIGHT LOOSE AT ROW 11ABC. SECURED THE LIGHT ASSY IAW MM.SDR REXA2018042500311Light · missingEXIT ROW MISSING PIECE OF EMERGENCY LIGHT SEAT 12DC. REPLACED THE SECTION OF EMERGENCY LIGHT IAW CMM 31-55-07, AND AMM 33-51-01.SDR QXEA2018043000163Battery Pack · inoperativeEMERGENCY LIGHTS ON THE CEILING PANEL 245EZ DID NOT COME ON DURING AN OPERATIONAL TEST. REPLACED THE BATTERY PACK.SDR AALA201804275002Battery Pack · no testR4 DOOR EMERGENCY POWER ASSIST SUPPLY FAILING. REPLACED EMERGENCY POWER ASSIST SUPPLY BATTERY PACK AND PERFORMED A SATISFACTORY OPS CHECK IAW MM 52-11-20.SDR DALA2018042602873Light · inoperativeR1 DOOR SLIDE GIRT BAR ENGAGEMENT LIGHT INOPERATIVE. REMOVED AND REPLACED THE LIGHT ASSY IAW AMM 25-66. CHECKED OK.SDR AALA20180424010Battery Pack · inoperativeEMERGENCY LIGHT POWER SUPPLY M33096 AT THE L2 DOOR FAILED AN OPS TEST. REPLACED THE POWER SUPPLY AND BATTERY PACK IAW MM 33-51-06. OPS CHECKED GOOD.SDR AALA2018042659020Battery Pack · no testEMERGENCY LIGHT TEST FLAGS POWER SUPPLY 12WL. REPLACED THE BATTERY PACK IAW AMM 33-50-00.SDR AALA2018042659019Light · missingEXIT LIGHT AT THE LOWER L4 DOOR MISSING. INSTALLED THE EXIT LIGHT IAW AMM 33-50-00.SDR RAIA2018042640001Bulb · inoperativeSERVICE DOOR EXTERIOR EMERGENCY FLOOD LIGHT NR 2 INOPERATIVE. R & R THE BULBS, OPS CHECKED GOOD.SDR HALA2018042500149Sign · unsecureR3 DOOR EXIT SIGN BROKEN. SECURED LOOSE HARDWARE.SDR HALA208042500187Sign · unsecureR3 DOO REXIT SIGN BROKEN. FOUND LOOSE HARDWARE. SECURED. OK TO CONTINUE SERVICE.SDR REXA201804250312Bulb · inoperativeRIGHT EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE BULB IAW AMM 33-51-21. OPS CHECKED GOOD. NO FURTHER DEFECTS FOUND.SDR SWAA2018042521405Battery Pack · no testLEFT FWD EMERGENCY LIGHT BATTERY PACK FAILED TO TEST. R & R THE BATTERY PACK IAW MM.SDR SWAA2018042521404Battery Pack · failedLEFT AFT CABIN EMERGENCY LIGHT BATTERY PACK FAILED TO TEST. R & R THE BATTERY PACK IAW MM.SDR SWAA2018042521399Lamp · inoperativeRIGHT FWD EMERGENCY EXIT LIGHT INOPERATIVE. REPLACED THE LAMPS IAW MM.SDR SWAA2018042521397Battery Pack · no testRIGHT FWD EMERGENCY LIGHT BATTERY PACK FAILED TO TEST. R & R THE BATTERY PACK IAW MM.SDR SWAA2018042521396Battery Pack · failedRIGHT AFT CABIN EMERGENCY LIGHT BATTERY PACK FAILED TO TEST. R & R THE BATTERY PACK IAW MM.SDR ASOA201804247070Battery Pack · inoperativeEMERGENCY LIGHTS INOPERATIVE FROM GALLEY TO THE EXIT ROW. REMOVED AND REPLACED THE NR 2 AND 3 BATTERY PACKS IAW AMM 33-50-04.SDR ASOA201804247069Battery Pack · inoperativeEMERGENCY LIGHTS INOPERATIVE FROM GALLEY TO THE EXIT ROW. REMOVED AND REPLACED THE NR 2 AND 3 BATTERY PACKS IAW AMM 33-50-04.SDR DALA2018042402795Charger · inoperativeWHILE PERFORMING A SERVICE CHECK, FOUND SEATS 1D AND 5D EMERGENCY LIGHTS INOPERATIVE. REPLACED THE EMERGENCY LIGHT BATTERY CHARGER M730. SYSTEM OPS NORMAL.SDR SIMA20180424001Inverter · inoperativeLEFT OVERWING EMERGENCY LIGHT WORKS INTERMITTENTLY. FOUND EMERGENCY LIGHT INVERTER TO BE INOPERATIVE. REMOVED AND REPLACED THE INVERTER IAW AMM 33-50-11. OPS CHECKED IAW AMM 33-50-00, OPS CHECKED GOOD.SDR DALA2018042402777Cids · malfunctionedOVERHEAD EXIT SIGN AT DOOR 3L WILL NOT GO OFF. RESET CIDS.SDR UIEA2018042400779Socket · dirtyEMERGENCY EXIT LIGHT AT THE L1 DOOR INOPERATIVE. CLEANED THE SOCKET IAW SWPM 20-60-01, OPS CHECKED GOOD IAW AMM 33-51-00.SDR UIEA2018042400781Power Supply · inoperativeEMERGENCY LIGHT ABOVE THE COCKPIT DOOR INOPERATIVE. REPLACED THE POWER SUPPLY M735 IAW AMM 33-51-07-402-010. OPS CHECKED IAW AMM 33-51-00-715-001, NO DEFECTS NOTED.SDR CALA2018042401197Power Supply · no testEMERGENCY LIGHT POWER SUPPLY CAPACITY CHECK FAILED. THE POWER SUPPLY WAS REPLACED AND TESTED NORMAL IAW AMM 33-51-06.
Back to JASC 3350