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 SWAA2016090155321Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1670. R & R BATTERY IAW AMM.SDR SWAA2016090155320Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1669. R & R BATTERY IAW AMM.SDR SWAA2016090155345Lens · missingEMERGENCY EXIT BULL NOSE LIGHT COVER LENS MISSING AT ROW 22. R & R LENS IAW SIP.SDR ASOA2016083115330Light · missingEMERGENCY LIGHT STRIP MISSING AT ROW 13CD. INSTALLED NEW LIGHT STRIP AT ROW 13CD IAW AMM 33-51-01, OPS CHECK GOOD, ACFT OK FOR SERVICE.SDR ASAA2016083117878Light · inoperativeEMERGENCY SPOTLIGHT ON ROW 27L BULLNOSE IS INOPERATIVE, REF T/C 78233008. ACFT GROUNDED. RELAMPED 27L BULLNOSE EMERGENCY LIGHT, OPS NORMAL, REF T/C 78233008.SDR DALA2016090106368Battery · inoperativeDURING INSPECTION FOUND EMERGENCY LIGHT BATTERY AT M01672 INOPERATIVE. MAINTENANCE R & R EMERGENCY BATTERY AT M01672 IAW AMM 33-51. OPS CK GOOD.SDR UHLA201608310426Light · inoperativeFOUND MAIN DOOR EXIT IDENTIFIED LIGHT NOT WORKING WHEN EMERGENCY PLACE ON. R & R SIGN, EXIT ID IAW MM 33-50-15.SDR DALA2016090106343Battery Pack · dischargedEMERGENCY PATH LIGHTS AT TAIL STAIRS GO OUT AFTER 5 SEC. R & R BATTERY PACK AT THE DROP DOWN CEILING LOCATION ABOVE F/A SEAT. LIGHTS OPS CHECK NORMAL.SDR REXA2016083101669Battery Pack · inoperativeEMERGENCY LIGHTS CAME ON BRIEFLY. THEN WENT OUT. REMOVED AND REPLACED ALL FOUR BATTERY PACKS IAW AMM 33-51-04. OPS CHECKED GOOD IAW AMM 33-51-04.SDR CALA2016090195710Power Supply · malfunctionedEMERGENCY LIGHTS FAILED TEST . MESSAGE FOR EPSU BATTERY. RESET OVERWING LEFT POWER SUPPLY UNIT, RAN TEST AGAIN, NO FAULTSSDR REXA2016083101668Light · inoperativeRIGHT EXTERIOR MIDDLE EMERGENCY LIGHT INOPERATIVE. REMOVED AND INSTALLED THE EMERGENCY LIGHT IAW AMM 33-51-21. OPS CHECKED GOOD.SDR MASA2016083112349Light · inoperativeROWS 21 AND 23 CEILING EMERGENCY FLOOD LIGHTS INOPERATIVE.SDR MASA2016083112350Battery Pack · dischargedROW 3 EXIT SIGN INOPERATIVE. CHARGED THE BATTERIESSDR R61A201608310509Light · inoperativeCREW REPORTED THAT THE EMERGENCY LIGHT IN FIRST CLASS WAS INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE LIGHT IAW AMM AND OPS CHECKED GOOD.SDR JJBA20160831001Battery · dischargedEMERGENCY LIGHTS INOPERATIVE. R & R NR 2 & NR 4 EMERGENCY BATTERIES, PN 2013-1A, SN 96788, TAH 21091.25, TAC 15137.SDR REXA2016083101614Light · looseLEFT GALLEY EMERGENCY FLOOR PATH LIGHTING STRIP IS LOOSE. RESECURED LT GALLEY EMERGENCY FLOOR PATH TRACK IAW AMM 33-51-01. ALL CHECKS GOOD.SDR SWAA2016092608171Light · brokenFORWARD ENTRY LOWERED CEILING EMERGENCY EXIT LIGHT BROKEN. R & R LIGHT IAW SOPM.SDR SWAA2016091355718Light · crackedAFT CABIN EMERGENCY LIGHT CRACKED. R & R THE LIGHT IAW AMM.SDR ABXA20160830140Battery Pack · dischargedEMERGENCY LIGHT SPARE BATTERY PACK M737 IS INOPERATIVE. THE EMERGENCY LIGHT BATTERY PACK M737 WAS REPLACED. THE CAUSE OF THE INOPERATIVE BATTERY PACK WAS A DISCHARGED BATTERY.SDR ABXA20160830139Socket · inoperativeEXTERIOR EMERGENCY LIGHTING SYSTEM INOPERATIVE. THE LAMP WAS REPLACED IN THE EMERGENCY LIGHT LAMPHOLDER ASSEMBLY. THE CAUSE OF THE INOPERATIVE LIGHT WAS A FAILED LAMP.SDR ABXA20160830138Battery Pack · dischargedINTERIOR EMERGENCY LIGHTING SYSTEM INOPERATIVE. THE EMERGENCY LIGHT BATTERY PACK WAS REPLACED. THE CAUSE OF THE INOPERATIVE LIGHTS WAS A DISCHARGED BATTERY.SDR SWAA2016090655403Sign · looseRIGHT OVERWING EXIT SIGN LOOSE. SECURED SIGN IAW S.I.P.SDR SWAA2016090155326Battery Pack · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1672. R & R BATTERY PACK IAW MM AND DWG.SDR SWAA2016090155318Sign · missingRIGHT OVERWING EMERGENCY EXIT SIGN MISSING. INSTALLED SIGN IAW MM.SDR DALA2016083106346Charger · inoperativeCREW REPORTED AFT EMERGENCY LIGHT BLINKING. R & R BATTERY CHARGER AND BATTERY PACK.SDR REXA2016083001667Bulb · inoperativeEMERGENCY LIGHT BULB BURNED OUT. R & R THE BULBS. OPS CHECK NORMAL, OK FOR SERVICE IAW AMM 33-11-05 & AMM 31-11-00.SDR AALA20160830012Battery Pack · inoperativeINTERIOR EMERGENCY SIDE WALL LIGHT AT R2 AND L2 DOORS ARE INOPERATIVE. REMOVED AND REPLACED BATTERY CHARGER MODULE AND BATTERY PACK IAW AMM 33-51-07. OPS CHECKED GOOD. THE AIRCRAFT WAS GROUNDED.SDR AALA20160830011Battery Pack · inoperativeINTERIOR EMERGENCY SIDE WALL LIGHT AT R3 AND L3 DOORS ARE INOPERATIVE. REPLACED THE BATTERY PACK IAW AMM 33-51-07. OPERATIONS CHECK GOOD IAW AMM 33-51-07. THE AIRCRAFT WAS GROUNDED.SDR AALA20160830010Battery Pack · inoperativeSEAT MOUNTED EMERGENCY LIGHTS ON SEATS 26D - 36D ARE INOPERATIVE. REPLACED BATTERY PACK IAW AMM 33-51-07. OPS CHECKED GOOD IAW AMM 33-51-07. THE AIRCRAFT WAS GROUNDED.SDR AALA20160830009Battery Pack · inoperativeSEAT MOUNTED EMERGENCY LIGHTS ON SEATS 26D - 36D ARE INOPERATIVE. REPLACED BATTERY PACK IAW AMM 33-51-07. OPS CHECKED GOOD, IAW AMM 33-51-07. THE AIRCRAFT WAS GROUNDED.SDR AALA20160830008Charger · inoperativeSEAT MOUNTED EMERGENCY LIGHTS ON SEATS 9D - 15D ARE INOPERATIVE. REMOVED AND REPLACED BATTERY CHARGER MODULE AND BATTERY PACK IAW AMM 33-51-07. OPS CHECKED GOOD. THE AIRCRAFT WAS GROUNDED.SDR AALA20160830007Lens · looseLENS LOOSE ON FORWARD EMERGENCY FLOOD LIGHT AT G2 GALLEY SIDEWALL. REPLACED FORWARD GALLEY ENERGENCY FLOOD LIGHT ASSEMBLY IAW AMM 33-51-14, CHECKED OK IAW AMM 33-51-00. THE AIRCRAFT WAS NOT GROUNDED.SDR SIMA20160830002Power Supply · inoperativeEMERGENCY LIGHTS 2 AND 3 INOPERATIVE. REMOVED AND REPLACED THE NR 2 EPSU IAW AMM 33-50-04. OPS CHECKED GOODSDR SWAA2016083155304Lens · detachedRIGHT OVERWING EMERGENCY EXIT SIGN LIGHT LENS FELL OFF. SECURED THE LENS IAW EA.SDR IPXA2016083007658Power Supply · inoperativeDURING PDC CHECK, FOUND EMERGENCY LIGHT BATTERY VOLTAGE LOW. R & R THE POWER SUPPLY AND TESTED NORMAL IAW AMM 33-51-01/401,501.SDR HNAA2016083100264Bulb · inoperativeROW 6DF EMERGENCY LIGHT INOPERATIVE. R & R THE BULB.SDR MASA2016083012346Lamp · inoperativeTWO LAMPS FOUND INOPERATIVE IN SERVICE DOOR EXIT SIGN.SDR CALA2016083000612Battery Pack · inoperativeAFT GALLEY EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE BATTERY PACK AND CHECKED NORMAL.SDR CALA2016083000611Battery Pack · inoperativeFWD CREW REST COMPARTMENT EMERGENCY LIGHTS WILL NOT EXTINGUISH WITH ACFT POWER REMOVED AND EMERGENCY LIGHTS SWITCH OFF. CYCLED SWITCH, NO HELP. REMOVED AND REPLACED BATTERY PACK.SDR MASA2016083012345Light · inoperativeROW 15 CEILING LEVEL EMERGENCY FLOOD LIGHT INOPERATIVE.SDR MASA2016083012344Light · inoperativeROW 15 CEILING LEVEL EMERGENCY FLOOD LIGHT INOPERATIVE.SDR SIMA20160830001Light · damagedEMERGENCY LIGHT DISCOLORED & DOES NOT CORRECTLY ILLUMINATE. REPLACED THE LIGHT & CHECKED OK IAW MM 33-50-21SDR SWAA2016083055268Light · inoperativeR1 DOOR EXTERIOR EMERGENCY LIGHT INOPERATIVE. RELAMPED LIGHT IAW MM.SDR ABXA20160829137Battery Pack · dischargedCREW SERVICE AREA INTERIOR LIGHTS ARE INOPERATIVE WHEN IN EMERGENCY LIGHTS MODE. THE EMERGENCY LIGHT BATTERY PACK M736 WAS REPLACED. THE CAUSE OF THE INOPERATIVE LIGHTS WAS A DISCHARGED BATTERY.SDR SWAA2016090155374Battery Pack · dischargedRIGHT AFT GALLEY AREA EMERGENCY EXIT SIGN INOPERATIVE. R & R BATTERY PACK IAW AMM.SDR SWAA2016090155373Battery Pack · dischargedRIGHT FORWARD GALLEY EMERGENCY EXIT SIGN INOPERATIVE. R & R BATTERY PACK IAW AMM.SDR SWAA2016090155352Lens · dirtyLEFT EXTERNAL EMERGENCY LIGHT LENS DIRTY, JUST FORWARD OF WING TO BODY FAIRINGS. CLEANED LENS IAW SOPM.SDR SWAA2016090155348Lens · dirtyLEFT EXTERNAL EMERGENCY LIGHT LENS DIRTY, JUST AFT OF WING TO BODY FAIRINGS. CLEANED LENS IAW SOPM.SDR ASOA2016082915328Light · unserviceableEMERGENCY TRACK LIGHTING ON FLOOR NEEDS TO BE REPLACED. REMOVED FLOOR TRACK LIGHTING 6 EA PIECES IAW AMM 33-51-01-000-808. INSTALLED 6 EA NEW PIECES OF FLOOR TRACK LIGHTING IAW AMM 33-51-01-400-808. PERFORMED OPS TEST OF THE EMERGENCY LIGHTS IAW AMM 33-51-0SDR ASOA2016082915327Light · inoperative12 CD LOWER EXIT SIGN HAS 1 LIGHT BULB BURNED OUT. R & R 12 CD LOWER EXIT SIGN LIGHT BULB IAW AMM 33-51-05. OPS CHECKED GOOD.
Back to JASC 3350