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 HNAA2016102800339Battery Pack · malfunctionedLEFT UPPER EMERGENCY EXIT SIGN INOPERATIVE. RESET EMERGENCY LIGHT BATTERY IAW MM 33-50-04-05.SDR HNAA2016102800338Bulb · inoperativeTHIRD EMERGENCY LIGHT IS INOPERATIVE. REMOVED AND REPLACED THE BULB. OPS CHECKED GOOD.SDR SWAA2016110809498Lens · crackedG-1 GALLEY EXIT LIGHT LENS CRACKED. R & R THE EMERGENCY LIGHT LENS IAW AMM.SDR REXA2016102702128Light · wornALL CABIN EMERGENCY LIGHTS DISCOLORED AND WORN. REMOVED & REPLACED THE EMERGENCY LIGHT IAW AMM 33-51-01. OPS TESTED GOOD IAW AMM 33-51-00-710-802.SDR SWAA2016110109287Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1672. R&R BATTERY PER AMM.SDR SWAA2016110109286Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1675. R&R BATTERY PER AMM.SDR SWAA2016110109285Battery Pack · failedEMERGENCY LIGHTING BATTERY PACK FAILED CAPACITY TEST AT LOCATION M01673. R&R BATTERY PACK PER DWG.SDR SWAA2016110109284Battery Pack · failedEMERGENCY LIGHTING BATTERY PACK FAILED CAPACITY TEST AT LOCATION M01672. R&R BATTERY PACK PER DWG.SDR SWAA2016110109283Battery Pack · failedEMERGENCY LIGHTING BATTERY PACK FAILED CAPACITY TEST AT LOCATION M01670. R&R BATTERY PACK PER DWG.SDR SWAA2016110109282Battery Pack · failedEMERGENCY LIGHTING BATTERY PACK FAILED CAPACITY TEST AT LOCATION M01669. R&R BATTERY PACK PER DWG.SDR SWAA2016110109281Battery Pack · failedEMERGENCY LIGHTING BATTERY PACK FAILED CAPACITY TEST AT LOCATION M01675. R&R BATTERY PACK PER DWG.SDR SWAA2016110109248Light · inoperativeRT OVERWING SIDEWALL EMERGENCY EXIT LIGHT INOP. RELAMPED LIGHT PER AMM.SDR SWAA2016110109237Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1670. R&R BATTERY PER AMM.SDR SWAA2016110109233Sign · defectiveR1 DOOR EXIT LIGHT SIGN MISSING DIRECTION ARROW. R&R LIGHT ASSEMBLY PER AMM.SDR SWAA2016110109200Battery Pack · no testEMERGENCY LIGHT BATTERY PACK FAILED CAPACITY TEST. R & R THE BATTERY PACK IAW DWG.SDR SWAA2016110109271Sign · looseOVERWING OVERHEAD EXIT SIGN LOOSE. R&R LIGHT ASSEMBLY PER SIP.SDR SWAA2016110109269Light · inoperativeL2 DOOR EMERGENCY LIGHT BULB INOP. R&R BULB IAW AMM.SDR SWAA2016110109266Sign · unsecureOVERWING OVERHEAD EXIT SIGN FELL OFF. SECURED LIGHT PER SIP.SDR AALA201610289002Lens · missingEMERGENCY LIGHT LENS MISSING AT SEAT 10C. REPLACED THE LENS IAW AMM 33-51-19.SDR AALA201610289001Lens · missingEMERGENCY LIGHT LENS MISSING AT 10F. REPLACED THE LENS IAW AMM 33-50-00.SDR CALA2016102800824Battery Pack · dischargedEPL LIGHTS INOP FROM ROW 22 TO 31. REMOVED BATTERY PACK S/N 68504 AND INSTALLED BATTERY PACK S/N 300708 AND OPS CHECK GOOD IAW AMM 33-51-06.SDR CALA2016102800823Battery · weakLT AFT EMERGENCY BATTERY PACK WEAK M01673. REMOVED BATTERY PACK S/N 96150 AND INSTALLED BATTERY PACK AND OPS CHECK GOOD IAW AMM 33-51-06.SDR AALA20161028012Lens · missingAIRCRAFT NOT GROUNDED. EMERGENCY ESCAPE PATH SEAT MOUNTED LIGHT LENS MISSING AT 26H. REPLACED LENS IAW AMM 33-51-10. OPERATIONAL CHECK GOOD.SDR AALA20161028011Lens · brokenAIRCRAFT NOT GROUNDED. RIGHT EMERGENCY AISLE LIGHT LENS BROKEN AT ROW 14. REMOVED AND REPLACED LENS IAW AMM 33-51-03. OPERATIONAL CHECK GOOD.SDR AALA20161028010Sign · detachedAIRCRAFT NOT GROUNDED. EMERGENCY EXIT SIGN BY SEAT 24C UNATTACHED. REPLACED EXIT SIGN AS REQUIRED.SDR AALA20161028006Battery · dischargedAIRCRAFT NOT GROUNDED. WIRELESS EMERGENCY LIGHTING CONTROL UNIT BATTERY INOPERATIVE IN L4 DOOR ZONE. REMOVED AND REPLACED BATTERY IAW AMM 33-51-07. OPERATIONAL CHECK GOOD.SDR AALA20161027013Sign · brokenAIRCRAFT NOT GROUNDED. R4 DOOR EMERGENCY ESCAPE PATH EXIT MARKER SIGN BROKEN. REMOVED AND REPLACED EXIT SIGN IAW AMM 33-51-13. OPERATIONAL CHECK GOOD.SDR AALA20161027012Sign · brokenAIRCRAFT NOT GROUNDED. R1 DOOR EMERGENCY ESCAPE PATH EXIT MARKER SIGN BROKEN. REMOVED AND REPLACED EXIT SIGN IAW AMM 33-51-13. OPERATIONAL CHECK GOOD.SDR AALA20161026019Power Supply · failedAIRCRAFT WAS IN BASE MAINTENANCE. L1 DOOR EMERGENCY POWER SUPPLY (M33093) FAILED DEEP CYCLE PROCEDURE. REMOVED AND REPLACED POWER SUPPLY IAW AMM 33-51-06. SYSTEM CHECKS NORMAL.SDR DALA2016102707910Battery · failedDURING INSPECTION, EPSU 19WL FAILED TEST. REPLACED EPSU 19WL BATTERY. OPERATIONAL CHECK OK.SDR DALA2016102807909Battery Pack · faultedDURING INSPECTION, EPSU BATTERY CAP CHECK FAULTED BATTERY PACK 19WL. REPLACED BATTERY PACK 19WL PER WORK CARD 0591-0204.SDR DALA2016102807861Lens · missingR1 DOOR HAS AN EMERGENCY LIGHT LENS MISSING. REPLACED THE LENS IAW AMM 33-53.SDR DALA2016102807846Relay · inoperativeEMERGENCY EXIT LIGHTS OVERWINGS ON - OFF DURING FLIGHT. STOPPED THEN OFF & ON AFTER LANDING, REPLACED THE RELAY 8WL ON 103VU.SDR FDEA201610273723Light · inoperativeL1 DOOR SLIDE LIGHT WILL NOT ILLUMINATE. RELAMPED L1 DOOR SLIDE LIGHT IAW AMM 25-66-00-5. OPS CHECK GOOD. A/C OK TO CONTINUE.SDR DALA2016102807829Plate · damagedSLIDE INDICATION LIGHT INOPERATIVE. REPLACED BASE PLATE. SYSTEM OPERATION IS NORMAL.SDR N6WA2016102701Light · inoperativeOVERHEAD EMERGENCY FLOOD LIGHT AT 2CD INOPERATIVE.SDR MASA2016102712478Light · inoperativeROW 14 EMERGENCY CEILING LIGHT INOP. RELAMPED.SDR DALA2016102707767Lens · detachedDURING LINE CHECK, MAINTENANCE FOUND THAT THE CATWALK EMERGENCY EXIT LIGHT LOST IT`S LENS. MAINTENANCE REPLACED THE LENS AND THE OPS CHECKED GOOD.SDR SWAA2016111409672Sign · brokenAFT LAV EMERGENCY EXIT SIGN BROKEN. R&R SIGN IAW AMM.SDR SWAA2016110109232Cover · missingCENTER CABIN CEILING EMERGENCY EXIT SIGN COVER MISSING. R&R COVER PER MM.SDR SWAA2016110109198Cover · looseFORWARD LT EXIT SIGN COVER LOOSE. REPAIRED COVER PER SIP.SDR SWAA2016110109193Sign · out of positionR1 DOOR LOWER EMERGENCY EXIT SIGN DIRECTIONAL ARROW MISPLACED. R&R SIGN PER AMM.SDR SWAA2016110109191Sign · out of positionL1 DOOR LOWER EMERGENCY EXIT SIGN DIRECTIONAL ARROW MISPLACED. R&R SIGN PER AMM.SDR SWAA2016110109189Battery Pack · no testBATTERY PACK BETWEEN LOCATION M1675 TO MO1672 FAILED CAPACITY CHECK. R & R THE BATTERY PACK IAW DWG.SDR AALA201610279014Lens · detachedR2 DOOR EXIT SIGN IS MISSING LENS. MAINTENANCE REPLACED THE LENS IAW AMM 52-10-00.SDR AALA201610279013Lens · missingEMERGENCY EXIT LIGHT AT DOOR 2R MISSING COVER. INSTALLED NEW LENS COVER.SDR AALA201610279012Lens · missingSEAT MOUNTED EMERGENCY LIGHT 9R LENS MISSING. REPLACED THE LENS IAW AMM 33-51-18. OPS CHECKED GOOD.SDR AALA201610279009Lens · missingEMERGENCY EXIT MARKER LIGHT AT THE R4 DOOR MISSING A LENS. INSTALLED THE LENS IAW AMM 33-51-13. AIRCRAFT WAS GROUNDED.SDR CALA2016102800819Battery · dischargedR4 DOOR EXTERIOR EMER LIGHT FOUND DIM. R4 DOOR EXTERIOR EMERGENCY LIGHT BATTERY AND CHARGER REPLACED. OPERATIONAL TESTED NORMAL AS PER AMM 33-51-06SDR CALA2016102800818Battery · dischargedL2 DOOR EXTERIOR EMER LIGHT FOUND DIM. L2 DOOR EXTERIOR EMERGENCY LIGHT BATTERY PACK REPLACED AND OPERATIONAL TESTED NORMAL AS PER AMM 33-51-06
Back to JASC 3350