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 SWAA2017011911309Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1668. R&R BATTERY PER AMM.SDR SWAA2017011911307Light · inoperativeLT EMERGENCY DOOR EXIT SIGN LIGHT INOP. RELAMPED LIGHT IAW MM.SDR SWAA2017011911303Cover · looseL1 DOOR EMERGENCY EXIT LIGHT COVER LOOSE. SECURED COVER PER SIP.SDR SWAA2017011911292Cover · unsecureFORWARD ENTRY WAY EXIT LIGHT COVER FELL OFF. REINSTALLED COVER PER SIP.SDR SWAA2017011911287Lens · missingRT OVERHEAD EMERGENCY LIGHT LENS MISSING AT ROW 25. INSTALLED LENS PER MM.SDR SWAA2017011911283Light · brokenL1 DOOR EMERGENCY EXIT LIGHT BASE BROKEN. R&R BASE ASSEMBLY PER MM.SDR DALA2017011900488Battery · dischargedEMERGENCY LIGHTS IN FWD GALLEY INOP. REPLACED BATTERY PER AMM 33-51.SDR DALA2017011900487Lens · damagedFWD DOOR 2R EMERGENCY LT LENS DAMAGED (EXTERIOR). REMOVED AND REPLACED 2R DOOR EMERGENCY LIGHT LENS PER AMM 33-51.SDR JJBA20170118015Bulb · inoperativeEMERGENCY LIGHTS AT RIGHT SIDE EXIT INOPERATIVE. R & R THE BULB. OPS CHECKED GOOD.SDR AALA20170119015Lens · damagedAIRCRAFT NOT GROUNDED. CEILING EMERGENCY EXIT LIGHT AT SEAT 1C/D HAS A DAMAGED LENS COVER. REMOVED AND REPLACED LENS COVER IAW AMM 33-51-11. OPERATIONAL CHECK GOOD.SDR VNAA2017011700024Warning System · activatedEMERGENCY LIGHTS ON “S” MESSAGE. AWAITING SUPPLEMENTAL INFORMATION.SDR AALA20170119019Lens · missingEMERGENCY EXIT SIGN ABOVE STAIRS IN OVERHEAD FLIGHT ATTENDANT REST COMPARTMENT IS MISSING LENS COVER. REPLACED LENS COVER IAW 33-29-10. OPS CHECKED GOOD.SDR UHLA201701170004Light · damagedEMERGENCY LIGHT DULL. R & R IAW AMM 33-50-21.SDR AALA20170119024Lens · missingAIRCRAFT NOT GROUNDED. EMERGENCY EXIT SIGN AT SEAT 21J IS MISSING LENS COVER. INSTALLED LENS COVER IAW AMM 33-51-09. OPERATIONAL CHECK GOOD.SDR AALA20170119022Battery · faultyAIRCRAFT NOT GROUNDED. EMERGENCY EXIT LIGHT IN THE MID GALLEY WAS ON WHEN THE AIRCRAFT WAS SHUTDOWN. REMOVED AND REPLACED BATTERY ASSEMBLY IAW AMM 33-53-00. OPERATIONAL CHECK GOOD.SDR AALA20170117014Power Supply · failedAIRCRAFT NOT GROUNDED. L3 OVERWING DOOR EMERGENCY EXIT LIGHTS FAILED CARD 8313. REMOVED AND REPLACED POWER SUPPLY IAW AMM 33-51-06. OPERATIONAL CHECK GOOD.SDR SWAA2017011911311Sign · defectiveL2 DOOR LOWER EMERGENCY EXIT SIGN MISSING DIRECTIONAL ARROW. R& SIGN PER AMM.SDR SWAA2017011911296Light · looseRT EMERGENCY EXIT LIGHT LOOSE. SECURED LIGHT PER AMM.SDR SWAA2017011911293Lens · looseRT OVERWING EMERGENCY EXIT SIGN LENS LOOSE. SECURED LENS PER AMM.SDR DALA2017011800478Battery Pack · inoperativeCOCKPIT EMERGENCY LIGHTS WERE INOPERATIVE. REPLACED THE BATTERY PACK AND TESTED IAW AMM 33-53. OPS CHECKED OK.SDR YENA201701170034Battery · dischargedDURING ROUTINE MAINTENANCE, THE EPSU BATTERY CAPACITY CHECK AT FIN 13 WL, 14 WL, 15 WL, FAILED. R & R EMERGENCY LIGHT BATTERIES AT FIN 13WL, 14WL, 15WL AS PER AMM 33-51-38. PERFORMED OPS CHECK. OPS CHECK PASSED.SDR YENA201701170033Battery · failedDURING ROUTINE MAINTENANCE, THE EPSU BATTERY CAPACITY CHECK AT FIN 13 WL, 14 WL, 15 WL, FAILED. R & R EMERGENCY LIGHT BATTERIES AT FIN 13WL, 14WL, 15WL AS PER AMM 33-51-38. PERFORMED OPS CHECK. OPS CHECK PASSED.SDR YENA201701170032Battery · failedDURING ROUTINE MAINTENANCE, THE EPSU BATTERY CAPACITY CHECK AT FIN 13 WL, 14 WL, 15 WL, FAILED. R & R EMERGENCY LIGHT BATTERIES AT FIN 13WL, 14WL, 15WL AS PER AMM 33-51-38. PERFORMED OPS CHECK. OPS CHECK PASSED.SDR AALA201701189010Lens · missingAIRCRAFT WAS NOT GROUNDED. MISSING EMERGENCY EXIT LIGHT LENS COVER AT 3C. MAINTENANCE REPLACED LENS COVER AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR IPXA2017011812901Power Supply · lowEMERGENCY LT BATT 1 LOW MSG DURING PREFLIGHT. R&R BATT POWER SUPPLY PER AMM 35-51-01-401. CHKS OK. IPC 33-51-01 -01, ITEM 5.SDR DALA2017011800467Light · damagedDURING INSPECTION FOUND FIRST CLASS EMERGENCY FLOOR LIGHTS DAMAGED. MAINTENANCE FOUND LIGHT FIXTURE BECAME UNSECURED FROM WALL. RESECURED, OPS CHECK OK.SDR SWAA2017011811278Battery · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1674. R & R THE BATTERY IAW AMM.SDR SWAA2017011811277Battery · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1673. R & R THE BATTERY IAW AMM.SDR SWAA2017011811276Battery · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1672. R & R THE BATTERY IAW AMM.SDR SWAA2017011811275Battery · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1670. R & R BATTERY IAW AMM.SDR SWAA2017011811274Battery · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1675. R & R THE BATTERY IAW AMM.SDR SWAA2017011811268Battery Pack · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1668. R & R THE BATTERY PACK IAW AMM.SDR SWAA2017011811258Lamp · inoperativeLEFT AFT LOWER EMERGENCY LIGHT EXTERIOR INOPERATIVE. REPLACED THE LAMP IAW AMM.SDR SWAA2017011811257Battery Pack · no testFORWARD CABIN RIGHT EMERGENCY LIGHT BATTERY PACK FAILED CAPACITY FUNCTIONAL TEST. R & R THE BATTERY PACK IAW MM.SDR SWAA2017011811253Cover · crackedLEFT EMERGENCY LIGHT LENS COVER CRACKED BETWEEN ROW 19 TO ROW 27. R & R THE COVER IAW AMM.SDR SWAA2017011811246Lens · looseL1 DOOR LOWER EXIT SIGN LIGHT LENS LOOSE. SECURED THE LENS IAW MM.SDR SWAA2017011811243Battery Pack · no testAFT CABIN RIGHT EMERGENCY LIGHT BATTERY PACK FAILED CAPACITY FUNCTIONAL TEST. R & R THE BATTERY PACK IAW MM.SDR SWAA2017011811242Battery Pack · no testAFT CABIN LEFT EMERGENCY LIGHT BATTERY PACK FAILED CAPACITY FUNCTIONAL TEST. R & R THE BATTERY PACK IAW MM.SDR SWAA2017011811241Battery Pack · no testLEFT ROW 17 EMERGENCY LIGHT BATTERY PACK FAILED CAPACITY FUNCTIONAL TEST. R & R THE BATTERY PACK IAW MM.SDR SWAA2017011811240Battery Pack · no testLEFT OVERWING EXIT EMERGENCY LIGHT BATTERY PACK FAILED CAPACITY FUNCTIONAL TEST. R & R THE BATTERY PACK IAW MM.SDR SWAA2017011811239Battery Pack · no testRIGHT OVERWING EXIT EMERGENCY LIGHT BATTERY PACK FAILED CAPACITY FUNCTIONAL TEST. R & R THE BATTERY PACK IAW MM.SDR SWAA2017011811238Battery Pack · no testFORWARD CABIN LEFT EMERGENCY LIGHT BATTERY PACK FAILED CAPACITY FUNCTIONAL TEST. R & R THE BATTERY PACK IAW MM.SDR SWAA2017011811228Sign · looseMID CABIN EMERGENCY EXIT SIGN LOOSE. SECURED THE SIGN IAW AMM.SDR HALA2017011700005Light · inoperativeEMERGENCY EXIT LIGHT IN COCKPIT INOPERATIVE. REPLACED THE LIGHT ASSY, OPS NORMAL. ACFT OK FOR SERVICE.SDR U2RA201701170001Battery Pack · inoperativeL1 EMERGENCY LIGHT INOPERATIVE. REPLACED THE EMERGENCY LIGHT BATTERY PACK IAW AMM 33-51-07. SYSTEM OPS CHECKED GOOD.SDR DALA2017011700348Power Supply · inoperativeDURING LINE CHECK, MAINTENANCE FOUND THAT THE EMERGENCY EXIT SIGN, THE AISLE EMERGENCY LIGHTS, THE FORWARD LAVATORY, AND THE SERVICE DOOR EMERGENCY LIGHTS WERE INOPERATIVE. MAINTENANCE REPLACED THE BATTERY PACK AND POWER SUPPLY FOR THE NOTED LIGHTED AREAS ANDSDR AALA20170119005Pin · brokenEMERGENCY EXIT LIGHT ABOVE SEATS 24HJ HAS BROKEN INSTALLATION PINS ON THE BRACKET. REPAIRED IAW EA 266739.SDR AALA20170119027Lens · detachedAIRCRAFT NOT GROUNDED. FLIGHT ATTENDANT REPORTED AFT EMERGENCY EXIT SIGN LENS COVER IS DETACHED. SECURED LENS COVER. OPERATIONAL CHECK GOOD.SDR AALA20170119008Lens · detachedAIRCRAFT NOT GROUNDED. EMERGENCY EXIT SIGN AT THE ENTRY DOOR HAS A DETACHED LENS COVER. SECURED LENS COVER IAW AMM 33-50-00. OPERATIONAL CHECK GOOD.SDR AALA20170119004Brace · looseAIRCRAFT WAS GROUNDED. OVERHEAD EMERGENCY EXIT SIGN BRACE AT SEAT 22H IS LOOSE. SECURED EXIT SIGN IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.
Back to JASC 3350