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 SWAA2017012311399Power Supply · inoperativeRT UPPER EMERGENCY LIGHT INOP AT ROW 6. R&R POWER SUPPLY PER AMM.SDR SWAA2017012311371Lamp · inoperativeR2 DOOR EXTERIOR EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMP IAW AMM.SDR SWAA2017012311359Lamp · inoperativeRIGHT EXTERIOR EMERGENCY EXIT LIGHT INOPERATIVE. REPLACED THE LAMP IAW AMM.SDR DALA2017012300544Lens · looseEMERGENCY EXIT SIGN COVER LOOSE AT DOOR 3R. SECURED LENS.SDR DALA2017012300541Lens · failedFOUND FWD EMERGENCY LIGHT LENS SHATTERED, REPLACED THE LENS.SDR CALA2017012200156Socket · faultyEMERGENCY PATH AISLE LIGHTS INOP AT SEATS 15, 20 AND 21. FOUND WIRE SHORTED AT SEAT 20 LOWER ARM REST, LIGHT SOCKET. REPLACED BAD LIGHT SOCKET. ALL EMERGENCY LIGHTS OPERATE NORMAL. REF AMM 33-51-00.SDR CALA2017012200150Battery Pack · dischargedEMERGENCY LIGHT’S AT ROW 22 ABC TO 26 ABC IS INOP. REMOVED AND REPLACED BATTERY PACK S/N 184763 IAW AMM 33 -51-06. OP'S CHECK GOOD IAW AMM 33-51-00 STA 727C.SDR ASAA2017012121277Cover · missingEMERGENCY LIGHT COVER AT 23C IS MISSING. ACFT GROUNDED. INSTALLED A NEW COVER.SDR DALA2017012300613Sign · brokenDOOR 2L EXIT SIGN BROKE ON OPENING. CORRECTIVE ACTION: REPLACED EMERGENCY LIGHT COVER AT DOOR L2 IAW AMM 33-53.SDR IPXA2017012413173Light · inoperativeEMERGENCY LIGHT ASSY AT ENTRY DOOR HAS 5 BULBS INOP. RELAMPED OPS GOOD AMM REF 33-51-13-0401.SDR AALA20170124008Lens · looseAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT BETWEEN GALLEY AND FIRST CLASS CABIN HAS A LOOSE LENS COVER. SECURED THE LENS COVER IAW AMM 33-51-00. OPERATIONAL CHECK GOOD.SDR AALA20170124007Battery Pack · dischargedAIRCRAFT WAS NOT GROUNDED. SEAT MOUNTED EMERGENCY ESCAPE PATH LIGHTS FROM ROW 20 TO ROW 32 FAILED TEST. REMOVED AND REPLACED BATTERY PACK AB5-3(AALA20170124006) AND BATTERY PACK AB5-4 IAW AMM 33-60-98. OPERATIONAL CHECK GOOD.SDR AALA20170124006Battery Pack · dischargedAIRCRAFT WAS NOT GROUNDED. SEAT MOUNTED EMERGENCY ESCAPE PATH LIGHTS FROM ROW 20 TO ROW 32 FAILED TEST. REMOVED AND REPLACED BATTERY PACK AB5-3 AND BATTERY PACK AB5-4 (AALA20170124007) IAW AMM 33-60-98. OPERATIONAL CHECK GOOD.SDR AALA20170124005Battery · dischargedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGNS ABOVE OVERWING DOORS FAILED TEST. REMOVED AND REPLACED BATTERY ASSEMBLY B5-103 (AALA20170122003) AND BATTERY ASSEMBLY B5-105 IAW AMM 33-53-00. OPERATIONAL CHECK GOOD.SDR AALA20170122003Battery · dischargedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGNS ABOVE OVERWING DOORS FAILED TEST. REMOVED AND REPLACED BATTERY ASSEMBLY B5-103 AND BATTERY ASSEMBLY B5-105 (AALA20170124005) IAW AMM 33-53-00. OPERATIONAL CHECK GOOD.SDR AALA201701229004Panel · unsecureAIRCRAFT WAS NOT GROUNDED. FORWARD ENTRY LOWER EXIT LIGHT PANEL NOT SECURED. REINSTALLED PANEL AT L1 ENTRY DOOR AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201701229003Cover · brokenAIRCRAFT WAS NOT GROUNDED. BROKEN EXIT LIGHT COVER AT 4L. MAINTENANCE REPLACED LIGHT COVER PER AMM 33-30-00.SDR SWAA2017012411436Lens · looseFORWARD ENTRY EMERGENCY EXIT LIGHT COVER LENS LOOSE. SECURED LENS PER SIP.SDR SWAA2017012311321Sign · detachedL1 DOOR EMERGENCY EXIT SIGN DETACHED. SECURED THE SIGN IAW MM.SDR SWAA2017012311320Sign · damagedR2 DOOR LOWER EXIT SIGN LENS MISSING UPPER HOLD TAB. R &R SIGN IAW AMM.SDR QXEA2017012300023Light · looseFA'S REPORT FLOOR EMERGENCY LIGHTING STRIPS LOOSE BY ROWS 1 AND 2. SECURED LOOSE LIGHTING STRIPS. RETURNED TO SERVICE.SDR MASA2017012112821Battery Pack · dischargedOVHD EMER LIGHTS AT ROW 2 AND 3 INOP. REPLACED BATTERY PACK.SDR CALA2017012100149Battery · faultyEMERGENCY LIGHTS CHECK,"EPSU BATTERY AFT L" REPLACED EMERGENCY BATTERY PER MM 33-51-38. EMERGENCY LIGHTS OPS CK GOOD.SDR CALA2017012100148Light · inoperativeEMERGENCY LIGHT ROW 37ABC INOP. RELAMPED EMERGENCY LIGHT. OPS CHECK GOOD.SDR MASA2017012112817Light · inoperativeAFT CABIN EMER FLOOD LIGHT INOP. PLACED ON MEL.SDR DALA2017012600655Light · brokenEMERGENCY LIGHT AT SEAT 24C BROKEN, REPLACED THE EMERGENCY LIGHT ASSY.SDR SWAA2017012511454Connector · disconnectedRT EMERGENCY EXIT HATCH EMERGENCY EXIT SIDEWALL LIGHT INOP. RECONNECTED CONNECTOR IAW AMM.SDR SWAA2017012511453Battery · dischargedLT EMERGENCY EXIT AISLE LIGHT INOP BETWEEN ROW 8 TO ROW 11. R&R BATTERY IAW AMM.SDR AALA201701249001Lens · missingAIRCRAFT WAS NOT GROUNDED. MISSING WHITE EMERGENCY AISLE LIGHT LENS AT ROW 12L. REPLACED LIGHT LENS AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201701219005Lens · missingAIRCRAFT WAS NOT GROUNDED. MISSING WHITE EMERGENCY AISLE LIGHT LENS AT ROW 3L. REPLACED LIGHT LENS AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR SWAA2017012411397Lens · crackedLT EMERGENCY EXIT LIGHT LENS COVER CRACKED AT ROW 23. R&R COVER PER SIP.SDR SWAA2017012411396Lens · crackedRT EMERGENCY EXIT LIGHT LENS COVER CRACKED AT ROW 10. R&R COVER PER SIP.SDR RAIA201701200001Bulb · inoperativeEMRGENCY EXIT LIGHT AT BOTTOM OF SERVICE DOOR HINGE NR 2 INOPERATIVE. R & R THE BULB, EMRGENCY EXIT LIGHT AT BOTTOM OF SERVICE DOOR HINGE, OPS CHECK GOOD.SDR SWAA2017012311415Battery Pack · failedEMERGENCY LIGHTING BATTERY PACK FAILED CAPACITY TEST AT LOCATION M01674. R&R BATTERY PACK PER AMM.SDR SWAA2017012311414Battery Pack · failedEMERGENCY LIGHTING BATTERY PACK FAILED CAPACITY TEST AT LOCATION M01672. R&R BATTERY PACK PER AMM.SDR SWAA2017012311413Battery Pack · failedEMERGENCY LIGHTING BATTERY PACK FAILED CAPACITY TEST AT LOCATION M01675. R&R BATTERY PACK PER AMM.SDR SWAA2017012311412Battery Pack · failedEMERGENCY LIGHTING BATTERY PACK FAILED CAPACITY TEST AT LOCATION M01668. R&R BATTERY PACK PER AMM.SDR SWAA2017012311411Light · inoperativeR2 DOOR EMERGENCY EXIT LIGHT INOP. R&R BULB PER AMM.SDR SWAA2017012311381Battery Pack · no testEMERGENCY LIGHT BATTERY PACK FAILED A CAPACITY TEST AT LOCATION M01669. R & R THE BATTERY PACK IAW AMM.SDR AALA20170123006Lens · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN ON WALL JUST AFT OF FORWARD GALLEY HAS A MISSING LENS COVER. REPLACED LENS COVER IAW AMM 33-51-00. OPERATIONAL CHECK GOOD.SDR AALA20170120008Battery Pack · dischargedAIRCRAFT WAS NOT GROUNDED. SEAT MOUNTED ESCAPE PATH LIGHTS IN ROWS 26 THROUGH 36 ARE DIM. REMOVED AND REPLACED AFT BATTERY PACK IAW AMM 33-51-07. OPERATIONAL CHECK GOOD.SDR ASAA2017012019499Lens · missingRT FORWARD OVERWING EXIT DOOR EMERGENCY LIGHT LENS MISSING. GROUNDED - YES. REPLACED MISSING EMERG LIGHT LENS COVER PER AMM 33-51-01. OPS OK.SDR AALA201701219004Lens · missingAIRCRAFT IN BASE MAINTENANCE. MISSING EMERGENCY EXIT LENS PLASTIC COVER AT 4R. MAINTENANCE REPLACED LENS COVER PER AMM 33-50-00.SDR AALA201701219003Cover · missingAIRCRAFT WAS NOT GROUNDED. MISSING EMERGENCY EXIT LIGHT COVER AT DOOR 2R. MAINTENANCE INSTALLED NEW LENS COVER PER AMM 25-10-00.SDR AALA201701219002Cover · unsecureAIRCRAFT WAS NOT GROUNDED. DOOR 3R EXIT SIGN COVER FELL OFF. NEEDS REINSTALL. MAINTENANCE REINSTALLED EXIT SIGN COVER AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR DALA2017012000552Lamp · inoperativeLEFT EXTERIOR EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS IAW AMM 33-50, OK FOR SERVICE.SDR SIMA20170120003Charger · failedLT AND RT OVERWING EXTERNAL EMERGENCY LIGHTS FAIL TO ILLUMINATE. REMOVED AND REPLACED POWER SUPPLY AND BATTERY IAW AMM 33-50-04. OPS CHECKED GOOD.SDR R61A201701200055Sign · looseCREW REPORTED THAT THE RAINBOW LIGHTS WERE IN THE FORWARD CABIN WERE LOOSE. MAINTENANCE REMOVED AND REPLACED AREA CALL SIGN PER EMB AMM AND OPS CHECKED GOOD.SDR CALA2017012000146Battery · faultyRIGHT SIDE WINDOWS EMERG LIGHTS ARE FLICKERING. R&R BATTERY AND BATTERY CHARGER REF AMM 33-51-07, OPS CK GOOD OK TO CONTINUE.SDR CALA2017012000142Battery Pack · dischargedEMERGENCY LIGHTS ASSOCIATED WITH BATTERY PACK M1674 WILL NOT STAY ILLUMINATED. REMOVED AND REPLACED BATTERY PACK AT M1674 IAW AMM 33-51-06-960-805. OPS CHECK GOOD IAW AMM 33-51-06-960-805 MFR PN D717-01-100 STA 952 WL-290 BL-L014.
Back to JASC 3350