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 CALA2017100903564Lens · looseR2 DOOR EMERGENCY EXIT SIGN LENS DETACHED. REPLACED THE LENS, OPS OK.SDR CALA2017100903560Sign · detachedEXIT SIGN OVER THE L2 DOOR FOUND DETACHED, INSTALLED THE EXIT SIGN. READY TO CONTINUE SERVICE.SDR CALA2017100903554Lamp · inoperativeL3 DOOR SLIDE EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMP IAW 33-40-00. OPS CHECKED GOOD.SDR CALA2017100903553Lens · crackedAFT GALLEY BULKHEAD, RT LOWER EMERGENCY LIGHT LENS CRACKED. REPLACED THE LENS IAW AMM 33-51-05.SDR CALA2017100903551Power Supply · faultedEMERGENCY POWER SUPPLY UNIT AT THE L1 DOOR, FAULTED ON CIDS. REMOVED AND REPLACED THE POWER SUPPLY IAW AMM 33=51-38, OPS CHECKED NORMAL.SDR CALA2017100903567Lens · crackedFWD L1 CLOSET EMERGENCY LIGHT LENS CRACKED. REPLACED LENS.SDR CALA2017100903563Lens · looseSEAT 21A LOWER WALL EMERGENCY EXIT LIGHT LENS FELL OFF. SECURED LENS.SDR CALA2017100903561Lamp · inoperativeL3 DOOR EXTERIOR EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS. CHECKED NORMAL.SDR CALA2017100903558Sign · looseEMERGENCY LIGHT COMING OFF AT ROW 21AC RIGHT, SECURED THE EXIT SIGN.SDR CALA2017100903556Lens · looseR2 DOOR EMERGENCY LIGHT DETACHED. SECURED THE LIGHT COVER ASSY. OK.SDR KCSA201710091069Light · inoperativeEMERGENCY LIGHT L5733 AT BS 550 IS INOPERATIVE.SDR CALA2017100903540Lens · brokenWHITE EMERGENCY EXIT LIGHT LENS BROKEN AT ROW 12C. REPLACED LENS ASSY, CHECKED GOOD.SDR AALA201710119026Light · inoperativeSEAT 26D MOUNTED EMERENCY LIGHT FOUND INOPERATIVE. REMOVED AND REPLACED THE LIGHT ASSEMBLY. OPS CHECKED GOOD.SDR SWAA2017101617074Battery Pack · inoperativeFORWARD CABIN EMERGENCY LIGHT INOPERATIVE. R & R THE BATTERY PACK IAW MM.SDR ASOA201710085119Battery Pack · no testDURING MX CHECK, THE EPSU NR 2 FAILED AN OPS CHECK. MX REMOVED AND REPLACED THE NR 2 EPSU BATTERY, OPS CHECKED GOOD. ACFT APPROVED FOR RETURN TO SERVICE.SDR ASOA201710085118Inverter · inoperativeMX REPORTED FWD CABIN EMERGENCY LIGHTS INOPERATIVE. MX REMOVED AND REPLACED THE NR 1 INVERTER AND NR 2 BATTERY, OPS CHECKED GOOD. ACFT APPROVED FOR RETURN TO SERVICE.SDR SWAA2017101117031Battery · failedAFT RT BATTERY FAILED TIME TEST. R&R BATTERY PER AMM.SDR AALA201710119013Sign · unsecureLOOSE CABIN EXIT MARKER AT THE R4 DOOR. REPLACED THE SIGN.SDR ASAA2017100822145Lens · detachedEMERGENCY LIGHT LENS OVER FWD CALL FELL OFF. ACFT GROUNDED. REMOVED AND REPLACED THE FWD GALLEY OVERHEAD EMERGENCY LIGHT ASSEMBLY IAW AMM 33-51-00. OPS GOOD.SDR DALA2017100907430Lens · detachedLEFT OVERWING EXIT LIGHT LENS FELL OFF. REPLACED LENS.SDR HNAA2017101000347Light · inoperativeFLOOR EMERGENCY LIGHT AT SEAT 7DF INOPERATIVE. R & R THE EMERGENCY LIGHT.SDR SWAA2017101017006Light · inoperativeRT EMERGENCY ESCAPE HATCH FORWARD LIGHT INOP. RELAMPED LIGHT PER AMM.SDR SWAA2017101017004Power Supply · inoperativeRT OVERHEAD OVERWING EMERGENCY EXIT LIGHT INOP. R&R POWER SUPPLY IAW AMM.SDR JJBA20171008005Bulb · inoperativeEMERGENCY LIGHT AT ROW 18CD INOPERATIVE. R & R THE EMERGENCY LIGHT BULB AT ROW 18CD. OPS CHECK SATISFACTORY.SDR DALA2017101007396Lamp · inoperativeCREW REST EXIT LIGHT AT THE STEP INOPERATIVE. REPLACED THE LAMP. OPS CHECKED OK.SDR AALA201710099001Lens · missingR1 DOOR EMERGENCY EXIT LIGHT LENS MISSING. INSTALLED MISSING EMERGENCY EXIT LENS AT 1R. OK FOR SERVICE.SDR AALA201710099046Sign · inoperativeMAIN CABIN R2 DOOR EMERGENCY EXIT SIGN INOPERATIVE AND CASE IS CRACKED. REPLACED EXIT SIGN IAW AMM 33-50-15-000-801, AMM 33-50-400-801, AND AMM 33-50-00.SDR AALA201710099044Battery Pack · no testLEFT FORWARD EMERGENCY LIGHT BATTERY PACK FAILED A FUNCTIONAL CHECK. REPLACED BATTERY PACK IAW AMM 33-50-01-000-801-A, 33-50-01-400-801-A, 33-50-01, AND 33-50-00.SDR AALA201710099043Battery Pack · no testRIGHT FORWARD EMERGENCY LIGHT BATTERY PACK FAILED A FUNCTIONAL CHECK. REPLACED THE BATTERY PACK IAW AMM 33-50-01-000-801-A, 33-50-01-400-801-A, 33-50-01, AND 33-50-00.SDR AALA201710099039Lens · detachedEMERGENCY LIGHT BY THE LEFT OVERWING EXIT HAS A DETACHED LENS COVER. REMOVED AND REPLACED LIGHT ASSEMBLY IAW AMM 33-51-01. OPS CHECKED GOOD.SDR YENA201710080832Power Supply · failedFWD EMERGENCY EXIT SIGNS DO NOT ILLUMINATE WHEN TESTED. R & R THE FWD RT EPSU IAW AMM 33-51-38. ALL CHECKED NORMAL.SDR ASAA2017100822144Lens · missingAFT EMERGENCY SIGN LENS MISSING FROM BULKHEAD. ACFT GROUNDED. INSTALLED A NEW LENS AMM 33-51-14.SDR YENA201710080831Epsu · failedFWD EMERGENCY EXIT SIGNS DO NOT ILLUMINATE WHEN TESTED. R & R THE FWD RT EPSU IAW AMM 33-51-38. CHECKED NORMAL.SDR YENA201710080829Lens · missingLENS FOR EMERGENCY EXIT LIGHT SEAT 3C MISSING. REPLACED THE EMERGENCY LIGHT LENS.SDR DALA2017100907354Lens · missingDURING INSPECTION, FOUND THE EMERGENCY EXIT SIGN LENS MISSING FROM CENTER ISLE. MAINTENANCE INSTALLED A NEW LENS.SDR DALA2017100907353Light · detachedDURING INSPECTION, FOUND THE SEAT 1C MOUNTED EMERGENCY LIGHT DETACHED. MAINTENANCE REINSTALLED THE EMERGENCY LIGHT INTO THE SEAT. THE LIGHT CHECKED OK IAW MM 33-51.SDR ASOA201710082008Power Supply · failedDURNING TASK CARD 700-33-900-701-A01 OPS TEST OF THE EMERGENCY POWER SUPPLY UNIT, FOUND THE NR 3 AND 4 EPSUS WOULD NOT TEST. REMOVED AND REPLACED THE EPSUS IAW AMM 33-55-17, OPS CHECKED GOOD.SDR SIMA20171007002Power Supply · inoperativePAX DOOR EMERGECY LIGHTS INOPERATIVE. REMOVED AND REPLACED THE NR 1 POWER SUPPLY IAW AMM 33-50-04, OPS CHECKED GOOD.SDR SIMA20171007003Power Supply · inoperativeEMERGENCY LIGHT FLOOR ROWS 6 - 8 INOPERATIVE. REMOVED AND REPLACED THE POWER SUPPLY IAW AMM 33-50-04.SDR SWAA2017101117037Light · looseAFT GALLEY EXIT SIGN LOOSE. SECURED LIGHT ASSEMBLY PER SIP.SDR AALA201710119007Light · unsecureUNSECURE EMERGENCY LIGHT ASSEMBLY NUT AT SEAT 21C. SECURED THE SEAT MOUNTED LED LIGHT IAW AMM 33-51-00. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201710119005Lens · missingMISSING EMERGENCY LIGHT LENS FORWARD OF LAVATORY L53 AND AFT OF SEAT 21B. REPLACED THE LENS IAW AMM 33-51-13.SDR KCSA2017100720Lamp · inoperativeFLIGHT DECK EMERGENCY EXIT LIGHT INOPERATIVE. REPLACED THE LAMP IAW AMM 33-50-00. CHECKED OKAY.SDR DALA2017100907435Battery Pack · inoperativeCOCKPIT AND ENTRY OVERHEAD EMERGENCY LIGHTS INOPERATIVE. R & R THE BATTERY PACK IAW AMM 33-53. OPS CHECKED GOOD.SDR JJBA20171007007Light · missingCABIN EMERGENCY LIGHT STRIP HAS A SEGMENT MISSING. REPLACED CABIN EMERGENCY LIGHT STRIP IAW AMM 33-50-12. OPS CHECKED GOOD.SDR AALA20171008001Battery Pack · no testEMERGENCY POWER SUPPLY UNIT 15WL FAILED CIDS OPERATIONAL TEST. REPLACED 15WL BATTERY PACK IAW AMM 33-51-38. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201710099016Lens · missingEXIT SIGN LENS FOR THE R4 DOOR MISSING. INSTALLED A NEW EXIT LIGHT LENSSDR AALA201710099008Lens · looseDOOR AFT EMERGENCY EXIT ECAM DURING CRUISE. EMERGENCY EXIT COVER FELL OFF IN FLIGHT. APPEARS LOOSE. EMERGENCY EXIT LENS SECURED.SDR AALA201710099006Lens · brokenSMALL EXIT LIGHT LENS FOR THE L1 DOOR FOUND BROKEN. REPLACED THE LENS IAW AMM.SDR RAIA201710070001Lamp · inoperativeCOCKPIT FLOOD LIGHT IS INOPERATIVE. R & R THE LAMP, OPS CHECKED GOOD.
Back to JASC 3350