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 SWAA2016122710778Lens · looseRIGHT OVERWING EXIT LIGHT LENS LOOSE. R & R LENS IAW MM.SDR SWAA2016122710774Light · inoperativeL1 DOOR EMERGENCY EXIT LIGHT INOPERATIVE. R & R THE LIGHT ASSY IAW MM.SDR FDEA201612204509Bulb · inoperativeDURING POSTFLIGHT FOUND LH SIDE EXTERIORE EMERGENCY EXIT LIGHT INOP EMERGENCY SLIDE LIGHT BULB REPLACED PER AMM 33-51-06 REV117.6 OPS TEST SATISSDR 29GA2016122300001Battery Pack · intermittentFORWARD EMERGENCY LIGHT WORKS INTERMITTENTLY. REMOVED AND REPLACED THE BATTERY PACK. OPERATIONAL CHECKED GOOD.SDR AALA20161222009Light · brokenEMERGENCY EXIT LIGHT ASSEMBLY BY R1 DOOR IS BROKEN. REMOVED AND REPLACED LIGHT ASSEMBLY IAW AMM 33-51-14. OPERATIONAL CHECKED GOOD.SDR RAIA201612200001Bulb · inoperativeEMERGENCY LIGHT ABOVE FA SEAT INOPERATIVE. R & R THE BULB. OPS CHECKED GOOD.SDR ASAA2016122019113Battery Pack · no testALL EMERGENCY LIGHT BATTERIES FAILED CAPACITY CHECK DURING ACCOMPLISHMENT OF T/C 78233001. ACFT GROUNDED. REPLACED THE EMERGENCY LIGHT BATTERIES. OPS CHECKED OK IAW AMM 33-51-06-960-805.SDR DALA2016122110034Lens · missingDURING INSPECTION. FOUND EMERGENCY LIGHT MISSING LENS COVER. MAINTENANCE REPLACED THE SIGN ASSEMBLY IAW AMM 33-50. OPS CHECKED GOOD.SDR SCNA20161221332Lens · missingTHE PLASTIC EXIT SIGN LENS IS MISSING FROM THE AFT LAVATORY LEFT SIDE. INSTALLED EMER EXIT CAP LENS AT L-2 LAV ISLE POSITION.SDR SWAA2016122110766Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1674. R&R BATTERY PER AMM.SDR SWAA2016122110765Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1673. R&R BATTERY PER AMM.SDR SWAA2016122110764Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1672. R&R BATTERY PER AMM.SDR SWAA2016122110763Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1670. R&R BATTERY PER AMM.SDR SWAA2016122110762Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1668. R&R BATTERY PER AMM.SDR SWAA2016122010760Cover · crackedRT OVERWING EMERGENCY EXIT LIGHT COVER CRACKED. R&R COVER IAW AMM.SDR SWAA2016122110755Sign · looseR1 DOOR EMERGENCY EXIT LOWER LIGHT SIGN LOOSE. SECURED SIGN AMM.SDR SWAA2016122110748Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1675. R&R BATTERY PER AMM.SDR SWAA2016122110744Light · inoperativeRT EMERGENCY EXIT HATCH LIGHT INOP AT UPPER FUSELAGE. R&R LIGHT PER AMM.SDR SWAA2016122010732Sign · brokenRT AFT EMERGENCY EXIT LIGHTED SIGN BROKEN. R&R SIGN ASSEMBLY PER AMM.SDR DALA2016122010001Wire · brokenFOUND EMERGENCY LIGHT INOPERATIVE. REPAIRED BROKEN WIRES AT SEAT 31ED IAW SWPM. OK FOR SERVICE.SDR R61A201612200746Battery Pack · faultedCREW REPORTED AN EMERGENCY LIGHT BATTERY FAULT. MAINTENANCE REMOVED AND REPLACED EMERGENCY BATTERY IAW AMM AND OPS CHECKED GOOD.SDR SIMA20161220001Bulb · inoperativeFIRST INTERIOR CEILING EMERGENCY LIGHT IS INOPERATIVE. REPLACED THE BULB IN THE FIRST INTERIOR CEILING EMERGENCY LIGHT. OPS CHECKED GOOD IAW AMM 33-50-08.SDR JJBA20161220018Bulb · inoperativeROW 18A OVERHEAD EMERGENCY LIGHT INOPERATIVE. R & R THE BULB.SDR AALA20161220016Pin · missingAIRCRAFT NOT GROUNDED. EMERGENCY EXIT SIGN AT RIGHT ROW 24 FELL OFF DUE TO MISSING INSTALLATION PINS ON THE BRACKET. PREVIOUS REPAIR REPLACED WITH PERMANENT REPAIR, REPLACED PIN IAW AMM 20-00-00 AND EA 266190. OPERATIONAL CHECK GOOD. (CLOSED)SDR DALA2016122010051Cover · damagedEMERGENCY EXIT COVER DIFFUSER LENS DAMAGED. REINSTALLED EXIT SIGN COVER.SDR AALA20161222002Sign · detachedEMERGENCY EXIT SIGN AT SEAT 21F IS DETACHED. SECURED THE SIGN IAW AMM 33-51-01. OPERATIONAL CHECKED GOOD.SDR DALA2016122110016Lens · missingDURING INSPECTION FOUND EMERGENCY EXIT COVER DIFFUSER LENS DAMAGED OR MISSING. MAINTENANCE REINSTALLED EMERGENCY EXIT LENS COVER.SDR REXA2016121902477Light · missingLEFT, FORWARD MOST SECTION OF EMERGENCY EXIT LIGHTING ALONG FLOOR IS MISSING. R&R EMERGENCY FLOOR TRACK IAW AMM 33-51-01. OPC GOOD, OK FOR SVC.SDR AALA201612209004Light · unsecureAIRCRAFT WAS NOT GROUNDED. HANGING LIGHT ON AISLE AT SEAT 13C. RESECURED LIGHT ASSEMBLY AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201612209003Lens · missingAIRCRAFT WAS NOT GROUNDED. FLIGHT ATTENDANT REPORTS LIGHT LENS MISSING, R4 DOOR FRAME. REPLACEDSDR SWAA2016122110749Cover · looseL1 DOOR LOWER EMERGENCY EXIT LIGHT COVER LOOSE. SECURED COVER IAW SIP.SDR ASAA2016121919103Sign · unsecureEXIT SIGN FWD GALLEY BY R1 DOOR WILL NOT STAY ATTACHED. GROUNDED - YES. REPLACED EXIT SIGN IAW IPC 33-51-05-02A.SDR ASAA2016121919102Light · inoperativeRIGHT EXTERIOR FORWARD OVERWING EXIT LIGHT INOP. GROUNDED - YES. RELAMPED. OPS CHECK NORMAL, REF AMM 33-51-04-960-801.SDR SWAA2016122010712Lens · missingR1 DOOR EMERGENCY "EXIT" LIGHT COVER LENS MISSING. INSTALLED LENS PER SIP.SDR SWAA2016122010702Sign · detachedFORWARD ENTRY EMERGENCY EXIT SIGN DETACHED. SECURED SIGN PER EA.SDR AALA20161221015Lens · detachedEMERGENCY EXIT LIGHT AT LEFT OVERWING AFT DOOR HAS A DETACHED LENS COVER. SECURED LENS COVER IAW AMM 33-50-00. OPERATIONAL CHECK GOOD.SDR AALA20161221014Lens · missingCEILING EMERGENCY EXIT SIGN RIGHT OVERWING EXIT IS MISSING LENS COVER. REMOVED AND REPLACED EXIT SIGN LIGHT ASSEMBLY IAW AMM 35-51-01. OPERATIIONAL CHECKED GOOD.SDR AALA20161221013Battery · dischargedAIRCRAFT NOT GROUNDED. EMERGENCY ESCAPE SEAT MOUNTED LIGHTS FROM SEAT 1E TO 6E ARE INOPERATIVE. CHARGED POWER SUPPLY BATTERY IAW IAW 33-51-07. OPERATIONAL CHECKED GOOD.SDR AALA20161221012Battery · dischargedL1 DOOR EMERGENCY EXIT LIGHT IS INOPERATIVE. CHARGED POWER SUPPLY BATTERY IAW IAW 33-51-07. OPERATIONAL CHECKED GOOD.SDR AALA20161221011Battery · dischargedR1 EMERGENCY EXIT LIGHT IS INOPERATIVE. CHARGED POWER SUPPLY BATTERY IAW IAW 33-51-07. OPERATIONAL CHECKED GOOD.SDR AALA201612209001Lens · missingLENS ON SEAT 9D MISSING, OPEN SOCKET. INSTALLED NEW LENS AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR DALA2016122009976Connector · damagedEMERGENCY LIGHTS AT SEAT 16J, 19B, AND 23B WERE INOPERATIVE. REPAIRED CONNECTORS AND REPLACED LIGHT ASSEMBLY AT 23B.SDR DALA2016122009975Battery Pack · no testDURING TESTING OF EPSU CAPACITY TEST, BATTERY PACK 19WL FAILED. REPLACED THE BATTERY PACK 19WL. LP 9049518SDR CALA2016121901120Fuse · faultyOVERHEAD EMERGENCY LIGHT INOP AT 29 DEF AND 34DEF. REPLACED FUSE IN BATTERY CHARGER M2627 MM 33-51-06. OP CKS GOOD.SDR CALA2016121901118Charger · inoperativeLEFT EMERGENCY EXIT OVERWING LIGHTS INOP INSIDE AND OUT REPLACED M1694 BATTERY CHARGER & BATTERY REF AMM 33-21-06. OPS CHECKED GOOD REF AMM 33-51-00SDR CALA2016121901117Charger · inoperativeRT AFT OVERWING EXIT EMERGENCY LIGHT IS INOP. FWD RT DOOR ALSO GOES OUT AFTER 1 MIN OF BEING ON REPLACED M1694 BATTERY CHARGER & BATTERY REF AMM 33-51-06. OPS CK GOOD REF AMM 33-51-00SDR CALA2016121901116Socket · defectiveAFT LEFT DOOR SLIDE EMERGENCY LIGHT INOP. REPLACED THE SOCKET ASSY FOR L397 AFT L DOOR SLIDE LIGHT. OPS GOOD.SDR CALA2016121901115Light · intermittentCABIN EMER EXIT LTS CABIN EMER EXIT LTS FLASH INTRMTTLY IN FLT. CYCLE EMERGENCY LIGHTS ON AND OFF AND LIGHTS OPERATED NORMAL.SDR CALA2016121901113Light · intermittentCABIN EMER EXIT LITES DISCO ON OFF INBD CREW STATED EMER LIGHTS CAME ON ONE TIME FOR 30SEC. CYC ALL EMER SWITCHES AND TEST SWITCHES. ALL LIGHTS CHECK OK AT THIS TIME REF AMM33-51-00.SDR CALA2016121901112Light · intermittentEMER LIGHTS KEEP TURNING ON AND OFF ON THEIR OWN. OPS CHK EMERGENCY LIGHTS PER MM 33-51-00. OPS CHK OK.
Back to JASC 3350