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 DALA2019071204193Light · inoperativeLEFT FORWARD OVERWING DOOR PULL HANDLE LIGHT HAS ONE BULB INOP, RELAMPED LT FWD OVERWING DOOR PULL HANDLE BULBS.SDR U2RA201907110001Light · inoperativeEXTERIOR EMERGENCY EXIT LIGHT FOR MAIN ENTRY DOOR 4 LEFT (SLIDE LIGHT) INOPERATIVE. REMOVED AND REPLACED LIGHT BULB IN ACCORDANCE WITH AIRCRAFT MAINTENANCE MANUAL 33-51-06. PERFORMED SATISFACTORY OPERATIONAL TEST OF EXIT LIGHT.SDR SWAA2019071234790Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATIONS M1674. R&R BATTERY PER AMM.SDR SWAA2019071234789Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATIONS M1673. R&R BATTERY PER AMM.SDR SWAA2019071234788Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATIONS M1672. R&R BATTERY PER AMM.SDR SWAA2019071234787Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATIONS M1670. R&R BATTERY PER AMM.SDR SWAA2019071234786Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATIONS M1669. R&R BATTERY PER AMM.SDR SWAA2019071234785Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATIONS M1675. R&R BATTERY PER AMM.SDR SWAA2019071234770Light · inoperativeRIGHT HAND OVER WING LOWER FWD EMERGENCY EXIT LIGHT HAS ONE BULB OUT. RELAMPED PER AMM.SDR SWAA2019071234769Light · inoperativeEMERGENCY EXIT LIGHT INOP. RELAMPED PER AMM.SDR SWAA2019071234765Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATIONS M1668. R&R BATTERY PER AMM.SDR SWAA2019071234760Light · inoperativeL2 EXTERIOR EMERGENCY EXIT LIGHT INOP. RELAMPED REF AMM 33-51-04.SDR SWAA2019071234758Lens · brokenEMERGENCY LIGHT LENS COVER AT FWD ENTRY DOOR BROKEN. R&R LENS COVER REF S.I.P.SDR SIMA20190711005Light · inoperativeSERVICE DOOR EMERGENCY LIGHT INOP. C/A-REMOVED AND REPLACED SERVICE DOOR EMERGENCY LIGHT LAMP IAW AMM 33-50-10-000-801-A & 33-50-10-000-801-A OPC GOOD AT THIS TIME NO FURTHER DEFECTS NOTED AT THIS TIME END.SDR DALA2019071104189Lens · missing(LOG 5980837) DURING INSPECTION FOUND L2 OVERWING LENS COVER MISSING. INSTALLED COVER. OK FOR SERVICE.SDR HNAA2019071200193Sign · inoperativeEMERGENCY EXIT DIRECTION LIGHT ON WALL AT ROW3 INOP. FIX: R&RD EMERGENCY LIGHT SIGN.SDR MASA2019071111946Light · inoperativeROW 13 A EXIT SIGN 1 BULB INOP.SDR DALA2019071104158Fuse · blownSHIP 3809 DURING SVC CHK FOUND EEPLS LIGHTS INOP ROWS 11-17. CORRECTIVE ACTION: REMOVED AND REPLACED POWER SUPPLY (M1676) FUSE (1EA) PER B737 AMM 33-51. LIGHTS OPS GOOD. (6291076).SDR UIEA2019071704777Cover · not seatedL1 EXIT SIGN LOOSE (<P>RE-SEATED L1 EXIT SIGN COVER, OPS CKS GOOD IAW AMM 33-51-00.<BR /></P>)SDR DALA2019071004232Battery Pack · dischargedSHIP 650 FOUND MULTIPLE EMERGENCY LIGHTS INOP. CORRECTIVE ACTION:T/S PER WDM 33-51. REMOVED AND REPLACED EMERGENCY LIGHT BATTERY PACKS AT MODULES: M736, M737, M10568, M732, M733, M730 AND M731 PER AMM 33-51. TEST OK. CHARGED BATTERY PACKS PER 33-51. (5284785)SDR JJBA20190710014Sign · unsecureOVERHEAD EMERGENCY EXIT SIGN HANGING AT EMERGENCY EXIT ROW. RESECURED EXIT LOCATION SIGN. NO DEFECTED NOTED.SDR CALA2019071301179Power Port · failedSUPPORT TASK - EA 2500-04866 M33400 EMERGENCY POWER PACK CAPACITY CHECK FOUND FAIL REF NR LP 9131789 M33400 EMERGENCY POWER PACK REPLACED AND INSTALLATION TEST CARRIED OUT NORMAL AS PER AMM 33-51-06.SDR CALA2019071301178Power Port · failedSUPPORT TASK - M33405 EMER POWER PACK CAPACITY CHECK FAIL REF NR LP 9131795 EMER POWER PACK M33405 REPLACED AND INSTALLATION TEST CARRIED OUT NORMAL AS PER AMM 33-51-06.SDR CALA2019071301177Powerpack · failedSUPPORT TASK - M33406 EMER POWER PACK CAPACITY CHK FAIL REF NR LP 9131794 EMER POWER PACK M33406 REPLACED AND INSTALLATION TEST CARRIED OUT NORMAL AS PER AMM 33-51-06.SDR SWAA2019071234768Light · inoperativeRT OVERWING ESCAPE HATCH LIGHT ASSY DOES NOT ILLUMINATE. RELAMPED AND PERFORMED GOOD OPERATIONAL TEST PER AMM.SDR SWAA2019071234767Battery Pack · failedEMERGENCY LIGHT BATTERY PACKS FAILED CAPACITY TEST AT LOCATION M1670. R&R BATTERY PACK PER MM.SDR SWAA2019071234766Battery Pack · failedEMERGENCY LIGHT BATTERY PACKS FAILED CAPACITY TEST AT LOCATION M1673. R&R BATTERY PACK PER MM.SDR SWAA2019071234764Battery Pack · dischargedEMERGENCY EXIT LIGHTS INOP. R&R CHARGER PACK & BATTERY PER AMM.SDR SWAA2019071234763Lens · loose"EXIT SALIDA" COVER KNOCKED LOOSE. RESECURED EXIT LIGHT LENS PER AMM.SDR ASOA201907105084Light · inoperativeDURING MX INSPECTION SEAT 18CD OVERHEAD EXIT LIGHT INOP. MX R&R SEAT 18CD OVERHEAD LIGHT BULB WITH OPS CHECK GOOD. A/C WAS APPROVED FOR RETURNED TO SERVICE.SDR ASOA201907105083Light · inoperativeDURING MX INSPECTION SEAT 18A OVERHEAD EXIT LIGHT INOP. MX R&R SEAT 18A OVERHEAD LIGHT BULB WITH OPS CHECK GOOD. A/C WAS APPROVED FOR RETURNED TO SERVICE.SDR DALA2019071104183Battery · discharged(LOG 5452472) DURING INSPECTION FOUND SEAT MOUNTED EMERGENCY LIGHTS AT ROW 16DE TO 18DE INOPERATIVE. REPLACED POWER SUPPLY BATTERY, REF. AMM 33-51. OPS CHECKS GOOD.SDR DALA2019071100120Sign · detachedEMERGENCY EXIT SIGN AT DOOR 2L DETACHED. RE-ATTACHED EMERGENCY EXIT SIGN AT DOOR 2L. LP 5988054SDR SWAA2019071134754Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1668. R&R BATTERY PER MM.SDR SWAA2019071134753Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1675. R&R BATTERY PER MM.SDR SWAA2019071134752Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1674. R&R BATTERY PER MM.SDR SWAA2019071134751Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1673. R&R BATTERY PER MM.SDR SWAA2019071134750Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1672. R&R BATTERY PER MM.SDR SWAA2019071134749Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1670. R&R BATTERY PER MM.SDR SWAA2019071134735Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1669. R&R BATTERY PER MM.SDR SWAA2019071134733Lens · brokenRT OVERWING EMERGENCY EXIT LIGHT LENS BROKEN. R&R EMERGENCY EXIT LIGHT LENS COVER PER AMM.SDR MASA2019071011945Light · inoperativeAFT CEILING EMERGENCY FLOOD LIGHT INOPERATIVE. REPLACED BULB.SDR IPXA2019071044291Battery · dischargedINSPECTION TYPE:SV FOUND UPPER DECK EMERGENCY LIGHT L5734, L1382 , L5607, L5604, L5524, M4716, M4714 INOPERATIVE.1. IAW WDM 33-51-12 AND WDM 33-51-13 REV.34.02 PERFORMED WIRING CHECK, FOUND POWER SUPPLY M5055 AND M5056 FAILED. 2. IAW AMM 33-51-04-902-001-001 RSDR DALA2019071004146Power Supply · inoperativeDURING SERVICE CHECK FOUND EMERGENCY LIGHT FROM ROW 23-29 IN OP. REMOVED AND REPLACED BATTERY POWER SUPPLY PER AMM 33-51 AND OPS CHECK GOOD. A/C OK FOR SERVICE. (LP5973324)SDR IPXA2019090546379Light · brokenINSPECTION TYPE:A EMERGENCY EXIT LIGHT ABOVE L1 DOOR CONTACTS WILL NOT LOCK IN. REMOVED AND REPLACED EMERGENCY EXIT LIGHT ABOVE L1 DOOR.SDR K11A2019072301Battery Pack · dischargedEMERGENCY EXIT LIGHTS INOP.SDR IPXA2019070944266Battery · dischargedINSPECTION TYPE:N/A ON PREFLIGHT EMERG LT TEST RECEIVED "EMERG LT BAT 1 LO". DEFERRED #1 EMERGENCY LIGHT BATTERY PER MEL 33-50-4 C/W DMP. **SUPPLEMENTAL SDR** REPLACED EMERGENCY LIGHTING BATTERY POWER SUPPLY UNIT PER MM 33-51-00. OPS CK OK. THIS CLEARS M6760SDR YENA201907090398Power Unit · failedFLT 1589, BOS-DCA. L2 DOOR EMERGENCY LIGHTS, ROW 24-25 CENTER ISLE EMERGENCY LIGHT AND AFT GALLEY CEILING EMERGENCY LIGHT INOP; REMOVED AND REPLACED #5 EMERGENCY LIGHT POWER UNIT IAW AMM 33-50-01. OPS CHECK GOOD AT THIS TIME.SDR JJBA20190709013Light · missingEMERGENCY SIGNATURE MISSING ON FLOOR AT GALLEY EXIT. R&R EXIT ILLUMINATION STRIP.SDR REXA2019070901090Light · inoperativeCEILING EMERGENCY EXIT LIGHT AT ROW 7 WILL NOT ILLUMINATE. REPLACED CEILING EMERGENCY CALL LIGHT @ ROW 7 IAW MEL 33-51-14. OPS CK GOOD, OK FOR SERVICE.
Back to JASC 3350