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 CALA2017051201382Unknown · malfunctionedEMERGENCY LIGHTS TEST DISPLAYED EPSU BATTERY AFT LEFT RESET SYSTEM. OPS CKS GOOD.SDR CALA2017051201406Lens · detachedROW 25 EMERGENCY EXIT LENS CAP NEEDS REATTACHED. REINSTALLED LIGHT COVER.SDR CALA2017051201393Sign · looseEMERGENCY EXIT SIGN AT DOOR 2L HAS FALLEN OFF. REPLACED.SDR JJBA20170512027Battery Pack · dischargedEMERGENCY LIGHTS AT ROW 18 INOPERATIVE. SECURED AND CHARGED AFT BATTERY POWER SOURCE, OPS CHECKED SAT.SDR CALA2017051201361Cover · looseSEAT 28C EMERGENCY LIGHT COVER LOOSE. TIGHTENED LIGHT COVER.SDR CALA2017051201353Lamp · inoperativeDURING AN OPS TEST, FOUND AN EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMP AND OPS TESTED GOOD IAW AMM 33-51-12-33 2-001, REV 87.SDR CALA2017051201352Light · missingDURING AN OPERATIONAL TEST, FOUND SEAT 20AC EMERGENCY LIGHT ASSY MISSING. REPLACED AND OPS TESTED GOOD IAW CMM 25-24-65, REV 5, AND AMM 33-51-12-712-009, REV 87.SDR CALA2017051201351Lens · missingAN OPERATIONAL TEST FOUND SEAT 3C EMERGENCY LIGHT COVER MISSING. REPLACED THE LIGHT ASSY AND OP TESTED NORMAL IAW AMM 33-51-12-332-001, REV 87 & AMM 33-51-12-712-009, REV 87.SDR CALA2017051201340Battery · no testDURING AN EMERGENCY LIGHT OPS TEST, FOUND THE R4 DOOR M33408 BATTERY INOPERATIVE. REPLACED THE BATTERY AND CARRIED OUT AN OPS TESTED NORMAL IAW AMM 33-51-00-710-801M REV 79.SDR CALA2017051201339Battery · no testDURING AN EMERGENCY LIGHT CAPACITY TEST, FOUND M33409 BATTERY RUN TIME 15 MINUTES. REPLACED THE BATTERY AND OPS TESTED NORMAL IAW AMM 33-51-00-710-801, REV 79.SDR MASA2017051212292Light · inoperativeEMERGENCY FLOOD LIGHT ROW 20 INOPERATIVE.SDR VQI2017F00023Battery Pack · no testDURING ACCOMPLISHMENT OF TASK CARD 33510031, EMERGENCY LIGHT BATTERY AT 11WL & 13WL FAILED TO TEST. BATTERIES AT 11WL & 12WL WERE REPLACED IAW AMM 33-15-138.SDR SIMA20170524002Charger · not reportedNR 3 EMERGENCY LIGHTING BATTERY AND BATTERY CHARGER . REMOVED AND REPLACED BATTERY HOLDER AND BATTERY CHARGER ASSEMBLY IAW WC 33-700-19SDR SWAA2017052213907Lens · wrong partR1 DOOR LOWER EXIT SIGN LENS INCORRECT. R & R LENS IAW SIP.SDR SWAA2017051713812Sign · looseRIGHT OVERWING EMERGENCY EXIT SIGN LOOSE. SECURED THE SIGN IAW SIP.SDR SWAA2017051613776Sign · brokenR2 DOOR EMERGENCY EXIT SIGN BROKEN. R&R SIGN PER MM.SDR AALA201705169036Lens · missingEMERGENCY LIGHT IN THE FIRST CLASS GALLEY HAS A MISSING LENS. REMOVED AND REPLACED THE LIGHT ASSEMBLY IAW AMM 33-51-14. OPS CHECKED GOOD.SDR SWAA2017051613790Battery Pack · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1675. R&R BATTERY PACK PER AMM.SDR SWAA2017051613789Battery Pack · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1673. R&R BATTERY PACK PER AMM.SDR SWAA2017051613788Battery Pack · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1668. R&R BATTERY PACK PER AMM.SDR SWAA2017051613717Battery Pack · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1672. R&R BATTERY PACK PER AMM.SDR AALA201705129026Light · looseEMERGENCY LIGHT STRIP ON RIGHT SIDE, ROWS 11 AND 12 IS LOOSE. SECURED THE LIGHT STRIP IAW AMM 25-27-31. OPS CHECKED GOOD.SDR ASAA2017051120731Lens · missingF/A REPORTED EXIT SIGN LENS MISSING. ACFT GROUNED. INSTALLED A NEW LT FWD OVERWING EXIT EMERGENCY SIGN LENS IAW AMM 33-51-01.SDR AALA201705139001Power Supply · no testPOWER SUPPLY 10WL FAILED EMERGENCY BITE TEST. REPLACED THE POWER SUPPLY AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201705139009Light · brokenLIGHT ASSEMBLY BROKEN ON CABIN AFT GALLEY AT R5 DOOR. REMOVED AND REPLACED WITH NEW PROXIMITY LIGHT ASSEMBLY AT CABIN AFT GALLEY R5 DOOR IAW AMM 33-51-05-201, OPS CHECK GOOD.SDR AALA201705139008Light · brokenCABIN GALLEY AT R2 DOOR FOUND 1 EA EMERGENCY LIGHT LENS BROKEN ADJACENT LAV 2F-R1. REPLACED WITH A NEW PROXIMITY LIGHT ASSEMBLY IAW AMM 33-51-05-201. OPS CHK GOOD.SDR AALA20170511002Lens · missingAIRCRAFT WAS GROUNDED. EMERGENCY EXIT LIGHT AT R1 DOOR HAS A MISSING LENS COVER. REMOVED AND REPLACED LIGHT ASSEMBLY IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR R61A201705110347Sign · crackedL2 DOOR EXIT IDENTIFIER SIGN IS CRACKED. R&R EXIT SIGN IAW AMM 33-50-11. OPS CHECK GOOD.SDR QXEA2017051200353Lens · brokenEMERGENCY EXIT LIGHT JUST FORWARD OF THE TYPE 2/3 DOOR HAS A BROKEN COVER. R & R TYPE 2/3 EMERGENCY EXIT DOOR "EXIT" LIGHT LENS BASE ONLY WITH NEW FROM STOCK. PERFORMED OPS TEST OF EMERGENCY LIGHTS IAW AMM 33-51-00-710-802. OPS TEST PASS. NO FURTHER DEFECTS NSDR AALA201705129010Lens · looseEMERGENCY LIGHT LENS AT SEAT 25C FOUND LOOSE. SECURED THE LENS.SDR AALA201705129009Lens · missingFLIGHT ATTENDANT FOUND AFT GALLEY EMERGENCY EXIT SIGN LENS MISSING. INSTALLED THE LENS AND PERFORMED AN OPS TEST IAW AMM 33-51-17. OPS CHECKED GOOD. OK FOR SERVICE.SDR AALA201705129008Lens · missingR1 DOOR EMERGENCY EXIT SIGN MISSING THE LENS. REPLACED THE LENS.SDR HALA2017051100170Sign · unsecureEXIT SIGN ON THE R3 DOOR IS LOOSE. SECURED THE EXIT SIGN.SDR DALA2017051203816Battery · dischargedAFT CABIN OVERHEAD EMERGENCY LIGHTS INOP. REPLACED EMERGENCY BATTERY AND BATTERY POWER SUPPLY PER AMM 33-51. OPS CHKS GOOD. NO FAULTS NOTED. OK FOR SVC.SDR MASA2017051112290Sign · inoperativeEMERGENCY EXIT SIGN INOPERATIVE. REPLACED THE BATTERY PACK.SDR MASA2017051112289Light · inoperativeROW 21 FLOOD LIGHT INOPERATIVE.SDR MASA2017051112288Battery Pack · dischargedNUMEROUS EXIT LIGHTS INOPERATIVE. CHARGED BATTERIESSDR SWAA2017052313962Light · brokenEMERGENCY EXIT LIGHT BROKEN AT SIDEWALL PANEL 232YHM. R&R LIGHT ASSY PER MM.SDR SWAA2017051613806Battery Pack · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATIONS M1673. R&R BATTERY PACK PER AMM.SDR SWAA2017051613805Battery Pack · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATIONS M1675. R&R BATTERY PACK PER AMM.SDR SWAA2017051613804Battery Pack · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATIONS M1669. R&R BATTERY PACK PER AMM.SDR SWAA2017051613722Battery Pack · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATIONS M1671. R & R THE BATTERY PACK IAW AMM.SDR AALA201705169033Lens · missingEMERGENCY EXIT LIGHT ABOVE SEAT 10D HAS A MISSING LENS. REPLACED THE LENS IAW AMM 33-20-00. OPS CHECKED GOOD.SDR AALA201705169025Lens · missingEMERGENCY EXIT LIGHT ON THE UPPER CABIN HAS A MISSING LENS. REPLACED THE LENS IAW AMM 25-63-00. OPS CHECKED GOOD.SDR AALA201705169024Lens · missingEMERGENCY EXIT LIGHT AT THE R1 DOOR HAS A MISSING LENS. REMOVED AND REPLACED THE LIGHT ASSEMBLY IAW AMM 33-51-01. OPS CHECKED GOOD. ACFT WAS GROUNED.SDR AALA20170512004Lens · brokenDURING A PS2 INSPECTION, FOUND THE R4 DOOR EMERGENCY LIGHT LENS AND BRACKET BROKEN. REPLACED LIGHT ASSEMBLY IAW AMM 33-51-13.SDR AALA201705159035Light · inoperativeAIRCRAFT NOT GROUNDED. FWD EMERGENCY EXIT PATH LIGHTING BULB INOP. REPLACED LAMP ASSY AS REQUIRED.SDR AALA201705159034Lens · unsecureAIRCRAFT NOT GROUNDED. EMERGENCY EXIT FLOOR LIGHTING LENS POPPED OFF-SEAT 11D. RESECURED LIGHT LENS AT 11D.SDR ASOA201705104021Light · inoperativeDURING AN A-CHECK INSPECTION, THE PASSENGER DOOR EMERGENCY LIGHT WAS FOUND TO BE INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE AFFECTED LIGHT, OPERATIONALLY TESTED WITH NO DEFECTS NOTED AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR ASAA2017051020708Battery Pack · dischargedF/A REPORTS EMERGENCY EXIT LIGHTS IN AFT CABIN & EMERGENCY EXIT ROW ON WITH THE SWITCH IN THE ARMED POSITION. AFT GALLEY L/H EXIT, OVERWING RIGHT, AFT GALLEY OVERHEAD WITH EMERGENCY LIGHT SWITCH IN ARMED POSITION. GROUNDED - YES. EMERGENCY LIGHTS OPS CHECK GOO
Back to JASC 3350