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 ASAA2017100722133Sign · detachedFA REPORTED AN EXIT SIGN IS HANGING BY THE WIRE MID CABIN. ACFT GROUNDED. ENGAGED THE RETAINER. LIGHT OPS NORMAL.SDR ASAA2017100722132Lens · missingLEFT AFT OVERWING EMERGENCY EXIT SIGN LENS ADJACENT TO FLOOR MISSING. ACFT GROUNDED. INSTALLED A NEW LENS. OPS CHECKED GOOD.SDR YENA201710070830Lens · missingSEAT 9D EMERGENCY LIGHT LENS MISSING. REPLACED THE LENS IAW AMM 33-50-00.SDR DALA2017100807377Lens · looseEMERGENCY EXIT SIGN LENS FOUND LOOSE SECURED THE LENS. OK FOR SERVICE.SDR DALA2017100907379Battery Pack · inoperativeDURING A LINE CHECK, NOTED SIGNS ABOVE FWD EMERERGENCY EXIT DOORS INOPERATIVE. BATTERIES WERE REPLACED AND OPERATION WAS NORMAL.SDR DALA2017100907351Power Supply · inoperativeDURING INSPECTION, FOUND EMERGENCY LIGHT AT SEAT 1DC, INOPERATIVE. MAINTENANCE R & R THE POWER SUPPLY AND BATTERY PACK M1674 IAW MM 33-51-06. OPS CHECKED GOOD.SDR ASOA201710065129Battery Pack · inoperativePILOT REPORTED EMERGENCY LIGHTS OVER EXIT ROW OUT. MX REMOVED AND REPLACED NR 4 EMERGENCY BATTERY AND CHARGER WITH OPERATIONAL CHECK GOOD. ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR HNAA2017101000346Bulb · burned outCABIN FLOOR EMERGENCY LIGHT THIRD RED LIGHT BULB INOPERATIVE AT SEAT 1DF. REMOVED & REPLACED THE BULB.SDR SWAA2017101016994Battery Pack · unknownR2 DOOR EMERGENCY EXIT LIGHT COVER MISSING. R&R BATTERY PACK PER AMM.SDR SWAA2017101016990Light · inoperativeRT EMERGENCY EXIT SIDEWALL LIGHT INOP. RELAMPED LIGHT PER AMM.SDR SWAA2017101016966Sign · unsecureR1 DOOR EMERGENCY EXIT SIGN CAME OFF. R&R SIGN PER MM.SDR AALA201710099015Lens · missingCLEAR LENS MISSING ON EMERGENCY LIGHT OVER R3 DOOR. REPLACED LENS IAW AMM.SDR AALA201710099010Lens · missingEMERGENCY LIGHT LENS AT THE L4 DOOR FOUND MISSING. REPLACED EMERGENCY LIGHT LENS IAW AMM.SDR AALA201710099009Battery Pack · dischargedR3 DOOR EMERGENCY EXIT SIGN INOPERATIVE. REPLACED 12WL EMERGENCY POWER SUPPLY BATTERY.SDR AALA201710099037Lens · unsecureEMERGENCY LIGHT BY THE R1 DOOR HAS A LENS THAT WILL NOT STAY ON. REMOVED AND REPLACED LENS IAW AMM 33-51-01. OPS CHECKED GOOD.SDR AALA201710099036Sign · missingEMERGENCY EXIT SIGN BY THE R2 DOOR IS MISSING. REPLACED THE SIGN IAW AMM 33-51-01. OPS CHECKED GOOD.SDR AALA20171006002Power Supply · no testEMERGENCY LIGHTS AT SEAT ROW 5 LEFT AND RIGHT, DO NOT ILLUMINATE. REMOVED AND REPLACED THE POWER SUPPLY IAW AMM 33-51-06. OPS CHECKED GOOD.SDR AALA20171006001Light · inoperativeEMERGENCY LIGHT BY SEATS 15DEGH IS INOPERATIVE. REMOVED AND REPLACED THE LIGHT ASSEMBLY IAW AMM 33-51-05. OPS CHECKED GOOD. AIRCRAFT WAS GROUNDED.SDR REXA2017100601071Light · brokenEMERGENCY LIGHT AT 13B BROKEN. REMOVED AND REISTALLED THE EMERGENCY LIGHT IAW AMM 33-51-01. NO OTHER DEFECTS AT THIS TIME.SDR YENA201710060833Power Supply · failedRIGHT EMERGENCY EXIT LIGHT DOES NOT ILLUMINATE. R & R POWER SUPPLY IAW AMM 33-50-00.SDR CALA2017100603534Lens · missingLENS MISSING OUTSIDE OF DOOR TO LAV D. REPLACED EMERGENCY LIGHT LENS IAW IFM 25-40-03. OPS CHECKED GOOD.SDR CALA2017100603533Lens · brokenEMERGENCY EXIT LIGHT RED LENS FOUND BROKEN AT SEAT 20D. REPLACED THE LENS IAW AMM 33-51-00. OPS CHECKED GOOD.SDR CALA2017100603532Battery Pack · inoperativeFIRST CLASS EMERGENCY LIGHT INOPERATIVE. REPLACED FWD RIGHT BATTERY ON POWER SUPPLY IAW AMM 33-51-06. OPS CHECKED OK.SDR CALA2017100603531Lamp · inoperativeEMERGENCY EXIT SIGN DOES NOT TURN ON 21F EMERGENCY EXIT LIGHT AT 21F DOES NOT ILLUMINATE. REPLACED THE LAMP, OPS CHECKED NORMAL.SDR CALA2017100603530Battery Pack · inoperativeFOUND EMERGENCY LIGHTS 28C THROUGH 32C INOPERATIVE DURING A SERVICE CHECK. REPLACED THE BATTERY PACK. OPS CHECKED OK.SDR CALA2017100603529Battery Pack · inoperativeEMERGENCY LIGHTS AT THE R2 DOOR DOES NOT ILLUMINATE. R & R THE POWER SUPPLY BATTERY PACK, OPS CHECKED GOOD IAW AMM 33-51-06-960-805.SDR CALA2017100603528Sign · damagedEMERGENCY EXIT SIGN ABOVE 20A DAMAGED. ON REMOVAL FOUND FWD MOUNT AND ENTIRE SEAL RETAINER ASSEMBLY DEBONDED FROM THE PANEL. ACCOMPLISHED A REPAIR IAW AMM 25-00-00, GPM 01-08-024 AND DRAWING 411A2810-3.SDR CALA2017100603525Power Supply · faultedOPS CHECK OF THE EMERGENCY LIGHTS, EPSU LT FAULTED. REPLACED POWER SUPPLY AND BATTERY. BITE CHECKED , TESTED OK IAW AMM 33-51-38.SDR CALA2017100603524Battery · no testEMERGENCY LIGHTS TEST MESSAGE, BATTERY EMERGENCY LIGHT, REPLACED THE MID LEFT BATTERY IAW MM 33-51-38. BATTERY CHECKED GOOD.SDR CALA2017100603523Power Supply · faultyEMERGENCY EXIT SIGN DOES NOT TURN OFF AT ROW 22A WITH EMERGENCY LIGHTS ARMED, EXIT AND FLOOR LIGHT COME ON AND FLICKER. AFT ROW 22. REMOVED AND REPLACED EMERGENCY POWER SUPPLY AND BATTERY. OPS CHECKED NORMAL.SDR CALA2017100603522Power Supply · inoperativeEMERGENCY LIGHTS INOPERATIVE FROM ROWS 22 TO 38. REMOVED AND REPLACED POWER SUPPLY AND BATTERY IAW AMM 33-51-06-960-806, OPS NORMAL.SDR CALA2017100603516Lens · missingEMERGENCY LIGHT LENS MISSING, AFT OF THE L1 DOOR AT STORAGE CLOSET CORNER. REPLACED THE LENS .SDR CALA2017100603514Bulb · inoperativeRIGHT SIDE EMERGENCY LIGHT BETWEEN OVERWING EXIT DOORS HAS A BULB INOPERATIVE. REPLACED THE BULB. OPS CHECKED NORMAL.SDR CALA2017100603511Lens · brokenEMERGENCY LIGHT LENS IS BROKEN AT SEAT 41D. REMOVED AND REPLACED THE LENS. OPS NORMALSDR CALA2017100603509Light · detachedEMERGENCY EXIT LIGHT BAR BY THE L3 DOOR HAS SHEARED SCREW AND DETACHED. REPLACED THE LIGHT ASSY. OPS CHECKED LIGHTS, OK.SDR CALA2017100603508Light · inoperativeROW 60CB SEAT EMERGENCY LIGHT INOPERATIVE. REPLACED THE EMERGENCY LIGHT. OPS CHECKED GOOD.SDR CALA2017100603507Light · inoperativeR2 SLIDE LIGHT INOPERATIVE. REMOVED AND REPLACED R2 DOOR SLIDE LIGHT ASSY IAW AMM 33-51-06. OPS CHECKED GOOD.SDR CALA2017100603513Lamp · inoperativeEXTERIOR EMERGENCY LIGHT IS INOPERATIVE AT THE R2 DOOR. REPLACED THE LAMP. OPS CHECKED NORMAL.SDR CALA2017100603512Lens · brokenEMERGENCY LIGHT LENS IS BROKEN AT SEAT 40F. REMOVED AND REPLACED THE LENS. OPS CHECKED NORMAL.SDR CALA2017100603519Bulb · inoperativeFOUND THE R3 EMERGENCY DOOR SLIDE LIGHT INOPERATIVE. REPLACED THE BULB AND OPS CHECKED GOOD.SDR CALA2017100603515Lens · missingEMERGENCY LIGHT LENS IS MISSING NEAR GALLEY CART 213. REPLACED THE LENS.SDR DALA2017100607330Battery Pack · no testEMERGENCY LIGHT BATTERY PACK FAILED AN EMERGENCY LIGHT FUNCTIONAL CHECK. REPLACED BATTERY PACK IAW AMM 33-51 .SDR DALA2017100607327Cover · looseEMERGENCY EXIT SIGN COVER LOOSE. INSTALLED THE SIGN COVER. OK TO CONTINUE.SDR MASA2017100612691Light · inoperativeRIGHT FWD EXTERNAL EMERGENCY LIGHT INOPERATIVE.SDR MASA2017100612690Light · inoperativeLEFT MID EXTERNAL EMERGENCY LIGHT INOPERATIVE.SDR MASA2017100612689Lamp · inoperativeROW 21 CEILING EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS.SDR MASA2017100612688Lamp · inoperativeROW 18 CEILING LEVEL EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPSSDR DALA2017101107440Light · inoperativeLEFT OVERWING EMERGENCY LIGHT INOPERATIVE. R & R EMERGENCY LIGHT. OPS CHECKED GOOD.SDR SWAA2017101017012Strip · delaminatedRT ESCAPE PATH STRIP DELAMINATED AT ROW 1. R&R STRIP PER DWG.SDR SWAA2017101017011Light · inoperativeL1 DOOR OVERHEAD EMERGENCY EXIT LIGHT BULB INOP. RELAMPED LIGHT PER AMM.
Back to JASC 3350