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 SWAA2017040512928Battery Pack · no testEMERGENCY LIGHT AT M1675 FAILED CAPACITY CHECK. R & R THE BATTERY PACK IAW AMM.SDR SWAA2017040512927Lens · dirtyAFT SLIDE LIGHT LENS DIRTY AT BS 1000, LBL 60. R & R THE LENS IAW AMM.SDR SWAA2017040512926Lens · dirtyAFT SLIDE LIGHT LENS DIRTY AT BS 1000, RBL 60. CLEANED THE LENS IAW AMM.SDR SWAA2017040512925Lens · dirtyOVERWING SLIDE LIGHT LENS DIRTY AT BS 757, RBL 51. CLEANED THE LENS IAW AMM.SDR SWAA2017040512924Lens · dirtyOVERWING SLIDE LIGHT LENS DIRTY AT BS 757, LBL 51. CLEANED THE LENS IAW AMM.SDR SWAA2017040512923Lens · dirtyR1 DOOR SLIDE LIGHT LENS DIRTY AT BS 365, LBL 72. CLEANED THE LENS IAW AMM.SDR SWAA2017040512922Lens · dirtyR1 DOOR SLIDE LIGHT LENS DIRTY AT BS 348, RBL 68. CLEANED THE LENS IAW AMM.SDR SWAA2017040512903Lens · detachedR1 DOOR LOWER EXIT LIGHT COVER LENS FELL OFF. INSTALLED THE LENS IAW AMM.SDR SWAA2017040512894Lens · looseRIGHT EMERGENCY EXIT LIGHT LENS LOOSE. SECURED THE LENS IAW AMM.SDR SWAA2017040512880Lamp · inoperativeRIGHT EMERGENCY LIGHT FORWARD OF AFT CARGO DOOR INOPERATIVE. R & R THE LAMP IAW AMM.SDR SWAA2017040512879Lamp · inoperativeLEFT OVERWING EXIT EXTERNAL EMERGENCY LIGHT INOPERATIVE. R & R THE LAMP IAW AMM.SDR AALA20170331011Battery Pack · dischargedDOOR 2 L/H FWD EMERGENCY LT POWER PACK REPLACED AND TEST FAILED. DOOR 2 L/H FWD EMERGENCY LT POWER PACK REPLACED AGAIN AND TEST NORMAL IAW AMM 33-51-06. AIRCRAFT IN BASE MAINTENANCE. (SEE ALSO SDR AALA20170331009)SDR AALA20170331009Battery Pack · dischargedDOOR 2 LT FWD EMER LIGHT POWER PACK INOP. DOOR 2 LT FWD EMR LT POWER PACK. REPLACED AND TEST CARRY OUT AND TEST FAILED. DOOR 2 LT FWD EMERGENCY LT POWER PACK REPLACED AGAIN AND TEST NORMAL IAW AMM 33-51-06. AIRCRAFT IN BASE MAINTENANCE. (SEE ALSO SDR AALA20170SDR SWAA2017040412907Battery Pack · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT M1675. R & R THE BATTERY PACK IAW MM.SDR AALA201703319026Light · brokenFWD DETACHABLE EMERGENCY LIGHT TOP LATCH BROKEN. REMOVED AND REPLACED EMERGENCY LIGHT IAW AMM 33-53-00. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA201703319025Lens · damagedLIGHT LENS/COVER/BEZEL DAMAGED. CLEANING CREW FOUND R2 EXIT SIGN COVER ON FLOOR. R2 EXIT SIGN COVER LENS ASSY WAS REPLACED IAW 33-51-01-201 TEST SATISFACTORY. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA201703319024Lens · brokenRIGHT HAND SIDE AISLE FLOOR ESCAPE LIGHTS BROKEN IN BUSINESS CLASS, NO SEAT POSITION GIVEN. REMOVED AND REPLACED BROKEN LENS RIGHT HAND SIDE AISLE BUSINESS CLASS IAW GPM. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA201703319023Lens · missingWALL MOUNTED EPL LENS MISSING ACROSS FROM 4A. INSTALLED LENS ON WALL ACROSS FROM 4A IAW GPM. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA201703319022Lens · brokenREF PIREP UNKNOWN POSITION OF BROKEN EPL FOUND WALL MOUNTED EPL ACROSS FROM 4R DOOR ON RT GALLEY WALL MISSING/BROKEN LENS. INSTALLED NEW LENS ON GALLEY WALL AT 4R IAW GPM. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA201703319021Lens · brokenREF PIREP UNKNOWN LOCATION OF BROKEN EPL LT. FOUND WALL MOUNTED EPL LENS BROKEN/MISSING AT LAV 3F-RC. INSTALLED NEW LENS AT LAV WALL 3F-RC IAW GPM. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA201703319020Roll Pin · shearedEXIT ROW SIGN OVER ROW 24C HELD IN PLACE BY TEMPORARY PLASTIC TIE. REPLACED SHEARED ROLL PINS. OK FOR SERVICE IAW GPM. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA201703319019Light · brokenDURING ACCOMPLISHMENT OF MCM 2904, FOUND FWD EXIT LIGHT NEAR GALLEY SINK OF R1 DOOR TO BE BROKEN. REMOVED + REPLACED EXIT IDENTIFIER LIGHT ASSEMBLY OF R1 DOOR BELOW GALLEY SINK IAW AMM 33-51-01. OPS CHECK GOOD. NO FURTHER DEFECTS NOTED. THE AIRCRAFT WAS NOT GRSDR AALA201703319018Sign · missingEXIT SIGN 14ABC MISSING. REPLACED EXIT SIGN 14ABC. SYS OPS CKD NORMAL IAW AMM33-51-01. THE AIRCRAFT WAS NOT GROUNDED.SDR CALA2017033100762Sign · crackedINSPECTION FOUND THE R3 DOOR FWD EXIT SIGN CRACKED. REPLACED THE SIGN ASSY. OPS TESTED NORMAL IAW AMM33-51-00-710-801, REV 79.SDR CALA2017033100761Sign · crackedTHE R4 DOOR EXIT SIGN CRACKED. REPLACED SIGN ASSEMBLY. OPS TESTED NORMAL IAW AMM 33-51-00-710-801, REV 79, AND AMM 33-51-01-960-802, REV 79.SDR CALA2017033100760Sign · crackedL3 DOOR EXIT LIGHT ASSY FOUND CRACKED. REPLACED THE EXIT SIGN ASSY, OPS TESTED NORMAL IAW AMM 33-51-00-710-801, REV 79, & AMM 33-51-01-960-802, REV 79.SDR ASOA201703285029Battery Pack · dischargedDURING SCHEDULED MX INSPECTION THE ROW 18 TOP CENTER AISLE FORWARD EMERGENCY SIGN WILL NOT ILLUMINATE. MX REMOVED AND REPLACED THE NR 4 BATTERY PACK WITH OPERATIONAL CHECK GOOD. A/C WAS APPROVED FOR RETURN TO SERVICE.SDR DALA2017033002575Cover · unsecureEXIT SIGN COVER OVER CABIN MAIN ENTRANCE DOOR KEEPS FALLING DOWN. SECURED THE COVER. (LP# 9461452)SDR ASAA2017032820292Lens · missingR2 DOOR EXIT SIGN LENS MISSING. ACFT GROUNDED. REPLACED THE LENS, OK FOR SERVICE.SDR AALA201703299007Cover · brokenEXIT LIGHT PLASTIC COVER BROKEN OFF. REPLACED THE COVER. OPS CHECKED GOOD.SDR I5PA2017032807Light · inoperativeFWD ENTRY DOOR EXTERIOR EMERGENCY LIGHT INOP. REPLACED LIGHT AND PERFORMED SATISFACTORY LIGHT TEST PER AMM 33-51-06. DOCUMENTED ON ATS JOB 722361 CARD 00061.SDR SIMA20170328003Light · inoperativeSERVICE DOOR SWING ARM COVER EMERGENCY LIGHT INOP. R&R SERVICE DOOR SWING ARM EMERGENCY LIGHT LAMP IAW AMM 33-50-09. OPC GOOD.SDR DALA2017032902533Lens · detachedEMERGENCY LIGHT ROW 25 COVER FELL OFF. REINSTALLED THE COVER.SDR FDEA201703280996Light · inoperativeDURING PREFLIGHT INSPECTION, L1 DOOR FWD EMERGENCY EXIT LIGHT NOT ILLUMINATED.SDR DALA2017032902519Light · out of adjustLT AFT EMERGENCY LIGHT INOPERATIVE. ADJUSTED LT AFT EXTERIOR EMERGENCY LIGHT PER B717 AMM 35-54. CHECKS OK.SDR DALA2017032802517Charger · inoperativeON SVC FOUND EMERG BATT PACK INOPERATIVE. R&R BATT CHARGER / BATT B5-235 REF AMM 33-51, WDM 33-51. CHECKS GOOD. OK FOR SVC.SDR QXEA2017032800192Battery Pack · no testALL EMERGENCY LIGHTS ON THE OUTSIDE EXCEPT RT FWD INOPERATIVE AND INSIDE EMERGENCY FWD AND AFT INTERIA LIGHTS INOPERATIVE, FOUND DURING AN EMERGENCY LIGHT OPS TEST. REMOVED AND REPLACED THE BATTERY PACKS IAW TC 335000203-60004, OPS CHECKED IAW TC 335000202-SDR AALA201703309038Battery Pack · failedRT MID COACH EMERGENCY LIGHT BATTERY PACK FAILED FUNCTIONAL TEST MCM CARD 2908. REMOVED AND REPLACED BATTERY PACK AT STA 727+13 RT SIDE JUST ABOVE FLOOR LEVEL IAW AMM 35-51-06. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA201703309037Lens · damagedLIGHT LENS/COVER/BEZEL DAMAGED. 3L EXIT SIGN COVER FELL OFF. REMOVED AND REPLACED EXIT SIGN LT ASSEMBLY IAW AMM 33-51-01, CHECK IS OK. THE AIRCRAFT WAS NOT GROUNDED.SDR CALA2017033100758Charger · inoperativeEXTERIOR RT NR 3 EMERGENCY LIGHT INOPERATIVE . REPLACED THE BATTERY PACK AND CHARGER IAW AMM 33-51-06. CHECKED NORMAL.SDR AALA20170328003Power Supply · failedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHTS POWER SUPPLY AT STATION 727+13 RIGHT MID COACH FAILED TEST. REMOVED AND REPLACED POWER SUPPLY IAW AMM 33-51-06.SDR SWAA2017032912846Lens · looseR2 DOOR EXIT SIGN LENS LOOSE. R & R THE LIGHT ASSEMBLY IAW AMM.SDR AALA201703289008Lens · missingL4 DOOR EMERGENCY LIGHT LENS MISSING. REPLACED THE LENS. OPS NORMAL.SDR DALA2017032802532Light · detachedFLOOR EMERGENCY LIGHT DETACHED AT SEAT 22D. SECURED THE LIGHT. OK FOR SERVICE.SDR DALA2017032802509Sign · brokenDURING INSPECTION FOUND EMERGENCY EXIT SIGN R-2 DOOR BROKEN. MAINTENANCE R&R EXIT SIGN ASSY R-2 DOOR. CKS GOOD PER AMM 33-51.SDR AALA201703289005Lens · detachedFOWARD GALLEY SIDEWALL L2 DOOR EXIT LIGHT COVER IS DETACHED. REPLACED THE LENS.SDR AALA201703289004Lens · damagedEMERGENCY LIGHT LENS DAMAGED. REPLACED THE LENS ASSEMBLY.SDR AALA201703289003Lens · out of positionEXIT SIGN LENS OVER THE L2 DOOR IS NOT IN PLACE. INSTALLED THE LENS.SDR MASA2017032712698Light · inoperativeROW 17 CEILING LEVEL EMER FLOOD LT INOP. PLACED ON MEL.SDR CALA2017032700756Light · crackedG2 GALLEY 6EA EMERGENCY LT FOUND CRACK . REPLACED THE G2 GALLEY 6EA EMER LIGHT ASSY AND C/O EMER LIGHT SYSTEM OPERATION TEST FOUND "NORMAL" REF AMM 33-51-00-710-801 REV 79.
Back to JASC 3350