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 UIEA2017112302284Charger · inoperativeEMERGENCY LIGHT AT ROW 20AC INOP. REMOVED AND REPLACED BATTERY CHARGER REF AMM 33-51-01, OPS CHECK OK.SDR DALA2017112508341Power Supply · inoperativeDURING INSPECTION, FOUND THE G2 GALLEY RED EMERGENCY LIGHT INOPERATIVE. MAINTENANCE FOUND THE FUSE BLOWN IN THE POWER SUPPLY M1674. REPLACED THE POWER SUPPLY IAW AMM 33-51. OPS CHECKED GOOD.SDR AALA201711249028Battery · no testOPERATIONAL TEST OF EMERGENCY POWER SUPPLY UNIT (CIDS 1) SHOWS THE FOLLOWING FAULTS. REPLACED THE POWER SUPPLY BATTERY IAW AMM 33-51-38. ACCOMPLISHED SATISFACTORY OPERATIONAL TEST. AIRCRAFT WAS GROUNDED.SDR DALA2017112408282Power Supply · inoperativeEMERGENCY LIGHTS SEAT 16JH TO 29JH ARE INOPERATIVE. REPLACED EPSU 16WL AND BATTERY PACK.SDR SIMA20171123001Power Supply · inoperativeFRONT SERVICE DOOR EMERGENCY DOOR LIGHT INOPERATIVE. REMOVED AND REPLACED THE NR 1 POWER SUPPLY IAW AMM 33-50-01. OPS CHECKED GOOD IAW 33-50-01 AND 33-50-00..SDR MASA2017112012782Light · inoperativeGALLEY EMERGENCY FLOODLIGHT INOPERATIVE.SDR MASA2017112312781Lamp · inoperativeCABIN OVERHEAD EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS.SDR MASA2017112312783Battery Pack · dischargedSEVERAL EMERGENCY LIGHTS WERE INOPERATIVE IN FORWARD CABIN. CHARGED THE BATTERIES WITH GPUSDR ASOA201711225237Relay · faultyCREW REPORTED THE EMERGENCY LIGHTS KEEP TURNING ON AND OFF. MX DISCONNECTED AND CONNECTED ELECTRICAL CONNECTORS ON BATTERY CHARGERS 1, 2, 3, 4, 5. REMOVED AND REPLACED RELAY K198. OPS CHECKED GOOD. ACFT APPROVED FOR RETURN TO SERVICE.SDR AALA201711249007Lens · missingCABIN CEILING EMERGENCY LIGHT LENS MISSING AT 5TH ROW FROM FRONT OF AIRCRAFT. REPLACED LIGHT LENS IAW AMM 33-51-11.SDR SWAA2017112818079Lens · brokenL2 DOOR EXIT SIGN LENS BROKEN. R&R LENS PER AMM.SDR SWAA2017112818074Battery Pack · dischargedLT EMERGENCY EXIT LIGHT INOP BETWEEN ROW 6 TO ROW 14. R&R BATTERY PACK POWER SUPPLY IAW AMM.SDR SWAA2017112818059Cover · looseEMERGENCY EXIT PLASTIC COVER LOOSE. SECURED COVER PER SIP.SDR SWAA2017112818056Battery Pack · dischargedLT BULLNOSE EMERGENCY EXIT LIGHT INOP. R&R BATTERY PACK IAW AMM.SDR AALA201711269008Lens · damagedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT BY THE FORWARD GARBAGE BIN DOOR, RIGHT SERVICE DOOR HAS A DAMAGED LENS COVER. REMOVED AND REPLACED LIGHT COVER AND ASSEMBLY PER AMM 33-51-00. OPERATIONAL CHECK GOOD.SDR AALA201711269007Lens · detachedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT IN THE FORWARD ENTRY AREA HAS A BROKEN OFF LENS COVER. REPLACED LENS COVER PER AMM 33-51-00. OPERATIONAL CHECK GOOD.SDR SWAA2017112718055Light · inoperativeR2 DOOR EXTERIOR EMERGENCY LIGHT INOP. RELAMPED LIGHT IAW AMM.SDR SWAA2017112717988Charger · faultyEMERGENCY LIGHTS OVER DOORS AND BINS FAULTY. R & R THE BATTERY CHARGER IAW AM.SDR DALA2017112708293Battery Pack · inoperativeDURING A SERVICE CHECK, FOUND THE SEAT MOUNTED EMERGENCY LIGHTS INOPERATIVE AT ROWS 33 TO 37. REPLACED THE BATTERY PACK IAW AMM 33-51. OPS CHECKED GOOD.SDR DALA2017112208291Battery Pack · inoperativeSEAT EMERGENCY LIGHTS INOPERATIVE IN AFT CABIN. REMOVED & REPLACED THE M736 BATTERY IAW WDM 33-50. OPS CHECKED GOOD.SDR REXA2017112201191Inverter · inoperativeFLOOR EMERGENCY LIGHTS ARE INOPERATIVE FROM ROWS 6 THRU 8. REPLACED THE INVERTER IAW AMM 33-51-07. OPS CHECKED GOOD.SDR DALA2017112308284Battery Pack · dischargedDURING SERVICE CK FOUND ROW 25 UPPER OVERWING EMERGENCY LIGHTS AND ADJACENT CEILING LIGHTS INOP. REPLACED BATTERY PACK AND OPERATION CHECKS NORMALLY.SDR AALA201711249004Lens · missingMISSING EMERGANCY LIGHT LENS AT SEAT 27C. REPLACED EMERGENCY LIGHT ASSEMBLY. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201711249003Lens · missingSEAT 9D EMERGENCY LIGHT LENS MISSING. REPLACED THE LENS IAW MM 25-21-00.SDR SIMA20171122001Sign · inoperativeAFT SIDE OF CENTER AISLE CEILING EMERGENCY EXIT LIGHT WILL NOT ILLUMINATE. REPLACED CENTER AISLE AFT EXIT LOCATING SIGN ASSEMBLY AND PERFORMED OPERATIONAL TEST. OPERATIONAL TEST GOOD IAW AMM 33-50-15 AND 33-50-00SDR CALA2017112204190Sign · missingEMERGENCY EXIT SIGN MISSING. REPLACED THE SIGN ASSY. OPS CHECKED GOOD IAW AMM 33-00-00.SDR CALA2017112204188Lamp · inoperativeR4 DOOR EXTERIOR EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS, OPS CHECKED GOOD IAW AMM 33-51-06.SDR CALA2017112204189Lens · missingCOAT CLOSET EMERGENCY LIGHT LENS MISSING. REPLACED THE LENS.SDR HNAA2017112800381Power Supply · inoperativeRIGHT FUSELAGE AFT EMERGENCY LIGHT INOPERATIVE. REMOVED THE POWER SUPPLY IN POSITION PS4 AND REPLACED WITH NEW.SDR HNAA2017112800380Power Supply · inoperativeTWO AFT MOST CEILING EMERGENCY LIGHTS ARE INOPERATIVE. REMOVED THE POWER SUPPLY IN POSITION PS4 AND REPLACED WITH NEW.SDR SWAA2017112818067Ballast · inoperativeRT EMERGENCY EXIT WALL LIGHT INOP. R&R BALLAST PER AMM.SDR DALA2017112208345Lens · detachedEMERGENCY EXIT DIFFUSER LENS DETACHED. ATTACHED THE LENS. OK FOR SERVICE.SDR SWAA2017112718073Sign · inoperativeLT LOWER OVERWING EMERGENCY ESCAPE EXIT SIGNS INOP. R&R SIGN IAW AMM.SDR SWAA2017112718072Light · inoperativeRT EXTERIOR OVERWING EMERGENCY EXIT LIGHT INOP. RELAMPED LIGHT IAW AMM.SDR SWAA2017112718071Light · inoperativeRT EMERGENCY AREA LIGHT INOP AT ROW 13. RELAMPED LIGHT IAW AMM.SDR SWAA2017112718040Sign · inoperativeRT LOWER OVERWING EMERGENCY ESCAPE EXIT SIGNS INOP. R&R SIGN IAW AMM.SDR SWAA2017112718039Sign · inoperativeRT OVERWING ESCAPE HATCH EXIT SIGN INOP. RELAMPED SIGN IAW AMM.SDR SWAA2017112718038Light · inoperativeLT EXTERIOR OVERWING EMERGENCY EXIT LIGHT INOP. RELAMPED LIGHT IAW AMM.SDR SWAA2017112718037Lamp · inoperativeLEFT EMERGENCY LIGHT INOPERATIVE AT ROW 6. REPLACED THE LAMPS IAW AMM.SDR SWAA2017112718033Lens · looseR1 DOOR EMERGENCY EXIT SIGN LENS LOOSE. R & R THE SIGN ASSEMBLY IAW AMM.SDR SWAA2017112718007Battery Pack · no testEMERGENCY LIGHT BATTERY PACK FAILED A CAPACITY CHECK AT LOCATION M01673. R & R THE BATTERY PACK IAW MM.SDR AALA201711249026Bracket · brokenAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN AT SEAT 21D HAS A BROKEN BRACKET. REPLACED PIVOT PINS ON EXIT SIGN BRACKET PER AARD 33-51-01-2. OPERATIONAL CHECK GOOD.SDR AALA201711229019Lens · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT AT ROW 25C HAS A MISSING LENS COVER. REPLACED LIGHT ASSEMBLY PER AMM 33-51-18. OPERATIONAL CHECK GOOD.SDR AALA201711229018Lens · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT AT ROW 21 RIGHT HAS A MISSING LENS COVER. REPLACED LIGHT ASSEMBLY PER AMM 33-51-18. OPERATIONAL CHECK GOOD.SDR AALA201711229017Lens · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT AT ROW 10 LEFT HAS A MISSING LENS COVER. REPLACED LIGHT ASSEMBLY PER AMM 33-51-18. OPERATIONAL CHECK GOOD.SDR AALA201711229003Lens · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY ESCAPE PATH LIGHT AT ROW 20 HAS A MISSING RED LENS. REMOVED AND REPLACED LIGHT ASSEMBLY PER AMM 33-51-18. OPERATIONAL CHECK GOOD.SDR AALA201711229015Decoder · faultyWHILE ACCOMPLISHING JOB CARD 33C20033002, DECODER - ENCODER-B 300RH3 FAULTED. REPLACED DECODER ENCODER IAW AMM 23-73-47-000-801 AND 23-73-47-400-801.SDR AALA201711229010Power Supply · no testWHILE ACCOMPLISHING JOB CARD 33C20033002, THE EMERGENCY POWER SUPPLY UNIT 13WL FAULTED. REPLACED THE POWER SUPPLY IAW AMM 33-51-38-000-801 AND 33-51-38-400-801.SDR DALA2017112108278Battery Pack · inoperativeEMERGENCY LIGHTS ABOVE BOTH AFT OVERWING EXIT DOORS INOPERATIVE. R & R THE B5-230 BATTERY PACK. OPS GOOD.SDR YENA201711210953Battery Pack · failedFOUND EPSU BATTERY FAULTED 11WL. R & R EMERGENCY THE BATTERY ON THE LT 11WL IAW AMM 33-51-38. OPS CHECKED GOOD.
Back to JASC 3350