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 ASOA201803215085Battery Pack · inoperativeDURING MX INSPECTION, THE AFT FACING OVERWING EMERGENCY EXIT SIGN, LEFT OVERWING EMERG EXIT, LEFT SIDE EXIT SIGNS, AND RIGHT OVERWING UPPER EXIT SIGN WAS FOUND INOPERATIVE. MX R & R THE NR 3 BATTERY PACK, OPS CHECKED GOOD. ACFT APPROVED FOR RETURN TO SERVSDR DALA2018032201858Lens · damagedEMERGENCY EXIT LIGHT LENS DAMAGED SEAT 26F, REPLACED EXIT LIGHT LENS.SDR DALA2018032201857Light · detachedEMERGENCY EXIT LIGHT AT SEAT 44 WAS FOUND DETATCHED FROM THE SEAT. SECURED THE LIGHT ASSY.SDR SWAA2018032220664Lens · missingL2 DOOR EMERGENCY LIGHTS LENS MISSING ARROW. R&R LENS IAW.SDR SWAA2018032220663Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1673. R&R BATTERY PER MM.SDR SWAA2018032220662Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1672. R&R BATTERY PER MM.SDR SWAA2018032220628Lens · missingR2 DOOR EMERGENCY LIGHTS LENS MISSING ARROW. R&R LENS IAW.SDR SWAA2018032220627Spring · brokenAFT EMERGENCY LIGHTS GUARDED SWITCH SPRING BROKEN. R&R LIGHT PANEL PER AMM.SDR SWAA2018032220626Lens · fadedLT OVERWING EMERGENCY DOOR LIGHT LENS COVER FADED. R&R LENS IAW AMM.SDR SWAA2018032220625Lens · missingL1 DOOR EMERGENCY EXIT SIGN COVER LENS MISSING RED ARROW. R&R LENS IAW AMM.SDR SWAA2018032220621Light · inoperativeRT BULLNOSE EMERGENCY LIGHT INOP AT ROW 16. RELAMPED LIGHT IAW AMM.SDR SWAA2018032220609Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1670. R&R BATTERY PER MM.SDR ASAA2018032124002Light · inoperativeR1 DOOR EMERGENCY LIGHT INOP. GROUNDED - YES. RELAMPED R1 DOOR EMERGENCY LIGHT REF AMM 33-51-04-960-801 OPS CHECK GOOD.SDR U2RA201803210002Lamp · inoperativeR3 DOOR EXTERIOR EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMP AND OPS CHECKED NORMAL.SDR U2RA201803210001Lamp · inoperativeR1 DOOR EXTERIOR EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMP AND OPS CHECKED NORMAL.SDR CALA2018032200980Indicator · damagedCAB DOOR 1L AFT EXIT IDENT BASE DAMAGED. CAB DOOR 1L AFT EXIT IDENT LT ASSY REPLACED, INSTALLATION TEST CARRIED OUT FOUND NORMAL REF AMM 33-51-01-960-802 REV82 & AMM 33 -51-01-710-802 REV82.SDR CALA2018032200979Indicator · damagedCAB DOOR 3L FWD EXIT IDENT BASE DAMAGED. CAB DOOR 3L FWD EXIT IDENT LT ASSY REPLACED, INSTALLATION TEST CARRIED OUT FOUND NORMAL REF AMM 33-51-01-960-802 REV82 & AMM 33 -51-01-710-802 REV82.SDR CALA2018032200978Indicator · damagedCAB DOOR 3R FWD EXIT IDENT BASE DAMAGED. CAB DOOR 3R FWD EXIT IDENT LT ASSY REPLACED, INSTALLATION TEST CARRIED OUT FOUND NORMAL REF AMM 33-51-01-960-802 REV82, AMM 33-51-01-710-802 REV82.SDR CALA2018032200977Light · crackedLAV 3A-LC R SIDE AFT FLOOR PROXIMITY LIGHT ASSY CRACKED. REPLACED LAV 3A-LC R SIDE AFT FLOOR PROXIMITY LIGHT ASSY C/OUT CONDITION CHECK & OPERATIONAL TEST FND "NORMAL" REF AMM 33-51-00 -710-801 REV82, REFER JOB CARD INN0806.SDR CALA2018032200976Light · crackedLAV 3A-LC DOOR LT FLOOR PROXIMITY LIGHT ASSY CRACKED. REPLACED LAV 3A-LC DOOR LT FLOOR PROXIMITY LIGHT ASSY C/OUT CONDITION CHECK & OPERATIONAL CHECK FND "NORMAL" REF AMM 33-51-0 0-710-801 REV82, REF JOB CARD INN0806.SDR CALA2018032200975Light · crackedLAV 3F-LC LT AFT FLOOR PROXIMITY LIGHT ASSY CRACKED. REPLACED LAV 3F-LC LT AFT FLOOR PROXIMITY LIGHT ASSY C/OUT CONDITION CHECK & OPERATIONAL TEST FND "NORMAL" REF AMM 33-51-00 -710-801 REV82, REF JOB CARD INN0806.SDR CALA2018032200974Light · crackedLAV 3A-LC R SIDE FWD FLOOR PROXIMITY LIGHT ASSY CRACKED. REPLACED LAV 3A-LC R SIDE FWD FLOOR PROXIMITY LIGHT ASSY C/OUT CONDITION CHECK & OPERATIONAL TEST FND "NORMAL" REF AMM 33-51-00 -710-801 REV82, REF JOB CARD INN0806.SDR CALA2018032200973Light · crackedLAV 3A-LC DOOR RT FLOOR PROXIMITY LIGHT ASSY CRACKED. REPLACED LAV 3A-LC DOOR RT FLOOR PROXIMITY LIGHT ASSY, C/OUT CONDITION CHECK & OPERATIONAL TEST PER AMM 33-51-00-710-802 REV82, REF JOB CARD INN0806.SDR DALA2018032201837Battery Pack · dischargedTOP AFT LEFT AND RIGHT OVER WING EMERGENCY DOOR EMERGENCY LIGHT INOP. T/S TOP AFT LT/RT OVER WING EXIT DOOR EMERGENCY LIGHT PER AMM 33-50. R&R EMERGENCY BATTERY PACK. OPS CK GOOD. OK FOR SVC.SDR PNSA2018032103Power Supply · failedEMERGENCY LIGHTING POWER SUPPLY FAILED DURING 6-MONTH FUNCTIONAL TEST.SDR MASA2018032113075Light · inoperativeEMERGENCY LIGHT STRIP AT FWD CLOSET INOPERATIVE. REPLACED THE LIGHT.SDR CALA2018032100955Battery Pack · inoperativeEMERGENCY EXIT LIGHTS WILL NOT ILLUMINATE AT THE R2 DOOR AND LAST FEW ROWS OF COACH SEATS. REMOVED AND REPLACED THE POWER SUPPLY BATTERY PACK M1672 IAW AMM 3 3-51-06-960-805. EMERGENCY LIGHTS OPS CHECKED GOOD.SDR SWAA2018032620676Battery Pack · no testEMERGENCY LIGHT BATTERY PACKS FAILED A CAPACITY TEST AT M01674. R & R THE BATTERY PACK IAW MM.SDR SWAA2018032620675Light · crackedFORWARD GALLEY EMERGENCY LIGHT STRIPS CRACKED. R & R THE LIGHT IAW MM.SDR SWAA2018032620656Lens · crackedRIGHT EXTERIOR EMERGENCY LIGHT LENS CRACKED AFT WING POSITION. R & R THE LENS IAW AMM.SDR SWAA2018032620654Battery Pack · no testEMERGENCY LIGHT BATTERY PACK FAILED A CAPACITY TEST AT M01669. R & R THE BATTERY PACK IAW MM.SDR ASOA201803205084Bulb · inoperativeDURING MX INSPECTION, THE LT OVERWING EMERGENCY LIGHT WAS INOPERATIVE. MX R & R THE BULB, OPS CHECKED GOOD. ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR SIMA20180320004Light · inoperativeEMERGENCY FLOOR LIGHTS AT 3A TO 6A INOP-C/A-ADJUSTED EMERG FLOOR LIGHT STRIPS IAW AMM 33-50-12. NO DEFECTS FOUND AT THIS TIME.SDR SIMA20180320005Light · inoperativeMAIN DOOR EXTERNAL EMERGENCY LIGHT INOP.-C/A-REMOVED AND REPLACED MAIN DOOR EXTERNAL EMERGENCY LIGHT LAMP. OPS CHECKED GOOD IAW AMM 33-50-10SDR AALA201803229006Battery Pack · defectiveAIRCRAFT WAS GROUNDED. EMERGENCY PATH LIGHT BATTERY BS-103 REQUIRES REPLACEMENT. REPLACED EMERGENCY PATH LIGHT BATTERY PACK PER WDM 33-51-12.SDR AALA201803229005Battery Pack · defectiveAIRCRAFT WAS GROUNDED. EMERGENCY PATH LIGHT BATTERY AT POSITION BS-105 REQUIRES REPLACEMENT. REPLACED EMERGENCY PATH LIGHT BATTERY AT BS-105 PER WDM 33-51-12.SDR AALA201803219026Light · intermittentSEAT ROW 17DEF EMERGENCY LIGHT INTERMITTENT. REPLACED THE LIGHT ASSEMBLY AND HARNESS IAW AMM 33-51-11.SDR AALA201803219018Power Supply · no testDURING EMERGENCY LIGHT TEST, THE POWER SUPPLY FORWARD LEFT AND RIGHT DISPLAYED, TEST DID NOT PASS. REPLACED THE POWER SUPPLY 12WL IAW AMM 33-51-38.SDR AALA201803219013Power Supply · no testDURING EMERGENCY LIGHT TEST, THE SUPPLY POWER UNIT FORWARD LEFT AND RIGHT DISPLAYED, TEST DID NOT PASS. REPLACED THE POWER SUPPLY 10WL IAW AMM 33-51-38.SDR DALA2018032101828Battery · faultedEMERGENCY LIGHT BATTERY 17WL FAULT LIGHT ILLUMINATED. REPLACED THE BATTERY.SDR HNAA2018032100063Bulb · inoperativeEMERGENCY LIGHT IS INOPERATIVE AT SEATS 6DF. REMOVED AND REPLACED THE BULB.SDR DALA2018032101821Light · unsecureSEAT MOUNTED EMERGENCY LIGHTING IS DAMAGED / INOPERATIVE AT 26C. MAINTENANCE RESECURED THE EMERGENCY LIGHT PER AMM 33-51. SYSTEM IS NOW OK FOR SERVICE.SDR KCSA201803201031Sign · damagedCENTER EMERGENCY EXIT SIGN HAS A DAMAGED STUD.SDR PNSA2018032001Light · looseFOUND L FWD EMERGENCY FLOOR ESCAPE PROXIMITY LIGHTING STRIP COME LOOSE. RE-SECURED STRIP.SDR DALA2018032001812Lens · unsecureDURING INSPECTION, FOUND THE EMERGENCY EXIT SIGNS INOPERATIVE. MAINTENANCE REINSTALLED LENS. ACFT OK FOR SERVICE.SDR YENA201803200136Battery · no testEPSU BATTERY 13WL FAILED AN EMERGENCY LIGHT SYSTEM TEST. R & R THE BATTERY IAW AMM 33-51-38, BATTERY AND SYSTEM OPS CHECKED GOOD.SDR SWAA2018032720613Lens · crackedLEFT EMERGENCY EXIT SIDEWALL LIGHT LENS CRACKED. R&R LENS IAW SIP.SDR SWAA2018032620653Bulb · inoperativeAFT AREA AISLE EMERGENCY EXIT LIGHT BULB INOPERATIVE. R & R THE BULB IAW AMM.SDR DALA2018032001853Power Supply · no testEMERGENCY POWER SUPPLY AFT LT FAILED 13WL. REPLACED THE POWER SUPPLY.SDR SWAA2018032220623Light · not seatedRT OVERHEAD BIN EMERGENCY LIGHT INOP AT ROW 8. RESEATED LIGHT IAW AMM.
Back to JASC 3350