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 MASA2017092912673Light · inoperativeROW 5 CEILING LEVEL EMERGENCY FLOOD LIGHT INOPERATIVE.SDR MASA2017092912672Battery Pack · inoperativeROW 13 LT & RT LOWER EMERGENCY EXIT SIGNS INOPERATIVE. REPLACED THE BATTERIESSDR DALA2017100507294Power Supply · faultedDISPATCH MESSAGE FOR THE EMERGENCY LIGHTS APPEARED. REPLACED THE EPSU 102WL3.SDR AALA201709299024Lens · detachedEMERGENCY EXIT SIGN BY THE L1 DOOR HAS A DETACHED LENS. REPLACED THE LENS IAW AMM 33-51-01. OPS CHECKED GOOD.SDR AALA201710039003Lens · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT OVERHEAD AT SEAT 13ABC BULLNOSE HAS A MISSING LENS COVER. REPLACED LENS COVER PER AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR SWAA2017100316879Cover · missingRT EMERGENCY EXIT LIGHT COVER MISSING AT ROW 11. R&R COVER PER AMM.SDR SWAA2017100316864Sign · looseOVERWING EMERGENCY EXIT LIGHT SIGN LOOSE. SECURED LIGHT ASSEMBLY PER AMM.SDR SWAA2017100316860Light · looseMID-CABIN OVERHEAD EXIT SIGN LOOSE. SECURED LIGHT PER AMM.SDR SWAA2017100316857Lens · looseRT EMERGENCY EXIT WHITE LIGHT LENS LOOSE. SECURED LENS PER AMM.SDR SWAA2017100216833Battery Pack · failedEMERGENCY LIGHTING BATTERY PACK FAILED CAPACITY TEST AT LOCATION M1674. R&R BATTERY PACK PER MM.SDR SWAA2017100216832Battery Pack · failedEMERGENCY LIGHTING BATTERY PACK FAILED CAPACITY TEST AT LOCATION M1675. R&R BATTERY PACK PER MM.SDR SWAA2017100216831Battery Pack · failedEMERGENCY LIGHTING BATTERY PACK FAILED CAPACITY TEST AT LOCATION M1673. R&R BATTERY PACK PER MM.SDR SWAA2017100216830Battery Pack · failedEMERGENCY LIGHTING BATTERY PACK FAILED CAPACITY TEST AT LOCATION M1672. R&R BATTERY PACK PER MM.SDR SWAA2017100216829Battery Pack · failedEMERGENCY LIGHTING BATTERY PACK FAILED CAPACITY TEST AT LOCATION M1670. R&R BATTERY PACK PER MM.SDR SWAA2017100216828Battery Pack · failedEMERGENCY LIGHTING BATTERY PACK FAILED CAPACITY TEST AT LOCATION M1669. R&R BATTERY PACK PER MM.SDR SWAA2017100216820Light · looseMID CABIN OVERWING EMERGENCY EXIT SIGN LOOSE. R&R LIGHT ASSEMBLY PER AMM.SDR SWAA2017100216811Light · inoperativeL2 DOOR EMERGENCY EXIT LIGHT INOP. RELAMPED LIGHT PER AMM.SDR SWAA2017100216810Light · inoperativeRT OVERWING EXIT AFT EMERGENCY LIGHT INOP. R&R LIGHT ASSEMBLY IAW AMM.SDR SWAA2017100216809Light · inoperativeR1 DOOR OVERHEAD EMERGENCY EXIT FLOOD LIGHT BULB INOP. RELAMPED LIGHT PER MM.SDR SWAA2017100216807Light · inoperativeL2 DOOR EXTERIOR EMERGENCY LIGHT INOP. R&R LIGHT PER AMM.SDR SWAA2017100216804Battery Pack · failedEMERGENCY LIGHTING BATTERY PACK FAILED CAPACITY TEST AT LOCATION M1668. R&R BATTERY PACK PER MM.SDR SWAA2017100216773Power Supply · inoperativeAFT LT EMERGENCY LIGHT POWER SUPPLY INOP. R&R POWER SUPPLY PER AMM.SDR DALA2017092907200Lens · missingEMERGENCY LIGHT LENS MISSING. REINSTALLED THE LENS.SDR DALA2017100107205Light · missingDURING A SERVICE CHECK, FOUND THE EMERGENCY LIGHT MISSING AT ROW 37AB. REPLACED THE LIGHT ASSEMBLY.SDR UIEA2017100201917Lamp · inoperativeDURING A POST FLIGHT INSPECTON, EXTEIOR EMERGENCY LIGHTS INOPERATIVE AT THE L1 DOOR AND GROUND FLOOD AFT OF RIGHT FLAG. R & R THE LAMPS, NORMAL OPERATION IAW MM 33-25-10.SDR AALA201710029003Battery · no testEMERGENCY POWER SUPPLY UNIT FAILED BITE TEST. REPLACED THE BATTERY IAW AMM 33-51-38. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201709299026Light · brokenAIRCRAFT WAS NOT GROUNDED. FORWARD GALLEY EMERGENCY LIGHT LUMINATOR IS BROKEN. REMOVED AND REPLACED LIGHT (LUMINATOR) PER AMM 33-26-00. OPERATIONAL CHECK GOOD.SDR AALA201709299025Sign · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN BY THE L2 DOOR IS MISSING. REPLACED EMERGENCY EXIT LIGHT ASSEMBLY PER AMM 33-51-00. OPERATIONAL CHECK GOOD.SDR AALA20170928004Power Supply · inoperativeAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGNS BY THE R3 DOOR OVERHEAD AND AFT AND BY THE L3 DOOR OVERHEAD, FORWARD AND AFT ARE INOPERATIVE. REMOVED AND REPLACED POWER SUPPLY (BATTERY PACK) AT M33406 PER AMM 33-51-06. OPERATIONAL CHECK GOOD.SDR AALA201709299027Light · inoperativeAIRCRAFT WAS NOT GROUNDED. EMERGENCY ESCAPE PATH LIGHT ON THE FORWARD CLOSET DOOR IS INOPERATIVE. REMOVED AND REPLACED LIGHT ASSEMBLY PER AMM 33-51-05. OPERATIONAL CHECK GOOD.SDR DALA2017092807159Battery Pack · inoperativeFWD EMERGENCY LIGHTS INOPERATIVE. REPLACED THE BATTERY PACKS IAW AMM 33-53, CHECKED GOOD.SDR DALA2017092907157Light · detachedSEAT 36F EMERGENCY LIGHT DETACHED. REPLACED EMERGENCY LIGHT HOUSING. TESTED OK.SDR DALA2017092907154Lamp · inoperativeL2 DOOR AFT EMERGENCY EXIT LIGHT INOPERATIVE. REPLACED THE LAMPS. TESTED OK.SDR YENA201709280801Battery Pack · failedEMERGENCY LIGHTS INOPERATIVE. FOUND LEFT MIDDLE EMERGENCY LIGHT BATTERY AT FAULT. R & R THE BATTERY, OPS CHECKED GOOD.SDR YENA201709280800Battery Pack · failedEMERGENCY LIGHTS INOPERATIVE. FOUND THE LEFT MIDDLE EMERGENCY LIGHT BATTERY AT FAULT. R & R THE BATTERY, OPS CHECKED GOOD.SDR AALA201709299006Lens · missingEMERGENCY LIGHT LENS IS MISSING AT ROW 3L. INSTALLED NEW EMERGENCY LIGHT LENS.SDR AALA201709299005Lens · missingTHE L2 DOOR EMERGENCY LIGHT LENS WAS MISSING. INSTALLED A NEW LENS.SDR SIMA20170928003Lamp · inoperativeLEFT FORWARD EXTERIOR EMERGENCY LIGHT INOPERATIVE. R & R THE LAMP IAW AMM 33-50-10-000-801-A, AND 33-50-10-400-801-A. OPS CHECKED GOOD.SDR UIEA2017092901899Lamp · inoperativeON POST FLIGHT INSPECTION, THE EXTERIOR EMERGENCY LIGHTS FOUND INOPERATIVE. L1 AND GROUND FLOOD AFT OF RIGHT FLAP. REPLACED THE LAMPS. NORMAL OPS IAW AMM 33-52-10.SDR HNAA2017092900334Contact · dirtyEMERGENCY LIGHT AT ROW 12A, AFT WINDOW DOES NOT ILLUMINATE. REMOVED THE EMERGENCY LIGHT. CLEANED THE CONTACTORS, AND INSTALLED THE LIGHT. OK FOR SERVICE. OPS CHECKED SATISFACTORY IAW AMM 33-50-14-000/400-801A.SDR HNAA2017092900333Inverter · inoperativeRIGHT EMERGENCY LIGHT AT THE RT EMERGENCY EXIT WILL NOT ILLUMINATE. REPLACED THE NR 5 INVERTER, OPS CHECKED GOOD IAW AMM 33-50-11-000/400-801A.SDR AALA201709299001Switch · intermittentRIGHT NR 1 EMERGENCY LIGHT STAYS ON. CYCLED EMERGENCY SWITCH. OPS NORMAL.SDR MASA2017092812671Light · inoperativeROW 15 CEILING LEVEL EMER LIGHT INOP.SDR MASA2017092812670Light · inoperativeROW 18 CEILING LEVEL EMERGENCY FLOOD LIGHT INOP. PLACED ON MEL.SDR MASA2017092812669Lamp · inoperativeCENTER EMERGENCY EXIT RED CALL LIGHT INOPERATIVE. REPLACED THE LAMP.SDR MASA2017092812668Lamp · inoperativeCEILING EMERGENCY FLOOD LIGHT INOPERATIVE. REPLACED THE LAMP.SDR SWAA2017100316872Sign · missingR2 DOOR EMERGENCY EXIT SIGN MISSING. R&R SIGN PER AMM.SDR SWAA2017100216834Battery Pack · failedEMERGENCY BATTERY PACKS FAILED CAPACITY CHECK AT LOCATIONS M01674. R&R BATTERY PACK PER AMM.SDR SWAA2017100216774Lens · missingLT OVERWING DOOR LOWER EXIT SIGN LENS MISSING. INSTALLED LENS PER AMM.SDR SWAA2017100216769Battery Pack · failedEMERGENCY BATTERY PACKS FAILED CAPACITY CHECK AT LOCATIONS M01675. R&R BATTERY PACK PER AMM.
Back to JASC 3350