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 AALA201710309014Lens · missingDOOR 1L EXIT MARKER LENS MISSING. INSTALLED DOOR 1L EXIT MARKER LENS IAW AMM.SDR AALA201710309013Lens · missingR1 DOOR OH LIGHTING LENS MISSING. REPLACED R1 DOOR OVERHEAD LIGHT LENS AMM.SDR AALA201710309009Lens · missingL2 DOOR AREA LIGHT LENS COVER MISSING. RE-INSTALLED L2 DOOR LIGHT LENS.SDR AALA201710309003Lens · unsecureEXIT LIGHT LENS COVER AT 4R WILL NOT STAY SECURE. INSTALLED NEW LENS COVER ON EMERGENCY EXIT ON R4 DOOR.SDR DALA2017102900253Power Supply · faultedDURING INSPECTION, FOUND EPSU 11WL FAULTY. REPLACED EPSU 11WL.SDR DALA2017102900252Power Supply · inoperativeDURING SERVICE CHECK, FLOOR EMERGENCY LIGHTS AT ROW 2A, 3A,7A,8A AND 9A INOPERATIVE. REPLACED EPSU 13WL.SDR DALA2017103007843Light · inoperativeSEAT MOUNTED EMERGENCY LIGHT 12D INOPERATIVE. INSTALLED A NEW LENS AT SEAT 12D EMERGENCY LIGHT. LIGHT OPS NORMAL IAW AMM 33-50.SDR 29GA2017102900001Power Supply · intermittentEMERGENCY LIGHTS WERE FLICKERING IN THE CABIN. R & R THE POWER SUPPLY IAW 33-50-01, CHECKED GOOD,SDR MASA2017102812730Bulb · inoperativeROW 15 OVERHEAD EMERGENCY FLOODLIGHT INOPERATIVE. REPLACED THE BULB.SDR MASA2017102812728Battery Pack · dischargedMID CABIN FLOOR AND CEILING EXIT SIGNS INOPERATIVE. CHARGED THE BATTERIES.SDR SWAA2017110217488Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY CHECK AT LOCATION M01672. R&R BATTERY PER AMM.SDR SWAA2017110217475Battery Pack · failedBOTH FORWARD EMERGENCY LIGHT BATTERY PACKS FAILED FUNCTIONAL TEST. R&R BATTERY PACK IAW AMM.SDR SWAA2017110217474Light · inoperativeRT WING EMERGENCY EXIT LIGHT INOP. RELAMPED LIGHT PER AMM.SDR AALA201710309036Power Supply · inoperativeAIRCRAFT WAS GROUNDED. EMERGENCY EXIT LIGHTS AT SEAT 18H, L4 AND R4 DOORS POPPED THE CIRCUIT BREAKER. REMOVED AND REPLACED POWER SUPPLY AT THE L4 DOOR PER AMM 33-51-06. OPERATIONAL CHECK GOOD.SDR AALA201710309033Lens · damagedTHE AIRCRAFT WAS NOT GROUNDED. DURING CRUSE THE EXIT SIGN LENS BETWEEN DOORS 2L AND 2R WAS REPORTED MISSING. THE EXIT SIGN LENS BETWEEN DOORS 2L AND 2R WAS REPLACED AND INSTALLED IAW TECH REF, MAINTENANCE OR REPAIR DONE IN PREVIOUS UPDATE.SDR AALA201710309032Lens · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT ON THE SIDEWALL JUST AFT OF THE FORWARD GALLEY HAS A MISSING LENS COVER. INSTALLED NEW LENS COVER PER 33-51-14. OPERATIONAL CHECK GOOD.SDR AALA20171027002Lens · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN AT THE R1 DOOR HAS A MISSING LENS COVER. REMOVED AND REPLACED LIGHT ASSEMBLY PER AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA201710319005Power Supply · faultyL3 & R3 EMER EXIT SIGNS NEAR DOOR HANDLE DOT NOT ILLUMINATE. REPLACED FAULTY EMERGENCY POWER SUPPLY IAW AMM.SDR CALA2017102803837Sign · brokenDOOR 1 AREA 2EA EXIT SIGN FOUND BROKEN. REPLACED THE EXIT SIGN AT DOOR 1 AREA AND C/O EMER LIGHT OPERATION TEST FOUND ''NORMAL'' REF AMM 33-51-00-710-801 REV 80.SDR CALA2017102803836Light · brokenFIRST CLASS 3EA EMERGENCY LIGHT BROKEN. REPLACED THE FIRST CLASS 3EA EMER LIGHT ASSY AND C/O EMER LIGHT OPERATION TEST FOUND "NORMAL" REF AMM 33-51-00-710-801 REV 80.SDR ASAA2017102722352Lens · detachedEXIT LIGHT LENS AT THE L2 DOOR DETACHED. ACFT GROUNDED. SECURED THE LENS OK FOR SERVICE.SDR DALA2017103007846Sign · inoperativeAFT OVERWING UPPER EMERGENCY EXIT SIGNS NOT ILLUMINATED.SDR AALA201710309016Power Supply · failedEMERGENCY LIGHT POWER SUPPLY FAILED OPERATIONAL TEST. REPLACE AS REQUIRED IN PASSENGER CABIN IAW AMM.SDR AALA201710309011Battery · faultedFWD LEFT EMERGENCY POWER SUPPLY BATTERY FAULT. REPLACE FWD LEFT EPSU BATTERY IAW AMM.SDR AALA201710309010Light · inoperativeEMERGENCY EXIT 'ON' INDICATION ON OVERHEAD PANEL NEEDS TO BE RE-LAMPED.SDR YENA201710270875Battery Pack · no testEMERGENCY LIGHTS BATTERY PACKS 15WL, 12WL AND 11 WL FAILED AN OPS CHECK IAW AMM 33-51-38-710-052B. REMOVED & REPLACED BATTERY PACKS AND OPS TESTED GOOD.SDR YENA201710270874Battery Pack · no testEMERGENCY LIGHTS BATTERY PACKS 15WL, 12WL AND 11 WL FAILED AN OPS CHECK IAW AMM 33-51-38-710-052B. REMOVED & REPLACED THE BATTERY PACKS, OPS TESTED GOOD.SDR YENA201710270873Battery Pack · no testEMERGENCY LIGHT BATTERY PACKS 15WL, 12WL AND 11 WL FAILED AN OPS CHECK IAW AMM 33-51-38-710-052B. REMOVED & REPLACED THE BATTERY PACKS AND OPS TESTED GOOD.SDR DALA2017102907835Sign · unsecureEMERGENCY EXIT SIGN COVER LOOSE AT LOCATION 601. EXIT SIGN FALLS OFF WHILE CLOSING INTERIOR DOOR. RE-SECURED EXIT SIGN AS REQUIRED.SDR CALA2017102703821Battery Pack · no testEMERGENCY LIGHT POWER SUPPLY AT M1670 FAILED A CHECK. R & R THE BATTERY PACK AND CHARGER IAW MM 33-51-06. OPS CHECKED NORMAL. OK FOR SERVICE.SDR CALA2017102703813Power Supply · inoperativePOWER SUPPLY M1210 FOUND INOPERATIVE, THE POWER SUPPLY M1210 WAS REPLACED AND OPS TESTED NORMAL IAW AMM 33-51-07.SDR CALA2017102703812Battery · faultySEAT 17AB TO 32AB CEILING EMERGENCY LIGHT FOUND DIM, THE POWER SUPPLY BATTERY M737 WAS REPLACED AND OPS TESTED NORMAL IAW AMM 33-51-07.SDR CALA2017102703811Battery · faultySEATS 22-26 AISLE EMERGECNY LIGHT FOUND DIM. THE POWER SUPPLY BATTERY M1209 WAS REPLACED AND OPS TESTED NORMAL IAW AMM 33-51-07.SDR CALA2017102703809Lamp · inoperativeEXTERIOR EMERGENCY LIGHT INOPERATIVE AT THE L4 DOOR. REPLACED THE LAMPS. OPS CHECKED GOOD.SDR CALA2017102703808Battery Pack · inoperativeFOUND THE L1 DOOR EMERGENCY LIGHTS CIRCUIT BREAKER TRIPPED. AND WILL NOT RESET. REMOVED AND REPLACED THE BATTERY PACKS, AND CHARGERS. OPS CHECKED GOOD. THE CIRCUIT BREAKER DID NOT TRIP IAW AMM 33-51-06.SDR CALA2017102703807Lamp · inoperativeL4 DOOR EXTERIOR EMERGENCY LIGHT IS INOPERATIVE. REPLACED THE LAMPS AND OPS CHECKED NORMAL.SDR CALA2017102703806Battery Pack · inoperativeDURING AN EMERGENCY LIGHT TEST, FOUND THE L3 & R3 AISLE EXIT LIGHT INOPERATIVE. REPLACED THE BATTERY PACK AND TESTED NORMAL IAW AMM 33-51-00-710-801, REV 80.SDR CALA2017102703805Light · brokenR2 DOOR FWD EMERGENCY LIGHT FOUND BROKEN,. REPLACED THE EMERGENCY LIGHT ASSY AND TESTED NORMAL IAW AMM 33-51-00-710-801, REV 80.SDR CALA2017102703818Sign · detachedCREW REPORTED EMERGENCY EXIT SIGN ABOVE THE L2 DOOR FELL OFF. ATTACHED THE EMERGENCY EXIT SIGNSDR CALA2017102703817Lamp · inoperativeEMERGENCY LIGHTS ARMED LIGHT RT SIDE INOPERATIVE ON THE OVERHEAD. REPLACED THE LAMPS, TESTED OK.SDR CALA2017102703810Lamp · inoperativeDURING AN OPS CHECK, FOUND THE EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMP AND TESTED IAW AMM 33-51-00.SDR CALA2017102703804Light · brokenA & B ZONE PARTITION EMERGENCY LIGHT FOUND BROKEN. REPLACED THE EMERGENCY LIGHT AND TESTED NORMAL IAW AMM 33-51-00-710-801, REV 80.SDR CALA2017102703803Battery Pack · dischargedBATTERY PACK DISCHARGED. REPLACED THE BATTERY PACK AND TESTED NORMAL IAW AMM 33-51-00-710-801, REV 80.SDR CALA2017102703802Battery Pack · dischargedBATTERY PACK DISCHARGED. REPLACED THE BATTERY PACK AND TESTED NORMAL IAW AMM 33- 51-00-710-801, REV 80.SDR CALA2017102703801Battery Pack · dischargedBATTERY PACK DISCHARGED. REPLACED THE BATTERY PACK AND TESTED NORMAL IAW AMM 33- 51-00-710-801, REV 80.SDR CALA2017102703800Battery Pack · dischargedBATTERY PACK DISCHARGED. REPLACED THE BATTERY PACK AND TESTED NORMAL IAW AMM 33-51-00-710-801, REV 80.SDR CALA2017102703799Battery Pack · dischargedEMERGENCY LIGHT BATTERY PACK DISCHARGED. REPLACED THE BATTERY PACK AND TESTED NORMAL IAW AMM 33-51-00-710-801, REV 80.SDR CALA2017102703798Light · brokenEMERGENCY LIGHT BROKEN. REPLACED THE EMERGENCY LIGHT AND TESTED NORMAL IAW AMM 33-51-00-710-801, REV.80.SDR CALA2017102703826Light · malfunctionedEMERGENCY LIGHT OPS CHECK FAILED, MESSAGE EPSU BATTERY FWD L CAME UP. RESET THE SYSTEM IAW AMM 23-73-00 OPS GOODSDR CALA2017102703832Lamp · inoperativeL2 DOOR EXTERIOR EMERGENCY LIGHT IS INOPERATIVE. REPLACED THE LAMP. OPS CHECKED GOOD.
Back to JASC 3350