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 AALA201703049002Light · unsecureEMERGENCY LIGHT DETACHING FROM THE FLOOR AT ROW 11 AND 12. MAINTENANCE SECURED THE LIGHT AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201703049008Lens · brokenL2 DOOR LOWER EMERGENCY EXIT SIGN LENS BROKEN. REMOVED AND REPLACED THE SIGN LENS.SDR AALA201703049007Lens · missingR1 DOOR LOWER EMERGENCY EXIT SIGN LENS MISSING. INSTALLED A NEW SIGN LENS.SDR AALA201703049006Lens · missingL1 DOOR LOWER EMERGENCY EXIT SIGN MISSING. INSTALLED NEW EMERGENCY EXIT SIGN LENS AT L1 DOOR.SDR AALA201703049005Lens · missingL4 DOOR EXIT LIGHT COVER MISSING. INSTALLED A NEW LENS.SDR AALA201703049004Lens · missingWHITE AISLE EMERGENCY LIGHT AT 20C LENS MISSING. REPLACED EMERGENCY LIGHT LENS AT 20C, OPS CHECK GOOD.SDR A6WA2017030344829Inverter · inoperativeEMERGENCY LIGHTS, RIGHT SIDE ROWS 6--8 FOUND INOPERATIVE, R & R THE INVERTER IAW AMM 33-51-07, OPS CHECKED GOOD.SDR MASA2017030312640Lamp · inoperativeROW 18 CEILING EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS.SDR HNAA2017030300072Bulb · dimLEFT CENTER EMERGENCY LIGHT IS DIM. REMOVED AND REPLACED BULBS. OPS CHECKED GOOD.SDR HNAA2017030300071Bulb · dimLEFT CENTER EMERGENCY EXIT WALL LIGHT IS DIM. REMOVED AND REPLACED THE BULBS. OPS CHECKED GOOD.SDR HNAA2017030200070Bulb · inoperativeSECOND MOST AFT FLOOR EMERGENCY LIGHT IS OUT, RIGHT SIDE. REMOVED AND REPLACED THE BULB. OPS CHECKED GOOD.SDR SWAA2017040412890Battery Pack · inoperativeFORWARD RIGHT EMERGENCY EXIT LIGHT BATTERY PACK M1674 INOPERATIVE. R & R THE BATTERY PACK IAW AMM.SDR AALA201703099021Battery · dischargedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHTS AT SEATS 18 THROUGH 26 DEF ARE DIM. RECHARGED BATTERIES IAW AMM 33-51-07. OPERATIONAL CHECK GOOD.SDR ASOA201703025014Battery · dischargedPILOT REPORTED THE EMERGENCY LIGHTS INOPERATIVE. ALLOWED EMERGENCY LIGHTS TO CHARGE AND PERFORMED OPERATIONAL TEST, TESTED GOOD. ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR SWAA2017030712392Battery Pack · no testBATTERY PACK FAILED CAPACITY TEST AT POSITION M01668. R & R THE BATTERY PACK IAW AMM AND DWG.SDR SWAA2017030712391Battery Pack · no testBATTERY PACK FAILED CAPACITY TEST AT POSITION M01673. R & R THE BATTERY PACK IAW AMM AND DWG.SDR SWAA2017030712390Battery Pack · no testBATTERY PACK FAILED CAPACITY TEST AT POSITION M01670. R & R THE BATTERY PACK IAW AMM AND DWG.SDR SWAA2017030712389Battery Pack · inoperativeRIGHT DOOR AFT GALLEY EMERGENCY EXIT LOWER LIGHT INOPERATIVE. R & R THE BATTERY PACK IAW MM.SDR SWAA2017030712382Battery Pack · no testBATTERY PACK FAILED CAPACITY TEST AT POSITION M01672. R & R THE BATTERY PACK IAW AMM AND DWG.SDR SWAA2017030712381Light · brokenRIGHT EMERGENCY LIGHT BROKEN AT ROW 1. R & R THE LIGHT IAW DWG.SDR SWAA2017030712364Battery Pack · inoperativeLEFT, AFT GALLEY EMERGENCY LIGHT INOPERATIVE. R & R THE BATTERY PACK IAW MM.SDR DALA2017030701853Light · inoperativeDURING A SERVICE CHECK, FOUND EMERGENCY LIGHT INOPERATIVE AT ROW 43. REMOVED AND REPLACED THE LIGHT ASSY IAW AMM 33-50. OPS CHECKED GOOD.SDR SWAA2017030612352Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1668. R&R BATTERY PER AMM.SDR SWAA2017030612351Sign · defectiveL1 LOWER EXIT SIGN MISSING DIRECTIONAL ARROWS. R&R SIGN IAW AMM.SDR SWAA2017030612346Light · inoperativeRT EXTERIOR OVERWING EMERGENCY EXIT LIGHT INOP. RELAMPED LIGHT PER AMM.SDR SWAA2017030612342Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1673. R&R BATTERY PER AMM.SDR SWAA2017030612319Sign · damagedR1 LOWER EXIT SIGN MISSING DIRECTIONAL ARROWS. R & R THE SIGN IAW AMM.SDR SWAA2017030612314Bulb · inoperativeLEFT INTERIOR EMERGENCY EXIT LIGHT BULBS INOPERATIVE. RELPLACED THE BULBS IAW AMM.SDR SWAA2017030612313Bulb · inoperativeRIGHT INTERIOR EMERGENCY EXIT LIGHT BULBS INOPERATIVE. REPLACED THE BULBS IAW AMM.SDR DALA2017030601843Lens · detachedEMERGENCY LIGHT LENS DETACHED. ATTACHED THE LENS.SDR DALA2017030601842Lens · detachedEMERGENCY LIGHT LENS DETACHED. INSTALLED THE LENS CHECKED GOOD.SDR DALA2017030601837Bulb · missingWHITE EMERGENCY LIGHT BULB AT R1 CLOSET IS MISSING. REPLACED THE BULB.SDR DALA2017030601836Light · damagedLOWER CABIN AISLE EMERGENCY LIGHT ASSY DAMAGED. R & R THE EMERGENCY LIGHT ASSEMBLIES IAW AMM 33-51.SDR DALA2017030601835Lens · missingWHITE EMERGENCY LIGHT LENS MISSING FROM MID LEFT GALLEY, AFT LEFT GALLEY PARTITION AND R1 CLOSET. INSTALLED THE MISSING LENSES IAW AMM 33-51.SDR DALA2017030601819Lamp · inoperativeSEVERAL EMERGENCY LIGHTS ON CAT WALK INOPERATIVE. REPLACED THE LAMPS IAW MM. OPS CHECKED OK.SDR DALA2017030601818Light · missingFOUND THE EMERGENCY LIGHT MISSING AT ROW 26. REPLACED THE LIGHT IAW MM.SDR DALA2017030501778Lamp · inoperativeEMERGENCY LIGHT AT SEAT 17EF IS INOPERATIVE. REPLACED THE LAMPS, OPS CHECKED GOOD IAW AMM 33-53.SDR SWAA2017030312309Light · crackedRIGHT EMERGENCY LIGHT CRACKED BETWEEN ROW 17 TO ROW 22. R & R THE EMERGENCY LIGHT IAW MM.SDR SWAA2017030312308Lens · crackedRIGHT OVERHEAD EMERGENCY LIGHT LENS CRACKED BETWEEN ROW 17 TO ROW 25. R & R THE LENS IAW MM.SDR SWAA2017030312272Light · crackedLEFT FLOOR EMERGENCY LIGHT CRACKED AT ROW 7. R & R THE LIGHT IAW MM.SDR SWAA2017030312271Light · crackedLEFT EMERGENCY LIGHT CRACKED BETWEEN ROWS 16 TO 22. / R & R THE LIGHT IAW MM.SDR SWAA2017030312270Lens · crackedLEFT OVERHEAD EMERGENCY LIGHT LENS CRACKED BETWEEN ROW 16 TO ROW 27. R & R THE LENS IAW MM.SDR SWAA2017030312268Lens · crackedL/H EMERGENCY LIGHT LENS CRACKED BETWEEN ROW 8 TO ROW 12. R & R THE LENS IAW AMM.SDR SWAA2017030312267Lens · brokenLEFT OVERHEAD EMERGENCY LIGHT LENS BROKEN BETWEEN ROW 15 TO ROW 23. R & R THE LENS IAW AMM.SDR AALA20170303012Sign · detachedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN AT L4 DOOR IS DETACHED. RE-INSTALLED EXIT SIGN IAW AMM 33-50-00. OPERATIONAL CHECK GOOD.SDR AALA20170303011Lens · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN AT L2 DOOR HAS A MISSING LENS COVER. REPLACED EXIT LIGHT ASSEMBLY IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20170303009Lens · brokenAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT AISLE LIGHT AT ROW 15 HAS A BROKEN LENS COVER. REPLACED LENS COVER IAW AMM 33-51-03. OPERATIONAL CHECK GOOD.SDR AALA20170303008Sign · looseAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN AT L3 DOOR IS LOOSE. RE-ATTACHED EXIT SIGN IAW AMM 33-51-10. OPERATIONAL CHECK GOOD.SDR AALA20170303006Sign · inoperativeAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN AT THE FORWARD FLIGHT ATTENDANT STATION IS INOPERATIVE. REMOVED AND REPLACED EXIT SIGN LIGHT ASSEMBLY IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20170302019Lens · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT AT R1 DOOR HAS A MISSING LENS COVER. REMOVED AND REPLACED LENS COVER IAW 33-51-00. OPERATIONAL CHECK GOOD.
Back to JASC 3350